We need to run a job on 1000's of records by filtering over an ID. In the dataloader when the condition section doesnt show IN or contains or LIke option.
However i tried to put a condition manually like : ID like ('a','b'). And the extract just pulled the record for 'a' , not for b.
How can I pass multiple Id's in my query?
Also my Id list would be quite a huge list about 3000 : does it look a feasible approach to consider?
The key error appears to be mapping a Java Enum value to a value in XML config file.
java.lang.IllegalArgumentException: No enum const class com.salesforce.dataloader.action.OperationInfo. at java.lang.Enum.valueOf(Unknown Source)
Specifically the OperationInfo enum.
Having had a peak into this Enum I can see it requires the following values...
insert,
update,
upsert,
delete,
hard_delete,
extract,
extract_all
Since Java is case senstiive by default, the following part of your config will need to change to using a value from the above....
<entry key="process.operation" value="extract"/>
The Salesforce documentation gives one example of this in this topic Data Loader Process Configuration Parameters.
However the linked topic, Data Loader Command Line Operations, gives only the labels of these values and not the actual config values needed, which I agree is confusing and misleading in the context from which the page was linked. Hopefully the above list gives future readers the mapping they need! :)
The sourceforge download is most likely the source code for Data Loader, not the actually installable exe for Windows.
To download the current supported version of Data Loader, log into your org, go to Setup > Data Management > Data Loader
From there, you should be able to install.
As of now, according to the official open source repo on github, Data Loader is supported on Windows 7 and XP. So your mileage may vary with Windows 8. But give it a try.
As of Summer 15, the next upcoming release Data Loader is set to expand support to Mac OSX.
Best Answer
LIKE is used to find wildcard matches. Instead, you would want to use the IN operator:
While the Data Loader probably won't show "IN" (because it's not designed to automatically build that filter), IN should definitely produce the desired output.