Bugzilla: Presenting Comments in Buglist and CSV

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Bugzilla: Presenting Comments in Buglist and CSV

kaneda-2
Hello,

does somebody know how I can be shown the comments within the bug list
and / or how I can export the comments to the CSV file?

Thanks,

Mariele

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Peter Kay
> does somebody know how I can be shown the comments within the bug list
> and / or how I can export the comments to the CSV file?

Mariele,

Someone asked that a long time ago, as I recall.  The answer was "You
don't want to do that."  Eventually, he agreed.

Why do you want to do it?

Oh, and you'd have to hack Bugzilla to do it :)

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

kaneda-2
Peter,

thanks for your answer. The reason I want to do this is that I need a
simple a way to work on a list of bugs. A simple example: If I meet
with my clients I take the bugzilla list with me to discuss them.
Nowadays I have to carry with me two list: the "real" list in CSV oder
Excel-type, which I can edit nicely, filter it, make reports and so on.
The second one ist the "Long Format" list. So when I discuss for
example all bugs of a certain component, I first have to look ate the
bug list, and the for the details in the long list. All in all, I would
like to have one list, which I can edit.

Yours,

Mariele
Peter Kay schrieb:

> > does somebody know how I can be shown the comments within the bug list
> > and / or how I can export the comments to the CSV file?
>
> Mariele,
>
> Someone asked that a long time ago, as I recall.  The answer was "You
> don't want to do that."  Eventually, he agreed.
>
> Why do you want to do it?
>
> Oh, and you'd have to hack Bugzilla to do it :)
>
> --Peter

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Peter Kay
kaneda wrote:

> Peter,
>
> thanks for your answer. The reason I want to do this is that I need a
> simple a way to work on a list of bugs. A simple example: If I meet
> with my clients I take the bugzilla list with me to discuss them.
> Nowadays I have to carry with me two list: the "real" list in CSV oder
> Excel-type, which I can edit nicely, filter it, make reports and so on.
> The second one ist the "Long Format" list. So when I discuss for
> example all bugs of a certain component, I first have to look ate the
> bug list, and the for the details in the long list. All in all, I would
> like to have one list, which I can edit.
>

Um.  Put a duplicate instance of Bugzilla on your laptop (I assume you
use a laptop to visit clients), and when you go to a client, back up the
"real" bugzilla (via "mysqldump --opt -ubugs -p<password> bugs >
bugdb.sql") and then upload it to your laptop (via "mysql -u bugs
-p<password> bugs < bugdb.sql").  Then, turn "bug #" in your spreadsheet
into a link to bugzilla (which I know can be done in Excel).

Ok, that may be a bit complicated, but it's probably less complicated
then hacking on bugzilla to get csv output...

Other then that...good luck :)

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Shankar Unni
In reply to this post by kaneda-2
kaneda wrote:

> thanks for your answer. The reason I want to do this is that I need a
> simple a way to work on a list of bugs. A simple example: If I meet
> with my clients I take the bugzilla list with me to discuss them.

The way to do this is to click on the "Long Format" button at the bottom
of the Summary page. That creates a single HTML page that has formatted
full displays of all the bugs in the list.

That's what I did on my last out-of-town trip..
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Peter Kay
In reply to this post by Peter Kay
Another possibility is to prepare your worksheet, and then extract the
bugnumbers.  Then, use the 'wget' utility to cycle through all the
bugnumbers and save http://yourbugzilla/show_bug.cgi?id=<id> to your
local drive.  Then link to these local pages from the spreadsheet.

That's probably even easier then setting up a full bugzilla :)

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Peter Kay
In reply to this post by Shankar Unni
Shankar Unni wrote:

> kaneda wrote:
>
>> thanks for your answer. The reason I want to do this is that I need a
>> simple a way to work on a list of bugs. A simple example: If I meet
>> with my clients I take the bugzilla list with me to discuss them.
>
>
> The way to do this is to click on the "Long Format" button at the bottom
> of the Summary page. That creates a single HTML page that has formatted
> full displays of all the bugs in the list.
>
> That's what I did on my last out-of-town trip..

OP was already using the Long Format; it's not convenient for quickly
pulling up a given bug, though.

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Shankar Unni
Peter Kay wrote:

> OP was already using the Long Format; it's not convenient for quickly
> pulling up a given bug, though.

Sorry - missed that. But yes, WIBNI the long format had an "index" at
the top with links to the bodies of the reports? Enhancement req coming
up.. (https://bugzilla.mozilla.org/show_bug.cgi?id=309416)
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Peter Kay
Shankar Unni wrote:
> Peter Kay wrote:
>
>> OP was already using the Long Format; it's not convenient for quickly
>> pulling up a given bug, though.
>
>
> Sorry - missed that. But yes, WIBNI the long format had an "index" at
> the top with links to the bodies of the reports? Enhancement req coming
> up.. (https://bugzilla.mozilla.org/show_bug.cgi?id=309416)

Oh, that's good - then if you wanted to do fancy manipulation of
searches output to csv in Excel, you could link to the Long Format
page's anchors.

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Gervase Markham
Peter Kay wrote:
> Oh, that's good - then if you wanted to do fancy manipulation of
> searches output to csv in Excel, you could link to the Long Format
> page's anchors.

Ever wondered why comment anchors have a "c" prefix before the comment
number? This possibility is why :-)

Gerv
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Bugzilla: Presenting Comments in Buglist and CSV

Peter Kay
In reply to this post by kaneda-2
kaneda wrote:

> Peter,
>
> thanks for your answer. The reason I want to do this is that I need a
> simple a way to work on a list of bugs. A simple example: If I meet
> with my clients I take the bugzilla list with me to discuss them.
> Nowadays I have to carry with me two list: the "real" list in CSV oder
> Excel-type, which I can edit nicely, filter it, make reports and so on.
> The second one ist the "Long Format" list. So when I discuss for
> example all bugs of a certain component, I first have to look ate the
> bug list, and the for the details in the long list. All in all, I would
> like to have one list, which I can edit.
>

A new product just got released and when I saw it, I immediately thought
of your situation.  You might take a look at it:

http://deskzilla.com/

It's $99/user and doesn't provide access to some parts of Bugzilla yet
(e.g., flags), but it probably answers what you need to do very well.

--Peter
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools