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
SFDave_126SFDave_126 

How do I direct Data Loader to back up multiple tables in a process-conf.xml file?

How do I direct the Salesforce Data Loader program for Windows operating systems to back up multiple tables defined in a sample process-conf.xml file? I've tried multiple entry keys like the one below in one <bean> and multiple <bean> ID's with different names directed at each entry key to no avail: 
<entry key="sfdc.extractionSOQL" value="





 
MaltaMalta
Hi, before we get started, I suggest you read https://developer.salesforce.com/forums/?id=906F0000000926hIAA
then I will be providing the xml code where I used to extract the data loader
I used the linux task scheduler to run the code at a certain time, it looks like you need it.

<!-- EXTRACT ACCOUNT-->
    <!-- if we specify mapping file while exporting then it will extract only those fields mention in mapping file -->
    <!-- if we do not specify mapping file then it will extract all fields specified in query -->
    <!-- command:  process.bat "C:\Program Files (x86)\salesforce.com\Data Loader\samples\conf" csvAccountExtractProcess  -->
    <bean id="csvAccountExtractProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>csvAccountExtract job gets account info from salesforce and saves info into a CSV file."</description>
        <property name="name" value="csvAccountExtractProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\sfdcSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://test.salesforce.com/"/> 
                <entry key="sfdc.username" value="kramos@singerlatam.com.dev"/>
                <!-- 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="e6971a5f485ca9fc2c787c739f232f60"/>
                <entry key="process.encryptionKeyFile" value="C:\Program Files (x86)\salesforce.com\Data Loader\bin\key.txt"/>
                <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, Name, CNPJ__c, Status__c, NumeroConta__c, Setor__c, InscricaoEst__c, InscricaoMun__c, CtgCFOP__c, NivelCliente__c, CodigoSAP__c, CPCode__c, RegTribut__c, LimiteDeCredito__c, LimiteDeCreditoLiquido__c, Class_Cli__c, Cons_Final__c, CodigoIv__c FROM Account"/>
                <entry key="process.operation" value="extract"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="C:\Program Files (x86)\salesforce.com\Data Loader\Exportacoes\extractAccounts.csv"/>
            </map>
        </property>
    </bean>
SFDave_126SFDave_126
Hi Malta, sorry but I'm not interested in running Data Loader in Wine under Linux. In your config example, you specify one bean per "sfdc.extractionSOQL" entry key. I have many entry keys because I'm trying to pull from multiple tables at once. The partial solution I found was to ensure any <bean id=>, <property name=>, and <entry key="sfdc.entity" value=> were not the same from a copy and paste. I'm trying another post.