Exporting ticket info including CFs, history and attachments

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Exporting ticket info including CFs, history and attachments

Jeff Lucas-2
Hello folks.

I am looking to export RT ticket info to a comma or tab-delimited file.  Another output format would be acceptable, if necessary.

Currently, I select all tickets with ticket ID less than 100000 (we only have ~25000 tickets so that should get all of them) in the query builder page and include all columns.  What is missing is custom field data as well as ticket history and attachments.

Would greatly appreciate if someone could provide guidance around capturing all ticket info in the output file.

Thank you.

-Jeff



--
RT Training in Seattle, June 19-20: http://bestpractical.com/training
Reply | Threaded
Open this post in threaded view
|

Re: Exporting ticket info including CFs, history and attachments

Emmanuel Lacour
On Tue, Jun 11, 2013 at 09:17:55PM +0000, Jeff Lucas wrote:
> Hello folks.
>
> I am looking to export RT ticket info to a comma or tab-delimited file.  Another output format would be acceptable, if necessary.
>
> Currently, I select all tickets with ticket ID less than 100000 (we only have ~25000 tickets so that should get all of them) in the query builder page and include all columns.  What is missing is custom field data as well as ticket history and attachments.
>
> Would greatly appreciate if someone could provide guidance around capturing all ticket info in the output file.
>


Here is a script I made (for 3.6.x, but should almost work with recent
RT) to export tickets and history as xls (and xml) file. Attachments are
exported in a directory per ticket.

--
Easter-eggs                              Spécialiste GNU/Linux
44-46 rue de l'Ouest  -  75014 Paris  -  France -  Métro Gaité
Phone: +33 (0) 1 43 35 00 37    -   Fax: +33 (0) 1 43 35 00 76
mailto:[hidden email]  -   http://www.easter-eggs.com



--
RT Training in Seattle, June 19-20: http://bestpractical.com/training

rt2xls.pl (7K) Download Attachment