test assignation

Unassigning to not discourage other contributors from helping.

I recommend adapting a script like https://github.com/ralli/migrate_from_bugzilla. I don't know any exporters from Roundup or how its databases are organized.

Having an SQL dump of the Roundup database could help with this.

First we should enable email integration of Roundup and include there comments sent via email and stored on repo, I will do needed repo mail configuration changes.

Then let's write a generic tool for migrating Roundup to ChiliProject, doing the following things:

• make a new issue in a specified single tracker of a single project for each original issue
• keep original issue identifiers somewhere in them
• map Roundup users to an existing ChiliProject user using specified mapping
• make a new user if not specified in the mapping, reset their password.

We don't have machine-readable metadata which would allow correctly choosing projects and trackers, so the first point is obvious.

We want to specify who wrote the comments, I don't see a better and simpler way to do this than described above. Migration of passwords could be possible, but might require implementing support for another password hashing scheme, I think this is not necessary.

All issues and comments would be migrated, not only the open ones.

The script should be useful for other projects doing similar migrations. I recommend licensing it under GPLv2 or later, since ChiliProject uses this license.

Changed priority.

I'll take care of this...
wish me all the luck of the world! ^_

So, what happened? We could also close all the opened bugs back there :P

Well, I think that is better to have a exported version of the old database in CSV and a exported version of the actual database in CVS too. In such case, would be easy to know how to accommodate the data from one exported database to another and then import such data to ChilliProject database (in CVS).

That's better than dealing with SQL instructions directly...

i gave shackra a pg_dumpall so he can work on this

So far, I have achive the indentification of some key rows from Roundup and Chilliproject. However, I not able to find comments on bugs from Roundup database, since then, I don't know what to do... Any suggestions on what to do?

Where is the Roundup database? There are a bunch of notes in blacklist.txt and comments in PKGBUILDs that refference Roundup bug IDs, and I have no idea what to make of them in many cases.

they should be in the backup on the new server, it was a postgresql db iirc

Yup. Do you know if the 75 file uploads were backed up anywhere?

Still in progress?