Hi, need your help on exporting additional data in tickets.
I wanted to add an additional line in the CSV file named "First Response" and the content is the name of the Agent and the timestamp when the first Agent response.
I'm fairly new to sql query and php.
osTicket - v1.10.4
Ubuntu Server 18.04
Apache/2.4.29 (Ubuntu)
PHP 7.2.10-0ubuntu0.18.04.1
Thank you,
John
If memory serves me correctly you would have to edit the include/class.export.php file and add code to display that information. To get that information you would need to look at the ticket find the thread id and then look at the ost_thread_entry table to get the staff_id. Then look up the ost_staff table (using the staff_id) to get the firstname lastname fields.
Sorry I'm not a dev. I can give you guidance but it is up to you to implement your mods. Maybe someone else who is more coding oriented could tell you exactly how to do it, but it is not something that I have ever done directly.
I have added a few custom columns to my queue through some hacks, and I can confirm that they show up on my export.
I have not modified the class.export.php file.
But I have done the following to my tickets.inc.php file:
However I have an issue where I only get a single row in the export... but this is not related to my code changes as it was happening before I made them.
So hopefully the above helps in someway.
alright, off to the books for now while waiting for wizards come to help out on this topic. Cheers
LewisHackfath
I can't seem to view your file.
website says {"errors":[{"code":500,"title":"Internal server error"}]}
Try again
if that doesn't work here is a dropbox link:
https://www.dropbox.com/s/yghh6w6ll1bh0ea/Adding%20Column%20to%20OSTicket%20Agent%20Queues.pdf?dl=0
LewisHackfath hi can i request to send the link again so i can open?
thank you very much
@anitasari i don't actually have it anymore as OST1.12 lets you do this in the admin panel.
Hello,
Can you please paste the content of the file here as is not working vua dropbox.
Thanks in advance 
