function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lauren Johnson 18Lauren Johnson 18 

Data Wizard error when creating contacts. DUPLICATE_VALUE:Duplicate id specified:000000000000000AAA:--

I am receiving "DUPLICATE_VALUE:Duplicate id specified:000000000000000AAA:-- " when upserting contacts into import wizard for any contact record that I am CREATING brand new.

For any record that was an updated record, all updates worked correctly. Even with two contacts linked to same account ID (one being an update and one being a new contact), I recieved this issue on the contact I was trying to create.

I've been trying to import lists since June and keep getting this error and multiple Salesforce rep's haven't been able to help me. Any ideas?
SandhyaSandhya (Salesforce Developers) 
Hi,

Try to use External ID when importing please refer below links.

https://success.salesforce.com/answers?id=90630000000grjpAAA
 
https://success.salesforce.com/answers?id=90630000000D8aFAAS
 
http://blog.jeffdouglas.com/2010/05/07/using-exernal-id-fields-in-salesforce/
 
Hope this helps you!

If this helps you mark it as solved.

Thanks and Regards
Sandhya
Mark MogridgeMark Mogridge

I see this as a bug.

I am trying import multiple Contacts into Accounts.
The Accounts use an external ID (EuroAISCustomerId__c) that is unique, and the Contacts have their own external ID (EuroAISContactId__c).

When I import multiple Contacts into an existing Account, using 'Add new & Update Existing Records' mode I get an error: "DUPLICATE_VALUE:Duplicate external id specified: 51100451:EuroAISCustomerId__c" for every Contact I am trying to add.

But the external ID field 'EuroAISCustomerId__c' is on the [Account] object not on the [Contact] object.
I am not trying to create a new duplicate [Account], so this is definately a BUG.

So we have to return to the 1990's and run the import in three parts: Import Accounts > extract Account IDs > Import Contacts. Sooo last century!