Apex Code Development You need to sign in to do that
Don't have an account?
Megachuckmc 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
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
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.
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
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
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.
Thank you, kishore....that was the problem!
Get more good morning quotes now (https://goodmorningquotes.live/" target="_blank)
Lovely morning quotes for your husband and wife (https://morningquotes.online/" 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)
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)
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)