⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Export only having 1000 records



Akhilkalapurakkal

Akhilkalapurakkal
  • profile picture
  • Member

Posted 19 September 2018 - 06:57 AM

Hi Everyone,

 

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

 

Thanks


web-johnny

web-johnny
  • profile picture
  • Administrator
  • 1,166 posts

Posted 20 September 2018 - 06:50 AM

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

Akhilkalapurakkal
  • profile picture
  • Member

Posted 20 September 2018 - 10:26 AM

Thank you Johnny. Thank you very much.


FiDo

FiDo
  • profile picture
  • Member

Posted 09 September 2020 - 14:41 PM

Thank you too.

This should be changable in /Config/GroceryCrudEnterpris.php