Standard RT Reporting and Statistics

RT Users
1

Hi All,

In the documentation there is mention of Simon Cozen Statistics Package, as
well as in several posts. So far I have heard of these Report/Statistics
packages:

Simon Cozen Statistics Package
http://www.tzi.de/~hollow/stats.tar.gz

py Request Tracker Report

Statistics 3
http://www.tzi.de/~hollow/Statistics3.tgz

Are there others that I have missed?
Is there one that is the standard / recommended / most used package?
Why is there no reporting or statistics in the standard distribution of RT
(Other than a search)? Will some Reports/Statistics be added to the
package?

Thanks in advance,
Real

2

Hi All,

In the documentation there is mention of Simon Cozen Statistics
Package, as
well as in several posts. So far I have heard of these
Report/Statistics
packages:

Simon Cozen Statistics Package
Technologie-Zentrum Informatik und Informationstechnik - Universität Bremen

py Request Tracker Report
py Request Tracker Report download | SourceForge.net

Statistics 3
Technologie-Zentrum Informatik und Informationstechnik - Universität Bremen

Are there others that I have missed?
Is there one that is the standard / recommended / most used package?

According to the error reports, Statistics3 is in high demands, but I
don’t seem to be able to help people with problems much )-: . I don’t
know about the python package, but the first and last mentioned seem to
be what people associate if they hear ‘RT Statistics’. The main problem
is that the creation of automatic graphs is an additional source of
errors and misconfigurations.

A quick look at the python tool seems to indicate that it is well
suited for creating information that can be processed in other
programs, whereas the statistics package is best suited for creating
pretty images on web sites.

Why is there no reporting or statistics in the standard distribution
of RT
(Other than a search)?
Will some Reports/Statistics be added to the
package?

Thanks in advance,
Real

Statistics 3 is the continuation of Simon Cozen’s Statistics package.
The old version is for RT 2, the new one for RT 3 (hence the ‘3’ in
‘Statistics3’).

Regards,
Harald Wagener

3

Statistics 3 is pretty much the standard on the list that I’ve seen so
far with users.

Michael-----Original Message-----
From: Real Carbonneau [mailto:contact@realcarbonneau.com]
Posted At: Tuesday, September 16, 2003 12:24 AM
Posted To: RT
Conversation: [rt-users] Standard RT Reporting and Statistics
Subject: [rt-users] Standard RT Reporting and Statistics

Hi All,

In the documentation there is mention of Simon Cozen Statistics Package,
as
well as in several posts. So far I have heard of these
Report/Statistics
packages:

Simon Cozen Statistics Package
http://www.tzi.de/~hollow/stats.tar.gz

py Request Tracker Report

Statistics 3
http://www.tzi.de/~hollow/Statistics3.tgz

Are there others that I have missed?
Is there one that is the standard / recommended / most used package?
Why is there no reporting or statistics in the standard distribution of
RT
(Other than a search)? Will some Reports/Statistics be added to the
package?

Thanks in advance,
Real

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

4

Is there some demonstration site running for “Statistics 3”
thx

At 14:29 16.09.2003, RT wrote:

Statistics 3 is pretty much the standard on the list that I’ve seen so
far with users.

Michael
— cut —
…

5

Not that I’ve seen in here, but it’s pretty cut n dry… extract the tar
file, move it to your share/html/ folder and access it
http://your-rt-site/Statistics

MichaelFrom: christian janssen [mailto:proftp_cj@kdd.de]
Posted At: Tuesday, September 16, 2003 10:13 AM
Posted To: RT
Conversation: [rt-users] Standard RT Reporting and Statistics
Subject: RE: [rt-users] Standard RT Reporting and Statistics

Is there some demonstration site running for “Statistics 3”
thx

At 14:29 16.09.2003, RT wrote:

Statistics 3 is pretty much the standard on the list that I’ve seen so
far with users.

Michael
— cut —
…

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

6

I’m using RT2, therefore limited to the RT2 stats from
the URL below. Simple enough to install, but the
graphs don’t work. I get a broken link which attempts
to go to:

http://my.rtbox//chart?type=bars&x_labels=[Sun,Mon,Tue,Wed,Thu,Fri,Sat]&data1=[,66,50,50,21,500,]&data2=[16,169,211,229,170,144,18]&data3=[,16,36,31,15,42,]

What is the stats package trying to find?— Harald Wagener hwagener@hamburg.fcb.com wrote:

On Dienstag, 16. September 2003, at 06:24vorm., Real Carbonneau wrote:

Simon Cozen Statistics Package
Technologie-Zentrum Informatik und Informationstechnik - Universität Bremen

According to the error reports, Statistics3 is in
high demands, but I
don’t seem to be able to help people with problems
much )-: . I don’t
know about the python package, but the first and
last mentioned seem to
be what people associate if they hear ‘RT
Statistics’. The main problem
is that the creation of automatic graphs is an
additional source of
errors and misconfigurations.

A quick look at the python tool seems to indicate
that it is well
suited for creating information that can be
processed in other
programs, whereas the statistics package is best
suited for creating
pretty images on web sites.

Statistics 3 is the continuation of Simon Cozen’s
Statistics package.
The old version is for RT 2, the new one for RT 3
(hence the ‘3’ in
‘Statistics3’).

Regards,
Harald Wagener

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

“I’m the Commander, see … I do not need to explain why I say things. That’s the interesting thing about being the President … [I] don’t feel like I owe anybody an explanation.” – President George W. Bush to the National Security Council

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

7

I’m using RT2, therefore limited to the RT2 stats from
the URL below. Simple enough to install, but the
graphs don’t work. I get a broken link which attempts
to go to:

http://my.rtbox//chart?
type=bars&x_labels=[Sun,Mon,Tue,Wed,Thu,Fri,Sat]&data1=[,66,50,50,21,50
0,]&data2=[16,169,211,229,170,144,18]&data3=[,16,36,31,15,42,]

What is the stats package trying to find?

You are probably missing a script alias from /chart to
Apache::GD::Graph. Do You have the following for Your rt vhost?

<Location /chart>

SetHandler perl-script
PerlHandler +Apache::GD::Graph

You also need, Apache::GD::Graph, hence GD::Graph, hence libgd
installed and working for RT2. The statistics package for RT2 only
works if You use mod_perl.

Regards,
Harald

8

Hi,

This last mail from Harald helped me a lot, I now managed to get a graph, but only by manually editing the URL called :

Here are my findings :

  1. As the mail says, Apache::GD::Graph is needed. The Readme file says it is not, that was the main reason why my install did not work. The README file should add the info about the Apache config file.

  2. The Statistics tabs still does not appear. If I drop the “Tabs” file into my local/html directory, RT crashes with the folowing message : 32 levels deep in component stack (infinite recursive call?) (full error message pasted at the end) (RT 3.0.5 with RTFM installed. I used to see the Statistics tabs before, it may be before I installed RTFM)

  3. The URL for the graph does not work :
    http://hotline.dauphin-affichage.com/Statistics/CallsQueueDay/Elements/Chart?x_labels=Thu%2011,Fri%2012,Mon%2015,Tue%2016,Wed%2017&data1=9,6,10,7,3&data2=18,8,12,9,4&data3=0,0,0,1,0

I can get a correct graph if :
a) I change the path to shorten it and replace “Chart” with “chart”.
b) I change the variables to arrays, adding pairs.

The URL bellow works OK
http://hotline.dauphin-affichage.com/chart?x_labels=[Thu%2011,Fri%2012,Mon%2015,Tue%2016,Wed%2017]&data1=[9,6,10,7,3]&data2=[18,8,12,9,4]&data3=[0,0,0,1,0]

I hope this can help

Blaise

-----Message d’origine-----De : Harald Wagener [mailto:hwagener@hamburg.fcb.com]
Envoyé : mercredi 17 septembre 2003 11:11
À : rt-users@lists.fsck.com
Objet : Re: [rt-users] Standard RT Reporting and Statistics

I’m using RT2, therefore limited to the RT2 stats from
the URL below. Simple enough to install, but the
graphs don’t work. I get a broken link which attempts
to go to:

http://my.rtbox//chart?
type=bars&x_labels=[Sun,Mon,Tue,Wed,Thu,Fri,Sat]&data1=[,66,50,50,21,50
0,]&data2=[16,169,211,229,170,144,18]&data3=[,16,36,31,15,42,]

What is the stats package trying to find?

You are probably missing a script alias from /chart to
Apache::GD::Graph. Do You have the following for Your rt vhost?

<Location /chart>

SetHandler perl-script
PerlHandler +Apache::GD::Graph

You also need, Apache::GD::Graph, hence GD::Graph, hence libgd
installed and working for RT2. The statistics package for RT2 only
works if You use mod_perl.

Regards,
Harald

Error message when starting RT

System error

error: 32 levels deep in component stack (infinite recursive call?)

context: …
160: die “Cannot make alias without caller”
161: unless defined $Exception::Class::Caller;
162:
163: no strict ‘refs’;
164: *{“$Exception::Class::Caller::$alias”} = sub { $subclass->throw(@_) };
165: }
166:
167: eval $code;
168:
…

code stack: /usr/local/lib/perl5/site_perl/5.8.0/Exception/Class.pm:164
/usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:975
/usr/local/rt3/share/html/Elements/Callback:58
/usr/local/rt3/local/html/Elements/Tabs:52
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
…

9

Hi,

This last mail from Harald helped me a lot, I now managed to get a
graph, but only by manually editing the URL called :

Here are my findings :

  1. As the mail says, Apache::GD::Graph is needed. The Readme file says
    it is not, that was the main reason why my install did not work. The
    README file should add the info about the Apache config file.

I have Statistics running without Apache::GD::Graph here (debian/sid,
apache-1.3.27). So, this is not entirely true. Joseph is running rt2,
for which I described what to do.

  1. The Statistics tabs still does not appear. If I drop the “Tabs”
    file into my local/html directory, RT crashes with the folowing
    message : 32 levels deep in component stack (infinite recursive call?)
    (full error message pasted at the end) (RT 3.0.5 with RTFM installed.
    I used to see the Statistics tabs before, it may be before I installed
    RTFM)

Maybe jesse can shed some light on this? I will be testing 3.0.5 as
soon as the debian package is ready. I haven’t tested with RTFM so far.

  1. The URL for the graph does not work :
    http://hotline.dauphin-affichage.com/Statistics/CallsQueueDay/
    Elements/Chart?
    x_labels=Thu%2011,Fri%2012,Mon%2015,Tue%2016,Wed%2017&data1=9,6,10,7,3&
    data2=18,8,12,9,4&data3=0,0,0,1,0

I can get a correct graph if :
a) I change the path to shorten it and replace “Chart” with “chart”.
b) I change the variables to arrays, adding pairs.

This is Apache::GD::Graphs way of parsing data. You basically undid my
changes to avoid Apache::GD::Graph.

Regards,
Harald

10

What’s your apache config look like? I’ve not been able to get the graphs
to work at all and don’t really care if I have to use Apache::GD:Graph or
not.From: “THAUVIN Blaise (Dir. Informatique)” bthauvin@clearchannel.fr
To: “Harald Wagener” hwagener@hamburg.fcb.com; rt-users@lists.fsck.com
Sent: Wednesday, September 17, 2003 1:42 PM
Subject: RE: [rt-users] Standard RT Reporting and Statistics

Hi,

This last mail from Harald helped me a lot, I now managed to get a graph,
but only by manually editing the URL called :

Here are my findings :

  1. As the mail says, Apache::GD::Graph is needed. The Readme file says it is
    not, that was the main reason why my install did not work. The README file
    should add the info about the Apache config file.

  2. The Statistics tabs still does not appear. If I drop the “Tabs” file into
    my local/html directory, RT crashes with the folowing message : 32 levels
    deep in component stack (infinite recursive call?) (full error message
    pasted at the end) (RT 3.0.5 with RTFM installed. I used to see the
    Statistics tabs before, it may be before I installed RTFM)

  3. The URL for the graph does not work :
    http://hotline.dauphin-affichage.com/Statistics/CallsQueueDay/Elements/Chart?x_labels=Thu%2011,Fri%2012,Mon%2015,Tue%2016,Wed%2017&data1=9,6,10,7,3&data2=18,8,12,9,4&data3=0,0,0,1,0

I can get a correct graph if :
a) I change the path to shorten it and replace “Chart” with “chart”.
b) I change the variables to arrays, adding pairs.

The URL bellow works OK
http://hotline.dauphin-affichage.com/chart?x_labels=[Thu%2011,Fri%2012,Mon%2015,Tue%2016,Wed%2017]&data1=[9,6,10,7,3]&data2=[18,8,12,9,4]&data3=[0,0,0,1,0]

I hope this can help

Blaise

-----Message d’origine-----
De : Harald Wagener [mailto:hwagener@hamburg.fcb.com]
Envoy� : mercredi 17 septembre 2003 11:11
� : rt-users@lists.fsck.com
Objet : Re: [rt-users] Standard RT Reporting and Statistics

I’m using RT2, therefore limited to the RT2 stats from
the URL below. Simple enough to install, but the
graphs don’t work. I get a broken link which attempts
to go to:

http://my.rtbox//chart?
type=bars&x_labels=[Sun,Mon,Tue,Wed,Thu,Fri,Sat]&data1=[,66,50,50,21,50
0,]&data2=[16,169,211,229,170,144,18]&data3=[,16,36,31,15,42,]

What is the stats package trying to find?

You are probably missing a script alias from /chart to
Apache::GD::Graph. Do You have the following for Your rt vhost?

<Location /chart>

SetHandler perl-script
PerlHandler +Apache::GD::Graph

You also need, Apache::GD::Graph, hence GD::Graph, hence libgd
installed and working for RT2. The statistics package for RT2 only
works if You use mod_perl.

Regards,
Harald

Error message when starting RT

System error

error: 32 levels deep in component stack (infinite recursive call?)

context: …
160: die “Cannot make alias without caller”
161: unless defined $Exception::Class::Caller;
162:
163: no strict ‘refs’;
164: *{“$Exception::Class::Caller::$alias”} = sub {
$subclass->throw(@_) };
165: }
166:
167: eval $code;
168:
…

code stack: /usr/local/lib/perl5/site_perl/5.8.0/Exception/Class.pm:164
/usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:975
/usr/local/rt3/share/html/Elements/Callback:58
/usr/local/rt3/local/html/Elements/Tabs:52
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
/usr/local/rt3/local/html/Elements/Tabs:24
…

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