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 4018) - 28 March 2024

Legacy Cumulus 1 release v1.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

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

Post Reply
User avatar
mcrossley
Posts: 12694
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

Post by mcrossley »

A minor tweak to 'my' ver 0.12 - I have dropped the 'driest years' to make some space (it duplicates wettest years until I have been running longer than 10 years!) and added Most (& Least) Rain Days in a Month.

http://weather.wilmslowastro.com/top10s.php
User avatar
JennyLeez
Posts: 314
Joined: Wed 16 Dec 2009 2:32 am
Weather Station: La Crosse WS3083
Operating System: Windows XP, Win7 & Win 10
Location: Wairoa, Hawkes Bay. New Zealand.
Contact:

Re: Top 10 Records Page

Post by JennyLeez »

and done..

Many thanks for alterations, good stats added.

Gee 127mm over 30 rain days for your January. So thats 1 dry day. Pleased I dont live up there.

I call my top10 page my auditor. It keeps me on my toes keeping my dayfile correct....lol

Again thanks,
Jenny
Wairoa, Hawkes Bay, New Zealand Weather Station:
http://wairoa.net/weather/index.htm
Cumulus Topsites:
http://cumulussites.net/
Image
Bridger
Posts: 60
Joined: Fri 01 Jun 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows 11 Home
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Post by Bridger »

Mark, thanks for the updated script - very useful additions to the table.
User avatar
mcrossley
Posts: 12694
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

Post by mcrossley »

Out of interest... as ever I make these scripts available for people to use as a basis for their own customised versions, so has anybody added their own stats that may be of interest to others?
Bridger
Posts: 60
Joined: Fri 01 Jun 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows 11 Home
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Post by Bridger »

At 1:30 on 19th July my FO WH1090 transmitter stopped working at the same time as a lightning strike on the nearby church.
About 10 minutes before the strike we had torrential rain and my station recorded a record rain rate of 111.6mm/hr.
I am back up and running with a new FO WH2080 but although Cumulus is correctly showing the Highest Rain Rate of 111.6 on 19 July my Top Ten page is showing it as being on 23 July - the date I started recording data again.
I am assuming this is because Cumulus is taking the data from the monthly log file whereas Top 10 is using the dayfile.txt - and there was no dayfile.txt created for 19 July.

What would be the best way to fix the Top 10 page?
By creating a line in the dayfile.txt for 19 July using the data up to the point of failure (then editing the line for 23 July)?
or
By inserting a line in the MySQL database for 19th July with just the Highest Rain Rate field populated or do all the fields have to have valid dated - or perhaps nulled?
My SQL knowledge is limited - which is probably obvious from my question!!!
Bridger
Posts: 60
Joined: Fri 01 Jun 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows 11 Home
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Post by Bridger »

Just found the "Create Missing" button in the Dayfile.txt Editor which should do what I want. :oops: :oops:
bobhutton
Posts: 12
Joined: Mon 07 Apr 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Post by bobhutton »

For some now I have tried to understand how to implement the Top10 records. I have looked through all the posts so far and cannot find and "idiots guide" which doesn't assume an in depth knowledge of MySQL and PHP.

Can anyone help?
User avatar
PaulMy
Posts: 3777
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis VP2 Plus 24-Hour FARS
Operating System: Windows8 and Windows10
Location: Komoka, ON Canada
Contact:

Re: Top 10 Records Page

Post by PaulMy »

I have much less than "in depth knowledge of MySQL and PHP", in fact no knowledge, and following the guidance from this thread I was able to get it implemented. If I recall correctly the first thing was to set up a MySQL database with my webhost, then using the utility from Cumulus Wiki to upload dayfile.txt, then take the code given in one of the posts and some cries for help here and I got it to work.

What steps have you taken so far?

Enjoy,
Paul
Davis Vantage Pro2+
C1 www.komokaweather.com/komokaweather-ca
MX www.komokaweather.com/cumulusmx/index.htm /index.html /index.php
MX www.komokaweather.com/cumulusmxwll/index.htm /index.html /index.php
MX www. komokaweather.com/cumulusmx4/index.htm

Image
bobhutton
Posts: 12
Joined: Mon 07 Apr 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Post by bobhutton »

Thanks for your reply.

I am trying to get it working locally on my laptop because I do not have any web space at the moment.

I have installed XAMPP, have a batch file that runs from Cumulus each day at rollover time and copies dayfile.txt. I have not worked out how to populate the database automatically, so I manually run a file ImportCumulusFile.php which I found in a post on the forum. That is where i am stuck because I am unable to work out what comes next.

Bob
User avatar
PaulMy
Posts: 3777
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis VP2 Plus 24-Hour FARS
Operating System: Windows8 and Windows10
Location: Komoka, ON Canada
Contact:

Re: Top 10 Records Page

Post by PaulMy »

Sorry I can't help on how to run locally :(

Paul
Davis Vantage Pro2+
C1 www.komokaweather.com/komokaweather-ca
MX www.komokaweather.com/cumulusmx/index.htm /index.html /index.php
MX www.komokaweather.com/cumulusmxwll/index.htm /index.html /index.php
MX www. komokaweather.com/cumulusmx4/index.htm

Image
User avatar
MackerelSky
Posts: 141
Joined: Fri 01 Apr 2011 8:14 pm
Weather Station: Davis VP2 w/FARS
Operating System: Toshiba Laptop Windows 7 x64
Location: Smethport, Pa.
Contact:

Re: Top 10 Records Page

Post by MackerelSky »

bobhutton wrote:For some now I have tried to understand how to implement the Top10 records. I have looked through all the posts so far and cannot find and "idiots guide" which doesn't assume an in depth knowledge of MySQL and PHP.

Can anyone help?
Are you getting any errors Bob? and do you have any other script that has been successful accessing the database. I have the same server on my laptop

Brad
Davis VP2/FARS
Cumulus 1.9.4(1092)

McKean Weather
'cause not everyone lives at the airport

Image
bobhutton
Posts: 12
Joined: Mon 07 Apr 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Post by bobhutton »

I am not aware of any errors in the database.
The only thing I have been able to do with the data in the database is to create a couple of queries.
User avatar
MackerelSky
Posts: 141
Joined: Fri 01 Apr 2011 8:14 pm
Weather Station: Davis VP2 w/FARS
Operating System: Toshiba Laptop Windows 7 x64
Location: Smethport, Pa.
Contact:

Re: Top 10 Records Page

Post by MackerelSky »

I was actually talking about errors when you tried to run the script to access the database.
Like what happens when you type http://localhost/top10s.php into your browser.

Before we go to far in this forum topic of top 10's, do you have anything working yet on your server?

If nothings happening there I might suggest starting a new topic on 'Getting Xampp Working' for other folks benefit and keep this thread for Marks script, or PM me if you feel like it.

Brad
Davis VP2/FARS
Cumulus 1.9.4(1092)

McKean Weather
'cause not everyone lives at the airport

Image
bobhutton
Posts: 12
Joined: Mon 07 Apr 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Post by bobhutton »

Sorry, it was not my intention to hijack this this thread.

When I run http://localhost/top10s.php in Firefox I get the following errors above the tables:
2014-11-22 11_00_38-Mozilla Firefox.jpg
The tables look OK.

Below the tables I get
2014-11-22 11_01_40-Mozilla Firefox.jpg
What this means is what is puzzling me.

Bob
You do not have the required permissions to view the files attached to this post.
duke

Re: Top 10 Records Page

Post by duke »

deleted, didn't read previously post correctly :shock:
Last edited by duke on Sat 22 Nov 2014 12:35 pm, edited 1 time in total.
Post Reply