Automatic push of data to MySQL server

Requests for future functionality

Moderator: Mattk

ZebraWetter
Junior Boarder
Junior Boarder
Posts: 22
Joined: Sun Aug 14, 2011 11:44 am
Location: Duisburg/northrhine-westfalia/germany/earth/sol system

Re: Automatic push of data to MySQL server

Post by ZebraWetter »

HLucas01 wrote: but I never install scripts on any server or computer unless I have validated the content of the script.
Same to me. I'm very careful with unknown scripts, so I decided not to test it.

How does the script retrieve the data? Does it retrieve the actual data using meteolog.cgi?mode=data in XML or plain text? Does it read the "all-sensors" in plain text or xml? Would be interesting to know how other programmers solve it.
Currently I'm writing an extension for TYPO3 using extbase and fluid and I'm not shure at the moment if it should retrieve the weather data "on the fly" or collect it continuously and store it in the database.
bcoulter
Fresh Boarder
Fresh Boarder
Posts: 11
Joined: Tue Jul 31, 2012 1:58 am
Contact:

Re: Automatic push of data to MySQL server

Post by bcoulter »

Hi,
Here's my version for doing this - again its a php script..but there's no encoding... You may find it useful or not!

http://www.wexfordharbour.info/csvimport_sheeva.zip

It's pretty simple, and requires a little bit of editing depending on what you want to achieve.
You'll need to set your server to run it as a Scheduled Application / CRON job as often as you require (personally i do it every 2 mins)
----------------------------------------

http://www.wexfordharbour.info
Mavy
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: Mon Nov 12, 2012 11:41 am
Location: Breda, The Netherlands

Re: Automatic push of data to MySQL server

Post by Mavy »

I actualy went a different route from the most of you. I also wanted to push weather data to a MySQL db for use in a few websites.
After a few quick google's i found wfrog.This python app pushed data to a mysql db and as a bonus generates real time graphs.

However both meteohub and wfrog need direct access to the weather station. The solution?
A new station driver for wfrog that uses the meteohub xml export to get its data.

It basically connects to the meteohub server 4 times a minute to get the latest data from the server and processes this info as if it was data from a normal weather station.

I am currently still testing the script but if someone wants to test it feel free to send me a PM and i will send you the setup instructions.
Post Reply