Part 2 – DML operation with CLIq

For other DML operations (Insert, Update, Upsert, Delete), you have to repeat the above steps. It means you will be having different folder for each operation.

Example – For Export we have created Export_Accounts directory structure likewise we have to repeat the same steps for other DML operation.

•  Select the operation and enter different process name.

• Enter the Object API name (Query in case of Export) and create the CLI files.

• It will create folder same as process name 

Instructions for Configuring DML

C:\dataloader\cliq_process\Import_Accounts\read 

• Replace this file with your csv. Do not change the file name. Just replace the existing .CSV file with your file.

• The first row should have the field names. Make sure to update the .sdl file. C:\dataloader\cliq_process\Import_Accounts\config\Import_Accounts.sdl.         

• Open processname/config/processname.sdl. Create a mapping with the CSV column header on the left and the Salesforce Field on the right.

Note: Insert will not require id mapping, update/delete requires id mapping. 

Now the configuration part is done. Just we need to schedule the bat file, which can be scheduled on Windows using Windows Scheduler.

Thanks!!