Bug #1

[bugs/labs] Migrate bug tracker

fauno - about 11 years ago - . Updated over 3 years ago.

% Done:



Move data from roundup here



Updated by fauno about 11 years ago

test assignation


Updated by mtjm about 11 years ago

Unassigning to not discourage other contributors from helping.

I recommend adapting a script like 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.


Updated by mtjm about 11 years ago

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.


Updated by mtjm almost 11 years ago

Changed priority.


Updated by shackra over 10 years ago

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


Updated by fauno over 10 years ago

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


Updated by shackra over 10 years ago

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...


Updated by fauno over 10 years ago

i gave shackra a pg_dumpall so he can work on this


Updated by shackra almost 10 years ago

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?


Updated by lukeshu over 8 years ago

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.


Updated by fauno over 8 years ago

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


Updated by lukeshu over 8 years ago

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


Updated by Anonymous over 3 years ago

Still in progress?


Updated by bill-auger over 3 years ago

  • Assignee changed from shackra to bill-auger

i sure hope not - this was seven years ago


Updated by bill-auger over 3 years ago

  • Status changed from in progress to fixed

Also available in: Atom PDF