function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Amol DixitAmol Dixit 

Unable to Load data through Command line Dataloader/ To find Alternative way.

Hi,

 

I want to add schedular to upload Excel sheet everyday through uploader. Is there any way to do that?

 

I have gone through web I found that using command line for Dataloader we can do that. I have done changes in process-conf.xml file as

 

 

 

 <bean id="MyProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Opportunity Upsert job gets the Customer record updates from a CSV file and uploads them to salesforce using 'upsert'.</description>
        <property name="name" value="MyProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="shahid_ali@persistent.co.in"/>
                <!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
                the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
                <entry key="sfdc.password" value="---------"/>
                <entry key="process.encryptionKeyFile" value="c:\dataloader\samples\conf\sample.key"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="TaskSchedular__c"/>
                <entry key="process.operation" value="Insert"/>
                <entry key="process.mappingFile" value="c:\dataloader\samples\conf\scheduleMapping.sdl"/>
                <entry key="dataAccess.name" value="c:\dataloader\samples\data\Schedule_Test.csv"/>
                <entry key="dataAccess.type" value="csvRead"/>
                <entry key="process.initialLastRunDate" value="2006-12-01T00:00:00.000-0800"/>
            </map>
        </property>

 

I have run the code on command line as "process ../conf Myprocess".

 

But it is giving error as:

C:\Program Files\salesforce.com\Data Loader\bin>process ../conf MyProcesscle
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: C:\Users\jeffrey.lai\AppData\Local\Temp\sdl.log (
The system cannot find the path specified)
        at java.io.FileOutputStream.openAppend(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at org.apache.log4j.FileAppender.setFile(FileAppender.java:294)
        at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java
:207)
        at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165)
        at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:3
07)
        at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.ja
va:295)
        at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurat
or.java:176)
        at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfi
gurator.java:191)
        at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOM
Configurator.java:523)
        at org.apache.log4j.xml.DOMConfigurator.parseCategory(DOMConfigurator.ja
va:436)
        at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:999)
        at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java
:867)
        at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java
:773)
        at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionCon
verter.java:483)
        at org.apache.log4j.LogManager.<clinit>(LogManager.java:127)
        at org.apache.log4j.Logger.getLogger(Logger.java:117)
        at com.salesforce.dataloader.process.ProcessRunner.<clinit>(ProcessRunne
r.java:82)
2012-08-06 15:14:29,137 INFO  [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: C:\Program
Files\salesforce.com\Data Loader\bin\..\conf\process-conf.xml
0 [main] INFO com.salesforce.dataloader.process.ProcessConfig  - Loading process
 configuration from config file: C:\Program Files\salesforce.com\Data Loader\bin
\..\conf\process-conf.xml
2012-08-06 15:14:29,193 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
 [C:\Program Files\salesforce.com\Data Loader\bin\..\conf\process-conf.xml]
56 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader  -
Loading XML bean definitions from file [C:\Program Files\salesforce.com\Data Loa
der\bin\..\conf\process-conf.xml]
2012-08-06 15:14:29,196 ERROR [main] process.ProcessConfig getProcessInstance (P
rocessConfig.java:96) - Error loading process: MyProcesscle configuration from c
onfig file: C:\Program Files\salesforce.com\Data Loader\bin\..\conf\process-conf
.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\Program Files\salesforce.com\Data Loader\bin\..\c
onf\process-conf.xml]; nested exception is java.io.FileNotFoundException: C:\Pro
gram Files\salesforce.com\Data Loader\bin\..\conf\process-conf.xml (The system c
annot find the path specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:73)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:61)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:104)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:246)
Caused by: java.io.FileNotFoundException: C:\Program Files\salesforce.com\Data L
oader\bin\..\conf\process-conf.xml (The system cannot find the path specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:110)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
        ... 8 more
59 [main] ERROR com.salesforce.dataloader.process.ProcessConfig  - Error loading
 process: MyProcesscle configuration from config file: C:\Program Files\salesfor
ce.com\Data Loader\bin\..\conf\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\Program Files\salesforce.com\Data Loader\bin\..\c
onf\process-conf.xml]; nested exception is java.io.FileNotFoundException: C:\Pro
gram Files\salesforce.com\Data Loader\bin\..\conf\process-conf.xml (The system c
annot find the path specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:73)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:61)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:104)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:246)
Caused by: java.io.FileNotFoundException: C:\Program Files\salesforce.com\Data L
oader\bin\..\conf\process-conf.xml (The system cannot find the path specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:110)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
        ... 8 more
2012-08-06 15:14:29,202 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loadin
g process: MyProcesscle configuration from config file: C:\Program Files\salesfo
rce.com\Data Loader\bin\..\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:246)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOExc
eption parsing XML document from file [C:\Program Files\salesforce.com\Data Load
er\bin\..\conf\process-conf.xml]; nested exception is java.io.FileNotFoundExcept
ion: C:\Program Files\salesforce.com\Data Loader\bin\..\conf\process-conf.xml (T
he system cannot find the path specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:73)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:61)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:104)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:93)
        ... 3 more
Caused by: java.io.FileNotFoundException: C:\Program Files\salesforce.com\Data L
oader\bin\..\conf\process-conf.xml (The system cannot find the path specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:110)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
        ... 8 more
65 [main] FATAL com.salesforce.dataloader.process.ProcessRunner  - Failed to cre
ate process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loadin
g process: MyProcesscle configuration from config file: C:\Program Files\salesfo
rce.com\Data Loader\bin\..\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:246)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOExc
eption parsing XML document from file [C:\Program Files\salesforce.com\Data Load
er\bin\..\conf\process-conf.xml]; nested exception is java.io.FileNotFoundExcept
ion: C:\Program Files\salesforce.com\Data Loader\bin\..\conf\process-conf.xml (T
he system cannot find the path specified)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:341)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:302)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:73)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:61)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:104)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:93)
        ... 3 more
Caused by: java.io.FileNotFoundException: C:\Program Files\salesforce.com\Data L
oader\bin\..\conf\process-conf.xml (The system cannot find the path specified)
        at java.io.FileInputStream.open(Native Method)
        at java.io.FileInputStream.<init>(Unknown Source)
        at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:110)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
        ... 8 more
C:\Program Files\salesforce.com\Data Loader\bin>

 

Please suggest me if there is another way to do that.. And whats the problem with this command line code? Do I need to do some changes?

 

 

Thak you so much...

 

Warm Regards,

Amol Dixit.

 

 

Jonathan A FoxJonathan A Fox
This might be the best place to start :)

https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/command_line_intro.htm