November 1

Searching and exporting tickets to CSV

0  comments

Searching

  • In Helpdesk > All Tickets, use the "Search Tickets" box. It searches the ticket subject and message text only. It does not search the customer's name or email, or the text of replies.
  • On the Agent Dashboard, the "Search tickets…" box searches subject and message in the same way. The filter bar (Saved Views) also has a "Customer (name or email)" filter. See "Filters and saved views (personal and shared)".
  • Customers can search their own tickets in My Tickets.

Dashboard lists show at most 50 tickets and hide Closed, Resolved and Merged tickets unless you search.

Exporting to CSV

  1. Go to Helpdesk > All Tickets.
  2. Click "Export CSV", next to the filter controls.
  3. Open the file (tickets-YYYY-MM-DD.csv) in Excel, Numbers or Google Sheets.
HelpDesk WP All Tickets screen in WordPress admin with the Export CSV button and the CSAT and SLA columns

What the export contains

Filters and search do not change the export. It always includes every ticket you are allowed to see, in all statuses except Bin. Agents with "View all tickets" get every ticket; other agents get only their assigned tickets.

ColumnContents
IDThe ticket number
SubjectThe ticket subject
StatusThe current status
PriorityThe priority
DepartmentThe department
Assigned ToThe agent's name
CustomerThe customer's display name (not their email)
CreatedWhen the ticket was created

To work on just some tickets, open the file and filter it in your spreadsheet.

Still stuck? Open a ticket on the support page on ABC and a real person will help.

Was this article helpful?

  • All Tickets
  • CSV export
  • HelpDesk WP
  • search

← Helpdesk WP


Tags


You may also like

Hello world!

Hello world!
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Get in touch

Name*
Email*
Message
0 of 350