Weather Software > Cumulus
Automate Cumulus to Access Database
carson:
For Cumulus users wanting to automate adding your monthly log text data to a MS Access database every 5 or 10 minutes or when ever... (you do not need to own MS Access).
http://getmyrealtime.com/Default.aspx
Cumulus from Sandaysoft documentation says it's monthly log file (Aug09log.txt) gets updated about every 10-minutes or so:
http://wiki.sandaysoft.com/a/Monthly_log_files
So my GetRealtime should be able to read this (;) or (,) delimited text file as well as Davis files and oodles of other data on the web... but remember the format is 'dd-mm-yy' or 'dd/mm/yy' and has to be added to the GetRealtime_setup.txt because of this screwy dating convention... just like Davis.
My software is free. If anyone gives it a try please let me know how it goes.
WeatherHost:
Will/can that work with Easyweather?
carson:
Sorry everyone, I assumed way too much and made and A.S.S. of myself. :oops:
But on what planet does months mean days and commas mean periods. So after further review of the Cumulus log file formats this afternoon I think I have it right.
Hi WeatherHost,
I don't know about Easyweather but I will take a look on the web. But I am about to give up on this stuff up and get out of the weather station business if this keeps up. ;)
carson:
WeatherHost, I updated GetRealtime to read EasyWeather text files but I have no actual data to test. If you could just paste a few lines of data to you post here that would help make sure it is working. I'm not making that mistake again.
EasyWeather.dat file:
http://www.jim-easterbrook.me.uk/weather/ew/
Great! A weather station that speaks English. I have added a extension to the date format in GetRealtime_setup.txt where you can set what column the date will be in:
The EasyWeather data file has it's date in the 3rd column so the base1 cell in GetRealtime_setup.txt would look like this:
yyyy-mm-dd, 3
Whoops, I spoke to soon. Note the date divider is '-' and so you would have to add the date format anyway. And Wind Direction ENE appears as NEE, ESE appears as SEE... What is with these weather people!?!? I will check for this so it should work ok.
But the integer Wind Direction is 0-15, not 0-360, so you are out of luck there unless you really really really just have to have it.
WeatherHost:
I pulled this out of Notepad which is the only way I know of to open a .dat file:
--- Code: --- 1, 2011-12-21 09:15:44, 2011-11-26 15:22:21, 30, 51, 21.3, 49, 21.8, 10.6, 19.3, 999.0, 1013.2, 4.4, 3, 7.1, 4, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000100, 1E 33 D5 00 31 DA 00 06 27 2C 47 00 0A 11 00 00 ,
2, 2011-12-21 09:15:44, 2011-11-26 15:52:21, 30, 49, 20.9, 52, 21.2, 11.0, 21.2, 998.8, 1013.0, 1.7, 2, 3.1, 2, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000110, 1E 31 D1 00 34 D4 00 04 27 11 1F 00 0A 11 00 00 ,
3, 2011-12-21 09:15:44, 2011-11-26 16:22:21, 30, 52, 20.0, 52, 21.0, 10.8, 19.6, 998.4, 1012.6, 2.7, 2, 4.1, 3, 8, S, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000120, 1E 34 C8 00 34 D2 00 00 27 1B 29 00 08 11 00 00 ,
4, 2011-12-21 09:15:44, 2011-11-26 16:52:21, 30, 57, 18.8, 54, 20.7, 11.1, 19.6, 998.4, 1012.6, 2.4, 2, 4.1, 3, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000130, 1E 39 BC 00 36 CF 00 00 27 18 29 00 0A 11 00 00 ,
5, 2011-12-21 09:15:44, 2011-11-26 17:22:21, 30, 59, 18.5, 54, 21.0, 11.4, 19.3, 998.2, 1012.4, 3.1, 2, 6.5, 4, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000140, 1E 3B B9 00 36 D2 00 FE 26 1F 41 00 0A 11 00 00 ,
6, 2011-12-21 09:15:44, 2011-11-26 17:52:21, 30, 59, 18.3, 53, 21.2, 11.3, 18.1, 998.0, 1012.2, 5.1, 3, 7.1, 4, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000150, 1E 3B B7 00 35 D4 00 FC 26 33 47 00 0A 11 00 00 ,
7, 2011-12-21 09:15:44, 2011-11-26 18:22:21, 30, 60, 18.1, 55, 21.0, 11.6, 18.8, 997.9, 1012.1, 3.7, 3, 7.1, 4, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000160, 1E 3C B5 00 37 D2 00 FB 26 25 47 00 0A 11 00 00 ,
8, 2011-12-21 09:15:44, 2011-11-26 18:52:21, 30, 61, 18.1, 55, 21.0, 11.6, 19.0, 997.8, 1012.0, 3.4, 3, 5.1, 3, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000170, 1E 3D B5 00 37 D2 00 FA 26 22 33 00 0A 11 00 00 ,
9, 2011-12-21 09:15:44, 2011-11-26 19:22:21, 30, 61, 18.1, 56, 21.0, 11.9, 18.1, 997.8, 1012.0, 4.8, 3, 8.8, 5, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000180, 1E 3D B5 00 38 D2 00 FA 26 30 58 00 0A 11 00 00 ,
10, 2011-12-21 09:15:44, 2011-11-26 19:52:21, 30, 60, 18.9, 65, 20.0, 13.2, 16.2, 998.3, 1012.5, 5.8, 4, 7.8, 4, 10, SW, 17, 5.1, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0, 0, 0, 0, 0, 0, 000190, 1E 3C BD 00 41 C8 00 FF 26 3A 4E 00 0A 11 00 00 ,
11, 2011-12-21 09:15:44, 2011-11-26 20:22:21, 30, 57, 20.9, 94, 15.9, 15.0, 15.9, 999.4, 1013.6, 1.7, 2, 3.1, 2, 14, NW, 34, 10.2, 5.1, 5.1, 5.1, 5.1, 5.1, 5.1, 0, 0, 0, 0, 0, 0, 0, 0, 0001A0, 1E 39 D1 00 5E 9F 00 0A 27 11 1F 00 0E 22 00 00 ,
12, 2011-12-21 09:15:44, 2011-11-26 20:52:21, 30, 59, 19.5, 95, 14.5, 13.7, 14.5, 999.5, 1013.7, 1.0, 1, 1.7, 2, 12, W, 48, 14.4, 4.2, 9.3, 9.3, 9.3, 9.3, 9.3, 0, 0, 0, 0, 0, 0, 0, 0, 0001B0, 1E 3B C3 00 5F 91 00 0B 27 0A 11 00 0C 30 00 00 ,
13, 2011-12-21 09:15:44, 2011-11-26 21:22:21, 30, 59, 19.2, 97, 14.2, 13.7, 14.2, 999.4, 1013.6, 1.0, 1, 1.4, 1, 12, W, 60, 18.0, 3.6, 7.8, 12.9, 12.9, 12.9, 12.9, 0, 0, 0, 0, 0, 0, 0, 0, 0001C0, 1E 3B C0 00 61 8E 00 0A 27 0A 0E 00 0C 3C 00 00 ,
14, 2011-12-21 09:15:44, 2011-11-26 21:52:21, 30, 60, 18.8, 99, 14.2, 14.1, 14.2, 999.3, 1013.5, 0.7, 1, 1.0, 1, 10, SW, 67, 20.1, 2.1, 5.7, 15.0, 15.0, 15.0, 15.0, 0, 0, 0, 0, 0, 0, 0, 0, 0001D0, 1E 3C BC 00 63 8E 00 09 27 07 0A 00 0A 43 00 00 ,
15, 2011-12-21 09:15:44, 2011-11-26 22:22:21, 30, 61, 18.8, 99, 14.1, 14.0, 14.1, 999.0, 1013.2, 0.3, 1, 1.0, 1, 8, S, 74, 22.2, 2.1, 4.2, 17.1, 17.1, 17.1, 17.1, 0, 0, 0, 0, 0, 0, 0, 0, 0001E0, 1E 3D BC 00 63 8D 00 06 27 03 0A 00 08 4A 00 00 ,
16, 2011-12-21 09:15:44, 2011-11-26 22:52:21, 30, 61, 18.9, 99, 14.1, 14.0, 14.1, 998.7, 1012.9, 0.3, 1, 1.0, 1, 8, S, 79, 23.7, 1.5, 3.6, 18.6, 18.6, 18.6, 18.6, 0, 0, 0, 0, 0, 0, 0, 0, 0001F0, 1E 3D BD 00 63 8D 00 03 27 03 0A 00 08 4F 00 00 ,
17, 2011-12-21 09:15:44, 2011-11-26 23:02:21, 10, 61, 18.9, 99, 14.1, 14.0, 14.1, 998.9, 1013.1, 0.3, 1, 1.0, 1, 10, SW, 80, 24.0, 0.3, 3.9, 18.9, 18.9, 18.9, 18.9, 0, 0, 0, 0, 0, 0, 0, 0, 000200, 0A 3D BD 00 63 8D 00 05 27 03 0A 00 0A 50 00 00 ,
18, 2011-12-21 09:15:44, 2011-11-26 23:12:21, 10, 61, 18.9, 99, 14.1, 14.0, 14.1, 998.5, 1012.7, 1.0, 1, 1.7, 2, 10, SW, 81, 24.3, 0.3, 4.2, 19.2, 19.2, 19.2, 19.2, 0, 0, 0, 0, 0, 0, 0, 0, 000210, 0A 3D BD 00 63 8D 00 01 27 0A 11 00 0A 51 00 00 ,
19, 2011-12-21 09:15:44, 2011-11-26 23:22:21, 10, 61, 18.9, 99, 14.1, 14.0, 14.1, 998.3, 1012.5, 0.3, 1, 0.7, 1, 8, S, 84, 25.2, 0.9, 3.0, 20.1, 20.1, 20.1, 20.1, 0, 0, 0, 0, 0, 0, 0, 0, 000220, 0A 3D BD 00 63 8D 00 FF 26 03 07 00 08 54 00 00 ,
--- End code ---
I remember seeing a post on the web somewhere that explained the fields, but I can't remember where.
Navigation
[0] Message Index
[#] Next page
Go to full version