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.


1 Answer 1


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:


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.

  • Any links that include command line instruction?
    – JeffO
    Commented Nov 19, 2015 at 15:50
  • I think this may be what you are looking for: code.google.com/p/dataloadercliq
    – Stefg
    Commented Dec 8, 2015 at 0:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .