3 replies to this topic

[Akhilkalapurakkal]

Hi Everyone,

 

I am only getting 1000 records when I am exporting an excel sheet. Can anyone please help me.

 

Thanks

[web-johnny]

Hello @Akhilkalapurakkal,

 

This is a bit of a limitation of the library and we have a task for the next release (2.6.4) to replace the export library by using XLS_Writer (https://github.com/mk-j/PHP_XLSXWriter) 

 

Till then you can have a work-around and add more than 1000 rows but please first check your server limitations before adding a new number as it is taking lot of memory. More specifically go to (if you are using Codeigniter): application/libraries/GroceryCrudEnterprise/grocerycrud/enterprise/src/GroceryCrud/Core/State/ExportState.php and change the line at around line 12 to:

const MAX_AMOUNT_OF_EXPORT = 10000;

As I said earlier this is only a work-around till then new version and you have to test the limitations of your server by trial and error.

 

Regards

Johnny

[Akhilkalapurakkal]

Thank you Johnny. Thank you very much.

[FiDo]

Thank you too.

This should be changable in /Config/GroceryCrudEnterpris.php