Apex Code Development You need to sign in to do that
Don't have an account?
marys pinda Export Data Command Line + Apex and FTP
Hello,
How do I export my CASES in command line?
I used this tutorial but in the end has many errors:::: http://www.shivasoft.in/blog/salesforce/tutorial-of-command-line-dataloader-salesforce/
Another thing is to make a FTP connection in Apex? I want to export in CSV my CASES and puts them on the FTP server.
Thank you,
How do I export my CASES in command line?
I used this tutorial but in the end has many errors:::: http://www.shivasoft.in/blog/salesforce/tutorial-of-command-line-dataloader-salesforce/
Another thing is to make a FTP connection in Apex? I want to export in CSV my CASES and puts them on the FTP server.
Thank you,
You need to configure you bean file which is process.config file in such a way that it takes an account of the "Case" entitiy object. You can take a below example of process.config file for exporting cases using CLI and modify your config file accordingly:
<bean id="CaseExtractFull" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false">
<!-- WORKING -->
<description>Extracts Case data on a Schedule</description>
<property name="name" value="CaseExtractFull"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.entity" value="Case"/>
<entry key="process.operation" value="extract"/>
<entry key="process.mappingFile" value="C:\dataloader18\conf\CobaltReporting\mappingDocs\CaseExtract.sdl"/>
<entry key="sfdc.extractionSOQL" value="SELECT Id, IsDeleted, CaseNumber, ContactId, AccountId, Type, ParentId, RecordTypeId, Status, Origin, Subject, Priority, IsClosed, ClosedDate, OwnerId, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, Problem_Detail__c, WebID__c, Monthly_Maintenance__c, Resolved_Issue__c, Account_Number__c, WebNum__c, Problem_Code__c, Product_Category__c, Rejected_Reason__c, Reopened_Reason__c, Waiting_On__c, Bugzilla__c, Version_Target__c, Survey_Location__c, Customer_Aware_Of_Issue__c, Bugzilla_Target_Completion_Date__c, AA_Transition_Prerequisites_Status__c, QA__c, Current_Budget__c, Desired_Budget__c, Reason_For_Transition__c, DMA__c, Geographies__c, Brand_Keywords__c, Specialist__c, DBA_Name__c, Domain_Name_Onb3__c, Tagline__c, Validate_Pixel_and_Phone__c , Review_Budget__c, Site_Status__c, Budget_Start_Date__c, Budget_End_Date__c, Ongoing__c, Bug_Reference_Type__c, Suspected_Resolution_Date__c, Reference__c, Proof_or_Publish__c, Follow_Up__c, AA_Transition_Site_Check_Status__c, AA_Transition_Worksheet_Status__c, Post_Transition_Worksheet_Status__c, Map_Prep_Call_Status__c, Initial_Optimization_Plan_Call_Status__c, Optimization_Plan_Implementation_Status__c, Origin_Type__c, Cancel_Reason_Owner__c, Save_Reason__c, Campaign_Management__c, CSI_Type__c, Call_Back_Required__c, Logged_Date__c, ProCare_Quality_Review__c, Products_to_Cancel__c, Program__c FROM Case"/>
<entry key="dataAccess.type" value="databaseWrite"/>
<entry key="dataAccess.name" value="CaseExtract"/>
<entry key="process.outputSuccess" value="c:\dataloader18\conf\CobaltReporting\status\CaseExtractSuccessFull.csv"/>
<entry key="process.outputError" value="c:\dataloader18\conf\CobaltReporting\status\CaseExtractErrorFull.csv"/>
<entry key="process.lastRunOutputDirectory" value="c:\dataloader18\conf\CobaltReporting\lastRun\"/>
<entry key="process.initialLastRunDate" value="2006-04-13T13:50:32.423-0700"/>
<entry key="process.statusOutputDirectory" value="C:\DataLoader18\conf\CobaltReporting\logs\"/>
</map>
</property>
</bean>
Also for FTP connection, please refer links below:
1.https://developer.salesforce.com/forums/ForumsMain?id=906F00000008uSuIAI
2.http://stackoverflow.com/questions/20468863/connect-salesforce-to-ftp-using-http-request
I hope this helps. Please mark this as a "Best Answer" if this has resolved your issue.
I will try!
Data Loader ... \ bin> process.bat "C: \ Program Files (x86) \ salesforce.com \ Data Loader" CaseExtractFull
I have many errors: SpringFramework, other dataLoader.process and others...
What should I do?
Have you got the "CaseExtractFull" bean modified as per your requirement?
Also could you send the entire error message which you are getting?
The errors:
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 (x86)\salesforce.com\Dat
a Loader\process-conf.xml]; nested exception is java.io.FileNotFoundException: C
:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml (Le fichier sp
ÚcifiÚ est introuvable)
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:78)
at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
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 (x86)\salesforce.com\
Data Loader\process-conf.xml (Le fichier spÚcifiÚ est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
... 8 more
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "C:\Program Fi
les (x86)\salesforce.com\Data Loader" csvAccountExtractProcess
2014-05-02 16:06:58,625 INFO [main] controller.Controller initLog (Controller.j
ava:389) - Using built-in logging configuration, no log-conf.xml in C:\Program F
iles (x86)\salesforce.com\Data Loader\bin\log-conf.xml
2014-05-02 16:06:58,628 INFO [main] controller.Controller initLog (Controller.j
ava:391) - The log has been initialized
2014-05-02 16:06:58,630 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: C:\Program
Files (x86)\salesforce.com\Data Loader\process-conf.xml
2014-05-02 16:06:58,697 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
[C:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml]
2014-05-02 16:06:58,699 ERROR [main] process.ProcessConfig getProcessInstance (P
rocessConfig.java:96) - Error loading process: csvAccountExtractProcess configur
ation from config file: C:\Program Files (x86)\salesforce.com\Data Loader\proces
s-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\Program Files (x86)\salesforce.com\Data Loader\pr
ocess-conf.xml]; nested exception is java.io.FileNotFoundException: C:\Program F
iles (x86)\salesforce.com\Data Loader\process-conf.xml (Le fichier spÚcifiÚ est
introuvable)
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:78)
at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
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 (x86)\salesforce.com\
Data Loader\process-conf.xml (Le fichier spÚcifiÚ est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
... 8 more
2014-05-02 16:06:58,701 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loadin
g process: csvAccountExtractProcess configuration from config file: C:\Program F
iles (x86)\salesforce.com\Data Loader\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 (x86)\salesforce.com\Dat
a Loader\process-conf.xml]; nested exception is java.io.FileNotFoundException: C
:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml (Le fichier sp
ÚcifiÚ est introuvable)
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:78)
at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
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 (x86)\salesforce.com\
Data Loader\process-conf.xml (Le fichier spÚcifiÚ est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
... 8 more
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "C:\Program Fi
les (x86)\salesforce.com\Data Loader" CaseExtractFull
2014-05-02 16:38:27,575 INFO [main] controller.Controller initLog (Controller.j
ava:389) - Using built-in logging configuration, no log-conf.xml in C:\Program F
iles (x86)\salesforce.com\Data Loader\bin\log-conf.xml
2014-05-02 16:38:27,575 INFO [main] controller.Controller initLog (Controller.j
ava:391) - The log has been initialized
2014-05-02 16:38:27,575 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: C:\Program
Files (x86)\salesforce.com\Data Loader\process-conf.xml
2014-05-02 16:38:27,645 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
[C:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml]
2014-05-02 16:38:27,645 ERROR [main] process.ProcessConfig getProcessInstance (P
rocessConfig.java:96) - Error loading process: CaseExtractFull configuration fro
m config file: C:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xm
l
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\Program Files (x86)\salesforce.com\Data Loader\pr
ocess-conf.xml]; nested exception is java.io.FileNotFoundException: C:\Program F
iles (x86)\salesforce.com\Data Loader\process-conf.xml (Le fichier spÚcifiÚ est
introuvable)
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:78)
at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
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 (x86)\salesforce.com\
Data Loader\process-conf.xml (Le fichier spÚcifiÚ est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
... 8 more
2014-05-02 16:38:27,645 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loadin
g process: CaseExtractFull configuration from config file: C:\Program Files (x86
)\salesforce.com\Data Loader\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 (x86)\salesforce.com\Dat
a Loader\process-conf.xml]; nested exception is java.io.FileNotFoundException: C
:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml (Le fichier sp
ÚcifiÚ est introuvable)
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:78)
at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
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 (x86)\salesforce.com\
Data Loader\process-conf.xml (Le fichier spÚcifiÚ est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
... 8 more
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "C:\Program Fi
les (x86)\salesforce.com\Data Loader" CaseExtractFull
2014-05-02 16:53:14,620 INFO [main] controller.Controller initLog (Controller.j
ava:389) - Using built-in logging configuration, no log-conf.xml in C:\Program F
iles (x86)\salesforce.com\Data Loader\bin\log-conf.xml
2014-05-02 16:53:14,620 INFO [main] controller.Controller initLog (Controller.j
ava:391) - The log has been initialized
2014-05-02 16:53:14,620 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: C:\Program
Files (x86)\salesforce.com\Data Loader\process-conf.xml
2014-05-02 16:53:14,690 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
[C:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml]
2014-05-02 16:53:14,690 ERROR [main] process.ProcessConfig getProcessInstance (P
rocessConfig.java:96) - Error loading process: CaseExtractFull configuration fro
m config file: C:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xm
l
org.springframework.beans.factory.BeanDefinitionStoreException: IOException pars
ing XML document from file [C:\Program Files (x86)\salesforce.com\Data Loader\pr
ocess-conf.xml]; nested exception is java.io.FileNotFoundException: C:\Program F
iles (x86)\salesforce.com\Data Loader\process-conf.xml (Le fichier spÚcifiÚ est
introuvable)
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:78)
at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
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 (x86)\salesforce.com\
Data Loader\process-conf.xml (Le fichier spÚcifiÚ est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
... 8 more
2014-05-02 16:53:14,690 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loadin
g process: CaseExtractFull configuration from config file: C:\Program Files (x86
)\salesforce.com\Data Loader\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 (x86)\salesforce.com\Dat
a Loader\process-conf.xml]; nested exception is java.io.FileNotFoundException: C
:\Program Files (x86)\salesforce.com\Data Loader\process-conf.xml (Le fichier sp
ÚcifiÚ est introuvable)
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:78)
at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:66)
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 (x86)\salesforce.com\
Data Loader\process-conf.xml (Le fichier spÚcifiÚ est introuvable)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at org.springframework.core.io.FileSystemResource.getInputStream(FileSys
temResource.java:113)
at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:328)
... 8 more
C:\Program Files (x86)\salesforce.com\Data Loader\bin>
My is empty ...
.sdl file is the file wherein you would like to extract your data. This file will get created automatically when export will take place. To configure CLI, the main two important files are process.config and config.properties.
I have 2 errors:
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "C:\Program Fi
les (x86)\salesforce.com\Data Loader\samples\conf" Account
2014-05-05 10:23:24,946 INFO [main] controller.Controller initLog (Controller.j
ava:389) - Using built-in logging configuration, no log-conf.xml in C:\Program F
iles (x86)\salesforce.com\Data Loader\bin\log-conf.xml
2014-05-05 10:23:24,950 INFO [main] controller.Controller initLog (Controller.j
ava:391) - The log has been initialized
2014-05-05 10:23:24,952 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: C:\Program
Files (x86)\salesforce.com\Data Loader\samples\conf\process-conf.xml
2014-05-05 10:23:25,018 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
[C:\Program Files (x86)\salesforce.com\Data Loader\samples\conf\process-conf.xm
l]
2014-05-05 10:23:25,069 INFO [Account] controller.Controller initConfig (Contro
ller.java:327) - config dir created at C:\Program Files (x86)\salesforce.com\Dat
a Loader\samples\conf
2014-05-05 10:23:25,074 INFO [Account] controller.Controller initConfig (Contro
ller.java:355) - The controller config has been initialized
2014-05-05 10:23:25,075 INFO [Account] process.ProcessRunner run (ProcessRunner
.java:116) - Initializing process engine
2014-05-05 10:23:25,075 INFO [Account] process.ProcessRunner run (ProcessRunner
.java:119) - Loading parameters
2014-05-05 10:23:25,397 INFO [Account] config.LastRun load (LastRun.java:96) -
Last run info will be saved in file: C:\Program Files (x86)\salesforce.com\Data
Loader\samples\conf\Account_lastRun.properties
2014-05-05 10:23:25,404 INFO [Account] process.ProcessRunner run (ProcessRunner
.java:127) - Logging in to: https://www.salesforce.com
2014-05-05 10:23:25,407 INFO [Account] client.PartnerClient login (PartnerClien
t.java:478) - Beginning Partner Salesforce login ....
2014-05-05 10:23:25,419 INFO [Account] client.PartnerClient loginInternal (Part
nerClient.java:519) - Salesforce login to https://www.salesforce.com/services/So
ap/u/30.0 as user veronicapurga@hotmail.com
2014-05-05 10:23:26,749 ERROR [Account] client.PartnerClient runOperation (Partn
erClient.java:332) - Error while calling web service operation: login, error was
:
[LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:628)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:505)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:230)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:204)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:15
0)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:990)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:161)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:152)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerCl
ient.java:328)
at com.salesforce.dataloader.client.PartnerClient.loginInternal(PartnerC
lient.java:520)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:488)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:213)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:173)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:168)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:128)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
2014-05-05 10:23:26,757 ERROR [Account] client.PartnerClient loginInternal (Part
nerClient.java:534) - Error while logging in to web service at: https://www.sale
sforce.com/services/Soap/u/30.0, error was:
[LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:628)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:505)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:230)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:204)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:15
0)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:990)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:161)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:152)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerCl
ient.java:328)
at com.salesforce.dataloader.client.PartnerClient.loginInternal(PartnerC
lient.java:520)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:488)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:213)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:173)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:168)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:128)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
2014-05-05 10:23:26,761 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Unable to run process Account
java.lang.RuntimeException: Invalid username, password, security token; or user
locked out.
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:160)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:628)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:505)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:230)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:204)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:15
0)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:990)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:161)
at com.salesforce.dataloader.client.PartnerClient$8.run(PartnerClient.ja
va:152)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerCl
ient.java:328)
at com.salesforce.dataloader.client.PartnerClient.loginInternal(PartnerC
lient.java:520)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:488)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:213)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:173)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:168)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:128)
... 2 more
C:\Program Files (x86)\salesforce.com\Data Loader\bin>
This error generally comes when your security token and password is wrong. Kindly regenerate your security token and then repeat the process. Hopefully this should work.
I reinstalled the Apex Data Loader and kept well IDs and Passwords.
But now I have 2 new errors with relation to Key.txt --> I created Key.txt with the key generated in cmd.
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "C:\Program Fi les (x86)\salesforce.com\Data Loader\samples\conf" Account 2014-05-05 16:03:52,628 INFO [main] controller.Controller initLog (Controller.j ava:389) - Using built-in logging configuration, no log-conf.xml in C:\Program F iles (x86)\salesforce.com\Data Loader\bin\log-conf.xml 2014-05-05 16:03:52,631 INFO [main] controller.Controller initLog (Controller.j ava:391) - The log has been initialized 2014-05-05 16:03:52,633 INFO [main] process.ProcessConfig getBeanFactory (Proce ssConfig.java:103) - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Data Loader\samples\conf\process-conf.xml 2014-05-05 16:03:52,695 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [C:\Program Files (x86)\salesforce.com\Data Loader\samples\conf\process-conf.xm l] 2014-05-05 16:03:52,740 INFO [Account] controller.Controller initConfig (Contro ller.java:327) - config dir created at C:\Program Files (x86)\salesforce.com\Dat a Loader\samples\conf 2014-05-05 16:03:52,741 INFO [Account] controller.Controller initConfig (Contro ller.java:338) - config file created at C:\Program Files (x86)\salesforce.com\Da ta Loader\samples\conf\config.properties 2014-05-05 16:03:52,746 INFO [Account] controller.Controller initConfig (Contro ller.java:355) - The controller config has been initialized 2014-05-05 16:03:52,746 INFO [Account] process.ProcessRunner run (ProcessRunner .java:116) - Initializing process engine 2014-05-05 16:03:52,747 INFO [Account] process.ProcessRunner run (ProcessRunner .java:119) - Loading parameters 2014-05-05 16:03:52,747 ERROR [Account] config.Config initEncryption (Config.jav a:719) - Error initializing encryption for key file C:\Program Files\salesforce. com\Data Loader\Key.txt: Cannot Access Key File: C:\Program Files\salesforce.com \Data Loader\Key.txt 2014-05-05 16:03:52,747 FATAL [main] process.ProcessRunner topLevelError (Proces sRunner.java:238) - Unable to run process Account java.lang.RuntimeException: com.salesforce.dataloader.exception.ConfigInitializa tionException: Error initializing encryption for key file C:\Program Files\sales force.com\Data Loader\Key.txt: Cannot Access Key File: C:\Program Files\salesfor ce.com\Data Loader\Key.txt at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav a:162) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav a:100) at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja va:253) Caused by: com.salesforce.dataloader.exception.ConfigInitializationException: Er ror initializing encryption for key file C:\Program Files\salesforce.com\Data Lo ader\Key.txt: Cannot Access Key File: C:\Program Files\salesforce.com\Data Loade r\Key.txt at com.salesforce.dataloader.config.Config.initEncryption(Config.java:72 0) at com.salesforce.dataloader.config.Config.postLoad(Config.java:634) at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config .java:664) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav a:120) ... 2 more C:\Program Files (x86)\salesforce.com\Data Loader\bin>Create a Folder on your desktop with any name say "DLTest". Within this folder, add the process.config file and config. properties.
Now create two text files with any name say it to be "encrypt.txt" and "key.txt".
Now, when you perform the CLI operations, The second step which is "encrypt -g hclsadsjkhasddajsdlasdka "C:://Desktop:\DLTest\encrypt.txt". In this step the generated key has to be stored in key.txt file which you have created in DLTest Folder.
Now encrypt the passowrd with security token and add that in encrypt.txt file and your process.config file.
I hope this helps.
Please specify.
Thanks.
But now I have 2 new errors with relation to Key.txt --> I created Key.txt with the key generated in cmd.
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "C:\Program Fi
les (x86)\salesforce.com\Data Loader\samples\conf" Account
2014-05-05 16:03:52,628 INFO [main] controller.Controller initLog (Controller.j
ava:389) - Using built-in logging configuration, no log-conf.xml in C:\Program F
iles (x86)\salesforce.com\Data Loader\bin\log-conf.xml
2014-05-05 16:03:52,631 INFO [main] controller.Controller initLog (Controller.j
ava:391) - The log has been initialized
2014-05-05 16:03:52,633 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: C:\Program
Files (x86)\salesforce.com\Data Loader\samples\conf\process-conf.xml
2014-05-05 16:03:52,695 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
[C:\Program Files (x86)\salesforce.com\Data Loader\samples\conf\process-conf.xm
l]
2014-05-05 16:03:52,740 INFO [Account] controller.Controller initConfig (Contro
ller.java:327) - config dir created at C:\Program Files (x86)\salesforce.com\Dat
a Loader\samples\conf
2014-05-05 16:03:52,741 INFO [Account] controller.Controller initConfig (Contro
ller.java:338) - config file created at C:\Program Files (x86)\salesforce.com\Da
ta Loader\samples\conf\config.properties
2014-05-05 16:03:52,746 INFO [Account] controller.Controller initConfig (Contro
ller.java:355) - The controller config has been initialized
2014-05-05 16:03:52,746 INFO [Account] process.ProcessRunner run (ProcessRunner
.java:116) - Initializing process engine
2014-05-05 16:03:52,747 INFO [Account] process.ProcessRunner run (ProcessRunner
.java:119) - Loading parameters
2014-05-05 16:03:52,747 ERROR [Account] config.Config initEncryption (Config.jav
a:719) - Error initializing encryption for key file C:\Program Files\salesforce.
com\Data Loader\Key.txt: Cannot Access Key File: C:\Program Files\salesforce.com
\Data Loader\Key.txt
2014-05-05 16:03:52,747 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Unable to run process Account
java.lang.RuntimeException: com.salesforce.dataloader.exception.ConfigInitializa
tionException: Error initializing encryption for key file C:\Program Files\sales
force.com\Data Loader\Key.txt: Cannot Access Key File: C:\Program Files\salesfor
ce.com\Data Loader\Key.txt
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:162)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: com.salesforce.dataloader.exception.ConfigInitializationException: Er
ror initializing encryption for key file C:\Program Files\salesforce.com\Data Lo
ader\Key.txt: Cannot Access Key File: C:\Program Files\salesforce.com\Data Loade
r\Key.txt
at com.salesforce.dataloader.config.Config.initEncryption(Config.java:72
0)
at com.salesforce.dataloader.config.Config.postLoad(Config.java:634)
at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config
.java:664)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:120)
... 2 more
C:\Program Files (x86)\salesforce.com\Data Loader\bin>