Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldBox » GoldBox Import Adding Duplicate Details?
Post new topic  Reply to topic View previous topic :: View next topic 
GoldBox Import Adding Duplicate Details?
PostPosted: Thu Dec 09, 2010 11:07 am Points: 0 Reply with quote
davidshq
GoldMine Journeyman
Joined: 15 Jun 2010
Posts: 38




I've been doing some test runs with my import (whew! its almost done!). What I've noticed is that it bypasses the main contact record - but then the detail records it adds an additional identical record to. So, for example, we have high schools as a detail record - if I import once its all good, if I import a second or third time it doesn't duplicate the whole record but does add the detail record multiple times so I have multiple instances of the same high school. Theoretically this shouldn't be too big of a problem (I'm only doing one import) but I'd like to clear it up before going any further. Any ideas on how to prevent this from occurring?
Thanks,
Dave.
View user's profile Send private message

PostPosted: Thu Dec 09, 2010 11:25 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




I'm not following everything about what you are saying, so I don't know whether removing the PlugIn from one or more of your Imports might be the answer. Of course, if all else fails, you can just run a Dedupe of a GoldMine table as the final item in your Q-file. Use the query to home in on the specific Detail, and be sure you like what GoldBox has given you for the matching expression. You can change it, if need be (I think what GoldBox figures on Details is usually good, though).

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

PostPosted: Thu Dec 09, 2010 11:34 am Points: 0 Reply with quote
davidshq
GoldMine Journeyman
Joined: 15 Jun 2010
Posts: 38




Found this in the GB docs:
"Even though you can 'conditionalize' each plug-in field set when Updating a Main Contact - please note that the plugged-in Tab records are ALWAYS added as New. There is no dupe checking to see if that Tab record already exists, or Update capability of that Tab record. For this functionality, choose the dedicated Tab Import/Update operations."
Essentially, it appears there is no way to filter out inserting details - they are always inserted. Sad
Dave.
View user's profile Send private message

PostPosted: Thu Dec 09, 2010 11:47 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




If the problem is duped Details, see my solution #2 above.

_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997.
View user's profile Send private message Send e-mail Visit poster's website

GoldBox Import Adding Duplicate Details?
  ContactReview Forum Index » GoldBox
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin