Author Topic: Automate Cumulus to Access Database  (Read 4965 times)

0 Members and 1 Guest are viewing this topic.

Offline carson

  • Member
  • *
  • Posts: 40
Automate Cumulus to Access Database
« on: January 14, 2012, 11:34:17 PM »
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.

Offline WeatherHost

  • Forecaster
  • *****
  • Posts: 3190
Re: Automate Cumulus to Access Database
« Reply #1 on: January 15, 2012, 09:34:32 AM »
Will/can that work with Easyweather?

Banners, tags, widgets, etc. are why I have Signatures turned off.

Offline carson

  • Member
  • *
  • Posts: 40
Re: Automate Cumulus to Access Database
« Reply #2 on: January 15, 2012, 04:34:17 PM »
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. ;)

Offline carson

  • Member
  • *
  • Posts: 40
Re: Automate Cumulus to Access Database
« Reply #3 on: January 15, 2012, 06:16:20 PM »
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.


Offline WeatherHost

  • Forecaster
  • *****
  • Posts: 3190
Re: Automate Cumulus to Access Database
« Reply #4 on: January 15, 2012, 06:28:15 PM »
I pulled this out of Notepad which is the only way I know of to open a .dat file:

Code: [Select]
   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 ,

I remember seeing a post on the web somewhere that explained the fields, but I can't remember where.

Banners, tags, widgets, etc. are why I have Signatures turned off.

Offline carson

  • Member
  • *
  • Posts: 40
Re: Automate Cumulus to Access Database
« Reply #5 on: January 15, 2012, 09:03:18 PM »
Thanks WeatherHost,
I think I got EasyWeather working right... I was not even close the first time. They snuck in 2 Tabs in the middle as a monkey wrench.  But give it try now.

Offline carson

  • Member
  • *
  • Posts: 40
Re: Automate Cumulus to Access Database
« Reply #6 on: January 19, 2012, 02:15:54 AM »
Well?... any feed back would help... Geez I don't want to buy a PWS just to test this stuff so help!  Although it does seem specious that nobody has not invented this lightbulb yet.

Offline JHellis

  • Senior Member
  • **
  • Posts: 59
  • Grandpa as drawn by Grandson
Re: Automate Cumulus to Access Database
« Reply #7 on: February 14, 2012, 02:11:05 PM »
Well?... any feed back would help... Geez I don't want to buy a PWS just to test this stuff so help!  Although it does seem specious that nobody has not invented this lightbulb yet.

Hi Carson

I am waiting for my Belfryboy's Data Logger to arrive. When it does and is set up I would be pleased to test your software.

I actually use Excel rather than Access but would be willing to try your system in the spirit of testing Access (I have 2003) and weather analyses.

John
« Last Edit: February 15, 2012, 03:51:47 AM by JHellis »
Davis Vantage Vue
Belfryboy Data Logger

Online Bushman

  • Forecaster
  • *****
  • Posts: 6976
    • Eagle Bay Weather
Re: Automate Cumulus to Access Database
« Reply #8 on: February 14, 2012, 04:29:16 PM »
Can't install it unless you are an admin.  Not  good.  Make a portable version.

Offline carson

  • Member
  • *
  • Posts: 40
Re: Automate Cumulus to Access Database
« Reply #9 on: February 16, 2012, 01:05:05 AM »
JHellis, That's an interesting idea... to just use Excel first instead of going through Access.  It may be just as simple as the connection string.  I like the idea.
Thanks!
Also I give Excel workbook examples with VBA code to load Access if you want to try.

Offline carson

  • Member
  • *
  • Posts: 40
Re: Automate Cumulus to Access Database
« Reply #10 on: February 16, 2012, 01:08:45 AM »
Bushman, what is a portable version?  And why are not you admin?  Who rules your rooste anyway?  #-o

Offline JHellis

  • Senior Member
  • **
  • Posts: 59
  • Grandpa as drawn by Grandson
Re: Automate Cumulus to Access Database
« Reply #11 on: February 16, 2012, 07:19:19 AM »
Bushman, what is a portable version?

A stand alone program that does not need to be installed on the computer. It can be run from a the computer, a USB stick, SD card or external hard drive. No installation files are left on the computer.

Not sure why this would be an advantage in this case.

Bushman, I think that your problem is with your computer security rather than Carsons program. Try right mouse click on the program, then select "run as administrator" from the drop down list. The program should then run OK.

And why are not you admin?  Who rules your rooste anyway?

Good question. I know that I am in charge of my computer. My wife told me so!  :lol:
« Last Edit: February 16, 2012, 11:35:03 AM by JHellis »
Davis Vantage Vue
Belfryboy Data Logger

Online Bushman

  • Forecaster
  • *****
  • Posts: 6976
    • Eagle Bay Weather
Re: Automate Cumulus to Access Database
« Reply #12 on: February 16, 2012, 03:25:37 PM »
Bushman, what is a portable version?  And why are not you admin?  Who rules your rooste anyway?  #-o

I have a general aversion to installing programs which modify the registry unless the publisher is a known quantity - which you are not.  Portable versions are non-intrusive.  You might want to study up a bit before you send out software.

Offline saratogaWX

  • Administrator
  • Forecaster
  • *****
  • Posts: 6765
  • Saratoga, CA, USA Weather - free PHP scripts
    • Saratoga-Weather.org
Re: Automate Cumulus to Access Database
« Reply #13 on: February 16, 2012, 03:49:08 PM »
n.b.  Carson was banned on 15-Feb-2011 for repeated failure to stay in the guidelines for postings.  There won't be any more replies to this thread from him.
Ken True/Saratoga, CA, USA main site: saratoga-weather.org
Davis VP1+ FARS, Boltek-PCI/NexStorm, microSferics ToA, Blitzortung RED, GRLevel3, WD, WL, VWS, Cumulus, Meteobridge/hub
Free weather PHP scripts/website templates - update notifications on Twitter saratogaWXPHP

 

anything