Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
We have two objects here. One is Master and other is child of that master. we have an external field on the master Object. I am trying to perform the Upsert Operation on the Child object with the help of external Field of master object.
I am providing the externalIdfield attribute in config file. But, dataloader is not identifying the field and throwing an error. entry key="sfdc.externalIdField" value="Master__r.External_id__c"
Please suggest . Thanks.
It looks as though there is a little confusion regarding the configuration.
In the config file
entry key="sfdc.externalIdField" value="Master__r.External_id__c"
tells the dataloader what externalid to use to differentiate the child objects when creating them.
To upsert a relationship in the dataloader you need to specify the mapping in the SDL file for example:
Id=Id
Master__r.External_id__c=Master__r\:External_id__c
Please note these relationship mappings are only available for upserts, not for inserts or updates as far as I am aware. You may find this link helpful too.
