[rt-users] Archiving old tickets

[Rehan van der Merwe]

Hi,

For those interested:

The following is how we are taking on archiving (in concept) - it is a
bit plain & simple, but it will suffice for our needs (please feel free
to comment):

If ticket was resolved e.g. more that 1 year ago it will be archived.

1. make a copy of the full displayed page with wget and save it to
<ticketno>.html:
http://support.nha.co.za/Ticket/Display.html?ShowHeaders=32624&id=32624

2. save the real document attachments to
../Attachment/<trasactionid>/<attachmentid>/mydoc.doc

3. remove all transactions & attachments related to the ticket

4. set Ticket.status to resolved.

This results in a repository of HTML pages of tickets with there links
to attachments still working, but with no workable back-end working. 
What is great is that this can still be viewable from e.g.
RTarchive.example.com and I will probably add a search script later.  It
will naturally be displayed as a numerical list of all the tickets
that's been archived.
The original ticket is still searchable on its attributes like people &
dates, but of course no content.

One extra thing I have not thought of is to create a table with archived
tickets and the date it was archived, or maybe to add a date field to
rt2.Tickets, but I would not want to change the actual structure of the
rt-db to ensure future seamless scalability.

I am concerned that deleting the transactions and attachments from the
db might mess up some db-integrity, but so far it has work fine - I can
view the tickets fine, except that there are no Details - please advise
on this if you know the internals better.


Any thoughts from you guys??


Rehan van der Merwe
Neil Harvey & Associates



> Anyone know how to do this and still be able to search them. Or would
> that be 
> a mysql thing.