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
Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080
Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080
realtime.txt and MySql
Moderator: daj
-
markrudling
- Posts: 10
- Joined: Wed 23 Mar 2011 4:13 pm
- Weather Station: WS2300
- Operating System: Windows XP
- Location: Durban, South Africa
-
steve
- Cumulus Author
- Posts: 26672
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: realtime.txt and MySql
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.
It does the 'monthly' log files and dayfile.txt, so it shouldn't be too hard to use the same principle on realtime.txt.
Steve