Hi Simone, See attached image.
> 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'; Yes, you can use any font you like. > 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. Can you try running a MySQL query and post the results: <connect to mysql, e.g. 'mysql -u [user] -h [host] -p'> USE otrs SELECT COUNT(DISTINCT(ticket_id)) FROM ticket_history WHERE history_type_id=1 AND create_time BETWEEN '2006-01-01' AND '2006-02-01' + INTERVAL 1 DAY; You can also try and select no queues. The script will then simply use all tickets. Regards, Edgar > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Simone > Girlanda > Verzonden: woensdag 8 februari 2006 15:45 > Aan: User questions and discussions about OTRS.org > Onderwerp: R: R: [otrs] OTRS statistics > > icon file: > > icon_vraagtaken.gif > > is missed > > It's possible to have a copy of it, or what do you intend to show there ? > > thank you again > > Simone > > -----Messaggio originale----- > Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di > Simone Girlanda > Inviato: mercoledì 8 febbraio 2006 15.34 > A: User questions and discussions about OTRS.org > Oggetto: R: R: [otrs] OTRS statistics > > > 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/ > > _______________________________________________ > 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/
icon_vraagteken.gif
Description: GIF image
_______________________________________________ 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/