Hi,
I am running the free version 1.8.1
I ran a report yielding 3,777 results and when I attempt to select all and export to excel, it does not work and instead of the export popup where you select the fields to export it jumps to the login page. I log back in and am looking at the screenshot attached. I have had no issues if I trim down the report to 829 results. The entity results I am pulling the report on includes 8 filters and 18 non-filter fields.
My assumption is that it has something to do with either a file size constraint or a Query constraint, however it is worth noting that the jump to login page happens instantly as opposed to loading or being frozen for any period of time. Please let me know if there are any ideas on how I can increase whatever constraint there may be.
Problems Exporting large reports
-
- Posts: 2
- Joined: 15 Jun 2017, 02:00
- Name: Drake
- Location: Honolulu
Problems Exporting large reports
- Attachments
-
- screenshot
- screen.png (9.79 KiB) Viewed 4374 times
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Problems Exporting large reports
Try to do next:
1. Open file config/server.php
2. Find line define('STORE_SESSIONS', 'mysql');
3. Replace it to define('STORE_SESSIONS', '');
Let me know if it helps.
1. Open file config/server.php
2. Find line define('STORE_SESSIONS', 'mysql');
3. Replace it to define('STORE_SESSIONS', '');
Let me know if it helps.
-
- Posts: 2
- Joined: 15 Jun 2017, 02:00
- Name: Drake
- Location: Honolulu
Re: Problems Exporting large reports
Thanks. That worked.