Removing Duplicates

[KMKM13]

Hello, Sugar newbie here.

I was looking for a way to find all of the duplicate contacts in our Sugar system. I have found instructions detailing how to find duplicates of a certain name or number I might have, but I want a list of all names or numbers that are entered more than once so I can do a general clean up of our data.

If anyone has any info on this it would be greatly appreciated.

Thank you!

[roblaus]

How would you know that records ARE duplicates? Name? Name, first name? Name, street? Name, street, zip?

You see what I mean. Deduplication is a very big issue with large databases and it is not easy because how would the system know that Mayer, Maier and Meyer is actually the same guy? And in short: No, Sugar doesn't have a deduplication tool.

Strategy: Get yourself a good tool (or use a provider but be careful - you won't get more than 70-80% success no matter what they promise), export your contact table as csv (or the tool accesses the Sugar DB directly) and let it run. Usually you will get a list of suspects that then must be treated individually (these tools can actually delete right from the suspect list but I wouldn't do that).

Depending on your number of records the whole procedure of deduplication might run for hours.