You need to sign in to do that
Don't have an account?
Linda 98
data loading
I/Client need a process of data loading where they can run script or something.. whenever they want like....daily/weekly (based on their time) and data will be loaded from excel file(csv file) to salesforce custom objects.
What would be best way??
You can schedule it using windows scheduler to run daily /weekly basis
Have a look here http://www.sundoginteractive.com/sunblog/posts/automating-the-apex-data-loader
All Answers
You can schedule it using windows scheduler to run daily /weekly basis
Have a look here http://www.sundoginteractive.com/sunblog/posts/automating-the-apex-data-loader
You can also think of ETL tools e.g. informatica cloud for the same where you have a drag and drop wizards.
The best solution in this case will the using the Data Loader CLI (Command Line Interface) utility, subject to the following condition:
1. The data only needs to be pushed into Salesforce.com and not any other system.
2. Data is clean and does not require any cleansing or de-duplication
3. Data does not require any transformation
4. You/Client is not willing to invest into ETL tools like Informatica, Cast Iron etc
In case you are looking for data transformation, cleansing and de-deuplication capabiities, then I believe you would probably need to explore an ETL tool as Data Loader CLI will not do the trick for you in this scenario.
Hope this helps!
You can schedule your Data loader. for this you can follow below links
http://wiki.developerforce.com/index.php/Using_Data_Loader_from_the_command_line
http://www.youtube.com/watch?v=8NiCjSqk6HA
Thanks
Sent from my iPhone
https://code.google.com/p/dataloadercliq/
Thanks friends!!!!