@KevinTheJedi

I see the same behavior in my production site.

I add new fields under Columns tab but it does not appear in Export tab.

Attached Both screenshot from Column as well as export. I have added Object ID in New Form, so even after adding in Columns list, its not showing at my site. Let me know if I missed any process in between.


Hi @apyash, from your previous picture. I'm seeing something that could be of help to a problem I've been trying to solve, in reference to "Recommended Solution" and "Resolution Summary".

I would like to reach out to you outside this thread, if you could send me your mail or you reach out to me @ ayomikunjude20@gmail.com, i will be glad.

Thanks

    ayomikunjude I have sent test email from my ID, see if you can suggest solution for the same.

      10 days later

      Is there any solution. Here i explain again the process if someone can suggest solution.

      I have added one New Form for specific Help Topic and under this one Field is created. That field is not coming in Export Option Setting in QUEUE. Is there any other way to add new Form Fields in Export?

      It seems that "Add Other Field" in Export Page of QUEUE is only showing which comes from Default FORM as if I Add any other field on Ticket form then there is no issue, Its showing in Drop Down. BUT If any field which is attached in new Form then its not showing in Export "Add New Field" Option. I believe this condition can be checked and suggested the solution to resolve this.

      Is anyone has solution for this as I have not found solution on anywhwere in forum so far.

      If we are able to Add Custom Form Field in Columns in Display then it should not be issue in Export, but not able to locate the solution.

      Suggest any solution for this if anyone is aware of!!!!

      2 months later

      any news on the issue. I can't understand if the button is a placeholder or this feature is working but we don't use it the right way ?

      a year later

      I too would like a solution to this. Seems odd that we can create a field for display but not use the same field for the export. Any update on this?

      23 days later

      Any update on this? That would ease up so much for getting a statistical report get done! 🙂

      Everyone

      You can not export custom fields from custom forms at this time. You can only export fields from the Ticket Details Form. We will eventually add this support in future versions. Please stay tuned.

      Cheers.

        2 months later

        Hey Guys,
        I got the solution of it. Please find below the steps to do that -

        1. Go to the DB-> table (ost_queue_column) - Copy the primary column value of your custom fields e.g. usercdatafunction, usercdataprocess
        2. Open the file upload-> include-> class.queue.php ; go to the function getExportableFields() -> Add the values in fields Array at last e.g. 'usercdatafunction' => __('Function') and save the file.
        3. Once you have added your custom fields values in an fields array(). You can easily see on the consoles, the values will appear in the list visible during exporting the ticket and also it is visible in export tab of your custom queue.


        Bingo !!! 🙂
        Cheers

          4 months later

          tabrez Hello, doesn't work on 1.14.6 🙁

          After following your steps, i can select field for export in UI(like your screenshots), but i get empty custom field value in exported csv.

          I tried usercdatafieldname, cdatafieldname,
          user          cdata__fieldname.
          I would to export field value from custom form.

          Could you advise something, please?

            10 months later

            Hello KevinTheJedi I am trying to understand if the announcement of 2020 "We will eventually add this support in future versions. Please stay tuned" was finally implemented afterwards, and if this feature is now available in feb 2022 for version 1.16.1. I am currently using v1.15.1 released on February 25, 2021 and I cannot export custom fields in the CSVs generated from Osticket. Thank you in advance for any additional information you will share.

              @cgubi

              No, that just meant it is on our Feature Request list for future versions. We have stopped most major development on the legacy (current codebase) to focus on the full rewrite, v2.0. You can follow the v2.0 roadmap here (which will receive an update soon):

              Cheers.

                Thanks KevinTheJedi but from the roadmap it is not clear if this feature (export custom fields from custom forms) is included in your plans for v 2.0

                As you are facing a major rewriting, could I suggest to take a look also to metrics and statistics? We went through a painful process of excel manipulation to get a graphic representation of simple metrics for our helpdesk. If you are interested in improving your dashboard I could submit more detailed feature requests.

                    cgubi

                    We don’t have our full list of requested features on there as the roadmap is currently what we are working on at the moment or will work on soon. As we progress more items will be added.

                    We always welcome community mods/plugins but as I said any major changes to the current codebase will most likely be rejected as we are focusing on v2.0. Even if you write something and make a pull we still have to review, test, maintain, etc. which we don’t have to time to do.

                    Cheers.

                      2 years later

                      Hope there is an update on this now 🙂

                      Write a Reply...