> On Nov 23, 2016, at 4:14:14 PM, rt-users-requ...@lists.bestpractical.com > wrote: > > Date: Wed, 23 Nov 2016 10:05:27 -0500 > From: "Eddie Jones" <ejo...@eastontelecom.com> > To: <rt-users@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:ejo...@eastontelecom.com] > Sent: Wednesday, November 23, 2016 9:55 AM > To: 'rt-users@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 --------- RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Los Angeles - January 9-11 2017