finalization of the report designer block "Run a query to the database" (data export to Excel)

Good afternoon. For 1 hour you can make such a setting. But you must understand that if there are 500k+ records, then you may not wait for the file and you will have to transfer the upload to a separate cron (as it is now in processes). If you have just a few thousand records there, then there will be no big delays.

[quote] Bodyako Dmitry Employee wrote: Good afternoon. For 1 hour you can make such a setting. But you must understand that if there are 500k+ records, then you may not wait for the file and you will have to transfer the upload to a separate cron (as it is now in processes). If you have just a few thousand records there, then there will be no big delays. [/quote] ok, accepted. issue an invoice

[quote] Bodyako Dmitry Employee wrote: Good afternoon. For 1 hour you can make such a setting. But you must understand that if there are 500k+ records, then you may not wait for the file and you will have to transfer the upload to a separate cron (as it is now in processes). If you have just a few thousand records there, then there will be no big delays. [/quote] Greetings! please note that the upload must be performed in one file. If the number of records does not fit into the excel file due to its limitations, then split into several files. Apparently, in this task https://crm-onebox.com/en/support/reports-and-analytics/3922-otchet-vigruzhat-odnim-faylom/ a person writes that the standard unloading works in such a way that even if the result is placed in one file, then the upload is still formed as several files. Do NOT do this!

[quote] Bodyako Dmitry Employee wrote: The work has been uploaded. Click the "Export to XLS" button, all data will be in one file [/quote] I made a test report with the request http://crm.swisstrade.com.ua/admin/report/desiner/19/view/ . Unloading does not work (throws out to a blank page). can you tell me why?

This is not a blank page, but a fatal page. It occurs because php does not have enough memory to form the file you need. Increase memoty_limit for php in php.ini settings ps I wrote it a little more in the engine on the specified box, so you can see now.

[quote] Bodyako Dmitry Employee wrote: This is not a blank page, but a fatal page. It occurs because php does not have enough memory to form the file you need. Increase memoty_limit for php in php.ini settings ps I wrote it a little more in the engine on the specified box, so you can see now. [/quote] helped. I close the task. thanks for the comment! if you "drank" some kind of alert like "the file is too large, change the request", then in the future this will completely exclude bug reports in your direction

the fact that there is not enough memory becomes clear only at the moment the file is formed and not before it, so any alerts are still quite a problematic thing, because boxing does not know whether it will have enough memory or not

[quote] Bodyako Dmitry Employee wrote: the fact that there is not enough memory becomes clear only at the moment the file is formed and not before it, so any alerts are still quite a problematic thing, because boxing does not know whether it will have enough memory or not [/quote] ok