+ Start a Discussion
Ricardo OrtegaRicardo Ortega 

Schedule Salesforce to upload

I have a csv full of contacts in a server that can be accessed through FTP. What I need is to get that csv and upload it to salesforce every 4 hours. I also need to avoid creating duplicate contacts at the upload time . Besides that, I have to create upload rules that some fields do not change the information if it was changed in Salesforce. For example, i upload a second time the telephone from John, in the csv its 1-800-000-00000 but in salesforce its 1-800-000-00001, so the Salesforce information of that field goes first than the csv. With other fields its the other way around, like an email address in the csv goes first than the email from Salesforce. Any idea how to do this? Thank you very much.

Best Answer chosen by Admin (Salesforce Developers) 
chiranjeevitgchiranjeevitg

You can achieve this using commandline dataloader

 

Check this links

 

http://wiki.developerforce.com/page/Using_Data_Loader_from_the_command_line
code.google.com/p/dataloadercliq/‎
http://help.salesforce.com/apex/HTViewHelpDoc?id=loader_operations.htm

All Answers

chiranjeevitgchiranjeevitg

You can achieve this using commandline dataloader

 

Check this links

 

http://wiki.developerforce.com/page/Using_Data_Loader_from_the_command_line
code.google.com/p/dataloadercliq/‎
http://help.salesforce.com/apex/HTViewHelpDoc?id=loader_operations.htm

This was selected as the best answer
Osvald MarkusOsvald Markus
As an alternative to commandline dataloader take a look at a no-coding solution - Skyvia (https://skyvia.com/data-integration/salesforce-data-loader). Here you can easily set up almost any kind of schedule