+ Start a Discussion
Mike McG.ax1035Mike McG.ax1035 

Allowing for "Related objects" in DataLoader CLI Batch process

Using the DataLoader UI I am able to insert records into the PriceBookEntry table that exist in the Product2 table virtue of the related objects setting in the wiazrd (Step 2b) - It works great!

 

Does anyone know if there is a way to achieve this in the process-conf.xml file?

Since the PriecebookEntry does not have an externalid field the setting below is superflous,  can I substitute something in the value attribute that points to an external field in the Product2 table?

 

<entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.externalIdField" value="PON_Id__c"/> 
                <entry key="sfdc.entity" value="PricebookEntry"/>

 

Thanks

Mike

CloudStrickerCloudStricker

Hi Mike ,

 

I think u can give the "ID" filed (i mean the salesforce Id field of the parent object) and you can modify the Map file that you use for the process.

 

You can the modify in the map file as

 

Salesforce ID of the parent object = Parent Object : \ External ID from parent Object

 

I have used this for creating opportunity for a newly created account in a single batch process.

 

You can check out

 

"http://cloudstriker.blogspot.in/2012/03/batch-upload-of-data-to-related-objects.html"

 

Hope this might help