YES!mcrossley wrote:
Any interest in me releasing this script?
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 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
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 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
Sun Plot
Moderator: daj
-
- Posts: 144
- Joined: Sun 13 Feb 2011 7:12 pm
- Weather Station: Davis Vantage Pro 2
- Operating System: RaspBerry Pi Win 10 OSx
- Location: Spring, Texas USA
- Contact:
Re: Sun Plot
That would be simply delightful!
retreat at augusta pines weather
CumulusMX on Raspberry π rPi5
http://augusta-pines-weather.com / CumulusMX 4.0.0 build:4020
WeatherUnderground KTXSPRIN538
CumulusMX on Raspberry π rPi5
http://augusta-pines-weather.com / CumulusMX 4.0.0 build:4020
WeatherUnderground KTXSPRIN538
- beteljuice
- Posts: 3292
- Joined: Tue 09 Dec 2008 1:37 pm
- Weather Station: None !
- Operating System: W10 - Threadripper 16core, etc
- Location: Dudley, West Midlands, UK
Re: Sun Plot
Mark, your suggestions and scripts are ALWAYS well received
......................Imagine, what you will KNOW tomorrow !
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Sun Plot
Not sure about that, some are more trouble than they are worth!beteljuice wrote:Mark, your suggestions and scripts are ALWAYS well received
Anyway, I've put a new page on my site to start collecting some of these scripts together. The sunplot should now be downloadable from there (if I've got the .htaccess file right!).
http://weather.wilmslowastro.com/scripts.php
-
- Posts: 1808
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: Sun Plot
Does the sunshine have to come from the realtime sql upload, or can the monthly one be used?
Edit: I see 'IsSunny' in the file, so I guess that is in the realtime?!
I don't upload that at the moment, but I will do it now. I'm not sure about the retention string bit - after reading a post by Steve, I see it is optional?
Edit: I see 'IsSunny' in the file, so I guess that is in the realtime?!
I don't upload that at the moment, but I will do it now. I'm not sure about the retention string bit - after reading a post by Steve, I see it is optional?
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Sun Plot
Sunshine has to come from a real time table, you need the minute by minute state, the daily value is just the total hours for the day and isn't created until midnight (or 9am).
The plot will work without the sunshine data though.
The plot will work without the sunshine data though.
-
- Posts: 1808
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: Sun Plot
I've got it up and running without the sunshine enabled.
It seems my server doesn't like 'Europe/London' in the timezone setting when dealing with sql, it comes up with an error. I tried +00:00 and +01:00 but it makes the plot go a bit strange.
It seems my server doesn't like 'Europe/London' in the timezone setting when dealing with sql, it comes up with an error. I tried +00:00 and +01:00 but it makes the plot go a bit strange.
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Sun Plot
Sounds like your MySQL instance doesn't have the time zone information imported.
http://dev.mysql.com/doc/refman/5.7/en/ ... o-sql.html
http://dev.mysql.com/doc/refman/5.7/en/ ... o-sql.html
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Sun Plot
Thanks John.jdc wrote:Another very clever & useful script, Mark.
-
- Posts: 1808
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: Sun Plot
I'm also one of those who can import the timezones, due to restrictions.
I did this instead: $tz = '+1:00';
I don't know if this is making the graphs odd, or whether it is correct?
http://www.warehamwx.co.uk/cumulus/sunplot.php
I did this instead: $tz = '+1:00';
I don't know if this is making the graphs odd, or whether it is correct?
http://www.warehamwx.co.uk/cumulus/sunplot.php
- mcrossley
- Posts: 12756
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Sun Plot
Try just commenting out the setting of the time zone in MySQL
-
- Posts: 1808
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: Sun Plot
I've got that solved. I sent a ticket explaining that I'm unable to load the timezones myself, and they have done it for me!
Now that's working, I need to add a retention string to CMX, so that it deletes the realtime data every 24hrs, otherwise it'll just fill up too quickly.
I though this would work: DELETE * FROM Realtime WHERE LogDateTime >= now() + INTERVAL 1 DAY;
I get an error though..
Now that's working, I need to add a retention string to CMX, so that it deletes the realtime data every 24hrs, otherwise it'll just fill up too quickly.
I though this would work: DELETE * FROM Realtime WHERE LogDateTime >= now() + INTERVAL 1 DAY;
I get an error though..
- steve
- Cumulus Author
- Posts: 26701
- Joined: Mon 02 Jun 2008 6:49 pm
- Weather Station: None
- Operating System: None
- Location: Vienne, France
- Contact:
Re: Sun Plot
Are you using the standard realtime.txt MySQL update? If so, you just need to specify the interval - see the announcement for build 3025 where I give some examples.
Steve
-
- Posts: 1808
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: Sun Plot
Ah bingo! Thank you Steve!steve wrote:Are you using the standard realtime.txt MySQL update? If so, you just need to specify the interval - see the announcement for build 3025 where I give some examples.
I tested it at 1 minute, and it did the job! I should've realised that, there was me trying to add in full syntax
So if I make it delete the table every 24 hours, will it be from time I click save in CMX?