On Jan 21, 2006, at 1:47 AM, Rudolf Marek wrote: > > Phil, what about the ticket system conversion as Jean mentioned it? Hi Rudolf and Jean, thanks for following up. I've processed the old tickets and put them into the new trac schema for Axel. I don't have write access to the trac database (which is fine), so I've done two things: - I've uploaded a sql script which contains the old tickets into my home directory on the server. It is called "old-tickets-trac.sql". It requires that there be a new component called 'legacy' so that we can keep these tickets apart from the new ones. (sql: insert into component values ('legacy','somebody','import from legacy ticket system'); ) - I've taken a copy of the current trac database (trac.db) and already added the new component and imported the tickets. Again this db (still named trac.db) is in my home directory if you want to use that, Axel. A couple notes: - The SQL comes from a Perl script, so if it looks/works aweful, I can tweak the script as needed and run another dump. I haven't see what this actually looks like in Trac yet, so if needed, we can try it again. - The dates are the same on all the tickets. If it is important to keep the dates, I can work on it some more. Trac's schema uses an integer to store dates instead of datetime/timestamp types. - For some reason tickets 125 and 126 didn't import. We can just copy and paste those in. Not bad considering there are over 2,000+ tickets! Phil