09-26-2011 07:47 PM
Good Evening Everyone,
I have 2 old databases I wanted to combine but both of them had some of the same contacts. In addition I had many csv files from my company I had to import as well.
The question is, does anyone know of a way to do a massive duplicate function rather than 2 at a time? My contacts are almost 35000 and probably about 2500 are duplicates. Any help would be appreciated.
09-26-2011 08:30 PM
09-27-2011 04:40 AM
PE's solution has the fatal flaw that it destroys the "relationships" tab data when merging. I have been trying to get them to fix that for many months and in the mean time, I cannot use the product I purchased.
09-27-2011 04:41 AM
Thanks but that look pretty much like a click by click manual process. I could go down my list and select to delete the one I did not want i believe just the same. I was looking for a more automated version.
09-27-2011 05:04 AM
If you have some programming ability, and your data is simple enough (e.g. no pictures), the best thing might be to export to Excel and write a macro to clean up your contacts, then import them back in.
11-22-2012 06:18 PM
Just watched the demo video on Egen Consulting web site. It did not mention the ability to merge records, just match potential duplicates and then blow away all but one preferred record. Dangerous. Apparently no option to carefully study the matched rcords and save important information which duplicate records may have and in the final record. All that happens is that data that is blown away is placed in a Note. $149 for this close-but-no-cigar software is not realistic. I wonder why de-duping in ACT is such a scourge for ACT customers.
11-22-2012 09:26 PM
First off don't post the same comment to multiple boards and see my response to your other posting.
11-22-2012 09:37 PM
I will post the same comment to multiple boards if the multiple boards have different people seeking a solution to the same problem. They are doing what I am doing, looking for help with a problem which has several boards with the same theme. That's the problem, not me.
11-29-2012 06:00 PM
I wanted to post a quick "watch this space" to say that Don has heard the pleas for maintaining relationships after we merge contacts with our duplicate remover expert wizard. he is working on it and it is almost done - like really almost done. we are hoping to announce it sometime next week. So, for those of you waiting it's almost here. Thanks for your support.
11-29-2012 06:09 PM
Oh ... need to post here on this board that my post a few notches up is history. I was grumpy. Sorry. I've since communicated with Patricia and Donald Egen, purchased their Duplicate Remover Expert program and it is excellent. Discussion on another board which also deals with duplicate removal (I found three) . It's all good. Apologies for the grumpiness that day. Pat and Don are certainly dedicated to ACT and its users.