Export Ticket data to spredsheet

Hi:

Users can export the tickets to an XML file but an admin can’t export all the tickets right now.

If you want one user to export their tickets, the option will be under the PRIVACY button on the front-end or the admin can do it for them via the EXPORT button in the user profile screen.

Thanks.

Hi:

Its always been something that we’ve thought about but the demand for it is surprisingly a lot lower than you would think. So when we look at what we should do next something else is always a higher priority.

Plus because there is a parent – child relationship along with random text from tickets, your standard file formats such as CSV files dont’ really work well. Which means even if you had an export, importing to spreadsheets etc isn’t going to be very easy which defeats the purpose of what most users want the export for. Its the reason why our individual user export is in XML format.

So, all in all, its on the table but not sure when its going to get done.

For the opening posts you can do an export using the WP ALL EXPORT plugin. But then you’ll need to do an export of the REPLIES separately and link the two files together manually. If all you need from the data is the basic ticket data itself such as dates, ticket topics and user ids, exporting the TICKET works well – then you can do things like ticket counts and such in a spreadsheet.

Thanks.

Hello – I found this post searching for a way to export ticket data.

When you say “the admin can do it for them via the EXPORT button in the user profile screen.”

I am not exactly certain how to get this this section you referenced in your reply above “user profile screen.” – are you referring to the User section/tab in WordPress or is there some place else where I should look for the user profile screen – if it is the standard WordPress user section I do not see any export options – Could you please tell me the steps needed to get to the user profile section so the ticket data can be exported, or if there are instructions someplace already could you please post a l ink to the instructions for exporting ticket data?

Or do I need to install a specific addon in order to enable ticket detail export functionality?

• This reply was modified 6 years, 11 months ago by tsaffeld.