• Keerthi P 5
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
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. 

Thanks
Kirthy

Hi,

 

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"/>