Apex Code Development You need to sign in to do that
Don't have an account?
nelrib88 Issues with large datasets
im working on integrating salesforce with my companies crm software. i have created a button in the salesforce campaign tab that alllows a user to upload all the members of the campaign to my companies database. My issues arise when a user tries to upload a campaign that is bigger than the 10000 row limit for soql queries. im looking for some advice on how i would be able to get more than 10000 rows of data from salesforce.
Batch Apex might help you.
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_batch_interface.htm
All Answers
Batch Apex might help you.
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_batch_interface.htm
i was initially thinking that the Batch API was used only to send data to salesforce and would not work in the opposite direction. Was i wrong in assuming that.
Yes, you were. The Batch API is for processing large amount of information in nice way. What it allows is to go through large amount of data (millions of records) using relatively small batches ( maybe 1000 records). Each batch runs in it's own context, with it's own governor limits. You can do whatever you like in a batchable process.
Read the link and you'll see examples on how to use it.