+ Start a Discussion
Ravi K 47Ravi K 47 

Commandline dataloder upsert issue

Im facing issues with Upsert operation from Command Line Data Loader.

Below is my requirement.

1) I have a custom object custom__c with Account has Master . Fields(Account_Name__c(Master),external__c(text field==>not unique/external))
2)Account has an external id (external__c==>Unique)

The data is coming from an external system and i need to insert/update into custom__c using Command Line Data Loader.
 
Process-config:

<entry key="sfdc.externalIdField" value="id"/>
                <entry key="sfdc.entity" value="custom__c"/>
                <entry key="process.operation" value="upsert"/>


 
Mapping File:

Id=Id
Account_Name__r.external__c=Account_Name__r\:external__c



Here ,im facing issues when keeping externalIdField value as "Id" ==>Its updating the existing records but not inserting and throwing me an error."Record Id is missing"

Even i tried with below ==> Still no luck
<entry key="sfdc.externalIdField" value="Account_Name__r.external__c"/>


Could you please help me on this issue.

 
Asif Ali MAsif Ali M
Process Config: Change the value of the External key of Custom__c object
<entry key="sfdc.externalIdField" value="external__c"/>