KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

CSV export failed #2497

Closed Epitello opened this topic on on Dec 15, 2021 - 2 comments

Epitello commented on Dec 15, 2021

Hi,

When I try to export data of a chart in csv, an 500 error occures.

We have a lot of rows to export, How can we do ?

Thanks

KoolReport commented on Dec 15, 2021

Could you please use error_reporting(E_ALL); on top of page so that php will give you detail error rather than just general 500 error code.

Sebastian Morales commented on Dec 16, 2021

How many rows were you trying to export? If it's a lot pls consider using BigSpreadsheetExportable, which uses stream to read/write to save memory and time at the cost of less customization and chart, instead of ExcelExportable, which normally requires more memory and time but is more customized. Here's the demo:

http://localhost/htdocs/KoolReport/koolreport_examples_dong/reports/excel/big_spreadsheet/

The example code is at the end of the page. One note is that to export to CSV with big spreadsheet you still need an excel view instead of using a datastore name directly.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None