Additional Export Data

johnjP

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

ntozier

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.

johnjP

ntozier
Im not sure how to go about what you said. I somewhat understand where to look but I can't convert it to code. I saw the content of class.export.php but I don't clearly know what to do. I'd really appreciate your help.

ntozier

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.

LewisHackfath

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:

adding-column-to-osticket-agent-queues.pdf

168kB

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.

johnjP

LewisHackfath
I can't seem to view your file.
website says {"errors":[{"code":500,"title":"Internal server error"}]}

johnjP

alright, off to the books for now while waiting for wizards come to help out on this topic. Cheers

LewisHackfath

adding-column-to-osticket-agent-queues.pdf

168kB

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

anitasari

LewisHackfath hi can i request to send the link again so i can open?
thank you very much

LewisHackfath

@anitasari i don't actually have it anymore as OST1.12 lets you do this in the admin panel.

ahmedvolks

Hello,
Can you please paste the content of the file here as is not working vua dropbox.

Thanks in advance 🙂