how to insert/update the data from FTP server (CSV File) to Salesforce.com

Using some of the few ways its possible:

1) Using salesforce APIĀ  ( e.g. Java, PHP, .Net APIs )
Using program (JAVA, PHP, .Net) can connect with Salesforce.com and FTP server and read the csv data and insert/update it into salesforce (respective object) based on your requirement.

and then generate jar file and schedule job and its execute based on the scheduled time, if you use php then use it in cronjobs for the schedule purpose.

2) We can also use Salesforce.com Dataloader command line interface ( CLI ) and can schedule .bat on windows or .sh and cron job on Linux / unix.

3) We can use the https://dataloader.io/ as well for read the data from FTP to Salesforce

4) using Jitterbit (http://www.jitterbit.com/solutions/salesforce-integration/salesforce-data-loader/) tool aslo possible

(913)

Written by 

I am Sakthivel Madesh, a certified Salesforce Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 13x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply