Jump to content


Export only having 1000 records

export

  • Please log in to reply
2 replies to this topic

#1 Akhilkalapurakkal

Akhilkalapurakkal

    Newbie

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

 

Thanks



#2 web-johnny

web-johnny

    grocery CRUD Author

  • Administrators
  • 1,101 posts
  • LocationLondon

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


Posted Image

#3 Akhilkalapurakkal

Akhilkalapurakkal

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 20 September 2018 - 10:26 AM

Thank you Johnny. Thank you very much.







Also tagged with one or more of these keywords: export

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users