Rt2stats - patch

Simon Cozens wrote:

Hall, Christian N:

I am looking for the rt2stats package. If anyone has a link or of a
known site that would be great.

http://users.ox.ac.uk/~simon/stats.tar.gz

No instructions, no support, have fun!

Hello,
attached You will find a patch that should make the Statistics package a bit
more generic . CallsMultiQueue needs something better than
@queues => qw(general) (the right hand side should be an array of all active
queues fo the current user - anybody have the code for that at hand?); and
Resolution.html should have something better than $queue => “general” as well.

My main additions are links back to RT or the Statistics start page on all
the sub pages.

Mind that some of the graphs are not created on my system. I get the
following error:

[Thu Aug 8 11:42:02 2002] [error] Apache::GD::Graph: GET
//chart?type=lines&x_labels=[Sun%204,Mon%205,Tue%206,Wed%207,Thu%208]&y_number_format=&data1=[,62299,31080,12349]

HTTP/1.0: Size of x_labels not the same as length of data.

Regards,
Harald

PS: quick instructions:

  • get Apache::GD::Graph installed (via CPAN). This might require installing
    gd and gd-devel (in redhat lingo), as well as some graphics libraries
    (libfreetype, libpng, libjpeg, libXpm (not needed)) and a fistful of perl
    modules (GD, GD::Graph, GT::Text::Util, Font::TTF, possibly others).

  • configure Your rt location in httpd.conf similar to this:

DocumentRoot /path/to/rt2/WebRT/html ServerName rt.yournamehere.com ErrorLog logs/error_log_rt CustomLog logs/access_log_rt combined PerlModule Apache::DBI PerlFreshRestart On PerlRequire /path/to/rt2/bin/webmux.pl SetHandler perl-script PerlHandler RT::Mason SetHandler perl-script PerlHandler +Apache::GD::Graph
  • put the Statistics Directory into /path/to/rt2/WebRT/html

  • restart Your httpd (ideally stopping and starting)

  • go to $RT::WebUrl/Statistics and behold the wonders of the Statistics
    package

  • If You’re in a good mood, fix some errors with the package and post Your
    diff (- :

Harald WagenerAn der Alster 4220099 Hamburg*http://www.fcb-wilkens.com

Statistics.diff (3.02 KB)

Harald Wagener:

attached You will find a patch that should make the Statistics package a bit
more generic .

Incidentally, Harald has agreed to take over maintainance of the statistics
package from me. Good luck, Harald!

Thermodynamics in a nutshell:
1st Law: You can’t win. (Energy is conserved)
2nd Law: You can’t break even. (Entropy)
0th Law: You can’t even quit the game. (Closed systems) – Taki Kogoma

Harald,

Any chance you can coordinate with Jesse to get this stuff put into contrib/ now that you’re the maintainer?

Increased exposure will mean increased feedback, one would hope :wink:

-DarrenFrom: Harald Wagener
To: ‘rt-users@lists.fsck.com’
Sent: Thursday, August 08, 2002 12:59 PM
Subject: Re: [rt-users] rt2stats - patch

Simon Cozens wrote:

Hall, Christian N:

I am looking for the rt2stats package. If anyone has a link or of a
known site that would be great.

http://users.ox.ac.uk/~simon/stats.tar.gz

No instructions, no support, have fun!

Hello,
attached You will find a patch that should make the Statistics package a bit
more generic . CallsMultiQueue needs something better than
@queues => qw(general) (the right hand side should be an array of all active
queues fo the current user - anybody have the code for that at hand?); and
Resolution.html should have something better than $queue => “general” as well.

My main additions are links back to RT or the Statistics start page on all
the sub pages.

Mind that some of the graphs are not created on my system. I get the
following error:

[Thu Aug 8 11:42:02 2002] [error] Apache::GD::Graph: GET
//chart?type=lines&x_labels=[Sun%204,Mon%205,Tue%206,Wed%207,Thu%208]&y_number_format=&data1=[,62299,31080,12349]

HTTP/1.0: Size of x_labels not the same as length of data.

Regards,
Harald

PS: quick instructions:

  • get Apache::GD::Graph installed (via CPAN). This might require installing
    gd and gd-devel (in redhat lingo), as well as some graphics libraries
    (libfreetype, libpng, libjpeg, libXpm (not needed)) and a fistful of perl
    modules (GD, GD::Graph, GT::Text::Util, Font::TTF, possibly others).

  • configure Your rt location in httpd.conf similar to this:

DocumentRoot /path/to/rt2/WebRT/html ServerName rt.yournamehere.com ErrorLog logs/error_log_rt CustomLog logs/access_log_rt combined PerlModule Apache::DBI PerlFreshRestart On PerlRequire /path/to/rt2/bin/webmux.pl SetHandler perl-script PerlHandler RT::Mason SetHandler perl-script PerlHandler +Apache::GD::Graph
  • put the Statistics Directory into /path/to/rt2/WebRT/html

  • restart Your httpd (ideally stopping and starting)

  • go to $RT::WebUrl/Statistics and behold the wonders of the Statistics
    package

  • If You’re in a good mood, fix some errors with the package and post Your
    diff (- :

Harald WagenerAn der Alster 4220099 Hamburg*http://www.fcb-wilkens.com

diff -r -U2 Statistics.orig/CallsMultiqueue.html Statistics/CallsMultiqueue.html — Statistics.orig/CallsMultiqueue.html Tue Feb 19 06:56:11 2002 +++ Statistics/CallsMultiqueue.html Thu Aug 8 11:47:18 2002 @@ -2,4 +2,8 @@
Number of Tickets Per Queue Per Day
+>Back to RT + Statistics/ >Back to Statistics +

  • @@ -89,5 +93,5 @@
    -% my $url = ‘SSO Login Service - Stale Request[’; +% my $url = $RT::WebURL.‘/chart?type=lines&x_labels=[’; % $url .= join “,”, @{ shift @data }; % $url .= ‘]&’; @@ -102,5 +106,5 @@ $status => “resolved” $max => 5 -@queues => qw(advisory maillist registration micros) +@queues => qw(general) $weekends => 0 diff -r -U2 Statistics.orig/CallsQueueDay.html Statistics/CallsQueueDay.html — Statistics.orig/CallsQueueDay.html Tue Feb 19 06:56:11 2002 +++ Statistics/CallsQueueDay.html Thu Aug 8 11:28:48 2002 @@ -2,4 +2,7 @@
    Number of Tickets Handled in Per Day
    +>Back to RT + Statistics/ >Back to Statistics +
    @@ -60,5 +63,5 @@
    -% my $url = $RT::WebURL.‘/chart?type=lines&x_labels=[’; +% my $url = $RT::WebURL.‘chart?type=lines&x_labels=[’; % $url .= join “,”, @{ shift @data }; % $url .= ‘]&’; @@ -74,5 +77,5 @@ Per Day
    +>Back to RT + Statistics/ >Back to Statistics +
    diff -r -U2 Statistics.orig/Resolution.html Statistics/Resolution.html — Statistics.orig/Resolution.html Tue Feb 19 06:56:11 2002 +++ Statistics/Resolution.html Thu Aug 8 11:47:45 2002 @@ -2,4 +2,7 @@
    Average Time-to-resolution for Tickets in
    +>Back to RT + Statistics/ >Back to Statistics +
    @@ -73,5 +76,5 @@ >Back to RT + Statistics/ >Back to Statistics + +

Darren Nickerson wrote:

Harald,

Any chance you can coordinate with Jesse to get this stuff put into
contrib/ now that you’re the maintainer?

Increased exposure will mean increased feedback, one would hope :wink:

-Darren

IMHO, the Statistics page is not yet up shape for general distribution. I
have about a dozen things I’d like to improve on (and that might take a
while, since I only inherited it yesterday.

Maybe some time later.

Regards,
Harald

Harald WagenerAn der Alster 4220099 Hamburg*http://www.fcb-wilkens.com

Hi,

We are in need of statistics package and I’m interested in helping
with it. Do you have it somewhere available?

Janne
jp@oppipoika.net

maybe we can work on that topic together, cause I already made a
statistics package, which integrates in our local extended RT2
Version. The only thing that it has in common with the rt2stats
Package is, that i have stolen some of the ideas. What I have at the
moment is:

  • Integration into the menues
  • Select start and end dates from a clickable calender
  • Export data to excel
  • Reports (from rt2stats) + keywords, no keywords, number of
    resolve transactions, etc.

Julian


Julian Hein NETWAYS GmbH
Managing Director Deutschherrnstr. 47a
Fon.0911/92885-0 D-90429 N�rnberg
Fax.0911/92885-31
jhein@netways.de www.netways.de


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm