External storage: Users accessing files directly?

I’m experimenting with the plugin (now core) External Storage. The files do not appear to be stored in a format, which would be usable (read only) via something like FTP.

Does anyone have a suggestion on how I could store attachments in a folder structure matching ticket numbers?

EDIT: Even extracting the files (And keep the data in the RT database) would be good.


One why is to create a page which query the Attachment table and join all tickets which refer/use this attachment. but that is a external script/page from RT it self and not smothering you can do with RT it self.

Hello rabin.

Sounds like a good idea. Would you use the RT CLI tools, or are you talking about accessing the database directly (I’d rather use the RT CLI)?