+ Start a Discussion
Amol DixitAmol Dixit 

Taking One day less as "Europian Date format Set to True." in Dataloader CLI.

Hi,

 

I have created Configuration file to schedule Dataloader through CLI(Command Line Interface). I have setted Time Zone as "GMT", and Use Europian Format as a true. But it is taking one day less.

 

That means reading one day less from actual date.

 

 

Please provide me the solution for this.

 

 

  <map>
                <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\accountMasterSoapTrace.log"/>
    
    <entry key="process.outputError" value="c:\Program Files\salesforce.com\Data Loader\Test\error.txt"/>
                <entry key="process.outputSuccess" value="c:\Program Files\salesforce.com\Data Loader\Test\success.txt"/>
    <entry key="sfdc.endpoint" value="/>
                <entry key="sfdc.username" value="--"/>
                <!-- 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:\Program Files\salesforce.com\Data Loader\Test\key.txt"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.externalIdField" value="AX_object__c"/>
                <entry key="sfdc.entity" value="AX_object__c"/>
                <entry key="process.operation" value="insert"/>
               <entry key="sfdc.timeZone" value="GMT"/>
              <entry key="process.useEuropeanDates" value="true"/>
              <entry key="dataAccess.name" value="c:\Program Files\salesforce.com\Data Loader\Test\SFData.csv"/>
              <entry key="process.mappingFile" value="c:\Program Files\salesforce.com\Data Loader\Test\axmapping.sdl"/>    
                <entry key="dataAccess.type" value="csvRead"/>
                <entry key="process.initialLastRunDate" value="2005-12-01T00:00:00.000-0800"/>
            </map>

 

 

Thank you.

 

Warm Regards,

Amol Dixit.

sharad bansalsharad bansal
Did anybody found the solution to this issue?
As i am using the same with inserting the normal records through Dataloader CLI but with containing the record with a date column but still it is saving the records with error-"Collection Updated with -1 Day".