Cacti: Graphing XML data from HTTP GET

I have a MeteoHub device that connects to our weather station in the office and stores the sensor values from various hygrometers in our office. They have an HTTP data request model that seems to be pretty extensive in what you can request (located here: http://www.meteohub.de/joomla/index.php?option=com_docman&task=doc_download&gid=99&Itemid=29 ).

What I want to do is get some way of parsing this data from the MeteoHub in a Cacti data source so I can graph the temperature and ambient humidity in the office. I'd want to break down the data for the 4 sensors we have: thb0, th0, th5, and th6.

One caveat is that some of the sensors check in every 90 seconds and not every 60, so in order to poll the source every minute, it would have to request a broader time range in the HTTP GET and use only the most recent value.

Also, the data is stored on a filesystem in a plain-text document, so if accessing the log file and parsing for the data would be an easier path let me know. I can close this question and open a new one with that in mind.
Example XML return from the HTTP GET on http://192.168.2.151/meteolog.cgi?mode=data&type=xml&start=20090501001200&end=20090501001300
 
<logger>
  <THB date=20090501001207 id=thb0 temp=22.4 hum=51 dew=11.8 press=988.0 seapress=1011.5 fc=2>
  <TH date=20090501001209 id=th5 temp=21.5 hum=59 dew=13.2>
  <THB date=20090501001217 id=thb0 temp=22.4 hum=51 dew=11.8 press=988.0 seapress=1011.5 fc=2>
  <THB date=20090501001227 id=thb0 temp=22.4 hum=51 dew=11.8 press=988.0 seapress=1011.5 fc=2>
  <THB date=20090501001237 id=thb0 temp=22.4 hum=51 dew=11.8 press=988.0 seapress=1011.5 fc=2>
  <UV date=20090501001244 id=uv0 index=0.0>
  <THB date=20090501001247 id=thb0 temp=22.4 hum=51 dew=11.8 press=988.0 seapress=1011.5 fc=2>
  <THB date=20090501001257 id=thb0 temp=22.4 hum=51 dew=11.8 press=988.0 seapress=1011.5 fc=2>
</logger>

Open in new window

drbill1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ai_ja_naiCommented:
Cacti is not suited. You'd spend more time in customizing it to accept your parsed data than finding something simpler to fullfill your goal.
I suggest using a php to to parse the xml and then using php built in graphic functions to draw the graphs, storing the old data in a rdbms for historical purposes.

php parser: http://www.devpapers.com/article/61/
rdbms: http://www.sqlite.org/
simple graphics in php: http://articles.techrepublic.com.com/5100-10878_11-5092227.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
drbill1Author Commented:
Not a complete solution, but it set me down the right path.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Network Analysis

From novice to tech pro — start learning today.