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
Linda 98Linda 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??

 

 

 

 

Best Answer chosen by Admin (Salesforce Developers) 
Avidev9Avidev9
The One and only Apex Datalaoder!
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

Avidev9Avidev9
The One and only Apex Datalaoder!
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
This was selected as the best answer
Rahul_sgRahul_sg
you can use data loader in CLI mode but this requires more effort and knowledge of dataloader CLI.
You can also think of ETL tools e.g. informatica cloud for the same where you have a drag and drop wizards.
AroraAnupAroraAnup

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!
sandeep@Salesforcesandeep@Salesforce

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
Linda 98Linda 98
Yeah

Thanks


Sent from my iPhone
Gunish Rai ChawlaGunish Rai Chawla
The CLI Utility is the best option, but it can be very daunting to new salesforce users. I highly recommend, using CLIq, which is very easy to use, which will quickly create, the CLI scripts, that you can use to run your own scheduling application, on Windows go for the task scheduler, and on linux go for an init script in a cron jobs

https://code.google.com/p/dataloadercliq/
Linda 98Linda 98

Thanks friends!!!!