Page 1 of 1
Cumulus 1.9.4 to MS SQL.
Posted: Sun 01 Mar 2015 2:01 pm
by xayide
I thought would it be possible to have a file with ALL webtags and let cumulus execute a CMD-file right after it has processed the web tags file?
If so one could use a web tags file with all data and let those insert to a MS SQL via command line. If that is executed after or right before the tags process?
I am asking this because I saw saratoga uses "realtime-extra.txt" which made me wonder if there are data which is NOT possible to gather/calculate from realtime.txt.
Does realtime.txt contain ALL important data or is something missing that is not possible to gather from other values like for instance "lux" which is possible to gather from Wm2 / 0.0079.
If I'm going to use cumulus in the future. I would like to show a webpage with data from MS SQL instead of using the "ftp-html-parser-upload" in cumulus. I rather use MS SQL to build my own page which is what I am more used to do.
A problem with this approach would be the "catch up" if computers goes down for maintenance. I guess catch up is not creating a realtime.txt for all those packets?
So bottom line question is. Does realtime.txt retain all possible data needed to calculate the others over time?
Re: Cumulus 1.9.4 to MS SQL.
Posted: Sun 01 Mar 2015 2:50 pm
by steve
The external command is executed just after the file processing. The definition of the realtime.txt file is in the help, and in the wiki -
http://wiki.sandaysoft.com/a/Realtime.txt. It is only created from 'live' data, as are any other web files.
Re: Cumulus 1.9.4 to MS SQL.
Posted: Sun 01 Mar 2015 6:58 pm
by xayide
OK found the cumuluswebtags.txt. But I am in the wrong country it seems....
1. Had problèmes whit , and . which I could solve somehow with another user account in english in windows.
2. Then I had problem with these rows....: $ByMonthAppTempH[1]=---; // January. So I changed them all to this $ByMonthAppTempH[1]='---'; // January....with quotes.
3. After that I had problem with things like $WindRoseData=[0.0,439.2,0.0,0.0,0.0,0.0,40.3,68.2,245.0,20.4,0.0,0.0,0.0,0.0,0.0,0.0]; PHP says Parse error: syntax error, unexpected '[' in cumuluswebtags.php
That one I didn't solve so far. This made me believe I am missing something here?
I mean the missing quotes on 2 shouldnt possibly work in english local either, right?
Is there some setting in php.ini missing or what is causing this?
Re: Cumulus 1.9.4 to MS SQL.
Posted: Sun 01 Mar 2015 7:07 pm
by steve
Someone else should be able to help you with that, I know very little about PHP.
Re: Cumulus 1.9.4 to MS SQL.
Posted: Sun 01 Mar 2015 11:49 pm
by water01
Why don't you use ImportCumulusFile from here
http://wiki.sandaysoft.com/a/Category:WebTools
It will import the Dayfile, multiple Realtime files (I keep a rolling 7 days worth) and the Month Files.
I know that Mark Crossley has an updated version that has some corrected rainfall fields in it as I have been testing it for him. He is (or was) about to update it to the Wiki.
Re: Cumulus 1.9.4 to MS SQL.
Posted: Mon 02 Mar 2015 10:15 am
by mcrossley
water01 wrote:He is (or was) about to update it to the Wiki.
'tis already there

Re: Cumulus 1.9.4 to MS SQL.
Posted: Mon 02 Mar 2015 10:17 am
by mcrossley
xayide wrote:OK found the cumuluswebtags.txt. But I am in the wrong country it seems....
1. Had problèmes whit , and . which I could solve somehow with another user account in english in windows.
2. Then I had problem with these rows....: $ByMonthAppTempH[1]=---; // January. So I changed them all to this $ByMonthAppTempH[1]='---'; // January....with quotes.
3. After that I had problem with things like $WindRoseData=[0.0,439.2,0.0,0.0,0.0,0.0,40.3,68.2,245.0,20.4,0.0,0.0,0.0,0.0,0.0,0.0]; PHP says Parse error: syntax error, unexpected '[' in cumuluswebtags.php
That one I didn't solve so far. This made me believe I am missing something here?
I mean the missing quotes on 2 shouldnt possibly work in english local either, right?
Is there some setting in php.ini missing or what is causing this?
2. Yes, good practice to quote tags that may not produce the expected value.
3. Sounds like you have an older version of PHP that does not understand the [] array syntax, replace "[...]" with "array(...)"
Re: Cumulus 1.9.4 to MS SQL.
Posted: Mon 02 Mar 2015 10:10 pm
by xayide
water01 wrote:Why don't you use ImportCumulusFile from here
http://wiki.sandaysoft.com/a/Category:WebTools
It will import the Dayfile, multiple Realtime files (I keep a rolling 7 days worth) and the Month Files.
I know that Mark Crossley has an updated version that has some corrected rainfall fields in it as I have been testing it for him. He is (or was) about to update it to the Wiki.
Sounds just like what I need. I guess I missed it somehow. So I guess the importcumulsfile imports all important values even tho it doesn't have all the 800 values of the web tags it is possible to extract/calculate the missing ones from the values it does import?
Also is importcumulusfile secure against realtime data missing since it read the log files will importcumulusfile also reflect the data read during catchup?