Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 313 subscribers
  • Views 2508 views
  • Users 0 members are here

How to mass delete duplicates

Paul Harrington

I just synced my Inbox25 to our leads module and it has Citrix integration for Gotowebinar and it uploaded each new lead 3 times so I need to figure out a way to either merge them or delete all the duplicates.

Any help would be great.

  • 0

    Hello Paul,

    Sorry to hear the sync process did not work as intended.

    You may want to consider using Sugar's import functionality to find duplicates where then you can re-import a lead records and by ensuring to include the "delete=1" column as shown, you can mass delete the duplicates rather efficiently:

    http://support.sugarcrm.com/Knowledge_Base/Import_Export/Using_Import_to_Find_Duplicates_Across_Modules/index.html 

    Regards,
    Rudy Robledo
    SugarCRM Support

  • 0

    I would suggest you copy the original import data, then delete all columns except "Name" & "ID". You then add a new column titled "Deleted" and set this to 1 for all rows. After doing so, import the file selecting the "Create new records and update existing records" option during the import. Make sure all 3 columns are mapped to appropriate Sugar field name and the records will be marked as deleted upon import completion. I hope this helps.