helpSavannah Administration - Support: sr #105668, Import Sourceforge Tracker Data

 
 

sr #105668: Import Sourceforge Tracker Data

Submitted by:  Kevin Atkinson <kevina>
Submitted on:  Sun 12 Nov 2006 01:55:57 PM UTC  
 
Category: NonePriority: 5 - Normal
Severity: 3 - NormalStatus: None
Assigned to: Sylvain Beucler <Beuc>Operating System: None
Open/Closed: Closed

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

(Jump to the original submission Jump to the original submission)

Thu 18 Jan 2007 10:49:16 PM UTC, comment #12:

This is more a feature request than a support request.
I keep that in mind and add it to the TODO list; I'll close this request to clarify the support requests list.

Sylvain Beucler <Beuc>In charge of this item.
Thu 30 Nov 2006 09:37:39 PM UTC, comment #11:

Hi,

I don't have much time right now to work on this but I don't give up! :)

Sylvain Beucler <Beuc>In charge of this item.
Thu 16 Nov 2006 08:32:30 AM UTC, comment #10:

Beuc: http://project.juiblex.co.uk/hg/sf2bz

J. Ali Harlow <j_ali>
Wed 15 Nov 2006 10:20:16 PM UTC, comment #9:

Unfortunately I don't know enough about Savene to do this. Maybe if you could give me some pointers on where to look. Maybe the schema. But I won't know if the SQL will truly do the right thing since I won't be able to test it.

Kevin Atkinson <kevina>
Wed 15 Nov 2006 09:23:25 PM UTC, comment #8:

j_ali: Yes, I would be glad to see your source code - it'll come in handy.

Kevin: do you think you could start working on the SF->SQL convertion?

Sylvain Beucler <Beuc>In charge of this item.
Mon 13 Nov 2006 11:31:16 PM UTC, comment #7:

Actually the attached file was only the Bugs Tracker. I want each tracker to be handled slightly differently.

As for the ones you pointed out:

artifact_type id: identifies the tracker

submitted_by: this one is tricky, Could you collect all the user ids and for each one let me know if on exists in savannah. It could be that the user is under a different id in which case the change should be mapped. If that is not the case would it be possible to open an account for the user with a random password and send the user an email. if not I can send email to those users and ask them to open an account. If it is simply not possible to assign an id than we can make use of the "Original Email" field.

artifact id: There is not formal syntax but they may be cross references in the text. It is best to look for the id in all the text and change it.

For each tracker:

Bugs: no special treatment.

For Feature Requests: Import to bug tracker.

Please set the category to "feature request".

For Patches: Import to bug tracker not patches.

Add the "Keyword", "with patch".

Also please change "group" to "Planned Release", changing "0.60" to "0.60.5".

If they is anything I can do to help please let me know.

Kevin Atkinson <kevina>
Mon 13 Nov 2006 11:19:11 PM UTC, comment #6:

It's a little more awkward than that if you want to do it properly. To get the attachment names you need to parse the html for each attachment (it's not in the xml) and you need to track whether attachments have been deleted by looking at the artifact history. I'm in the process of doing something similar for sourceforge -> bugzilla. It's distinctly raw at present (and I'm still working on users) but I'll happily do at dump on you if you like.

J. Ali Harlow <j_ali>
Mon 13 Nov 2006 11:09:04 PM UTC, comment #5:

Hmm, I see we'll also have to grab the attachments from SF.net along the way. Shouldn't a problem though.

Sylvain Beucler <Beuc>In charge of this item.
Mon 13 Nov 2006 10:04:01 PM UTC, comment #4:

Hi,

Well it can't be 'compatible' anyway because SF and Savane can only export trackers data - not import them :/ However it is possible to build SQL queries that matches the XML structure.

There's a couple caveats we need to deal with:

- <submitted_by>jhein-sf</submitted_by>
=> if that user is not present at Savannah, what will we replace him with?

- <artifact_type id="100245">100245</artifact_type>
=> I can't figure out what that relates to. But it seems it's the same value for every item, so maybe it can be discarded.

- <artifact id="1501324">
=> we'll need to renumber the IDs. Can there be references from a tracker item to another tracker item (dependency, special syntax to link other items in follow-ups)?

Sylvain Beucler <Beuc>In charge of this item.
Mon 13 Nov 2006 09:25:29 PM UTC, comment #3:

Spell checker gone made. That "Becca's" should be becuase. Sorry.

Kevin Atkinson <kevina>
Mon 13 Nov 2006 09:17:10 PM UTC, comment #2:

It is a hidden link:
http://sourceforge.net/export/sf_tracker_export.php?atid=100245&group_id=245

Attached in the latest export.

I have a felling that it won't be compatible. Since at very least Aspell has different set of trackers. I would like these all to go into the Bug tracker.

Let me know how close these are to what Savane expects. I am perfectly willing to do some transformations on the XML file to make it compatible.

Please don't do anything permanent yet Becca's I want to make sure things get imported correctly, and sensibly.

Kevin Atkinson <kevina>
Mon 13 Nov 2006 02:43:06 PM UTC, comment #1:

Hi,

This should be possible. Can you send the XML file? (can you also tell me how you can get an XML export at SF?)

Sylvain Beucler <Beuc>In charge of this item.
Sun 12 Nov 2006 01:55:57 PM UTC, original submission:

I would like to start using the Bug Tracker on Savannah for GNU Aspell. I am currently using the one on Sourceforge. If at all possible I would like to be able to migrate the data from the Sourceforge trackers to Savannah. If this at all possible? I can export Sourceforge tracker data via an XML file.

Thanks in advance. If this is not possible I will likely to continue to use Sourceforge for the time being. Eventually I may manually import the open bugs....

Kevin Atkinson <kevina>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

Attached Files
file #11257:  aspell-patches.xml.gz added by kevina (88KiB - application/x-gzip - Aspell Patches Tracker)
file #11256:  aspell-fr.xml.gz added by kevina (26KiB - application/x-gzip - Aspell Feature Requests Tracker)
file #11255:  aspell-tracker.xml.gz added by kevina (124KiB - application/x-gzip - Sourceforge Tracker Export)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by Beuc (Posted a comment)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 5 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Thu 18 Jan 2007 10:49:16 PM UTCBeucOpen/ClosedOpen=>Closed
    Mon 13 Nov 2006 10:57:20 PM UTCkevinaAttached File-=>Added aspell-patches.xml.gz, #11257
    Mon 13 Nov 2006 10:56:09 PM UTCkevinaAttached File-=>Added aspell-fr.xml.gz, #11256
    Mon 13 Nov 2006 09:21:19 PM UTCkevinaAttached File-=>Added aspell-tracker.xml.gz, #11255
    Mon 13 Nov 2006 02:43:06 PM UTCBeucAssigned toNone=>Beuc

    Back to the top


    Powered by Savane 3.1-cleanup1