Problems Exporting large reports

Post Reply
drakeramore
Posts: 2
Joined: 15 Jun 2017, 02:00
Name: Drake
Location: Honolulu

Problems Exporting large reports

Post by drakeramore »

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.
Attachments
screenshot
screenshot
screen.png (9.79 KiB) Viewed 4046 times
User avatar
support
Site Admin
Posts: 6190
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Problems Exporting large reports

Post by support »

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.
drakeramore
Posts: 2
Joined: 15 Jun 2017, 02:00
Name: Drake
Location: Honolulu

Re: Problems Exporting large reports

Post by drakeramore »

Thanks. That worked.
Post Reply