Paul Boven wrote:
Mike Jackson wrote:
I'm sure there are some PHP hackers who have much nicer graphs than I
do, but I found the easiest thing to do was to extract numbers from
my logs with some perl scripts and paste them into Excel. Management
likes Excel and it makes pretty charts. :)
It's not automated, but it does have lots of primary colours.
You can save yourself a lot of time with the Spreadsheet::WriteExcel
CPAN module. I don't know if you can use it to make the charts and
graphs, but at least you can have it write out the data.
Instead of making a spreadsheet, how about a bit of gnuplot?
Input: (generated by some overly complicated script-magic I don't dare
share in here)
#date recvd spam rej FN FP Vir
2005-04-03: 18615 11776 4445 163 0 93
2005-04-04: 20920 10750 5206 73 0 131
2005-04-05: 19325 9368 5412 70 0 150
2005-04-06: 22396 11259 5803 86 0 95
2005-04-07: 20741 8981 6499 75 0 116
2005-04-08: 23526 12300 6222 120 0 115
2005-04-09: 21856 14664 6489 128 1 91
^ Uhoh...
gnuplotrc:
set terminal png small color picsize 800 500
set output 'spamstats.png'
set format x '%Y-%m-%d'
set key outside
set xdata time
set timefmt "%Y-%m-%d"
set xtics rotate
set xtics 86400
plot 'bayes.log' using 1:2 title ' received' with linespoints, \
'bayes.log' using 1:3 title 'spam' with linespoints, \
'bayes.log' using 1:4 title ' rejected' with linespoints, \
'bayes.log' using 1:($5+$6) title 'false' with linespoints, \
'bayes.log' using 1:7 title 'virus' with linespoints
set output 'percentage.png'
plot 'bayes.log' using 1:(100*$5/($2)) title ' %falseneg' with
linespoints, \
'bayes.log' using 1:(100*$6/($2)) title ' %falsepos' with
linespoints
And then it's just 'gnuplot gnuplotrc' and presto, pretty pictures.
Regards, Paul Boven.
i like it... thanks i was gonna go rrdtool but i like the looks of this.
but why isnt your "complicated script-magic I don't dare share in here"
GNU public licesnce????
;)
ronan
--
========
Regards
Ronan McGlue
Info. Services
QUB
