⚠ In case you've missed it we are migrating 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 forum is read-only and soon will be archived. ⚠

Export only having 1000 records


  • Please log in to reply
3 replies to this topic

#1 Akhilkalapurakkal



  • Members
  • Pip
  • 9 posts

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.



#2 web-johnny


    grocery CRUD Author

  • Administrators
  • 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.




#3 Akhilkalapurakkal



  • Members
  • Pip
  • 9 posts

Posted 20 September 2018 - 10:26 AM

Thank you Johnny. Thank you very much.

#4 FiDo



  • Members
  • Pip
  • 4 posts

Posted 09 September 2020 - 02:41 PM

Thank you too.

This should be changable in /Config/GroceryCrudEnterpris.php

Also tagged with one or more of these keywords: export

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users