How it all fits and works ? Automate Command Line Data Loader This template will be used to create actual “process-conf.xml” to update records.Ībove 2 xml files will act as a template, in which we will replace parameters like “_serverURL_”,”_userName_” etc… using ANT. Template-process-conf_update.xml (to update records) This template will be used to create actual “process-conf.xml” to extract records. TemplatedCsvExtract extracts to a CSV file." Template-process-conf.xml (to extract records) Sf. = your_encrypted_password_generated_with_securitytoken #Example to generate Pwd - encrypt.bat -e urpassword key.txt #Example to generate Key - encrypt.bat -g somkey Next step would be creating configuration file which will contain server URL, username and password. You will need to download ANT and add path of ANT jar file in environment variable.Īlso, create secret key file and using this file, you will need to create password, check this post to see how to do it. We will be automating all these problem with help of ANT tool. There are many tools available which will auto generate “Process-config.xml”, but again it will be manual operation everytime. If you want to repeat same operation every time then there is no issue however what if you need to modify SOQL everytime ? what if you need to extract data, modify some value and upload back to Salesforce ? There are endless possibilities you may want to perform with Dataloader but everytime you will need to manually generate “ Process-config.xml“, manually update extracted file and then upload. Create field mapping (sdl) file if required.Create “Process-conf.xml” ( here is the problem).Generate Password on basis of Secret key generated.Automate Command Line Data Loaderįollowing are basic steps for CLI Dataloader : Assuming you already have basic knowledge about how CLI Data loader works, I will go more advance in this article. However if you want to automate data related operations, better choice would be Command Line Data Loader. Most of us already know that User interface based Dataloader needs manual interaction by end user. Dataloader by default supports User Interface or Command Line interface. As we know, there are multiple ways to load data inside Salesforce like using Workbench, Jitterbit, API etc… Salesforce also provides standard tool to load data into Salesforce using DataLoader.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |