Custom Form Field in Export

ScoFlo

Also interested in this answer, thanks

apyash

ntozier Thanks for support. I am sure dev will share either correct process or solution for this to use Custom form so their field data available in excel export as available for display.

apyash

See if I can get suggested solution for this soon for this at least.

apyash

ntozier Any update recd from dev?

ntozier

If there was an update from the devs it would be posted here.

apyash

Any Luck on this issue fixing so far?

KevinTheJedi

@apyash

Okay, then how it will be linked to specific Help Topic as I need this field to be dynamic based on Help Topic selection. Is there any way where I can use this in Ticket details form where list will be changed as per help topic selection?

We do not have a "dependent fields" feature at this time so you cannot have a field that depends on another field to populate data. There is no way to accomplish this at this time unless you modify the code. You can however have fields appear when choosing certain Help Topics but that about it.

One more thing as we have given option QUEUE display of this field than it can be done in Export also as both are one or same thing, see if I can get some clue to change in core files at my end for this

Unfortunately, the Export fields selection is basic for now as it only includes Ticket Details form fields. We plan to add all fields including custom fields to exports in the future so please stay tuned.

Cheers.

lvivianar

Is there any update to add custom form fields to the export option?

mechbaral

Was just wondering, exporting the columns value that are listed in the page might solve the problem isn't, because we can list those number in the search the only question is about the exporting. So if we export what is displayed then we can export the custom fields also right.

CHAHCHAH

Hey OST team. Joined in to dig for this feature and saw there was a thread on it. I would love this feature in our build as well. Any update on the progress of exporting custom fields?

Thanks!

ntozier

You can already export custom fields. The caveat to that is that they have to be located on Ticket Details form.

CHAHCHAH

ntozier Right. We see that from KevenTheJedi's post above:
"Unfortunately, the Export fields selection is basic for now as it only includes Ticket Details form fields. We plan to add all fields including custom fields to exports in the future so please stay tuned."
Currently, our environment would benefit greatly from being able to export custom fields outside of the Ticket Details form. We use a number of custom forms that we'd love to pull data on without having to dive into SQL every time.

Thank you. Also: Love this project. OSTicket is excellent!

manojphutela

I have added few fields in ticket details form which i am able to export as per below screen shot, however i am unable to find closed by field in the export list, is there any way, i can add that field and get this exported along with the above list.
May be addition in any of the data tables, or through admin page. Please suggest

ethan_mllr

Hello,
I had the exact issue and was looking for a solution, and I think I just find a workaround. This worked for me, and if you want to try, please do it at your own risk 🙂

1 - First, add the custom columns to "Columns" in Queues settings page so that you can see the details of them for the next step.
(I have two columns named "IT-Having Issue With" and "Maint-Having Issue With")

2 - Open the database on phpMyAdmin and find the custom columns in ost_queue_column table you want to add to Export and note the value in the primary column. (The screenshot doesn't show the second custom column. I just changed ID, which was 39, of the first custom column)

3 - Open the file /include/class.queue.php, go to line 600ish, and add the value you got from step 2 in the same format as the other lines. (Line number may change. I added whole list of the fields so that you can identify them.)

4 - Finally, go to "Export" tab on Queues page and add these columns.

Hope this will help you!

manojphutela

ethan_mllr
Hello
Thank You for your response, however i do not have expertise in PHP, i would really appreciate if you could help us with the guidelines to do it through mysql

Again, my purpose is to export the data by closed by, when i export the csv , it should have the data who closed the ticket, along with other fields which i am already getting.

miguelss

ethan_mllr Wow...that works perfect!
Thank you very much for sharing this useful information.
You have a beer on your account
M.

ISD

Hope there is an update on this now 🙂

KevinTheJedi

ISD

There is no update. As it currently stands, this feature is slated for v2.0. Stay tuned!

Cheers.