2

Can we automate the process of a data import operation with the following conditions ?

-> The .csv file containing the data to be imported is present in the particular folder.

-> The custom object (target object of data import) has 5 fields. 4 fields' data is available in the .csv. The fifth field should be set by the data loader itself. It is not a formula field. The fifth field will contain a string data of a Case number.

->The fifth field will be sent as one of the parameters during the batch file invocation.

Improve this question
2
  • So the dataloader should be adding a column? I'm not sure it can do that but an etl tool like talend can.
    – Girbot
    Commented Oct 2, 2014 at 6:36
  • tx..cannot we default the fifth's field value in the .sdl file ?
    – Varun
    Commented Oct 2, 2014 at 8:47

2 Answers 2

Reset to default
3

The dataloader itself cannot modify the data in the csv. However, a shell script (batch file in Windows) can modify the csv before it is passed to the dataloader for loading.

Improve this answer
2
  • tx..cannot we default the fifth's field value in the .sdl file ?
    – Varun
    Commented Oct 2, 2014 at 8:46
  • I don't think so.
    – Dominic
    Commented Oct 2, 2014 at 9:59
2

For Automating the apex data loader through command line refer the following liks.....

It might be useful for your scenario....

http://www.sundoginteractive.com/sunblog/posts/automating-the-apex-data-loader

http://gaganbansalblog4u.com/2013/08/11/cli-data-loader-through-command-prompt-salesforce/

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .