function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
CillaCilla 

"Extract All" in Data Loader Command Line

Per the Data Loader Command Line documentation, "Extract All" should be a valid argument for Process.Operation. However, it does not work.

I have a process that has been running just fine with the "Extract" argument. Have a need to now use "Extract All" and this is the error that is returned: 
java.lang.RuntimeException: java.lang.IllegalArgumentException: No enum const class com.salesforce.dataloader.action.OperationInfo.Extract All

It seems that "Extract All" is not defined. Am I understanding this correctly? Has anyone encountered & resolved this?
Using: Data Loader v34

Thank you!

Priscilla

Best Answer chosen by Cilla
Champ44Champ44
Try using "extract_all" instead of "Extract All".  The documentation does not make it clear exactly what you should be entering into that field.

All Answers

Naval Sharma4Naval Sharma4
Hi Cilla,

Can you post your config file here?
CillaCilla
Sure!

Config.properties looks like:
#Loader Config
sfdc.connectionTimeoutSecs=120
sfdc.endpoint=[deleted for post]
sfdc.username=[deleted for post]
sfdc.password=[deleted for post]
sfdc.useBulkApi=true
sfdc.bulkApiCheckStatusInterval=5000
sfdc.bulkApiZipContent=false
sfdc.timezone=America/Chicago
sfdc.insertNulls=false
sfdc.loadBatchSize=100
sfdc.maxRetries=3
sfdc.resetUrlOnLogin=true
sfdc.extractionRequestSize=2000
sfdc.truncateFields=true
sfdc.minRetrySleepSecs=2
sfdc.enableRetries=true
sfdc.timeoutSecs=540
sfdc.bulkApiSerialMode=false
sfdc.debugMessages=false
process.encryptionKeyFile=C:/temp/key.txt
process.enableExtractStatusOutput=true
process.loadRowToStartAt=0
process.enableLastRunOutput=true
dataAccess.readBatchSize=100
dataAccess.writeBatchSize=500

and process-conf.xml includes:
<property name="configOverrideMap">
            <map>
                <entry key="dataAccess.name" value="insertAccounts"/>
                <entry key="dataAccess.type" value="databaseWrite"/>
                <entry key="process.operation" value="Extract All"/>
                 <entry key="process.outputError" value="C:\ProgramData\salesforce.com\Data Loader\status\errorInsertAccounts.csv"/>
                 <entry key="process.outputSuccess" value="C:\ProgramData\salesforce.com\Data Loader\status\successInsertAccounts.csv"/>
                <entry key="process.mappingFile" value="C:\ProgramData\salesforce.com\Data Loader\conf\SFtoDB_InsertAccountMap.sdl"/>  
                <entry key="sfdc.entity" value="Account"/>
                <entry key="sfdc.extractionSOQL" value="SELECT ID, NAME FROM ACCOUNT WHERE CREATEDDATE = YESTERDAY"/>                       </map>
        </property>
Champ44Champ44
Try using "extract_all" instead of "Extract All".  The documentation does not make it clear exactly what you should be entering into that field.
This was selected as the best answer
CillaCilla
Thanks, Champ! I had tried that previously, but per your post decided to try again since I had recently updated Data Loader with latest version (v37), and it works!

My config file contains the following line:
process.operation=extract_all