Extracting Salesforce Data Using the Data Loader Command Line

Рет қаралды 17,932

6 жыл бұрын

This is a walk through of how to use the Data Loader in command line mode to extract objects from Salesforce. The last six minutes of the video discusses some troubleshooting.
The video uses a sample batch file and a sample process-conf.xml file that can be downloaded here: flyingpuma.com/extracting-sal...
3/7/2023 Update:
There has been an update to the data loader utility.
At 5:09 in the video I show using the encrypt command with a "-g" handle. This is now "-k" per the updated Salesforce documentation: developer.salesforce.com/docs...
10/13/2023 Update:
I have created a new video using the Winter 2024 (v59.0.0) version of the data loader.
• Extracting Salesforce ...
Feel free to buy me a Thai iced tea! :)
www.buymeacoffee.com/flyingpuma

Пікірлер: 18

@debendraray4600 4 жыл бұрын

Excellent presentation on Dataloader CLI usage

@sofiagroner4557 4 жыл бұрын

So clear and helpful, I could cry tears of joy bless you and your entire lineage

@masterpenky 4 жыл бұрын

Thank you @neshap160 for this very useful introduction to data loader command line. Very much appreciated!

@jyotikumbhar9175 4 жыл бұрын

Great walk through. Thank you!

@nagachaitanyayepuri3016 3 жыл бұрын

Thank you so much for the detailed explanation 🙂

@MT-rv3uh 4 жыл бұрын

Excellent ... wonderful ... very helpful

@25Apr76 5 жыл бұрын

simply fantastic...thx a lots for the info..

@cgobrien4696 5 жыл бұрын

This worked the first time - Thank you so much for making a clear tutorial!

@Starcom23 3 жыл бұрын

This is amazing - if all IT videos on youtube would be like yours - I could sit back and drink pinacollada all day. You have talent please DO MORE!

@flyingpuma 3 жыл бұрын

Glad you enjoyed it!

@stevechan3908 4 жыл бұрын

Cool ！Nice tutorial

@pritipadmabehera6607 5 ай бұрын

Hi, Amazing video. Can we schedule the daily export of data through data loader command line

@flyingpuma 4 ай бұрын

Yes, you can schedule a daily extract using a scheduling application. I have used Windows Task Scheduler to run the extract batch file on a daily/weekly/monthly basis. I did not include a demo of doing this in the video. There is a newer video of the extract process that uses the current version of the Data Loader utility: kzfaq.info/get/bejne/d5uhi7eFvqrXiaM.html

@Marco-bk7ry 2 жыл бұрын

Hi, Thank you. Do you have a video tutorial about import a csv File automate in Salesforce + Ressources like that?

@flyingpuma 2 жыл бұрын

Sorry, no. Thank you for watching the video.

@ankitdeswal2231 Жыл бұрын

Thanks a lot for the wonderful explanation. Can we automate the Update task too ?

@flyingpuma Жыл бұрын

I expect that the answer is yes, but I have never done an update from the command line utility. Most of my work as a data analyst is centered on getting my hands on the data as opposed to the entry and updates. At the time I created this video, I was concentrating on methods of bringing data from Salesforce and other platforms together for further analysis.

@flyingpuma Жыл бұрын

I have created a new video using the Winter 2024 (v59.0.0) verson of the dataloader. kzfaq.info/get/bejne/d5uhi7eFvqrXiaM.html At 5:09 in this video I show using the encrypt command with a "-g" handle. This is now "-k" per the updated Salesforce documentation: developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/loader_encryption.htm