What are my ticket export options?

Return to top
Have more questions? Submit a request

46 Comments

  • Jessie Schutz
    Zendesk team member

    Hi Andrea!

    I'm not sure I understand your question here...are you trying to export your ticket data, or are you trying to export something from the Advanced Search App?

    0
  • Sean McPartlin

    we exported data using CSV.  we though that would be the simplest way to load tix into a MS SQL database for historical review.  However, we noticed the attachments are missing from the CSV export.      

    What if we did XML export?  Would attachments be in the XML file?  

    What are our options to export the attachments and keep them in order with each ticket?

    0
  • Patrick Bosmans
    Zendesk Customer Advocate

    Hello Sean,

    Our export files do not include the attachments themselves, but instead, links to where those attachments are hosted.

    This is by design for a few reasons, in part because including the attachments would bloat the file and we would be unable to email a file that could grow into hundreds of gbs.  But also because users can request export files regularly and creating a file of that size can lock up our resources that could cause performance issues across accounts.

    I know that other customers have asked about this type of feature in the past and we have recommended posting in our Feedback Forum to see if our Dev team could work this enablement into our platform, but as yet it does not appear to be upcoming on our roadmap.

    0
  • hello

    Hi!

    Our app dont use the in-app zendesk service, instead, we just use zendesk to collect the tickets by api. So when i use the report, i cannot export any details of the tickets but only the number of the certain tag.

    what i would like is that, i can export the description of the tickets sending by users based on each tag. plz help me and this will increase our efficiency a lot! thanks! 

    0
  • Joey

    Hi there-

    As the article mentions, you can export ticket data using our REST APIs; depending on your plan type you can also create a view based on conditions you define and export that.

    0
  • Jay Kelly

    @Andrea McMahon

    you have to select the all pages tick box in the top row of the search options. Then it displays all tickets searched and the downloaded csv file has all of the data

    0
  • Joel Munson

    I am on the Plus plan and this option is not available.

    0
  • Brett - Community Manager
    Zendesk Community Team

    Hey Joel,

    Our Customer Advocacy team will need to enable this on your account to give you access. I'm going to create a ticket on your behalf to get this taken care of.

    Cheers!

    1
  • Dave McManus

    I'm having issues exporting data from the Explore tool. I can't seem to find where to include 'message body and comments.

     

    All I can see is the Subject Line. And that's all I can export. 


    Any ideas where i'm going wrong?

     

    Thanks

    0
  • Gail L
    Zendesk Community Team

    Hi Dave,

    You're not missing anything in Explore. The message body of comments isn't pulled into Explore (or Insights). The export options that include the comment data are XML, JSON, or the API so those are what you want to look at to pull out that data.

    0
  • David Quinn

    Hi,

    I don't have Reports available in Advanced, and I'm not sure where to go to get this.  The Google sheets option mentioned earlier in this thread looks like it would be a great solution for my needs too, but it takes me to a 404 page.  Can you please help?

    0
  • Gail L
    Zendesk Community Team

    Hi David,

    It looks like the Google Sheets app mentioned in the thread has since been removed from the marketplace. I do see at least one Zapier integration coming up in general searches (outside the app marketplace) if you want to explore that.

    Can you clarify what you mean by Advanced though? Where are you looking for the export options?

    If you are looking for the CSV/XML/JSON export options in the Admin settings those do have to be enabled by the Zendesk support team (they aren't enabled by default because not all accounts want this feature on for their own internal security reasons). That can be enabled for you if you're on the Plus/Professional or Enterprise plan by having the account owner reach out.

    0
  • Caroline Bruister

    I am not seeing "reports" as an admin either. I have emailed support. This seems like it should be the default setting. Once I have access I need help pulling a full ticket report that has the tags associated with the tickets and cards from the tickets using the Clubhouse API.

    0
  • Erika Camille Sundian
    Zendesk Community Team

    Hi there,

    Upon checking the internal ticket you raised, your data export option is now enabled.  For more information you may check this article here: Where is the data export option?

    If you have any questions or concerns, please let me know! 😊

     

    0
  • Ricardo Mariano Díaz de León

    Hi, i've created a ticket since last week asking to activate this option but i didn’t receive any answer from you guys. Can you help me this way? i cannot contact you over a chat, always sends me the same option to get in touch. I'm sorry but what a terrible support service.
    For reference my tickets are: #5636990 & #5669093

    0
  • Nicole S. - Community Manager
    Zendesk Community Team

    Hi Ricardo - 

    I just checked and both of those tickets have been responded to, and data export has been enabled in your account, so you should be all set. Let us know if other questions come up!

    0

Please sign in to leave a comment.

Powered by Zendesk