When I try to use the Apex Data Loader or another application such as Jitterbit to upsert data into fields on the opportunity, I get an error that says "ID value of incorrect type: [text from .csv file attempted to load into field]". I get this error in a lookup field that accesses the Account Name on the Account object.
I am using the an external id called "reference_number__c". I've researched this error on this forumn and elsewhere, but can't find an answer that works. Any help would be greatly appreciated.
Thanks!
11 réponses
So you are trying to upsert a custom external ID field into the Account Name lookup field? Lookup fields must be populated by Salesforce.com record IDs.
You will need to export your Accounts with Salesforce 18 character ID and your External ID fields. Then use VLOOKUP() to match the Account ID from Salesforce to the External IDs on your upsert file. Then match the Account ID column to the Account Name lookup field.
