Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
NeelimaGNeelimaG 

Automate the reading of text files and update SF records

I have a requirement to read multiple files that will be placed on a network drive on a daily basis and update Salesforce records with the data from the file. These are csv files with each value in quotes (to handle the commas in the values).
The process should be automated. Looking for suggestions on possible ways of implementing this. Any code samples will be appreciated.
Thanks in advance.
Prad NethasPrad Nethas
Hey Neelima,

I guess with command line data loader you can achieve this.

Regards
Prad
Prad NethasPrad Nethas
Below are few for your reference.

https://developer.salesforce.com/page/Using_Data_Loader_from_the_command_line
https://developer.salesforce.com/docs/atlas.en-us.dataLoaeder.meta/dataLoader/using_the_command_line_interface.htm

Let me know if it is worked for you.

Regards
Prad
NeelimaGNeelimaG
Data loader is not an option as not all the fields and rows will be used for updates. (I don't have control over the format or content of the files) I guess I am looking for suggestions on possible ways to access the files on the network drive from a scheduled apex job.
NeelimaGNeelimaG
Data loader is not an option as not all the fields and rows will be used for updates. Also, in some cases I need to have logic to set values based on the data in the files. (I don't have control over the format or content of the files)

I guess I am looking for suggestions on possible ways/work arounds to access the files on network drive from a scheduled apex job.
Thanks.