Skip to main content

How can I export the content (body text) of all my tickets?

  • December 10, 2019
  • 4 replies
  • 2016 views
M
Apprentice

Hey all,


I'd like to do a search for particular keywords in all my company's tickets. Freshdesk doesn't provide a search function for keywords so I figured I'd make an export of all tickets and do the search manually in Excel, because searching ticket by ticket when you have 1,000s of tickets is very time-consuming.


Now that I've made some exports, it seems as if the body text of the tickets isn't included in the export. Doesn't Freshdesk provide this option? 


Thanks in advance for your help.


Gregor


    Did this topic help you find an answer to your question?

    4 replies

    A
    Top Contributor
    • antony.pain
    • Top Contributor
    • 40 replies
    • December 10, 2019

    Hi,


    There is an export button in the tickets menu. You can export all fields from your ticket to CSV or Excel directly. Freshdesk will email you the file.

    O
    Contributor
    Forum|alt.badge.img+7

    @Antony: this only exports the ticket or contact fields plus some time/date fields. It does not export ticket content i.e. description and subsequent discussion.

    M
    Contributor
    • mirko
    • Contributor
    • 3 replies
    • December 22, 2019

    New here, but being a programmer I'd use API to pull it all out, preferably in text format and not HTML. https://developers.freshdesk.com/api/#conversations

    V
    Community Debut

    Hello, 


    The description of the ticket can be obtained from the UI. Click on Show multiline text fields and choose Description. Please refer to the screenshots below:





    To obatin the conversations present in the ticket, you can make use of List all conversations API:
    https://developers.freshdesk.com/api/#list_all_ticket_notes

    Hope this helps.

    Cheers! 

    Reply


    Most helpful members this week

    Terms of UsePrivacy Notice