/ 
bugzillareport-1.02
/ bugzillareport

NAME

bugzillareport - Prints text list of bugzilla bugs to stdout suitable for non IT people

USAGE

bugzillareport [OPTION]..

-d       debug
-h       help
-v       version
-o       only open bugs
-c       only closed bugs

DESCRIPTION

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.

Motivation

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.

Example Output

================================================================================
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.

INSTALL

To install..

perl Makefile.PL
make install

You will also need a /etc/bugzillareport.conf file..

/etc/bugzillareport.conf

This is a yaml file which contains:

---
username: buguser
password: bugpasss
database: bugzilla
hostname: localhost

Follows YAM::DBH convention.

CAVEATS

For this script, you must be running Bugzilla 3+ You must have the /etc/bugzillareport.conf

SEE ALSO

YAML::DBH WWW::Bugzilla3

AUTHOR

Leo Charre leocharre at cpan dot org

COPYRIGHT

Copyright (c) 2009 Leo Charre. All rights reserved.

LICENSE

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".

DISCLAIMER

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.