InaPlex
»
InaPlex
»
KnowledgeBase
»
GoldMine: Fail appending to CONTACT2
Rank: Administration
Groups: Administrators
Joined: 8/17/2015(UTC) Posts: 22
Was thanked: 2 time(s) in 2 post(s)
|
Do you have a numeric UDEF field in contact2? If so, you are running into a known issue with GM7. PROBLEMWhen an application (such as Inaport) creates a C2 record using the API, GoldMine issues an insert on the database, which succeeds. Inaport then accumulates all the field values, and issues a single update to the record when the changes are commited by the application. For reasons best known to the GoldMine developers, the WHERE clause to the UPDATE checks that each field being updated is currently null. Problem with this is that with GM7, the schema definition for UDEF numeric fields was changed to have them default to 0. That means any numeric fields are set to 0 when the record is first inserted, which in turn means that the where clause fails. WORKAROUNDIn Inaport, you can work around this problem by having two instances of the _contact2 table in your table map. On the first instance: - Set the operation to "Create not exist", and accept the default primary key/foreign key settings.
- Change the action for "If there are multiple matches" to be: "Continue processing this source row"
- Do not specify any match criteria.
- Do NOT map any values to the fields - have an empty "Map for Create" grid
On the second instance: - Set the operation to "Update single existing"
- Do not specify any match crieria
Now map all your fields to the required fields in C2.
|
|
|
|
Users browsing this topic |
Guest (2)
|
InaPlex
»
InaPlex
»
KnowledgeBase
»
GoldMine: Fail appending to CONTACT2
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.