function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
mfawcettmfawcett 

Command Line Data loader upsert external ID on Master object

Hi,

I have the an issue using data loader command line, in my case I have two custom objects A and B and there is a master detail relationship between the two, and object A has an external ID.

I found some documents on line and based on those I have done the following configurations:

In the process-conf file I included:
<entry key="sfdc.externalIdField" value="A__r.External_ID__c"/>

In the mapping file I have this:
Id=Id
A__r.External_ID__c=A__r\:External_ID__c


But I am getting an error the " Field name provided A__r.External_ID__c id is not an external id or indexed field on B" 

It worked using the data loader wizard. Any help I will appreciate it.
Kevin Stinson 5Kevin Stinson 5
I am having the same trouble. Does anyone out there have a solution? This seems like a pretty basic operation: there must be a solution to this!!!
Olavo ZapataOlavo Zapata
I'm having the same difficulties. We tried to change the master-detail connection to Lookup and it works, probably because when we have a master object, it requests the ID as required.
ihssan tazinyihssan taziny
Hi @mfawcett

The field ExternalId__c is it marked as external id in the custom field definition ? :

User-added image
mfawcettmfawcett
Sorry for the delay but the issue was resolved, I had the changed the relationship between the objects. Thanks for the help