You need to sign in to do that
Don't have an account?
sandra_AB34
Apex data loader command line query
I'm using the Apex data loader command line and wondered if there is a way of including parameters in the query string extractionSOQL to extract data from salesforce. I want to extract all new accounts created that day by a certain user.
The XML from the sample process-conf.xml for a process is :- Code:
Is there a way to extend the SQL string to add a parameter ( say a date stamp )?
- <bean id="databaseAccountExtractProcess" class="com.salesforce.lexiloader.process.ProcessRunner" singleton="false" abstract="false" lazy-init="default" autowire="default" dependency-check="default"> <description>DatabaseAccountExtract job gets account info from salesforce and updates or inserts info into database."</description> <property name="name" value="databaseAccountExtract" /> - <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://www.salesforce.com" /> <entry key="sfdc.username" value="user@mycompany.com" /> - <!-- password specified below is invalid, please generate one using the encrypt.bat utility --> <entry key="sfdc.password" value="1111111111111111" /> <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, Type, ParentId, Phone, AccountNumber, Website, Sic, AnnualRevenue, NumberOfEmployees, TickerSymbol, Oracle_Id__c FROM Account" /> <entry key="process.operation" value="extract" /> <entry key="process.mappingFile" value="c:\dataloader\samples\conf\accountExtractToDbMap.sdl" /> <entry key="dataAccess.type" value="databaseWrite" /> <entry key="dataAccess.name" value="updateAccount" /> </map> </property> </bean>
Is there a way to extend the SQL string to add a parameter ( say a date stamp )?