Page 1 of 1

realtime.txt and MySql

Posted: Mon 28 Mar 2011 5:47 am
by markrudling
Hi Guys

Does anyone know how to import the realtime.txt file into a mysql database?

Reason, I want to run jpgraph, but not just for historical data, I would like it to be "Realtime". My idea is to feed the realtime.txt data into mysql as often as possible, then make graphs after with all the data.

Part of the reason is data sampling, I would like to have as much control as possible, so I would like to sample the data frequently and design the graphs to get the best results or most meaning full data.

Also, the weather station is at a remote location and running from a mobile data package, so the least amount of data would be best.

Im very green when it comes to mysql and php, so wrighting my own scripts wont happen, but if someone knows of this being done, or something similar, i would love to hear about it.

Searching the forums seems to only bring me to importing daily data into the DB.

Regards
Mark

Re: realtime.txt and MySql

Posted: Mon 28 Mar 2011 7:30 am
by steve
This should help to get you started - http://wiki.sandaysoft.com/a/ImportCumulusFile

It does the 'monthly' log files and dayfile.txt, so it shouldn't be too hard to use the same principle on realtime.txt.