+ Start a Discussion

Apex Data Loader Regarding Process.config



below is my  process. file.it is  running fine.I want to make some changes so  it will be generic,Iwant read the soql from a file.How to dothat.if store that file in local is it possisble  to read from there.itreied its showing error.



<bean id="exportAccounts"
        <description>Exports all accounts.</description>
        <property name="name" value="exportAccounts"/>
        <property name="configOverrideMap">
        <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="G:\Apex\Test\logs\accountExport.log"/>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="sm_miky@gmail.com"/> <!-- INSERT YOUR SFDC USERNAME -->
                <entry key="sfdc.password" value="906355326acfbe1ba1297cb7ea61c1bd7d45f70f113639e2e77a1b551285c0d6527790ee11353e9b"/> <!--INSERT YOUR ENCRYPTED SFDC PASSWORD -->
        <entry key="process.encryptionKeyFile" value="G:\Apex\Test\key.txt"/> <!-- INSERT A PATH TO YOUR KEY FILE-->  
        <entry key="sfdc.entity" value="Account"/> <!-- INSERT THE API NAME OF REFERENCED SFDC OBJECT -->
                <entry key="sfdc.extractionSOQL" value="Select Id, Name, Type FROM Account"/> <!-- INSERT DOWN YOUR SOQL QUERY -->
        <entry key="process.operation" value="extract"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="G:\Apex\Test\exports\accountexpo.csv" /> <!-- INSERT A PATH TO YOUR EXPORT FILE -->



If some one have some solution please let me know.