[rt-users] Exporting Data From RT

[Greg Vernon]

> On Nov 23, 2016, at 4:14:14 PM, rt-users-request at lists.bestpractical.com wrote:
> 
> Date: Wed, 23 Nov 2016 10:05:27 -0500
> From: "Eddie Jones" <ejones at eastontelecom.com>
> To: <rt-users at lists.bestpractical.com>
> Subject: [rt-users] Exporting Data From RT
> Message-ID: <004301d2459b$0613bd10$123b3730$@eastontelecom.com>
> Content-Type: text/plain; charset="us-ascii"
> 
> From: Eddie Jones [mailto:ejones at eastontelecom.com] 
> Sent: Wednesday, November 23, 2016 9:55 AM
> To: 'rt-users at lists.bestpractical.com'
> Subject: Exporting Data From RT
> 
> 
> 
> Hello,
> 
> 
> 
> I need to export data from RT, including all ticket information (comments,
> custom field values, etc.).  Is there an easy way to do that?
> 
> 
> 
> Thanks,
> 
> 
> 
> Eddie Jones
> 
> Systems Administrator
> 
> Easton Telecom Services
> 
> www.eastontelecom.com <http://www.eastontelecom.com/> 
> 
> 330-659-6700  x234

Greetings,

You could use SQL to query the DB directly, but that's probably not what you want.  Perhaps a dump of the DB?

What might work for you is the TicketPDF extension:
https://metacpan.org/pod/RT::Extension::TicketPDF

It's a bit ugly to export all of the info, but users seem to be okay with using PDFs.  They can use the search capabilities of their desktop to find things.  Spotlight works great for this.  Of course, re-importing the data isn't an option with it.  One thing to note is that there is a memory leak someplace in the extension, so if you have a really large queue you can find yourself running out of RAM.  It also quietly continues without failing in this situation. 

Cheers!
Greg