168593 - contrib: sourceforge -> bugzilla migration

Status: NEW

(Bugzilla :: Bugzilla-General, enhancement)

Description

[Dave Miller [:justdave]]

received this in email:

-------------------

I'm not sure if you're familiar with sourceforge's bug tracker, but I
was in the process of converting to Bugzilla from there, and found the
XML export feature.
Attached is a XSL transform document that will create a SQL query
document from a sourceforge xml exported bug tracker list. I hope
someone will find it useful, and maybe continues maintaining it. A bit
more documentation is at the top of the file :)
I'm no longer maintaining it as my team just decided to move to Mantis
instead of bugzilla, so I need to write a transform document for that.
But if you have any questions, feel free to ask me. I left a copyright
in there, if that gives licensing problems also contact me please.
I'd just like to see someone benefit from this, because I no longer have
use for it.

johannes

Comment 1

[Dave Miller [:justdave]]

Attachment: xsl file for conversion

Comment 2

[Dave Miller [:justdave]]

Comment on attachment 99159 [details]
xsl file for conversion

note if you want to view this attachment online you might need to view source
on it.

Comment 3

[Johannes Berg]

Thanks for adding here, I wasn't sure where to put it.

For those who have never heard of the export facility (which is inofficial
anyway), here are the relevant URLs:
http://sourceforge.net/export/sf_tracker_export.php?group_id=XXXXX&atid=YYYYY
and the XML schema:
sourceforge.net/export/sf_tracker_export.xsd (supposedly broken, never looked at it)
Copy the group_id and atid from your tracker URL.

Comment 4

[Dave Miller [:justdave]]

Reassigning bugs that I'm not actively working on to the default component owner
in order to try to make some sanity out of my personal buglist.  This doesn't
mean the bug isn't being dealt with, just that I'm not the one doing it.  If you
are dealing with this bug, please assign it to yourself.

Comment 5

[Teemu Mannermaa (:wicked)]

Comment on attachment 99159 [details]
xsl file for conversion

Can't really test this because SourceForge only allows admins to export tracker data. Looks like their export URL (see http://sourceforge.net/export/) has also changed so their export format might have changed too.

Maybe this file is fine as an example contrib script that people can use as a basis when converting from sf.net to Bugzilla. In any case manual changes are needed for the script before it will work each case.

I'll give this a r+ with following changes as it doesn't seem todo anything nasty. Better approach in the future would be to parse the XML and use Bugzilla objects to create and update bugs and comments.

This file seems to use Mac line endings (only CR). Unix line endings would be more appropriate.

>    <xsl:when test="category='YOUR SOURCEFORGE CATEGORY'">YOUR BUGZILLA CATEGORY</xsl:when>

Nit: "YOUR BUGZILLA COMPONENT".

>    <xsl:when test="status='Pending'">CLOSED</xsl:when>

I don't think this mapping is correct. It's more like NEW or in the future NEEDINFO.

>    <xsl:when test="resolution='Postponed'">LATER</xsl:when>

There is no LATER resolution anymore.

Comment 6

[Johannes Berg]

Hah, this is ancient. Yeah, feel free to put it somewhere as an example that people can adapt to their needs, it doesn't work without changes anyway.

I can export you some tracker data from an sf project if you want to try it. I haven't used bugzilla in ages and don't even remember what project I needed this for.