Reply
Newbie
Andras
Posts: 1
0

csv.CSVFileReader variable error?

Hi all,

i would like to use dinamic path in my apex loader caller application.

 

In the process.conf i use this parameter: <entry key="dataAccess.name" value="${DataAccess.Name}"/>

i create the path and filename, and call the loader:

java.exe -cp "C:\Program Files\salesforce.com\Data Loader\dataloader-26.0.0-uber.jar" -Dsalesforce.config.dir="D:\work\ADL\conf\XXXlog" -DADL_Clyster.log.dir="D:\work\ADL\XXX" -DdataAccess.name="D:\work\tmp\XXX.input.csv" -Dprocess.outputSuccess="D:\work\tmp\XXX.success.csv" -Dprocess.outputError="D:\work\tmp\XXX.error.csv" com.salesforce.dataloader.process.ProcessRunner process.name=LeadUpsert

 

It works fine the loader is running fine until call CSVFileReader:

 

2013-01-19 13:47:53,109 INFO [main] controller.Controller initLog (Controller.j
ava:388) - The log has been initialized
2013-01-19 13:47:53,125 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: D:\work\ADL\conf\XXX\process-conf.xml
2013-01-19 13:47:53,265 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
[D:\work\ADL\conf\XXX\process-conf.xml]
2013-01-19 13:47:53,359 INFO [transactionUpsert] controller.Controller initConf
ig (Controller.java:326) - config dir created at D:\work\ADL\conf\XXX
2013-01-19 13:47:53,359 INFO [transactionUpsert] controller.Controller initConf
ig (Controller.java:354) - The controller config has been initialized
2013-01-19 13:47:53,375 INFO [transactionUpsert] process.ProcessRunner run (Pro
cessRunner.java:116) - Initializing process engine
2013-01-19 13:47:53,375 INFO [transactionUpsert] process.ProcessRunner run (Pro
cessRunner.java:119) - Loading parameters
2013-01-19 13:47:54,046 INFO [transactionUpsert] config.LastRun load (LastRun.j
ava:96) - Last run info will be saved in file: D:\work\ADL\conf\XXX\transactionUpsert_lastRun.properties
2013-01-19 13:47:54,062 INFO [transactionUpsert] process.ProcessRunner run (Pro
cessRunner.java:127) - Logging in to: https://login.salesforce.com
2013-01-19 13:47:54,062 INFO [transactionUpsert] client.PartnerClient login (Pa
rtnerClient.java:478) - Beginning Partner Salesforce login ....
2013-01-19 13:47:54,109 INFO [transactionUpsert] client.PartnerClient loginInte
rnal (PartnerClient.java:519) - Salesforce login to https://login.salesforce.com
/services/Soap/u/26.0 as user (username cleared from my post :)) )
2013-01-19 13:47:56,234 INFO [transactionUpsert] dao.DataAccessObjectFactory ge
tDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access objec
t: ${DDataAccess.Name} of type: csvRead
2013-01-19 13:47:56,250 INFO [transactionUpsert] process.ProcessRunner run (Pro
cessRunner.java:132) - Checking the data access object connection
2013-01-19 13:47:56,250 ERROR [transactionUpsert] csv.CSVFileReader open (CSVFil
eReader.java:154) - File: D:\work\${DDataAccess.Name} not found. Open fa
iled.

 

What can be wrong? It seems to: The csv.CSVFileReader cant get the created path and filename.

 

Any idea?