Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Thursday, August 20, 2015 10:25:58 AM(UTC)

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.


When 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.


In 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
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.

Powered by YAF | YAF © 2003-2021, Yet Another Forum.NET
This page was generated in 0.076 seconds.