bugzillareport - Prints text list of bugzilla bugs to stdout suitable for non IT people
-d debug -h help -v version -o only open bugs -c only closed bugs
Bugzilla is a great bug tracking/development tool.
I often get asked by non tech people, how a project is coming along. Bugzilla long text format is *almost* human legible. The short detail search is too vague.
This script creates output that is more concise, so you can show it to your coworkers- and it will make some sense.
The module WWW::Bugzilla3 allows you to do some of this. But it depends on Bugzilla's xmlrpc.cgi transactions. Which seem not to support full text retrieval, with comments etc.
What bugzillareport does is make direct sql calls to the database itself. So while this works for Bugzilla3, it may not work retroactively or in the (not so far?) future.
================================================================================ AP links show wrong file counts (DMS WUI) Status: RESOLVED Bug ID: 11 "This past week there were 2 cases where the information in the hearders did not match what was in the folders."... WJA, shows 11 files listed as Invoices Pending Payment, but going to place shows 11 and 2 APIE files. The various screens in the dms ap process were designed to be for use inhouse. The users were supposed to be able to approve, and disapprove invoices. The managers were to merge an approved invoice with a scanned check. We did not design view screens specifically for users in these various steps of the ap process. These various screens have to be designed. This ================================================================================ Need additional ap process view screens for users (DMS WUI) Status: RESOLVED Bug ID: 16 The screens needed are 1) invoices pending approval API 2) invoices pending payment APIA APIE 3) invoices disapproved APD 4) invoices and checks pending filing 5) vendor history New screens have been made, new logic for navigation bar for ap has been made and deployed.
perl Makefile.PL make install
You will also need a /etc/bugzillareport.conf file..
This is a yaml file which contains:
--- username: buguser password: bugpasss database: bugzilla hostname: localhost
Follows YAM::DBH convention.
For this script, you must be running Bugzilla 3+ You must have the /etc/bugzillareport.conf
Leo Charre leocharre at cpan dot org
Copyright (c) 2009 Leo Charre. All rights reserved.
This package is free software; you can redistribute it and/or modify it under the same terms as Perl itself, i.e., under the terms of the "Artistic License" or the "GNU General Public License".
This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the "GNU General Public License" for more details.