I have some problems using it:
fonts are not present in my system, where may I get them ? or may I use
other ?
my $GraphFont = '/usr/share/fonts/truetype/DINLt____.ttf';
my $BoldFont = '/usr/share/fonts/truetype/DINBd.ttf';
I tried to use OTRS_stats.pl but I always have this error:
"No tickets created in Queues: Supporto, between 1-1-2006 and 1-2-2006"
but there are 31.
I think that the problem (if a problem exist) is in this part of the
software, but I'm not able to understant / change it:
# Put wanted tickets in array (right qID's)
if (scalar (@{$Param{QueueID}}) == 0) { # No queues selected, thus
select
all
%NewTickets = %ticket;
@{$Param{QueueID}} = keys %queue_ids;
} else {
foreach my $Key (keys %ticket) {
$NewTickets{$Key}++
if (grep {$ticket{$Key}{q_id} == $_}
@{$Param{QueueID}});
}
}
# Print error if there are no tickets within the selcted time interval
my $Error = "No tickets created in Queues: ";
foreach my $ID (@{$Param{QueueID}}) {$Error .= "$queue_ids{$ID}, ";}
$Error .= "between $Param{StartDay}-$Param{StartMonth}-$Param{StartYear}
and $Param{EndDay}-$Param{EndMonth}-$Param{EndYear}";
error("$Error")
if scalar keys %NewTickets == 0;
# Find those tickets which were initially calls
(type_id(PhoneCallCustomer)= 12)
# Could have done this with a nested SELECT, but this is way faster
$sql = qq~
SELECT DISTINCT(t.id)
FROM ticket t,
-----Messaggio originale-----
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di
Edgar Meij
Inviato: martedì 7 febbraio 2006 18.28
A: User questions and discussions about OTRS.org
Oggetto: Re: R: [otrs] OTRS statistics
There is an earlier post from me, I've included it below. And there is
a readme file within the archive, have you tried those?
Regards,
Edgar
---
Dear all,
During the greater part of this year I've been developing a statistics
module for OTRS (and Hostnet). Attached you'll find a zip file with the
final result. See the README file within for further installation
details, requirements, etc. etc.
The script is able to produce the following ticket statistics,
aggregated on a per-day or per-week basis, between specified dates and
in specified queues. The output can be selected as well; graphs, CSV and
HTML (tables) are supported.
- Number of new tickets (total/calls/e-mails)
- Workload (number of calls, in- and outgoing e-mails)
efficiency:
- E-mail time calculations:
Open time
Reply time
Resolution time
efficacy:
- Average number of follow-ups/replies per ticket
- Number of first time fixes
An example graph is attached as workload.gif.
On 2/7/06, Simone Girlanda <[EMAIL PROTECTED]> wrote:
> may you give us more detailed installation instruction ?
>
> thank you
>
> -----Messaggio originale-----
> Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di
> Edgar Meij
> Inviato: martedì 7 febbraio 2006 18.16
> A: [EMAIL PROTECTED]
> Cc: 'User questions and discussions about OTRS.'
> Oggetto: [otrs] OTRS statistics
>
>
> Hi Rémi,
>
> Sure, see the attached file. If you have any questions, drop me an e-mail.
>
> Regards,
>
> Edgar
>
> > -----Oorspronkelijk bericht-----
> > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Verzonden: dinsdag 7 februari 2006 10:21
> > Aan: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Onderwerp: OTRS statistics
> >
> > Hi Edgar, Hi Danie
> >
> > I use otrs too since june 2003 (1.3.2 at this time but I'm going to
update
> > to 2.0.4 soon) and I'm interested in statitics over OTRS database but
I'm
> > not an expert in SQL so, as Danie asked, could you possibly send me the
> > zip file , I would really like to have a look at it (the ouputs that you
> > have made meet my goals)
> >
> > Thanks a lot
> >
> > Rémi
>
> _______________________________________________
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
> Support oder Consulting für Ihr OTRS System?
> => http://www.otrs.de/
>
--
'An approximate answer to the right question is worth a great deal
more than a precise answer to the wrong question'
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
