The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
bugzillareport-1.02
River stage zero No dependents
++
/ 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.