You need to sign in to do that
Don't have an account?
Suhel Cruise
Duplicate Leads error with Sample data
Hi,
Using Sample data provided with developer edition, I deleted all the Leads and then tried to re-insert them again. What I find is all the Leads get successfully inserted using Bulk v2 API, except for the following three. It fails with an error saying DUPLICATED DETECTED. I checked my portal again and find that none of these Leads already exist. Any guesses why I am getting this error for these 3 Leads when rest 19 (There are in all 19 + 3 = 22 Leads)
"sf__Id","sf__Error","LastName","FirstName","Salutation","Title","Company","Street","City","State","PostalCode","Country","Latitude","Longitude","GeocodeAccuracy","Phone","MobilePhone","Fax","Email","Website","Description","LeadSource","Status","Industry","Rating","AnnualRevenue","NumberOfEmployees","OwnerId","IsConverted","ConvertedDate","ConvertedAccountId","ConvertedContactId","ConvertedOpportunityId","IsUnreadByOwner","CreatedDate","CreatedById","LastModifiedDate","LastModifiedById","Jigsaw","CleanStatus","CompanyDunsNumber","DandbCompanyId","IndividualId","SICCode__c","ProductInterest__c","Primary__c","CurrentGenerators__c","NumberofLocations__c"
"","DUPLICATES_DETECTED:Use one of these records?:--","Stumuller","Pat","Ms","SVP, Administration and Finance","Pyramid Construction Inc.","","","","","France","","","","33562156600","","","pat@pyramid.net","","","Phone Inquiry","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Young","Andy","Mr","SVP, Operations","Dickenson plc","","","KS","","USA","","","","(620) 241-6200","","","a_young@dickenson.com","","","Purchased List","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Rogers","Jack","Mr.","VP, Facilities","Burlington Textiles Corp of America","525 S. Lexington Ave","Burlington","NC","27215","USA","","","","(336) 222-7000","","(336) 222-8000","jrogers@btca.com","","","Web","Closed - Converted","Apparel","Warm","3.5E8","9000","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","7267","GC5000 series","Yes","John Deere","3.0"
Regards,
Suhel
Using Sample data provided with developer edition, I deleted all the Leads and then tried to re-insert them again. What I find is all the Leads get successfully inserted using Bulk v2 API, except for the following three. It fails with an error saying DUPLICATED DETECTED. I checked my portal again and find that none of these Leads already exist. Any guesses why I am getting this error for these 3 Leads when rest 19 (There are in all 19 + 3 = 22 Leads)
"sf__Id","sf__Error","LastName","FirstName","Salutation","Title","Company","Street","City","State","PostalCode","Country","Latitude","Longitude","GeocodeAccuracy","Phone","MobilePhone","Fax","Email","Website","Description","LeadSource","Status","Industry","Rating","AnnualRevenue","NumberOfEmployees","OwnerId","IsConverted","ConvertedDate","ConvertedAccountId","ConvertedContactId","ConvertedOpportunityId","IsUnreadByOwner","CreatedDate","CreatedById","LastModifiedDate","LastModifiedById","Jigsaw","CleanStatus","CompanyDunsNumber","DandbCompanyId","IndividualId","SICCode__c","ProductInterest__c","Primary__c","CurrentGenerators__c","NumberofLocations__c"
"","DUPLICATES_DETECTED:Use one of these records?:--","Stumuller","Pat","Ms","SVP, Administration and Finance","Pyramid Construction Inc.","","","","","France","","","","33562156600","","","pat@pyramid.net","","","Phone Inquiry","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Young","Andy","Mr","SVP, Operations","Dickenson plc","","","KS","","USA","","","","(620) 241-6200","","","a_young@dickenson.com","","","Purchased List","Closed - Converted","","","","","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","2768","GC5000 series","Yes","All","130.0"
"","DUPLICATES_DETECTED:Use one of these records?:--","Rogers","Jack","Mr.","VP, Facilities","Burlington Textiles Corp of America","525 S. Lexington Ave","Burlington","NC","27215","USA","","","","(336) 222-7000","","(336) 222-8000","jrogers@btca.com","","","Web","Closed - Converted","Apparel","Warm","3.5E8","9000","0055g00000BgDCaAAN","false","","","","","true","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","2021-08-11T11:17:48.000Z","0055g00000BgDCaAAN","","Pending","","","","7267","GC5000 series","Yes","John Deere","3.0"
Regards,
Suhel
The Data Import Wizard and Duplicate Management match records based on different criteria.
When you use Data Import Wizard, you can select criteria to match existing records on:
Have you checked the criteria?
reference:
https://salesforce.stackexchange.com/questions/293077/duplicates-detecteduse-one-of-these-records
https://help.salesforce.com/s/articleView?id=000314351&type=1
Thanks!
Regards,
Suhel