Importing data from CSV file to make graph

[rbl]

Hi,

I have data in a csv file.
The info is like this:
12-8-2013 14:00 0
12-8-2013 14:15 0
12-8-2013 14:30 0.744
12-8-2013 14:45 1.528
12-8-2013 15:00 1.612
12-8-2013 15:15 1.496
12-8-2013 15:30 1.332

It has a data and a time stamp.
On date time is the value to use.

Is there a way to import this data into cacti?
And to do this by hand and not automatic. I get the data one a week.

Kind regards,
Martijn

[phalek]

- Yes it can be added.
- Yes it can be done manually
- Yes it can also be done automatically once a week

Basically you're using an external script, which parses your file and converts it to "rrdtool update" commands which stores the data into a pre-created rrd file ( that can be defined in Cacti ):

The script would look like this ( in Perl ):

Code: Select all

 my $file = $ARGV[0];
 my $rrdfile = '/var/www/html/cacti/rra/host_csv_data.rrd';
 
 open(INPUT,'<',$file) or die 'cannot open file ['.$file.'] !'."\n";
 
 while (my $line = <INPUT>) {
	chomp($line);
	if ($line =~ m/^(\d+)-(\d+)-(\d+)\s(\d+):(\d+)\s(.*)/ig) {
		my $day = $1;
		my $month = $2;
		my $year = $3;
		my $hour = $4;
		my $minutes = $5;
		my $seconds = 0;
		my $data = $6;
		my $startTime = timelocal($seconds,$minutes,$hour,$day,$month-1,$year-1900);
		`rrdtool update $rrdFile $startTime:$data`;
		#print "rrdtool update $rrdFile $startTime:$data\n";
	}
}

close(INPUT);

[rbl]

tnxs,
I will try this out