Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ganesh HegdeGanesh Hegde 

Insert Case Comments from CSV File

HI,

I have a CSV file which contains both case and case comments. I want to insert both into Salesforce and i need to automate this process to run everyday. I need a parent ID to insert Case Comments which i dont have in my CSV.

Is there a way fullfill my requirement without using Java program?

Thanks,
Ganesh
Sforce.NinjaSforce.Ninja
Hi Ganesh,
If you don't want to use any JAVA/ .Net program you could look into automating data-loader using command line. This link elaborates with example on how to do it. 

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

Mark this as best answer if you find the solution.
Ganesh HegdeGanesh Hegde
Hi,

I am using Data Loader only. I can insert a case. But how can i insert Case comments? because it requires a parent id(id of the case)

Thanks,
Ganesh
Iqrar AhmedIqrar Ahmed
Hi Ganesh,
Insert parent id of case in case comment csv file which is present in case csv file.

Regards
Ganesh HegdeGanesh Hegde
Hi,

Thanks for the reply. I do not have parent ID of case in my CSV file. I need to export the data to get parent id. If I do that I will have 2 CSVs and merging the CSVs will become a manual process.

Thanks,
Ganesh