function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sunny GSunny G 

Urgent How to automate uploading a .csv file data to SFDC



I have one .csv file on Server, which has few fields. I simply want to insert that .csv file data to SFDc twice in a week.


Please let me know how can i achieve this functionality. And that is ofcourse should be very practical.





When you say insert into SFDC, does the csv file contain information that should be used to update records, or should it be uploaded as an attachment or a regular document?

Sunny GSunny G



In terms of uploading/inserting the records the contains in the .csv files. Thanks


I'd suggest you use the Salesforce Data Loader running in batch mode.  This will allow you to start the data loader on demand using a particular configuration and process the file.

Sunny GSunny G



I am sorry.. but i have no idea at all.. regarding using data loader in Batch mode. Can you help me from where can i have detailed elaboration on this. Thanks


Try searching the online help (the help link in the upper right corner of every page after you log in) for "data loader batch mode".


Sunny first you need write a property file in xml format then think about how to put it in a bacth mode using OS


here yours work is 2 parts.


1.write a xml file to insert date


2.put it in a server upload it in sfdc based on OS timing(do some research in online).if you find some thing let know.



You might try CLIq, which is a tool I wrote to solve this problem:


It will create a working .bat file (and .sh for *nix) which you can schedule using Windows Scheduler or Unix cron.



Sumit KumarSumit Kumar

Through talend you can achive it ....

Jamie MartinJamie Martin
The practical way to reach it is to upload your data with help of our tool Skyvia ( It is a cloud data integration solution where you can easily set up almost any kind of schedule with no-coding at all.