Welcome to the new home of the Cumulus Support forum.

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3044 7 December 2018. See the Wiki for download

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: 5236
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2
Operating System: Stretch Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Top 10 Records Page

Post by mcrossley » Fri 07 Feb 2014 6:45 pm

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: 266
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 » Fri 07 Feb 2014 11:22 pm

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: 37
Joined: Fri 01 Jun 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Post by Bridger » Sat 08 Feb 2014 10:26 am

Mark, thanks for the updated script - very useful additions to the table.

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

Re: Top 10 Records Page

Post by mcrossley » Sat 08 Feb 2014 10:54 am

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: 37
Joined: Fri 01 Jun 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Post by Bridger » Sat 26 Jul 2014 3:00 pm

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: 37
Joined: Fri 01 Jun 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Post by Bridger » Sat 26 Jul 2014 8:54 pm

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 » Fri 21 Nov 2014 10:02 am

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: 1732
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis Vantage Pro 2+ w/Envoy USB
Operating System: Windows-8
Location: Komoka, ON Canada
Contact:

Re: Top 10 Records Page

Post by PaulMy » Fri 21 Nov 2014 6:01 pm

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

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 » Fri 21 Nov 2014 9:26 pm

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: 1732
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis Vantage Pro 2+ w/Envoy USB
Operating System: Windows-8
Location: Komoka, ON Canada
Contact:

Re: Top 10 Records Page

Post by PaulMy » Fri 21 Nov 2014 9:43 pm

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

Paul

User avatar
MackerelSky
Posts: 139
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 » Fri 21 Nov 2014 11:09 pm

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 » Sat 22 Nov 2014 6:34 am

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: 139
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 » Sat 22 Nov 2014 9:25 am

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 » Sat 22 Nov 2014 11:16 am

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.

User avatar
duke
Posts: 840
Joined: Sun 03 Jul 2011 6:23 pm
Weather Station: Davis VP2 Plus - 24hr FARS
Operating System: Windows 10 - 64 bit
Location: Eastleigh, Hampshire, UK
Contact:

Re: Top 10 Records Page

Post by duke » Sat 22 Nov 2014 12:04 pm

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.
Duke

Nightingale Weather
Eastleigh, Hampshire, UK
------------------------------------------------------
Validate your pages - often!

Post Reply