On Tue, Jul 3, 2012 at 8:02 AM, ronald higgins <[email protected]> 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" <[email protected]> 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.
