[openbeos] Re: BugZilla => Trac

On 8/24/06, Axel Dörfler <axeld@xxxxxxxxxxxxxxxx> wrote: 
Charlie Clark <charlie@xxxxxxxxxxxxxx> wrote:
> Did you use one of the Trac scripts for the conversion? When I
> migrated the Yellowtab databases from Bugzilla to Trac last year it
> didn't take very long to adapt the existing MySQL -> SQLite script to
> the latest version of Bugzilla and I had no problems with non-ASCII
> characters.


We are running everything on MySQL, not SQLite. Unfortunately, I can't
use UTF8 for our DBs because our host is using a too old version... :(
The problem is that I can't convert those characters. The mysql-python
library tries to use the UTF8 converter and fails. I'm sorry. This
time those characters were replaced with "???" (which at least makes
sure you won't have problems with displaying any tickets, unlike
before...).
If you take a look at BugZilla you will notice that there are a few
tickets which don't display correctly in your browser. Trac always
checks for valid characters and refuses to add invalid input.

At least, all bugs have been imported and after a quick look the
comments seem to fit to their ticket. I've also disabled Bugzilla and
added a redirect. Unfortunately, this won't work if you browse some
subpage of haiku-os.org/bugzilla/.
So, if nothing

Anyway, I'll try to see how I can import the old Trac tickets with our
netstack tasks, too. Maybe it's not too much and I can even do it
manually...

Do you still have that script around by any chance? 

I've put it in your FTP folder. (/axeld/bugzilla2trac.py)
It's a modified version of the original bugzilla2trac.py. But I also
messed around with the original BZ DB and replaced invalid chars and
when importing I used the phpmyadmin SQL input form instead of
uploading a file in order to overcome those "invalid chars" errors.

Bye,
Waldemar Kornewald

Other related posts: