Rock your everyday

I have used a nice, simple script to export the rrd values into excel using PHP 5. You can find the script here:

http://code.google.com/p/php-excel/

Here is my code for the rrd export (here you'll find two functions - calculate_rrd() and format_bits(), these are described in my previous blog):

/*
Author: Md.Monjurul Hasan

Description
- RRD data exporter - output values into excel file
*/
/***************included files*******/

#include the export-xls.class.php file
require('export-xls.class.php');

$filename = 'rrd_export'.rand(0,10000).'.xls'; // a random filename chosen
#create an instance of the class
$xls = new ExportXLS($filename);

//read config file and get variables
$rrd_array = array ('rra/test1.rrd', 'rra/test2.rrd');
//export to excel
$header = " RRD Export"; // single first col text
$xls->addHeader($header);

#add blank line
$header = null;
$xls->addHeader($header);

#add 2nd header as an array of 3 columns
$header[] = "RRD Name";
$header[] = "Cur In";
$header[] = "";
$header[] = "Cur Out";
$header[] = "";
$header[] = "Avg In";
$header[] = "";
$header[] = "Avg Out";
$header[] = "";
$header[] = "Max In";
$header[] = "";
$header[] = "Max Out";
$header[] = "";
$header[] = "95% In";
$header[] = "";
$header[] = "95% Out";
$header[] = "";

$xls->addHeader($header);

$count = 0;
for ($c = 0; $c < count($rrd_array); $c++) {
$ret = calculate_rrd($rrd_array[$c], $graph_type); // graph type is daily/weekly/yearly and monthly
$row = array();
$row[] = $rrd_array[$c];
$result = format_bits($ret['current_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['current_out']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['average_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['average_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['max_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['max_out']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['percentile_in']);
$row[] = $result[0];
$row[] = $result[1];
$result = format_bits($ret['percentile_out']);
$row[] = $result[0];
$row[] = $result[1];
$xls->addRow($row);
}
//output the excel file
$xls->sendFile();

?>

I needed the rrd values in tabular format rather than graph. So i fetched the rrd values using rrd_fetch() function of PHP-RRDTool API. Then I calculated the required Current, Average, Max and 95th Percentile using the following function which may save time of others:

For percentile calculation, I followed the following article:
http://forums.cacti.net/post-95140.html&highlight=

To represent the values in bps/kbps/Mbps, you can use the following function:

/***
Function format value from bit to bps/kbps/Mbps

@input : bits
@output array: array[0] = value
array[1] = bps/kbps/Mbps

***/
function format_bits ($bits) {
$round_precision = 2;
if ($bits < 1000) {
$result[0] = round($bits,$round_precision);
$result[1] = "bps";
}
else if ($bits >= 1000 && $bits < 100000) {
$kbits = $bits/1000;
$result[0] = round($kbits,$round_precision);
$result[1] = "kbps";
}
else {
$mbits = $bits/(1000*1000);
$result[0] = round ($mbits, $round_precision);
$result[1] = "Mbps";
}
return $result;
}

Rupok (Ekti gaan)
Kotha: Rumman

Moner vitor juddho chole amar sharakhon
Neshar moto thomke thake
Klanto a jibon
Dhongsho smritir parey boshe amar ahoban
Dhukkho vule notun kore
Likhchi tomar a gaan

Michil vanga nirjonotay dariye eka
Alor nicher ondhokare smritir dekha
Char deyaler shobdo gula ekhon shudhoi chai
Meghe Dhaka shohor tate tui kebol nai
Moner vetor changa ghorar adim ayojon
Shunnotay dube thake amar sharakhon
Niyom vangar mogoz jure ekhon shudhoi chhok
Tepantor er nirbashone hariye geche rupok

Monei juddho amar nijer shathey lori
Smritir deyal chuye hazar murti gori
Chokher dekhay ja dekhi
Aar hoyni ja dekha
Ovimaaner nodir teer a
Datiye thaki eka

Vul jonme koshto amar lekhar aposhe
Odekha ek shorgo vashe ochena akashe
Moner vetor juddho ekhon
Amar shararaat
Ondhokarer kolahole dhorchi
Tomari haat

Ekla vishon amar ghore
Smritir hahakar
Aloy chaichhi niviye debo
Molin ondhokaar
Moner vetor juddho chole amar sharakhon
Mohakale miliye geli hothat kokhon

I found some nice videos on zdnet on web 2.0 concepts. Hope it will help others...
Web2.0 - http://news.zdnet.com/2422-13569_22-154425.html
Mashup - http://news.zdnet.com/2422-13569_22-152729.html
SOA - http://news.zdnet.com/2422-13569_22-155698.html

Yesterday I attended the facebook developer garage'09 in bangladesh. It was held in de ja vue cafe, gulshan. It was really good and inspiring!! Got 2 T-shirts and a pen n nicee notepad...labh hoise giya:-D.

It was a great tour with friends. We targeted the rainy weather of the sea beach. Although we didn't get the cats-n-dogs rain, it was not bad at all. We left dhaka on friday night (07/18/09) and came back from tour on tuesday morning(11/08/09). Mentionable places that we went other than sea beach were himchhari, inani beach and moheshkhali.

I got one brandnew MacBook Pro with Leopard 10.5.7 as Mac OS X. Installed windows vista in this Mac using bootcamp and cracked the vista with developer activation :-D. I can explore and copy the files of Mac OS from vista using HFSExplorer. From Mac OS, win vista partitions can be accessed by default with bootcamp. Working lyk charm!!

ek din, ghum vanga shohore
mayabi shondhay, chand jaga ek rat e...
ekti kishore chele, ekaki shopno dekhe,
hashi ar gaan e, shukher chobi ake
ahaa kije shukh..

shopnera hariye jay, shomoyer shagore e,
bethar abir e, kobita adhar e haray
vabonaro ful jhore jhore jay ahaaa
jiboner o gan hoyna surer kangal...

ekdin ghum vanga shohore..
mayabi shonday chand jaga rat eeee..
ekti kishor chhele, ekaki shopno dekhe....
hashi ar gan e .. shukher chobi akee..
ahaaaa kije shukh....

shoishob bimurto hoy, jay na bojha jayna
ashar jhorna payna shukher thiknaa
hotasha shudhu shathi hoye jaya ahaaa
she kishor ebar jibon chere palay

ekdin ghum vanga shohore