-The first is a list of all Account IDs and External_Id fields
-The second is all Contact IDs and External_Id fields
-The third is all AccountID, ContactID recrords AccountContactRelation
-The fourth is a lookup on all the Account IDs which match the Contact IDs in the AccountContactRelation sheet. Then, the Contact.Ids external field for that Contact Id, now beside it's matched Account Id.
What we wish to do is now update the Accounts for those Contacts, and populate the Account.External_Id__c with the External_Id__c we already have for the Contact (thus, they will be equal.)
When we import the fourth spreadsheet in Data Loader, we get an error either saying "... is not a valid Salesforce ID for the type Account", or alternatively "Duplicate Id specified".
When we import the fourth spreadsheet in Data Import Wizard and manually map the fields, we get an error saying "The matching field you chose (Name) is not mapped..."
3 réponses
The account IDs you are trying to import begin with 003 - meaning they are actually Contact IDs.
