+ Start a Discussion
IPFramptonIPFrampton 

Standardising properties in Data Loader beans

Afternoon,

I am currently writing a number of separate beans for a Data Loader command line process I am building that all share a common set of attributes in the same process-conf.xml file. Is there any way that I can have one location for the following keys so that I don't have to maintain them several times in the same process-conf.xml file as this is likely to cause errors?
 
<entry value="false" key="sfdc.debugMessages"/>
<entry value="sfdcSoapTrace.log" key="sfdc.debugMessagesFile"/>
<entry value="endpointurl" key="sfdc.endpoint"/>
<entry value="username" key="sfdc.username"/>
<entry value="password" key="sfdc.password"/>
<entry value="encryptionkeyfile" key="process.encryptionKeyFile"/>
<entry value="600" key="sfdc.timeoutSecs"/>
<entry value="extract" key="process.operation"/>
<entry value="csvWrite" key="dataAccess.type"/>
I have seen something about using a config.properties file but can't find any more on it so was hoping someone could point me in the right direction? I'm using Data Loader v33.
 
Best Answer chosen by IPFrampton
Amit Chaudhary 8Amit Chaudhary 8
Yes . You can use config.properties file like below :-
 
#Loader Config
#
# History
# 2015/23/02	AMIT CHAUDHARY	Created the file 
dataAccess.name=database-conf.xml
dataAccess.readBatchSize=200
dataAccess.type=databaseRead
dataAccess.writeBatchSize=1000

process.enableLastRunOutput=true
process.encryptionKeyFile=C:\\CLI\\conf\\SFDC.key
process.lastRunOutputDirectory=C:\\CLI\\log
#process.statusOutputDirectory=C:\\CLI\\log
process.initialLastRunDate=2010-01-01T00:00:00.000-0800


sfdc.useBulkApi=true
sfdc.bulkApiCheckStatusInterval=5000
sfdc.bulkAPiSerialMode=true
sfdc.bulkApiZipContent=true
sfdc.connectionTimeoutSecs=180
#sfdc.debugMessages=false
sfdc.debugMessages=true
sfdc.debugMessageFile=C:\\CLI\\log\\Dataloader_debug.log
sfdc.enableRetries=true
sfdc.maxRetries=5
sfdc.minRetrySleepSecs=180
sfdc.insertNulls=true
sfdc.loadBatchSize=2000
sfdc.noCompression=false
sfdc.timeoutSecs=180

sfdc.endpoint=https\://test.salesforce.com/
sfdc.username=UserName
sfdc.password= encryptedpasswordWithToken

Please let us know if this will help you.

NOTE :- You need to save this file in Conf folder as config.properties

User-added image


Please reffer below link that will help you:-
https://help.salesforce.com/apex/HTViewHelpDoc?id=using_the_command_line_interface.htm
http://www.jitendrazaa.com/blog/salesforce/tutorial-of-command-line-dataloader-salesforce/
https://code.google.com/p/dataloadercliq/

Please mark this as solution if this will help you. So that if some one have same issue this post can help other also.

Thanks
Amit Chaudhary