+ Start a Discussion
Amol DixitAmol Dixit 

Dataloader One day less issue..

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="https://login.salesforce.com"/>
                <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>

 

I have Checked the log, Found some entries,

 

<sobj:Allocation_To__c xsi:type="xsd:dateTime">2014-07-11T18:30:00.000Z</sobj:Allocation_To__c>

 

<sobj:Allocation_From__c xsi:type="xsd:dateTime">2012-07-31T18:30:00.000Z</sobj:Allocation_From__c>

 

 

                <userLanguage>en_US</userLanguage>
                  <userLocale>en_US</userLocale>
                  <userName>admin@sfpmoportal.com</userName>
                  <userTimeZone>Asia/Calcutta</userTimeZone>

 

But I is taking wrong date. The fields are of type "Date", but taking as a "dateTime". Please help me out.

 

Thank you.

 

Warm Regards,

Amol Dixit.