[rt-users] REQ to RT2 Conversion.

Bruce Campbell bruce_campbell at ripe.net
Wed Dec 26 16:29:25 EST 2001


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





More information about the rt-users mailing list