Cannot export tickets to CSV

mrudella

On the Open Ticket tab, for example, agents can no longer export tickets to CSV. When the Export button is clicked, it brings up the options of what to select. However, clicking Export again transitions the window to loading, then it switches to a small, white-colored rectangular box. The CSV file is not generated and the user has to refresh the page in order to regain access to OSTicket.

Version 1.17.3
Windows Server 2022
Microsoft IIS/10.0
MySQL 8.0.15
PHP 8.0.27

KevinTheJedi

mrudella

You are using an older version of osTicket. You need to upgrade to the latest and retest.
You are using IIS so you likely have temp directory issues. IIS is notorious for temp directory issues with PHP applications. To resolve this you can either add your own temp directory somewhere with appropriate permissions for a PHP application and update the osTicket code to use this temp directory instead of the system temp directory. OR you can try to resolve the system temp directory issues and retest.

Cheers.

waczny

I still have the same issue too.
What I'm wondering, that I see the file in my Temp folder for a second before it disappears. I can fetch it (and copy it) manually before it disappears. So if IIS would have access issues it wouldn't be able to write into the folder, or am I wrong?
BR waczny

KevinTheJedi

waczny

Depends on the setup and permissions/security policies. I don't use IIS often (only for small testing purposes) so I don't really know how to fully address this issue with PHP and the system temp directory. There are many posts and guides online that explain it though.

If you want to look through the code here is where it all kicks off:

https://github.com/osTicket/osTicket/blob/develop/include/ajax.tickets.php#L2041-L2061

... and this is where we generate the temp file:

https://github.com/osTicket/osTicket/blob/develop/include/class.export.php#L403

... and this is where we write to the file:

... and here is where we push to browser for download:

Cheers.

mrudella

If anyone stumbles across this post with a similar issue, here's what fixed it for me:

https://forum.osticket.com/d/104022-ticket-export-fails-in-118x/9

Modifying permissions on the system temp directory did not help, neither did creating a new custom location. In my case, it must have been something with the amout of time that it was taking the create the files and them getting deleted before getting pushed to the browser.