#DataTipOfTheDay 2011-01-11Q: "How do I run Data Loader from the Command Line?"
A: First, to folks who don't see WHY I'd run Data Loader from the Command Line, I'll say two words: it's automated. An automated Data Loader routine (or "script") makes it easy to - load new data on a scheduled basis;
- extract all my critical data on a regular basis; or
- load a set of sample data with one double-click, prior to conducting a demo or training.
Okay, sounds good. How do I do it?
But there are also utilities out there that can build the scripts for you: - This is an old DOS script that does an okay job of generating Data Loader scripts.
- Vijay Swamidass's CLIq is an installable application that generates Data Loader scripts--it also works on Unix boxes.
- My Synchronizer generates Data Loader scripts for every SyncStep run. In the "Run Behavior" dropdown,
- use the "Run SyncSteps" setting to create scripts and then run those scripts;
- use the "Generate Working Files Only" to create scripts, then stop.
|