+ Start a Discussion
sandra_AB34sandra_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:
- <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 )?