Link to home
Start Free TrialLog in
Avatar of mirde
mirdeFlag for Canada

asked on

PHP Script that will graph CSV data?

Hello,

I am looking for a decent php script (or any other type) that I can configure to create a graph out of a CSV file that is constantly appended with new data feeds?

The sample CSV data is also attached.

Anyone know of anything out there that will do what i am trying to do here?
Date,DB Writes,BI Reads,Record Reads,BI Writes,Record Updates,AI Writes,Record Creates,Record Deletes,Record Locks,Index operations,Record operations,Total OS IO,Total OS Reads,Total OS Writes
0416-0705,2536,14,21347764,2292,31265,1651,3316,1812,217497,21337670,21383891,132231,125758,6473
0416-0735,1134,26,16994036,427,1509,379,1721,813,263958,16915886,17006076,123150,121210,1940
0416-0805,2262,24,18030918,1139,23082,992,1655,1024,121704,17983683,18035586,163953,159564,4389

Open in new window

Avatar of rjdown
rjdown
Flag of United Kingdom of Great Britain and Northern Ireland image

Check out Google Charts, it's pretty good http://code.google.com/apis/charttools/index.html

Or GraPHPite http://graphpite.sourceforge.net/
Also, if your site uses the jQuery JavaScript library there are various graphing plugins for it, e.g. http://code.google.com/p/flot/
Avatar of mirde

ASKER

Not sure if anyone knows, but I have seen a very nice "timeline" like line chart, i think it was an open source project somewhere..

Maybe i'm thinking of a plugin available to Perl.. anyone able to read my mind?

It was a very interactive timeline like chart that you could pan left/right, etc..
ASKER CERTIFIED SOLUTION
Avatar of rjdown
rjdown
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mirde

ASKER

I guess for graphing csv data which would create "many" data points (currently generating 30 data points per day, and trying to graph a month worth).

What is the best way to do this?

Annotated time-line might not be the best for this, maybe just a line graph?
Sure, line graph sounds best. The annotation is just an example of what it can do, for me the best feature there is the ability to zoom in and scroll along. For ~900 points per graph that'll probably be very useful.
Avatar of mirde

ASKER

Never really played with API stuff, more of a tech admin here..

Any idea on how to pass many csv datapoints to google API and have it graphed?

I would imagine this would need to be done programatically.. any examples of that? or references to some good reads to get started on?
Avatar of mirde

ASKER

Just the type of graph I am looking for.