You need to sign in to do that
Don't have an account?
Bylithium
Data Loader from Command Prompt
I have created the process.xml file and I am able to run the data loader from the command line.
I am trying to create a batch file to intantiate the load process...need some help with the batch as I am not able to create one and getting errors
@ECHO OFF
call process ../conf csvExportLeads
How do I call process.bat and pass parameters like process_name and path to process-conf.xml file from another .bat file
Hi, if you are creating the batch file, you will need to call a process through Java similar to the way it is done in the file process.bat.
Note that all the paths need to be specified.
Here is the format I used:
@ECHO OFF
SET YourDataLoaderDirectory=where your data loader is sitting
SET CONFIGPATH=%YourDataLoaderDirectory%\conf
SET javaCmd=%YourDataLoaderDirectory%\_jvm\bin\java.exe
SET jarFile=%YourDataLoaderDirectory%\DataLoader.jar
%javaCmd% -cp %jarFile% -Dsalesforce.config.dir=%CONFIGPATH% com.salesforce.dataloader.process.ProcessRunner process.name=YourProcess > where you want to put your log file
@ECHO ON
Also, if you are using DataLoader version less than 17, use
com.salesforce.lexiloader.process.ProcessRunner
command.
I have put in the path...but it still gives me a error
@ECHO OFF
SET YourDataLoaderDirectory= "Y:\salesforce.com\Apex Data Loader 18.0"
SET CONFIGPATH=%Y:\salesforce.com\Apex Data Loader 18.0%\conf
SET javaCmd=%Y:\salesforce.com\Apex Data Loader 18.0%\_jvm\bin\java.exe
SET jarFile=%Y:\salesforce.com\Apex Data Loader 18.0%\DataLoader.jar
%javaCmd% -cp %jarFile% -Dsalesforce.config.dir=%CONFIGPATH% com.salesforce.dataloader.process.ProcessRunner process.name=csvExportLeads
@ECHO ON
Error Message:
Y:\salesforce.com\Apex Data Loader 18.0\Lead_Insert_To_SFDC>Autoloadleads.bat
'\salesforce.com\Apex' is not recognized as an internal or external command,
operable program or batch file.
Leave %YourDataLoaderDirectory% as it is in the definition of variables 2-4 - these variables use the YourDataLoader path defined in the first line.
In other words:
@ECHO OFF
SET YourDataLoaderDirectory="Y:\salesforce.com\Apex Data Loader 18.0"
SET CONFIGPATH=%YourDataLoaderDirectory%\conf
SET javaCmd=%YourDataLoaderDirectory%\_jvm\bin\java.exe
SET jarFile=%YourDataLoaderDirectory%\DataLoader.jar
%javaCmd% -cp %jarFile% -Dsalesforce.config.dir=%CONFIGPATH% com.salesforce.dataloader.process.ProcessRunner process.name=YourProcess > where you want to put your log file
@ECHO ON
thisis the .bat file which I have created but when I am running its throwing errors
@ECHO OFF
SET YourDataLoaderDirectory="Y:\salesforce.com\Apex Data Loader 18.0"
SET CONFIGPATH=%YourDataLoaderDirectory%\conf
SET javaCmd=%YourDataLoaderDirectory%\_jvm\bin\java.exe
SET jarFile=%YourDataLoaderDirectory%\DataLoader.jar
%javaCmd% -cp %jarFile% -Dsalesforce.config.dir=%CONFIGPATH% com.salesforce.dataloader.process.ProcessRunner process.name=csvMFTVOMData
@ECHO ON