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
Fabio RochaFabio Rocha 

Export Very Large CSV

I'm trying to export a large CSV file (150,000 lines) using a batch apex and put the file in a FTP.
When it is about 100,000 lines it throws a heap limit exception.

What could be the best alternative to export a CSV and put it in a FTP folder?
Ashish_SFDCAshish_SFDC
Hi Fabio, 


Please go through the related thread, 

http://salesforce.stackexchange.com/questions/3894/create-csv-file-bigger-than-15-mb-from-within-force-application-no-dataloader


Regards,
Ashish
Osvald MarkusOsvald Markus

An alternative to using a batch apex method is to use 3-rd parties connectors like Talend (coding and desktop) or Skyvia (no-coding cloud-based).
 

https://www.talend.com/ 
https://skyvia.com/