function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Data Loader Ant Tool



The following process definition with Ant Tool  works in Sandbox but does not work in Production. The extracted account.csv file for production contains empty string values for the ID column whereas in Sandbox the ID column contains expected values for the extract records. Any idea why this does not work in production. Secondly, is hard delete possible with Ant Tool?


Thanks in advance for your time. 


 <bean id="accountExtract"



      <description>AccountExtract job gets account info from salesforce and saves info into a CSV file"</description>

        <property name="name" value="accountExtract"/>

        <property name="configOverrideMap">


                <entry key="sfdc.debugMessages" value="false"/>

                <entry key="sfdc.debugMessagesFile" value="..\extract\account.log"/>

                <entry key="sfdc.endpoint" value=""/>

                <entry key="sfdc.username" value=""/>

                <entry key="sfdc.password" value="xxxxa04f895004e1fe4f0e70b"/>

                <entry key="process.encryptionKeyFile" value="test.key"/>

                <entry key="sfdc.timeoutSecs" value="600"/>

                <entry key="sfdc.loadBatchSize" value="200"/>

                <entry key="sfdc.entity" value="Account"/>

                <entry key="sfdc.extractionRequestSize" value="500"/>

                <entry key="sfdc.extractionSOQL" value="Select Id FROM Account WHERE RecordTypeId not in  (Select Id from RecordType Where Name = 'Provider Group')"/>

                <entry key="process.operation" value="extract"/>

                <entry key="process.mappingFile" value="..\extract\accountMap.sdl"/>

                <entry key="dataAccess.type" value="csvWrite"/>

                <entry key="process.statusOutputDirectory" value="..\status"/>

                <entry key="" value="..\extract\account.csv"/>

                <entry key="process.outputError" value="..\status\errorExtractAccount.csv"/>

                <entry key="process.outputSuccess" value="..\status\successExtractAccount.csv"/> 

                <entry key="sfdc.useBulkApi" value="true"/>

                <entry key="process.enableLastRunOutput" value="false"/>