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

Top 10 Records Page

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

Moderators: daj, TNETWeather

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

Re: Top 10 Records Page

Postby mcrossley » Fri Feb 07, 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 Dec 16, 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

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

Re: Top 10 Records Page

Postby Bridger » Sat Feb 08, 2014 10:26 am

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

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

Re: Top 10 Records Page

Postby mcrossley » Sat Feb 08, 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: 36
Joined: Fri Jun 01, 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Postby Bridger » Sat Jul 26, 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: 36
Joined: Fri Jun 01, 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Top 10 Records Page

Postby Bridger » Sat Jul 26, 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 Apr 07, 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Postby bobhutton » Fri Nov 21, 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: 1675
Joined: Sun Sep 28, 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

Postby PaulMy » Fri Nov 21, 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 Apr 07, 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Postby bobhutton » Fri Nov 21, 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: 1675
Joined: Sun Sep 28, 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

Postby PaulMy » Fri Nov 21, 2014 9:43 pm

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

Paul

User avatar
MackerelSky
Posts: 139
Joined: Fri Apr 01, 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

Postby MackerelSky » Fri Nov 21, 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 Apr 07, 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Postby bobhutton » Sat Nov 22, 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 Apr 01, 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

Postby MackerelSky » Sat Nov 22, 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 Apr 07, 2014 7:30 am
Weather Station: Fine Offset
Operating System: Windows 7
Location: Notts, UK

Re: Top 10 Records Page

Postby bobhutton » Sat Nov 22, 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 Jul 03, 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

Postby duke » Sat Nov 22, 2014 12:04 pm

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

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


Return to “Web site - General”

Who is online

Users browsing this forum: No registered users and 1 guest