• Keerthi P 5
  • 0 Points
  • Member since 2016

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 2
Hi Everyone,

We are trying to extract delta loads from SF, using Data loader. Can any suggest how to pass value dynamically to sfdc.extractionSOQL parameter value. 




I use the Apex dataloder in CLI mode for an extract operation and I would like to specify one or more criteria in my SOQL query stored in my process-conf.xml file as below:


<entry key="sfdc.extractionSOQL" value="Select Id, Name, fle__Field1__c, fle__Field2__c FROM fle__DLObject1__c where fle__OtherExtId__c = 1"/>

How to do to pass a parameter ? Here to replace dynamically the '1' ?


Thanks in advance for your help.


  • October 22, 2012
  • Like
  • 0

I want to use Apex Data Loader for integration through CSV files (ERP to SFDC).

There would be a one time initial dump of data and then incremental updates.

On incremental updates, I want to be able to include a date in the csv file. E.g accounts042409.txt for new accounts on 24th April 09.


Is there anyway of doing this?

The process-conf.xml seems to require the name of csv file. I am not sure if I can wildcard it...  I haven't tried it, but would accounts*.csv work? 


                <entry key="dataAccess.name" value="R:\SF_data_exchange\accounts.csv"/>