[rt-users] Attachment extraction from DB

[ronald higgins]

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.

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120703/9a722547/attachment.htm>