Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sunny GSunny G 

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

Hi,

 

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.

 

 

Thanks

bob_buzzardbob_buzzard

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

Hi,

 

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

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

Hi,

 

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
mtbclimbermtbclimber

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".
gv007gv007

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

 

http://wiki.developerforce.com/index.php/Using_Data_Loader_from_the_command_line

 

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.
vswamidassvswamidass

Hi,

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

http://code.google.com/p/dataloadercliq/

 

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

 

Vijay
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 (https://skyvia.com/data-integration/salesforce-data-loader). It is a cloud data integration solution where you can easily set up almost any kind of schedule with no-coding at all.