7 months later

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.

a year later

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!

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

    11 days later

    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!

      a year later

      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

      3 months later

      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!

        a month later

        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.

          5 months later

          ISD

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

          Cheers.

            7 months later

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

              Write a Reply...