I am facing a bit problem while uploading csv data in salesforce org by data loader from command line.
I have master detail objects
OBJECT 1: Customer__c - Age__c - CustomerExternal_ID__c OBJECT 2: Customer_detail__c - Customer_D__c - phone__c
I have two csv files for respective object. In the child (customer detail) csv file there will be some records having a common number which is unique in the master (customer) records.
I have created a external id field on the master object to store this unique number.
since I'll be running this through the command line and there will be no human intervention, I won't be able to add the recently added master record id in the child csv file.
i want that while inserting data in the child object, if system can take the external id mentioned in the child csv file and look in the master object with same external id and assign the id of matching master record to the Customer_D__c id in child object.
I have got one post having similar issue Parent Id Apex Data Loader
I tried doing below mapping in the .sdl(mapping file)
but this didn't work for me.
please help me out in this.