Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

Highcharts Graphs

Discussion and support for 3rd-party (non-Sandaysoft) tools for Cumulus
uncle_bob
Posts: 471
Joined: Wed Aug 17, 2011 2:58 pm
Weather Station: WeatherDuino Pro2
Operating System: 2008
Location: Canberra

Re: Highcharts Graphs

Postby uncle_bob » Tue May 08, 2018 9:48 am

Good morning all (trying to sound like Julian Ilett :) )

Yes, vers 2.8 seemed to have worked fine:

08/05/18 - 11:45:20
Importing to table: Dayfile ...
Processing dayfile: C:\Cumulus\data\dayfile.txt
Table does not exist, creating it...
Inserting data...
Inserted 2446 rows
done.
End of script 08/05/18 - 11:45:23 - execution time: 2.864s

User avatar
mcrossley
Posts: 5147
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Highcharts Graphs

Postby mcrossley » Tue May 08, 2018 9:54 am

OK, good to know, I think the binding error is to do with you having "null" values in the data file - In mine I have set all those to zero values at some point. I didn't get a chance to look at this yesterday, but at some point I'll see if that is the problem and what I can do about it...

uncle_bob
Posts: 471
Joined: Wed Aug 17, 2011 2:58 pm
Weather Station: WeatherDuino Pro2
Operating System: 2008
Location: Canberra

Re: Highcharts Graphs

Postby uncle_bob » Tue May 08, 2018 10:58 am

Hi Mark, and thanks for the help with this.
There will definitely be issues since I had to try and Un-Fine Offset the corrupted data when I've noticed it.
If you want to have a play around with my complete dayfile, let me know.
Thanks again UB :)

sfws
Posts: 409
Joined: Fri Jul 27, 2012 11:29 am
Weather Station: Customised Fine Offset
Operating System: off-line Vista and W10 PCs
Location: UK

Re: Highcharts Graphs

Postby sfws » Tue May 08, 2018 1:42 pm

mcrossley wrote:having "null" values in the data file - In mine I have set all those to zero values

Maybe, it is just personal preference, as I'm not a computer specialist, but "garbage in, garbage out" is a saying that I have heard. I don't want to apply validation in each retrieval script, I prefer to apply it once when loading the database (and therefore I use nulls extensively). The use of zero values does not make sense to me, zero is definitely a valid number in many measurements.

Back in 2014 when I made my first exploratory venture into PHP and database, I rejected using your script (earlier version) and wrote my own because I wanted to use official nulls for any values where either the measurement was missing or it was suspect. Ironically it was some rogue temperature measurements that influenced my thinking, so using zero would definitely not suit me. Incidentally, in my script I also set time-stamps to null when the associated value does not "make sense" (unlike Cumulus that would leave those time-stamps at rollover time). So if there is no rain in a day, the time of the highest hourly rain (or time of peak rain rate) is to my way of thinking null rather than rollover time just as much as it would be if the rain gauge was not working. Of course, my database tables are not exact mirrors of any Cumulus log files, so I don't think your binding approach would work with my tables, and because I access real-time log directly on the rare times I need it, speed of loading database tables does not matter to me.

User avatar
mcrossley
Posts: 5147
Joined: Thu Jan 07, 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Highcharts Graphs

Postby mcrossley » Tue May 08, 2018 2:11 pm

It's been debated before, if I were starting from scratch I'd possibly use a different DB schema, however the script and DB was in existence for a year or so before I started using it. David Jamieson originally constructed it and decided to make the DB a more or less straight copy of the Cumulus log files, which was as valid decision as any at the time.

I'm sure if Steve were starting from scratch he'd probably alter the Cumulus log file format too, but we have what we have.


Return to “3rd Party Tools”

Who is online

Users browsing this forum: No registered users and 5 guests