Welcome to the Cumulus Support forum.
Latest Cumulus MX V4 release 4.0.0 (build 4022) - 11 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 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 V4 release 4.0.0 (build 4022) - 11 May 2024
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 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
Top 10 Records Page
Moderator: daj
- mcrossley
- Posts: 12824
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
Fixed, though I see my phone is now in a time warp, it updated this morning to the Oreo 5th October 2017 update!
-
- Posts: 79
- Joined: Mon 09 Mar 2015 10:45 am
- Weather Station: wh3080
- Operating System: windows
- Location: Cosenza
Re: Top 10 Records Page
Hi guys
after updating my file squil in the import phase I give error 500
I downloaded the latest version of importcumulusfile.php and toptens.php
who helps me solve it?
after updating my file squil in the import phase I give error 500
I downloaded the latest version of importcumulusfile.php and toptens.php
who helps me solve it?
- mcrossley
- Posts: 12824
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
You will need to look in your web servers error log for a clue. Failing that you will need to enable full error reporting in the script. I'm away on holiday at the mo, so support from me is going to be patchy/intermittent.
-
- Posts: 86
- Joined: Thu 10 Nov 2011 8:14 pm
- Weather Station: VP2+SHT31+DFars+Solar+AeroCone
- Operating System: Windows 10
- Location: Hemel Hempstead, Hertfordshire, UK
Re: Top 10 Records Page
Installed Top 10 records, and I have a query regards this years records. I was expecting to see all records broken in 2017 showing in blue, however only one in September for smallest pressure change is showing. Is this how it’s meant to be; if so is there a way to turn on all records broken for 2017?
To see how my records look, go to the the system info page; which I use for testing.
Colin
To see how my records look, go to the the system info page; which I use for testing.
Colin
- mcrossley
- Posts: 12824
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
The highlight's are for the last 30 days, or this year depending on the record type. You can change the 30 day period somewhere near the top of the source code. I don't have access to that at the mo to check though.
To do "this year" for all records would be more involved as the SQL queries themselves return the highlight flag.
To do "this year" for all records would be more involved as the SQL queries themselves return the highlight flag.
-
- Posts: 86
- Joined: Thu 10 Nov 2011 8:14 pm
- Weather Station: VP2+SHT31+DFars+Solar+AeroCone
- Operating System: Windows 10
- Location: Hemel Hempstead, Hertfordshire, UK
Re: Top 10 Records Page
Mark
I thought that's how it was working. My old Access produced top ten records changing for the current year, but on numerous pages. Your work is far superior.
Thank you
Colin
I thought that's how it was working. My old Access produced top ten records changing for the current year, but on numerous pages. Your work is far superior.
Thank you
Colin
-
- Posts: 1183
- Joined: Fri 27 Jul 2012 11:29 am
- Weather Station: Chas O, Maplin N96FY, N25FR
- Operating System: rPi 3B+ with Buster (full)
Re: Top 10 Records Page
I have not looked up Mark's source, and I recall that I made many changes for my version as discussed with Mark at the time.
I have found I used
Colin
I suspect $recentHighlight is the variable name that Mark chose, and as you can see from my comment I have approximated it to highlight everything this year by multiplying it by the values shown ($monthNum will be 10 for October). PHP does have ability to report a date in the number of days this year format (it is 'z') so with hindsight that would be better way to define the maximum number of days old that require the highlight.
As Mark says for many tables recent test is in the SQL, the first two items in the select are what appears in the table and the third is a condition that determines if it is highlighted. Again I modified mine to compare just year by writing
but I suspect Mark uses a different variable name in RH side, and there are a lot of queries to edit (even more in my version).
I have found I used
Code: Select all
$recentHighlight = $monthNum * 31; // number of days (+1) of recent records to highlight, initialised at approximate equivalent for number of days so far this year
I suspect $recentHighlight is the variable name that Mark chose, and as you can see from my comment I have approximated it to highlight everything this year by multiplying it by the values shown ($monthNum will be 10 for October). PHP does have ability to report a date in the number of days this year format (it is 'z') so with hindsight that would be better way to define the maximum number of days old that require the highlight.
Code: Select all
$recentHighlight = new DateTime ("now") -> format("z");
Code: Select all
"DATE_FORMAT(LogDate, '%Y') = DATE_FORMAT('$lastDateOnDB', '%Y') ";
-
- Posts: 86
- Joined: Thu 10 Nov 2011 8:14 pm
- Weather Station: VP2+SHT31+DFars+Solar+AeroCone
- Operating System: Windows 10
- Location: Hemel Hempstead, Hertfordshire, UK
Re: Top 10 Records Page
As it is works on rolling days, If I up the 32 to 366 it’s giving me all the records so far for 2017. However as there’s still October/November and December 2017 to left check, it showing records from 2016. So I’m getting pretty much what I want. A fix would be to change previous years records to black as top 10 moves to current year.
Colin
Colin
- BeaumarisWX
- Posts: 376
- Joined: Mon 09 Apr 2012 2:38 pm
- Weather Station: Davis VP2 Plus - 24hr FARS
- Operating System: Windows 10 Pro Hades Canyon
- Location: Beaumaris, Tasmania, AU
- Contact:
Re: Top 10 Records Page
When I want to highlight current year I use this, works perfect every time:
regards,
Code: Select all
$dayNumber = date("z"); // Day Number of current Year eg. ( 284 ) for today 2017/10/11
$recentHighlight = $dayNumber; // number of days (so far in current year) of recent records to highlight
Tony Beaumaris, Tasmania (AUS)
CMX Mobile : https://beaumaris-weather.com/BWX/
CMX Default: https://beaumaris-weather.com/cumulusmx_default/
Colour Dashboard : https://beaumaris-weather.com/dashborad_color.php
Click below for Saratoga Template :
CMX Mobile : https://beaumaris-weather.com/BWX/
CMX Default: https://beaumaris-weather.com/cumulusmx_default/
Colour Dashboard : https://beaumaris-weather.com/dashborad_color.php
Click below for Saratoga Template :
-
- Posts: 57
- Joined: Mon 11 Apr 2016 12:39 pm
- Weather Station: Ecowitt hp2551
- Operating System: Windows 10
- Location: Finland
Re: Top 10 Records Page
Hi. This is first time i try to do anything with MYSQL and of course it didn't work. I created MYSQL database in my web hosting and then edited the ImportCumulusFile and CumulusMX settings with same passwords etc..
Host name <--- my local host
Port <-- cumulusmx port, cumulusmx only, not in the ImportCumulusFile
User name <--- user name from MYSQL database i created
Password <--- <--- password from MYSQL database i created
Database name <---- <--- database name from MYSQL database i created
So these are identical with CumulusMX and ImportCumulusFile. I saved settings in CumulusMX and tried to create dayfile but it only says: Error: Lost connection to MySQL server during query.
I have uploaded the edited ImportCumulusFile and Cumulus already uploads the dayfile. What have i done wrong? I tried web hosting passwords and mysql passwords etc but always end up with same error.
Host name <--- my local host
Port <-- cumulusmx port, cumulusmx only, not in the ImportCumulusFile
User name <--- user name from MYSQL database i created
Password <--- <--- password from MYSQL database i created
Database name <---- <--- database name from MYSQL database i created
So these are identical with CumulusMX and ImportCumulusFile. I saved settings in CumulusMX and tried to create dayfile but it only says: Error: Lost connection to MySQL server during query.
I have uploaded the edited ImportCumulusFile and Cumulus already uploads the dayfile. What have i done wrong? I tried web hosting passwords and mysql passwords etc but always end up with same error.
- mcrossley
- Posts: 12824
- Joined: Thu 07 Jan 2010 9:44 pm
- Weather Station: Davis VP2/WLL
- Operating System: Bullseye Lite rPi
- Location: Wilmslow, Cheshire, UK
- Contact:
Re: Top 10 Records Page
Normally remote access directly to your MySQL database will be disabled, you have to add the IP address that that server sees from your CumulusMX host to the allowed remote servers list.
In the PHP import script, because it runs on the same server as your database, leave the host at the default "127.0.0.1" or "localhost" settings.
In the PHP import script, because it runs on the same server as your database, leave the host at the default "127.0.0.1" or "localhost" settings.
-
- Posts: 57
- Joined: Mon 11 Apr 2016 12:39 pm
- Weather Station: Ecowitt hp2551
- Operating System: Windows 10
- Location: Finland
Re: Top 10 Records Page
I added IP address to MYSQL remote access but still have same error
-
- Posts: 57
- Joined: Mon 11 Apr 2016 12:39 pm
- Weather Station: Ecowitt hp2551
- Operating System: Windows 10
- Location: Finland
Re: Top 10 Records Page
Sorry again for stupid questions but why my top 10 page looks like this: PK!ߤÒlZ [Content_Types].xml ¢( ´”ËnÂ0E÷•ú‘·Ub袪*‹>–-Ré{Vý’Ǽþ¾QU‘ l"%3÷Þ3VƃÑÚšl µw%ë=–“^i7+Ù×ä-d&á”0ÞAÉ6€l4¼½L60#µÃ’ÍS Oœ£œƒXøŽ*•V$z3„ü3à÷½Þ—Þ%p)Oµ^ “²×5}nH"dÙsÓXg
and the list goes on.. I have no idea what to do..
and the list goes on.. I have no idea what to do..
-
- Posts: 57
- Joined: Mon 11 Apr 2016 12:39 pm
- Weather Station: Ecowitt hp2551
- Operating System: Windows 10
- Location: Finland
Re: Top 10 Records Page
Yes: http://kesis.info/Saa/Top10.phpmcrossley wrote:Do you have a link to the page?