You need to sign in to do that
Don't have an account?
boBNunny
Using External ID for Upsert
I'd like to know how DataLoader 10 sets a field for Upsert based on External ID. What attribute of the Contact sObject does it set? Also, it asks for 2 records for foreign key External ID Upsert (Account and Reports To). What does it actual DO with the field selected in order to tell SalesForce to use it and why doesn't that apply to other foreign keys (i.e. Owner).
Thanx!
the second type of upsert is upsert with relationships. This allows you to associate a contact with a related record, based on that related record's externalid. Say you wanted to associate a contact to an account. If the account has an externalid, you can use the account externalid, and not have to use the salesforce.com accountid. Owner would only be an option if you have an externalid on the User record.
Hey bytor1971,
Would you mind sharing how did you do that.
Thanks
Kamran
Getting DataLoader via command line to use the foreign keys is easy. Just make the column header the reference field instead.
i.e. Account__r\:Vantive_Customer_ID__c
I'm more interested in how they did it code-wise so that we can create our own applications similarly.