Re: [rt-users] Exporting Data From RT

[Emmanuel Lacour]

Le 23/11/2016 à 16:05, Eddie Jones a écrit :
>
> *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?
>
>  
>

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.
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: [rt-users] Exporting Data From RT

[Greg Vernon]

> 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" 
> To: 
> 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  
> 
> 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

Re: [rt-users] Exporting Data From RT

[Matt Zagrabelny]

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.

-m

On Wed, Nov 23, 2016 at 9:05 AM, Eddie Jones 
wrote:

> *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
>
> 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
>
-
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017