Removing attachments from tickets

This is probably a FAQ, but I’m afraid I didn’t find it written up as one.

In the interest of keeping the database size down, I would like to be
able to remove attachments folks have sent in from tickets without
disturbing the tickets themselves in any other way. I seem to remember
having done this once by looking up something and updating the content
of the field that contained the attachment to be NULL, but I didn’t
write it up at the time and can’t remember for the life of me.

Is there a better way to do this? If not, I’d appreciate a run-through
on how to do it again.

Best regards,
Atro Tossavainen (Mr.) / The Institute of Biotechnology at
Systems Analyst, Techno-Amish & / the University of Helsinki, Finland,
+358-9-19158939 UNIX Dinosaur / employs me, but my opinions are my own.
< URL : http : / / www . helsinki . fi / %7E atossava / > NO FILE ATTACHMENTS

Have a look onto this: http://github.com/bestpractical/rt-extension-utils

could possibly useful for you, other way:
RT-Extension-AttachmentsOnDisk written by BPS for us, not yet public
published.

@BPS: Do you have any plan to publish it public?

Torsten2010/4/1 Atro Tossavainen atossava@cc.helsinki.fi:

This is probably a FAQ, but I’m afraid I didn’t find it written up as one.

In the interest of keeping the database size down, I would like to be
able to remove attachments folks have sent in from tickets without
disturbing the tickets themselves in any other way. I seem to remember
having done this once by looking up something and updating the content
of the field that contained the attachment to be NULL, but I didn’t
write it up at the time and can’t remember for the life of me.

Is there a better way to do this? If not, I’d appreciate a run-through
on how to do it again.

Best regards,

Atro Tossavainen (Mr.) / The Institute of Biotechnology at
Systems Analyst, Techno-Amish & / the University of Helsinki, Finland,
+358-9-19158939 UNIX Dinosaur / employs me, but my opinions are my own.
< URL : http : / / www . helsinki . fi / %7E atossava / > NO FILE ATTACHMENTS

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

MFG

Torsten Brumm

http://www.brumm.me