[rt-users] Exporting ticket info including CFs, history and attachments

Emmanuel Lacour elacour at easter-eggs.com
Wed Jun 12 03:46:33 EDT 2013

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:elacour at easter-eggs.com  -   http://www.easter-eggs.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: rt2xls.pl
Type: text/x-perl
Size: 7629 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130612/0d9c32fc/attachment.pl>

More information about the rt-users mailing list