function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ivan@LMIvan@LM 

Using parameters in data loader help!

Hi, Experts - I am running data loader command line export. How can I pass in a parameter to sfdc.extractionSOQL in process-conf file from the .bat, so the export data can vary based on passed in parmameter value ? Thank you.
hitzhitz

Hi,

i have also the same problem here i want daynamic field list of object  instad of  static query

i have written query to extract data.

 

<bean id="ExtractAccounts"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Account CSV 'extract'.</description>
        <property name="name" value="ExtractAccounts"/>
        <property name="configOverrideMap">
            <map>
                <entry key="process.operation" value="extract"/>
                <entry key="sfdc.extractionSOQL" value="select Id, Name from Account"/>
                <entry key="sfdc.entity" value="Account"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="data/Accounts.csv"/>
            </map>
        </property>
    </bean>

 

 

 
sfdcfoxsfdcfox

As far as I'm aware, SOQL bind parameters and SQL-like "*" field lists are not supported. Instead, consider dynamically generating the config files using Perl, PHP, Ruby, or some other scripting language.