function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lourens HeunisLourens Heunis 

Automated csv file import

Hi all,

We are currenlty importing data from an external system that dumps a csv file in a predefined network folder location. We engaged a SF Partner that basically wrote Java Scripts and using a Windows Task Scheduler to read the csv file and then import into SF and send a notificaitn email with the results. This is a very old-school way of doing data integration. I am looking for alternative ways of automatically importing data from csv files on a schedule (e.g. every day at 2PM). Or via API. I'd love to find out how others are doing it ...

Thanks,
Lourens
 
Raj VakatiRaj Vakati
These are few way you can able to do 
  1. Data loader CLI to schedule job and load the data from network folder location 
  2. Javasctipr or node js app to load data into salesforce from network folder location 
  3. Python Apps 
  4. Use some tools like dataloader.io or Informatica 
  5. Build your own apps using java or other technologies

Lot more ...
 
Data Loader 5Data Loader 5
Skyvia (https://skyvia.com/data-integration/salesforce-csv-file-import-and-export) is another great tool to automate CSV files import into Salesforce. It supports complex data transformations and has a bunch of useful features, including related objects and binary files import.