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

ContactReview Forum Index » GoldMine Legacy » Dedupe 5.7 SQL database
Post new topic  Reply to topic View previous topic :: View next topic 
Dedupe 5.7 SQL database
PostPosted: Tue May 12, 2009 11:45 am Points: 0 Reply with quote
norbus77
n00b
Joined: 12 May 2009
Posts: 8




We have 75K records with many dupes and, due to limited IT support, new dupes created monthly (new records from web, trade shows, etc, are directly imported via Excel spreadsheet with no dupe-looking).

Does the Goldmine Merge-Purge procedure work OK? I know Goldbox is recommended, but I don't know if that's because it can do a more complete job or if the GM tool is faulty.

I know that one option is having a VAR do it for us, but wanted opinion on this question, too.

TIA,
Dave
View user's profile Send private message

PostPosted: Tue May 12, 2009 3:59 pm Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




You should be able to use the GoldMine Merge/Purge process if, and that is a big if, you set it up properly.

Oh, did I mention to backup before you tried this?

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Re: Dedupe 5.7 SQL database
PostPosted: Tue May 12, 2009 7:21 pm Points: 0 Reply with quote
automationstation
Sensei of the GoldMine
Joined: 16 Jan 2009
Posts: 193
Location: Saint Paul, Minnesota




norbus77 wrote:
We have 75K records with many dupes and, due to limited IT support, new dupes created monthly (new records from web, trade shows, etc, are directly imported via Excel spreadsheet with no dupe-looking).

Does the Goldmine Merge-Purge procedure work OK? I know Goldbox is recommended, but I don't know if that's because it can do a more complete job or if the GM tool is faulty.

I know that one option is having a VAR do it for us, but wanted opinion on this question, too.

TIA,
Dave


You can use GoldMine's Merge/Purge features to do this, but unless you stop the problem at the source... during the import... your problem will just keep coming back.

With products like GoldBox or Inaport, you can do more comprehensive record matching and only bring in the new records and/or update a field on records that already exist in the database.

_________________
Eric L. Turnipseed, President, SBSC, MCSE
GoldMine CRM Certified Technician/Trainer
The Automation Station, Inc.
Phone: (651)248-3191
View user's profile Send private message Visit poster's website

PostPosted: Wed May 13, 2009 5:28 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I would use GoldBox or Inaport as opposed to GoldMine's merge/purge. I am more familiar with GoldBox so I will refer to that. It is much safer than GoldMine's merge purge because it give you many more options to include the ability to do a dry run without changing data just to make sure that you have used the correct criteria. This is particularly true when compared to older versions of GoldMine.

Also, properly used, if GoldBox is used to handle your imports, you will be able to prevent duplication during the importing process.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

Dedupe 5.7 SQL database
PostPosted: Thu May 14, 2009 2:04 pm Points: 0 Reply with quote
norbus77
n00b
Joined: 12 May 2009
Posts: 8




Thanks to all. I agree on preventing rather than fixing problems......The tragic thing is, IT has Goldbox - and complaints about the learning curve.

DJ - I think you said in a post at the old FR forum that the M/P in GM had a record/data limit and we'd have to do it in chunks?

Dave
View user's profile Send private message

PostPosted: Thu May 14, 2009 2:12 pm Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




I offer (paid) assistance with GoldBox. You'd be surprised how easy much of it actually is. But of course, parts of it are definitely advanced. I really don't think that should surprise anyone.

_________________
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 May 14, 2009 3:16 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I agree with Bob Taylor. Once you start using GoldBox, you will find it quite easy to use. Bob Taylor would be a good way to get a head start on the use of this wonderful program.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Thu May 14, 2009 11:02 pm Points: 0 Reply with quote
automationstation
Sensei of the GoldMine
Joined: 16 Jan 2009
Posts: 193
Location: Saint Paul, Minnesota




bgannett wrote:
I agree with Bob Taylor. Once you start using GoldBox, you will find it quite easy to use. Bob Taylor would be a good way to get a head start on the use of this wonderful program.


I am sure Bob Taylor would be a good start... so would any GoldMine/GoldBox partner that haves experience and expertise!

_________________
Eric L. Turnipseed, President, SBSC, MCSE
GoldMine CRM Certified Technician/Trainer
The Automation Station, Inc.
Phone: (651)248-3191
View user's profile Send private message Visit poster's website

PostPosted: Fri May 15, 2009 3:54 am Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Agreed.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Fri May 15, 2009 4:10 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




I'll second that! Smile

_________________
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: Fri May 15, 2009 5:51 am Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




I have always contended that GoldBox is extremely user unfriendly. This is not to say that I do not recommend GoldBox, as I do recommend GoldBox, however, whenever I recommend GoldBox I always recommend the services of Bob Taylor in conjunction with the GoldBox product. I do not want the users having to learn this product to solve their immediate problems. The learning curve is just too extreme. On the other hand, more often than not, GoldBox is the recommended solution. I am of the opinion that if you are going to recommend GoldBox that you recommend it as a bundle with the services of Bob Taylor.

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Fri May 15, 2009 6:12 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




Thanks, DJ; I am delighted by your recommendation. I'll continue to aver that GoldBox gets a bit of a raw deal when it comes to the user unfriendly thing; but I'm sure you'd be disappointed if I didn't do that Laughing

_________________
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

Dedupe 5.7 SQL database
  ContactReview Forum Index » GoldMine Legacy
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