03-10-2010
Data storing and chart
I apologize if this has been posted before but I have been doing a lot of searching and I have not found any real answers, this is quite possibly due to that I may not be searching for the right terms or something. Little bit of info about my situation is that I'm a newbie as you probably guessed already and I am running a Debian server as a game server.
What I am trying to do is store the valueble statistical data related to the game for later analysis to help improve/optimize/diagnose. This means that I need to store data over long periods of time for example the number of users online or the number of active game rooms that are active. Then with the data that is stored I would like to be able to pull up daily/weekly/monthly/yearly charts through web/apache or something but I need visual charts. This data that is to be stored is only available on the Debian server side and is in no way available to any of the clients. This data will also only ever be viewed by me or possibly anyone who is part of the project.
I am well aware of the fact that I can just store the data myself into mysql with timestamps and other related data and then use a php type of chart creating 3rd party app or create my own charts through php/apache. But I don't want to do this because it creates more work for me and that is what I'm trying to avoid because working on the game project alone is more than enough work for me.
So what I am asking is that if someone can point me in the right direction of any 3rd party app that does this that I can look into or possibly other solutions that I am unaware of that would suite these needs. I would appreciate any info on this.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In AWK script how do I store data in variables for later use.
I have a multiline input and I do not want to print the data read on the console
Thnaks in advance.
Nilotpal. (7 Replies)
Discussion started by: 2nilotpal
7 Replies
2. UNIX for Dummies Questions & Answers
Hi,
How to store datas of the file into a string?
Thanks in advance.. (1 Reply)
Discussion started by: Fr0z3n999
1 Replies
3. Shell Programming and Scripting
Hi,
I have a file in the given format:
|aaa |hhh |fat hat chat |make sure
I need to get store in a variable,say 'error' the value of the string 'fat hat chat'
In short,
echo $error should give the result
fat hat chat
Is this possible using awk?
Also, can this be split.For... (10 Replies)
Discussion started by: jisha
10 Replies
4. UNIX for Dummies Questions & Answers
Please help me store the content of Input file to many files.
Input file:
record
a
b
c
record
d
record
e
f
record
.....
Create file1:
a
b
c
Create file2: (1 Reply)
Discussion started by: buddyme
1 Replies
5. Shell Programming and Scripting
Hello dear friends,
My problem as explained below seems really basic.
Fact is that I'm totally new to programming, and have only a week to produce a script ( CShell or Perl ? ) to perform this action.
While searching on the forums, I found a command that could help me, but I don't know... (2 Replies)
Discussion started by: ackheron
2 Replies
6. UNIX and Linux Applications
Hi all,
I posted the same message under 'Kaleidagraph like software for Ubuntu' thread. I guess there may not be many people familiar with Kaleidagraph.
So I post my message under another subject name.
I need a tool for Ubuntu 8.10,
-which is quick and easy to learn and use (as I am... (1 Reply)
Discussion started by: apprentice
1 Replies
7. Shell Programming and Scripting
Hi,
i have a problem writing a script.
Actually i have many files which contains some data, now the last line has some data as in the format : 2556||04-04-10
now i want to do tail -1 filename.txt and store the result into a variable which will be used later for some other calculations.
My... (7 Replies)
Discussion started by: fidelis
7 Replies
8. UNIX for Dummies Questions & Answers
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
Discussion started by: ladyAnne
1 Replies
9. Shell Programming and Scripting
Respected All,
Kindly help me out.
I have got file listings in a directory like this:
-rw-r--r-- 1 root root 115149 2011-11-17 07:15 file1.stat.log
-rw-r--r-- 1 root root 115149 2011-11-18 08:15 file2.stat.log
-rw-r--r-- 1 root root 115149 2011-11-19 09:15 file3.stat.log
-rw-r--r-- 1... (2 Replies)
Discussion started by: teknokid1
2 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::chart::bar
Excel::Writer::XLSX::Chart::Bar(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Chart::Bar(3pm)
NAME
Bar - A class for writing Excel Bar charts.
SYNOPSIS
To create a simple Excel file with a Bar chart using Excel::Writer::XLSX:
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart.xlsx' );
my $worksheet = $workbook->add_worksheet();
my $chart = $workbook->add_chart( type => 'bar' );
# Configure the chart.
$chart->add_series(
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Add the worksheet data the chart refers to.
my $data = [
[ 'Category', 2, 3, 4, 5, 6, 7 ],
[ 'Value', 1, 4, 5, 2, 1, 5 ],
];
$worksheet->write( 'A1', $data );
__END__
DESCRIPTION
This module implements Bar charts for Excel::Writer::XLSX. The chart object is created via the Workbook "add_chart()" method:
my $chart = $workbook->add_chart( type => 'bar' );
Once the object is created it can be configured via the following methods that are common to all chart classes:
$chart->add_series();
$chart->set_x_axis();
$chart->set_y_axis();
$chart->set_title();
These methods are explained in detail in Excel::Writer::XLSX::Chart. Class specific methods or settings, if any, are explained below.
Bar Chart Methods
The "Bar" chart module also supports the following sub-types:
stacked
percent_stacked
These can be specified at creation time via the "add_chart()" Worksheet method:
my $chart = $workbook->add_chart( type => 'bar', subtype => 'stacked' );
EXAMPLE
Here is a complete example that demonstrates most of the available features when creating a chart.
#!/usr/bin/perl
use strict;
use warnings;
use Excel::Writer::XLSX;
my $workbook = Excel::Writer::XLSX->new( 'chart_bar.xlsx' );
my $worksheet = $workbook->add_worksheet();
my $bold = $workbook->add_format( bold => 1 );
# Add the worksheet data that the charts will refer to.
my $headings = [ 'Number', 'Batch 1', 'Batch 2' ];
my $data = [
[ 2, 3, 4, 5, 6, 7 ],
[ 10, 40, 50, 20, 10, 50 ],
[ 30, 60, 70, 50, 40, 30 ],
];
$worksheet->write( 'A1', $headings, $bold );
$worksheet->write( 'A2', $data );
# Create a new chart object. In this case an embedded chart.
my $chart = $workbook->add_chart( type => 'bar', embedded => 1 );
# Configure the first series.
$chart->add_series(
name => '=Sheet1!$B$1',
categories => '=Sheet1!$A$2:$A$7',
values => '=Sheet1!$B$2:$B$7',
);
# Configure second series. Note alternative use of array ref to define
# ranges: [ $sheetname, $row_start, $row_end, $col_start, $col_end ].
$chart->add_series(
name => '=Sheet1!$C$1',
categories => [ 'Sheet1', 1, 6, 0, 0 ],
values => [ 'Sheet1', 1, 6, 2, 2 ],
);
# Add a chart title and some axis labels.
$chart->set_title ( name => 'Results of sample analysis' );
$chart->set_x_axis( name => 'Test number' );
$chart->set_y_axis( name => 'Sample length (mm)' );
# Set an Excel chart style. Blue colors with white outline and shadow.
$chart->set_style( 11 );
# Insert the chart into the worksheet (with an offset).
$worksheet->insert_chart( 'D2', $chart, 25, 10 );
__END__
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
Copyright MM-MMXII, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
perl v5.10.1 2012-04-02 Excel::Writer::XLSX::Chart::Bar(3pm)