[rt-users] Attachment extraction from DB

[Ruslan Zakirov]

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.