Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 291 subscribers
  • Views 1885 views
  • Users 0 members are here
Related content from around SugarClub

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.

Parents
  • 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.  

Reply
  • 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.  

Children
No Data