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
MegachuckmcMegachuckmc 

Defining a Related Object in Data Loader

I'm setting up the process-conf.xml file to set up a series of Upsert processes and can't find a Configuraton Parameter for Related Objects...

 

'sfdc.externalIdField' allows me to specify the External ID field used for data matching which in the GUI corresponds to

 

Step 2a: Choose your field to use for matching --> sfdc.externalIdField

 

Step 2b: Choose your related objects --> ???

 

 

I can't find any mention of this in any of the Data Loader documentation...

 

Any help is greatly appreciated!

 

Mike

 

 

 

 

 


Best Answer chosen by Admin (Salesforce Developers) 
GoForceGoGoForceGo

As long as your mapping file (.sdl) maps correctly to foreign keys it  works. You can create this file using the UI version of Data Loader using step 2b. you describe 

 

Let's say you are trying to upsert B records that have a lookup to object A.

 

So in the process-conf.xml would only reference B's sfdc.externalIdField.

 

<entry key="sfdc.externalIdField" value="B_ID__c"/> (equivalent of step 2a).

 

The mapping file would have something to effect: 

 

A_ID =A__r\:A_ID__c (UI step 2b will generate this reference)

 

Where A_ID is the column name in your .csv file, A_ID__c is the external ID for your object A.

All Answers

GoForceGoGoForceGo

As long as your mapping file (.sdl) maps correctly to foreign keys it  works. You can create this file using the UI version of Data Loader using step 2b. you describe 

 

Let's say you are trying to upsert B records that have a lookup to object A.

 

So in the process-conf.xml would only reference B's sfdc.externalIdField.

 

<entry key="sfdc.externalIdField" value="B_ID__c"/> (equivalent of step 2a).

 

The mapping file would have something to effect: 

 

A_ID =A__r\:A_ID__c (UI step 2b will generate this reference)

 

Where A_ID is the column name in your .csv file, A_ID__c is the external ID for your object A.

This was selected as the best answer
MegachuckmcMegachuckmc

Thanks for this great explanation!

 

I had come to the same conclusion after much hand-wringing when I noticed that once I got the External Id fields set up properly then the Foreign keys just worked.  I think my problem was that the fields I created were so closely named that when I set up the .conf file I was using the wrong field. 

 

I appreciate your help! 

 

 

Mike

vanrentvanrent

Could I have just a little more explanation on this, please? Just getting started in Sales Force. I've got the mapping done successfully and can run the upsert through the Data Loader Wizard, but cannot get it to run from the command line. I'm unclear about 'B records' in the previous post.

 

I am trying to upsert Accounts. The field in my csv file is CID and the custom field in SalesForce is RMAcctNbr_c. What do I set the entry key value?

 

<entry key="sfdc.externalIdField" value="????"/>

 

When I run the command line, I'm getting the following message:

 

2012-11-12 13:57:56,821 ERROR [accountUpsert] progress.NihilistProgressAdapter d
oneError (NihilistProgressAdapter.java:58) - Field name provided, RMAcctNbr_c do
es not match an External ID for Account

 

Any help would be appreciated!

 

Connie

kishore ankishore an

connie, Are you sure the external id field is RMAcctNbr_c and not RMAcctNbr__c ( with 2 underscores before c). Usually when you create custom field, it would be <field name>__c.  Also make sure to check the external id on the field.

vanrentvanrent

Thank you, kishore....that was the problem!

ranker dexranker dex
The subject of money is perhaps more discussed than any other subject. The reason is not far-fetched. Modern commerce has no other instrument or vehicle to operate than money. 꽁머니 (http://www.https.com//www.mtboan.com/index.php?mid=board_tyGM92)There is no market on earth where money is not required for its transactions. 
Vivek SandurekarVivek Sandurekar
best WhatsApp status to share with friends (https://twilightteens.com/" target="_blank)
Get more good morning quotes now (https://goodmorningquotes.live/" target="_blank)
Lovely morning quotes for your husband and wife (https://morningquotes.online/" target="_blank)
Vivek SandurekarVivek Sandurekar
https://twilightteens.com/rose-status-for-whatsapp/ (https://twilightteens.com/rose-status-for-whatsapp/" target="_blank)

https://twilightteens.com/rain-whatsapp-status/ (https://twilightteens.com/rain-whatsapp-status/" target="_blank)

https://twilightteens.com/whatsapp-marathi-status-in-one-line/ (https://twilightteens.com/rain-whatsapp-status/" target="_blank)

https://twilightteens.com/best-attitude-status/ (https://twilightteens.com/best-attitude-status/" target="_blank)

https://twilightteens.com/romantic-status/ (https://twilightteens.com/best-attitude-status/" target="_blank)

https://twilightteens.com/cool-status-in-hindi/ (https://twilightteens.com/best-attitude-status/" target="_blank)

https://twilightteens.com/cool-status-for-boys/ (https://twilightteens.com/cool-status-for-boys/" target="_blank)

https://twilightteens.com/cool-status-in-english/ (https://twilightteens.com/cool-status-in-english/" target="_blank)

https://twilightteens.com/cool-attitude-status/ (https://twilightteens.com/cool-attitude-status/" target="_blank)

https://twilightteens.com/cool-status/ (https://twilightteens.com/cool-status/" target="_blank)

https://twilightteens.com/life-status-in-english/ (https://twilightteens.com/life-status-in-english/" target="_blank)

https://twilightteens.com/attitude-status-in-english/ (https://twilightteens.com/attitude-status-in-english/" target="_blank)

https://twilightteens.com/attitude-status-in-hindi/ (https://twilightteens.com/attitude-status-in-hindi/" target="_blank)

https://twilightteens.com/motivational-status-in-marathi/ (https://twilightteens.com/motivational-status-in-marathi/" target="_blank)

https://twilightteens.com/whatsapp-status-in-marathi/ (https://twilightteens.com/whatsapp-status-in-marathi/" target="_blank)

https://twilightteens.com/motivational-status-in-hindi/ (https://twilightteens.com/motivational-status-in-hindi/" target="_blank)

https://twilightteens.com/marathi-love-status/ (https://twilightteens.com/marathi-love-status/" target="_blank)

https://twilightteens.com/love-status-in-hindi/ (https://twilightteens.com/love-status-in-hindi/" target="_blank)

https://twilightteens.com/whatsapp-status-in-hindi/ (https://twilightteens.com/whatsapp-status-in-hindi/" target="_blank)

https://twilightteens.com/how-to-hide-online-status-on-whatsapp/ (https://twilightteens.com/how-to-hide-online-status-on-whatsapp/" target="_blank)

https://twilightteens.com/best-motivational-status/ (https://twilightteens.com/best-motivational-status/" target="_blank)

https://twilightteens.com/best-whatsapp-status/ (https://twilightteens.com/best-whatsapp-status/" target="_blank)

https://twilightteens.com/love-status/ (https://twilightteens.com/love-status/" target="_blank)

https://twilightteens.com/life-status/ (https://twilightteens.com/life-status/" target="_blank)

https://twilightteens.com/attitude-status/ (https://twilightteens.com/attitude-status/" target="_blank)

https://twilightteens.com/motivational-status/ (https://twilightteens.com/motivational-status/" target="_blank)

https://twilightteens.com/whatsapp-status-quotes/ (https://twilightteens.com/whatsapp-status-quotes/" target="_blank)

https://twilightteens.com/whatsapp-status-images/ (https://twilightteens.com/whatsapp-status-images/" target="_blank)

https://twilightteens.com/whatsapp-status/ (https://twilightteens.com/whatsapp-status/" target="_blank)
Vivek SandurekarVivek Sandurekar
https://goodmorningquotes.live/good-morning-inspirational-quotes-in-english/ (https://goodmorningquotes.live/good-morning-inspirational-quotes-in-english/" target="_blank)

https://goodmorningquotes.live/good-morning-monday-quotes/ (https://goodmorningquotes.live/good-morning-monday-quotes/" target="_blank)

https://goodmorningquotes.live/good-morning-positive-quotes/ (https://goodmorningquotes.live/good-morning-monday-quotes/" target="_blank)

https://goodmorningquotes.live/good-morning-quotes-for-bf/ (https://goodmorningquotes.live/good-morning-quotes-for-bf/" target="_blank)

https://goodmorningquotes.live/good-morning-quotes-for-gf/ (https://goodmorningquotes.live/good-morning-quotes-for-gf/" target="_blank)

https://goodmorningquotes.live/romantic-good-morning-quotes/ (https://goodmorningquotes.live/romantic-good-morning-quotes/" target="_blank)

https://goodmorningquotes.live/good-morning-quotes-for-him/ (https://goodmorningquotes.live/good-morning-quotes-for-him/" target="_blank)

https://goodmorningquotes.live/good-morning-quotes-for-her/ (https://goodmorningquotes.live/good-morning-quotes-for-her/" target="_blank)

https://goodmorningquotes.live/good-morning-quotes-for-love/ (https://goodmorningquotes.live/good-morning-quotes-for-love/" target="_blank)

https://goodmorningquotes.live/good-morning-love/ (https://goodmorningquotes.live/good-morning-love/" target="_blank)

https://goodmorningquotes.live/good-morning-sunday-quotes/ (https://goodmorningquotes.live/good-morning-sunday-quotes/" target="_blank)

https://goodmorningquotes.live/good-morning-images-with-quotes-for-whatsapp/ (https://goodmorningquotes.live/good-morning-images-with-quotes-for-whatsapp/" target="_blank)

https://goodmorningquotes.live/meaningful-good-morning-quotes/ (https://goodmorningquotes.live/meaningful-good-morning-quotes/" target="_blank)
Vivek SandurekarVivek Sandurekar
https://morningquotes.online/sweet-girls-quotes/ (https://morningquotes.online/sweet-girls-quotes/" target="_blank)

https://morningquotes.online/quotes-about-thursdays/ (https://morningquotes.online/sweet-girls-quotes/" target="_blank)

https://morningquotes.online/quotes-about-sunday/ (https://morningquotes.online/sweet-girls-quotes/" target="_blank)

https://morningquotes.online/morning-funny-quotes/ (https://morningquotes.online/sweet-girls-quotes/" target="_blank)

https://morningquotes.online/good-morning-jokes/ (https://morningquotes.online/sweet-girls-quotes/" target="_blank)

https://morningquotes.online/funny-engaged-quotes/ (https://morningquotes.online/sweet-girls-quotes/" target="_blank)

https://morningquotes.online/cute-girl-quotes/ (https://morningquotes.online/sweet-girls-quotes/" target="_blank)

https://morningquotes.online/touchy-love-quotes/ (https://morningquotes.online/touchy-love-quotes/" target="_blank)

https://morningquotes.online/quotes-for-ex-boyfriends/ (https://morningquotes.online/quotes-for-ex-boyfriends/" target="_blank)

https://morningquotes.online/quote-about-missing-someone-you-love/ (https://morningquotes.online/quote-about-missing-someone-you-love/" target="_blank)

https://morningquotes.online/good-morning-quote-for-him/ (https://morningquotes.online/good-morning-quote-for-him/" target="_blank)

https://morningquotes.online/thursday-motivational-quotes/ (https://morningquotes.online/thursday-motivational-quotes/" target="_blank)

https://morningquotes.online/sunday-motivational-quotes/ (https://morningquotes.online/sunday-motivational-quotes/" target="_blank)

https://morningquotes.online/quotes-on-sacrificing/ (https://morningquotes.online/quotes-on-sacrificing/" target="_blank)

https://morningquotes.online/morning-workout-quote/ (https://morningquotes.online/morning-workout-quote/" target="_blank)

https://morningquotes.online/fit-girl-quotes/ (https://morningquotes.online/fit-girl-quotes/" target="_blank)

https://morningquotes.online/sad-and-depressing-quotes/ (https://morningquotes.online/sad-and-depressing-quotes/" target="_blank)

https://morningquotes.online/hurting-quotes-for-him/ (https://morningquotes.online/hurting-quotes-for-him/" target="_blank)

https://morningquotes.online/hurting-quotes-for-her/ (https://morningquotes.online/hurting-quotes-for-her/" target="_blank)

https://morningquotes.online/cheer-up-quotes-for-friends/ (https://morningquotes.online/cheer-up-quotes-for-friends/" target="_blank)
madhav sharma 1madhav sharma 1
Boss Lady Space (https://www.bossladyspace.com/" style="color:#0563c1; text-decoration:underline) est une professionnelle du marketing digital depuis 2006. Notre expérience à travers le développement de notre blog et de notre boutique ainsi que les formations spécialisées dans le domaine nous ont permis d'améliorer nos compétences dans le domaine du marketing web. Si vous débutez ou si vous avez un site sans avoir aucune connaissance dans le domaine, vous êtes au bon endroit car nous vous éviterons de commettre des erreurs que nous avons nous-mêmes commises dans le passé par manque de connaissances.
 
cam heatingcam heating
Browse Scarborough's largest and most-trusted source for reputable Heating & Air Conditioning home professionals.Cambridge Heating and Cooling (https://www.camheating.com/)