Без кейворда

Hi,I would like to export the bugzilla report to Excel.Can anybody tell me how can I do that?I am not finding any link in the report page to export/import data.

Dave Miller 2003-04-11 06:51:22 UTC

Post by ShashidharHi,I would like to export the bugzilla report to Excel.Can anybody tell me how can I do that?I am not finding any link in the report page to export/import data.

If you have version 2.17.1 or later, there should be "CSV" as an outputformat choice on the reports screen, or as a link at the bottom of thestandard buglists.

--Dave Miller Project Leader, Bugzilla Bug Tracking Systemhttp://www.justdave.net/ http://www.bugzilla.org/

Shashidhar 2003-04-11 13:53:40 UTC

Post by Dave MillerIf you have version 2.17.1 or later, there should be "CSV" as an outputformat choice on the reports screen, or as a link at the bottom of thestandard buglists.

I am using Bugzilla-2.16.2.

I am able to get the bug report as XML file using "xml.cgi".But is it possible to import bugs from MS Excel generated XML files?

Gervase Markham 2003-04-14 09:47:44 UTC

Post by ShashidharI am able to get the bug report as XML file using "xml.cgi".But is it possible to import bugs from MS Excel generated XML files?

I had no idea MS Excel could generate XML. And, even if it does, I doubtit would be to Bugzilla's schema :-)

But yes, the best way to import bugs is to create them as XML files withBugzilla's schema, and use importxml.pl.

2003-04-21 15:14:59 UTC

Hi,You can connect excel directly to mysql and run your own sql.

Here is an example of a Macro

' Microsoft ActiveX data object 2.6' *.recordCount does not work, always return -1Public Sub test()Dim aConn As ADODB.ConnectionDim Counter As IntegerDim Counter1 As IntegerDim strSQL As StringDim aRS As ADODB.RecordsetDim nDay As DateDim nFromDate As DateDim nToDate As Date

Set aConn = New ADODB.ConnectionWith aConn.Provider = "MSDASQL".ConnectionString = "DSN=myodbc3-test;UID=toto;PWD=toto;".OpenEnd With

strSQL Set aRS = New ADODB.RecordsetaRS.ActiveConnection = aConnaRS.Open strSQLaRS.MoveFirstSheet3.Cells(2, 2) = "P1 open"Sheet3.Cells(2, 3) = aRS.Fields("Count(*)")aRS.CloseSet aRS = Nothing

aConn.CloseSet aConn = NothingEnd Sub

Post by ShashidharHi,I would like to export the bugzilla report to Excel.Can anybody tell me how can I do that?I am not finding any link in the report page to export/import data.regards,Shashi

📎📎📎📎📎📎📎📎📎📎