Version of bugzilla2trac.py that works with Bugzilla 2.22 and trac 0.10.3-1

[bstandefer at digg dot com]

I could not get bugzilla2trac.py to work with these versions. I was getting an error saying that the time (which was null) was already inserted into the database, which required unique values of time (why?). Anyway, I messed with the time objects a bit, and was able to import data from Bugzilla 2.22 into trac 0.10.3-1. I have seen people post about this problem, but no solution. I have not verified that this fix is backwards compatible or even compatible with any other versions, but I do not see why it would not be.

[bstandefer at digg dot com]

updated bugzilla2trac.py that works with Bugzilla 2.22 and trac 0.10.3-1

[Christian Boos]

This patch eventually supersedes #3213, to be checked.

[Christian Boos]

This patch also contains the patch provided in #3818.

#4467 has also be marked as duplicate of this one.

[leo]

I believe you need to make one more change to get it to work, I'm not sure if its just a newer version of MySQLdb or what, but I needed to change line 412 to:

filedata = StringIO.StringIO(athedata)

athedata already came back as a 'str' so didn't have a tostring() method.

Python 2.4, MySQL 5.0.41, MySQLdb 1.2.2

[leo]

er, should be:

        filedata = StringIO.StringIO(a['thedata'])

[quasistoic]

Patch intended to be applied to r3544

[quasistoic]

The patch I added rolls in changes

1. by asmodai on #3213
2. by Norman on #3818
3. by myself @@ -531,9 +534,14 @@
4. by myself, also, normalizing tabs to spaces and getting rid of unnecessary whitespace on blank lines (these make the patch noisy, but offer a slight improvement in the end)

I did not include any of the changes proffered by bstandefer because, well, I didn't see the point of many of them, e.g. adding a random number between 1 and 900 to ticket numbers. I'll leave it up to whoever resolves this bug to evaluate bstandefer's changes.

For the record, I was using this script to move from Bugzilla 2.2.2 to Trac 0.10.4.

[Christian Boos]

Thanks for the patch. That script is not maintained actively by the TracTeam, however it's often presented as a starting point for rolling your own migration script.

It won't hurt if we integrate a more up-to-date version of the script and I take your word that it worked for you ;-)

Patch applied in r4639 (trunk) and r4640 (0.10-stable).

[Christian Boos]

oops, Patch applied in r5639 (trunk) and r5640 (0.10-stable). of course.

[quasistoic]

Aww, sweet! Glad I could help.

The script as packaged certainly was a great starting point. There wasn't too much I needed to do to get it working for me, and had I wanted to do so, I could have easily extended it because everyone who's worked on it did a great job keeping things legible.

I'm really enjoying Trac so far. It's a much more complete development management solution than Bugzilla on its own, and usability++!