Exporting to CSV

sllbakkbone

Hi there!

Migrating away from osTicket as it doesn't meet our use case at this time, and trying to export all tickets to CSV. Firstly, server info:

Server Information
osTicket Version v1.16.3 (e148727) — Up to date
Web Server Software Apache
MySQL Version 8.0.19
PHP Version 7.3.33

All extensions/settings on the info page are installed and working, and the installation is standard (english, only core module and official extensions)

When I try to export tickets to CSV, after selecting columns and clicking Export:

so far so good...

then we get stuck here

and this error appears in console:
GET https://______/scp/ajax.php/export/zdADv6/check [404 Not Found]

Nothing in PHP error logs etc, just the above occurring.

Any ideas?

KevinTheJedi

sllbakkbone

Do you have URL Rewriting enabled for Apache? Make sure it’s enabled, restart Apache, and retest.

Cheers.

sllbakkbone

KevinTheJedi no luck there unfortunately - although I don't have root access to restart Apache or make changes, checked that rewriting is on and it is

KevinTheJedi

sllbakkbone

It’s a 404 Not Found and that appears to be the correct url as seen below:

https://github.com/osTicket/osTicket/blob/develop/scp/ajax.php#L256

Can you dig deeper in the browser console network tab to see if it’s returning No Such Export or if it’s strictly just 404?

https://github.com/osTicket/osTicket/blob/develop/include/ajax.export.php#L12

Do you see any other errors being logged somewhere? (general server logs, webserver error logs, PHP error logs, MySQL/MariaDB error logs, osTicket System Logs, Browser Console logs, etc.)

Cheers.

sllbakkbone

KevinTheJedi Ok so fun fact, hadn't noticed that the osTicket logs were showing an email error because we've already disabled the account that site was sending from, so after putting in a different account for the moment... It emails me the CSV upon export

But yes, it is (still, I guess) showing "No such export" - which is even more bizarre since it's emailing the file...?

I mean, technically my problem is resolved because I got the file I wanted but I feel like this is unlikely to be behaviour as intended

KevinTheJedi

sllbakkbone

Yea we’ve seen in some weird instances there is a race condition where the temporary file is deleted before the check call happens and fails to push the file to the browser for download but oddly enough is emailed (I guess because it skips the download step). You can comment out where it deletes the temp file or put a sleep or something before so that it waits ample time before removing the temp file.

Cheers.

sllbakkbone

(and no, no other errors anywhere in any logs etc)

ghmercado

with apologies i would like to revisit this issue as it is happening on my softaculous installed osticket v1.18.1 with Apache, MySQL 10.5.25 and php 8.1.3

Can someone please explain to me "You can comment out where it deletes the temp file or put a sleep or something before so that it waits ample time before removing the temp file." ?

Also, where is the option to email the results of an advanced search? I'd be ok with that at the very least since all the users need is the csv.

Thank you so much.

Finally: The recaptchas in this forum are of out of control and need to be nearly every minute.

KevinTheJedi

ghmercado

There has been some headway on this since. Try the changes I mention here to see:

https://forum.osticket.com/d/104854-fixed-export-blank-page-when-try-to-export-ticket-queue-from-agent-side/7

To get an email of the export simply click “Export” at the bottom of the Queue/Search then click “Yes, Email Me!”.

Lastly, we didn’t develop this forum software nor the reCaptcha plugin so unfortunately I can’t control that.

Cheers.