Exporting Data From RT

RT Users
1

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

logo

2

Hey Eddie,

You can get spreadsheet (TSV) representation of ticket search results -
which could include CFs. I’m not sure about the transaction (txn) history.

Perhaps via REST?

I’m guessing that there isn’t an easy way to get all that.

-mOn Wed, Nov 23, 2016 at 9:05 AM, Eddie Jones ejones@eastontelecom.com wrote:

From: Eddie Jones [mailto:ejones@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

330-659-6700 x234

[image: logo]

RT 4.4 and RTIR training sessions, and a new workshop day!
https://bestpractical.com/training

  • Los Angeles - January 9-11 2017

3

Date: Wed, 23 Nov 2016 10:05:27 -0500
From: “Eddie Jones” ejones@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:ejones@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:

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

4

Le 23/11/2016 � 16:05, Eddie Jones a �crit :

*From:*Eddie Jones [mailto:ejones@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?

http://lists.bestpractical.com/pipermail/rt-users/2013-June/080582.html
for example.

There is also a tool to serialize the RT DB in RT, but it’s targeted to
be use to migrate datas from one instance to another RT one.