[rt-users] Attachment extraction from DB

Ruslan Zakirov ruz at bestpractical.com
Thu Jul 5 08:57:03 EDT 2012

On Tue, Jul 3, 2012 at 8:02 AM, ronald higgins <ronald.higgins at gmail.com> wrote:
> right clicking through 1.2 million tickets might cause some finger strain :)
> indeed, i meant a method to dump directly from mySQL to disk. i shall look
> into how to interact via the api then.

For mysql it's pretty much simple. Just dump whatever in Content column. I would
use Perl API rather than REST for this operation, but it's for you to decide.

> thanks
> On 2 Jul 2012 23:58, "Kevin Riggle" <kevinr at bestpractical.com> wrote:
>> Excerpts from ronald higgins's message of Mon Jul 02 03:41:18 -0400 2012:
>> > Hi All,
>> >
>> > Has anyone ever had to extract files (docs,pdf's) out of the RT DB
>> > onto files on the filesystem? If so would you mind sharing how you
>> > went about it?
>> To be terribly snarky, I went to the attachment I wanted in RT's web UI,
>> right-clicked on the link, and selected 'Save link as'.
>> Look at lib/RT/Attachment.pm and the places it's used for how RT does
>> it, using the Perl API.  And that's mostly just taking the information
>> that running 'describe Attachments' in your favorite SQL DB will tell
>> you exists in the database and putting it in the right places.
>> Best,
>> - KevinR

Best regards, Ruslan.

More information about the rt-users mailing list