[rt-users] Removing attachments from tickets

2010-04-01 Thread Atro Tossavainen
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


Re: [rt-users] Removing attachments from tickets

2010-04-01 Thread Torsten Brumm
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?

Torsten

2010/4/1 Atro Tossavainen atoss...@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
http://www.elektrofeld.de

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