• Ivan@LM__h
  • NEWBIE
  • 0 Points
  • Member since 2011

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I can't seem to pass the sfdc.extractionSOQL property as a parameter on the command line when running the data loader. Other parameters work fine. Is sfdc.extractionSOQL not passable, or is my syntax just off? See my attempts below

 

This works (excluding sfdc.extractionSOQL):

_jvm\bin\java.exe -cp DataLoader.jar;"c:\integration\sqljdbc.jar" -Dsalesforce.config.dir=conf com.salesforce.lexiloader.process.ProcessRunner process.name=SalesforceContactToDB

 

This doesn't (tried to put quotes around it):

_jvm\bin\java.exe -cp DataLoader.jar;"c:\integration\sqljdbc.jar" -Dsalesforce.config.dir=conf com.salesforce.lexiloader.process.ProcessRunner process.name=SalesforceContactToDB sfdc.extractionSOQL="SELECT ID, FIRSTNAME, LASTNAME, EMAIL, PHONE, TESTVALUE__C FROM CONTACT WHERE TESTVALUE__C = 1"

 

Nor this (no quotes):

_jvm\bin\java.exe -cp DataLoader.jar;"c:\integration\sqljdbc.jar" -Dsalesforce.config.dir=conf com.salesforce.lexiloader.process.ProcessRunner process.name=SalesforceContactToDB sfdc.extractionSOQL=SELECT ID, FIRSTNAME, LASTNAME, EMAIL, PHONE, TESTVALUE__C FROM CONTACT WHERE TESTVALUE__C = 1

 

 

 Nor this (escape spaces):

_jvm\bin\java.exe -cp DataLoader.jar;"c:\integration\sqljdbc.jar" -Dsalesforce.config.dir=conf com.salesforce.lexiloader.process.ProcessRunner process.name=SalesforceContactToDB sfdc.extractionSOQL=SELECT\ ID,\ FIRSTNAME,\ LASTNAME,\ EMAIL,\ PHONE,\ TESTVALUE__C\ FROM\ CONTACT\ WHERE\ TESTVALUE__C\ \=\ 1

 

 

Thanks!

Message Edited by patros on 09-18-2009 02:08 PM
Message Edited by patros on 09-18-2009 02:09 PM
  • September 18, 2009
  • Like
  • 0