276321 - Import Excel list of bug reports

Status: RESOLVED WONTFIX

(Bugzilla :: Bug Import/Export & Moving, enhancement)

Description

[Balaji Krishnamurthy]

Hi ,

    I am using buzilla . Problem here i have is i have a excel sheet which i 
used to maintain bugs is there any way where i can upload the excel sheet bugs 
to bugzilla .

Comment 1

[Oliver Klee]

Changing to Feature Request and rewording summary.

Comment 2

[Frédéric Buclin]

Maybe should you save your file in CSV format first before importing it in Bugzilla. But even in this case, I don't really see what the structure of the CSV file would/should be. ghendricks, any thoughts?

Comment 3

[Greg Hendricks]

There is no method of importing information from a csv file yet and there are no plans to support it.

If you can export your spreadsheet to xml and then use xslt to transform it to conform to the bugzilla dtd you can use importxml.pl to import the records.

Another option might be to link your csv to your bugzilla database. Many spreadsheet applications allow you to import information directly back and forth between the database and the spreadsheet.

Comment 4

[Mick Weiss]

I'm going to take this bug. I have it already written (as a perl script ready for the contrib directory). I just need to clean it up a bit and make sure there are no bugs. 

Comment 5

[Frédéric Buclin]

Reassigning to Mick per comment 4. Be sure to write your code based on the coming Bugzilla 3.2 code (currently 3.1.2+), not the 3.0.x one.

Comment 6

[c_gingold]

I WANT SPAM DELIVERED TO MY EMAIL!

Comment 7

[Frédéric Buclin]

I think the right approach is to first convert the Excel file into a XML file matching bugzilla.dtd. I don't see any good approach to import Excel files.