Hi Everyone,
I am only getting 1000 records when I am exporting an excel sheet. Can anyone please help me.
Thanks
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
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 20 September 2018 - 10:26 AM
Thank you Johnny. Thank you very much.
Support →
Bugs / Issues →
Export and Print Not working with GET and POST DataStarted by abhinay1435, 09 Mar 2019 ![]() |
|
![]() |
||
Support →
Bugs / Issues →
Error Export DataStarted by rdroguett, 02 Jan 2019 ![]() |
|
![]() |
||
Support →
Grocery CRUD Enterprise →
Export List IssuesStarted by simricci, 31 Oct 2017 ![]() |
|
![]() |
||
Support →
Grocery CRUD Enterprise →
Export with relations not showing dataStarted by arve, 05 Sep 2017 ![]() |
|
![]() |
||
Support →
Bugs / Issues →
export does not work with bootstrap or flexigridStarted by mckaygerhard, 30 May 2017 ![]() |
|
![]() |
0 members, 0 guests, 0 anonymous users