Hello,
when i export grid to excel in prod environment (Linux) , the export steel unfinished on 99%.
Regards
maybe a cell empty or null or quote or dubble quote
No, that work on windows but not on Linux.
and the generated security grids the export works fine, but when i generate a grid from table of users it doesn’t work.
i think the problem is the SQL server collation. but I’m not sure.
do a search in the name of your users, if you find a name such as x’xx or empty, you should know that windows has its default font type, which is not necessarily the case with linux, and a character is not necessarily the same under linux, I already had this case when importing Excel to a table
i did export with a single record and it doesn’t work
i verify this record to be sure if there is no field with abnormal values
I work with mysql or mariadb
first do a print_r or a var_dump,
when all is ok, maybe you can see there:
https://www.the-art-of-web.com/php/dataexport/
i work with MSSQL 2019
when the exportation is blocked i got this warning message in chrome console
Cookie “PHPSESSID_” will be soon rejected because it has the “sameSite” attribute set to “none” or an invalid value, without the “secure” attribute. To know more about the “sameSite“ attribute, read https://developer.mozilla.org/docs/Web/HTTP/Headers/Set-Cookie/SameSite
Have a look in your php.info file. It needs the zip-Module to be activated.
You find further information in your error_log of your http-Server (apache, nginx)