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. Commented Oct 2, 2014 at 6:36
  • tx..cannot we default the fifth's field value in the .sdl file ? 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 ? Commented Oct 2, 2014 at 8:46
  • I don't think so. 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.