+ Start a Discussion
BylithiumBylithium 

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

BylithiumBylithium

How do I call process.bat and pass parameters like process_name and path to process-conf.xml file from another .bat file

t1cadmin@scotiacapital.com.devt1cadmin@scotiacapital.com.dev

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

t1cadmin@scotiacapital.com.devt1cadmin@scotiacapital.com.dev

Also, if you are using DataLoader version less than 17, use

 

com.salesforce.lexiloader.process.ProcessRunner

 

command.

BylithiumBylithium

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.

t1cadmin@scotiacapital.com.devt1cadmin@scotiacapital.com.dev

Leave %YourDataLoaderDirectory% as it is in the definition of variables 2-4 - these variables use the YourDataLoader  path defined in the first line.

t1cadmin@scotiacapital.com.devt1cadmin@scotiacapital.com.dev

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

BylithiumBylithium

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