My code to convert a req queue to RT2 is now available from:
http://www.amsterdamned.org/~bc/rt/
( Jesse, these files can go into contrib now )
This is based on Daniel R’s YaR2R routines for RT1 and others (see the
code). It has been tested with RT2.0.9 (MySQL backend) with a database
set of ~40,000 tickets. (With ~100 tickets per run for other reasons)
Bugs:
Won't fix possibly broken req tickets
Can create multiple (identical) transactions if repeatedly
called on the same broken ticket (state is on success)
Not tested under databases other than MySQL (newTS_drop())
Only tested under 2.0.9.
Usage is longer than one screen
Features:
No-SQL mode to test the validity of your req queue.
Can exit after a given number of tickets.
Can keep state, so next invocation won't do multiple imports.
Can be used just to update a known ticket set
( Useful if a particular ticket # marks req to rt )
Provides an abstraction layer if wanting to convert req to
some-other-ticketing-system.
Regards,
Bruce Campbell RIPE
NCC
Operations