You need to sign in to do that
Don't have an account?

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 )?