Exporting ticket info including CFs, history and attachments

RT Users
1

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

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.

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@easter-eggs.com - http://www.easter-eggs.com

rt2xls.pl (7.45 KB)