Welcome to the Cumulus Support forum.

Latest Cumulus MX release 3.10.1 (build 3116) - 26 February 2021 (please see announcement regarding releases since 3.5.0)
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 the NOAA report and Snow Index drop-down menus to 2030)

Use this Wiki link to Download the Software (Cumulus MX / Cumulus 1 and other related items).

Highcharts Graphs

Discussion and support for 3rd-party (non-Sandaysoft) tools for Cumulus
The it guy
Posts: 8
Joined: Fri 22 Feb 2019 12:46 am
Weather Station: Davis
Operating System: Windows 10

Re: Highcharts Graphs

Post by The it guy »

Hi all I know this is a cop Out but I'm trying to set up the Highcharts Graphs databases I was reading about something in where you need triggers and table structures for columns is there any nice people out there will share there database layout and columns and triggers

As I need the structure for

Sunbyhour

Sun by month hour

Daily insolation

stewartwlewis
Posts: 32
Joined: Sat 29 Jan 2011 7:08 pm
Weather Station: Davis VP2 Plus
Operating System: Rasbian on RPI
Location: Durham, Co Durham
Contact:

Re: Highcharts Graphs

Post by stewartwlewis »

These are the structures and triggers I use for SunbyHour, SunbyMonth Hour and TempbyMonth Hour. I don't have the Daily Insolation ones and have been looking for them plus those for the Temperature Comfort Chart for a while so if you have those it would be great if you could share.
The table files are sql table creation scripts that you can run from within your database. The triggers are specific to my database name so you will need to amend those to your specific name. Also I added solar and uv sensors after the main data collection started so you will need to amend or adjust those where statements.
You do not have the required permissions to view the files attached to this post.

The it guy
Posts: 8
Joined: Fri 22 Feb 2019 12:46 am
Weather Station: Davis
Operating System: Windows 10

Re: Highcharts Graphs

Post by The it guy »

ok thank u so much for them and ive had a look about and ive havent got them but ive hade a look and it seem i can olny see mark as got them on his site so if he is very nice maybe he can share all the one are missing incuding the air quality :D :o

User avatar
billy
Posts: 155
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Davis VP2+
Operating System: RPi buster
Location: Gooseberry Hill, Western Australia

Re: Highcharts Graphs

Post by billy »

For what it is worth, I keep a MySQL table of rain, sunshine and insolation for every hour of every day. It gets updated every time the cmx log file (monthly) gets updated (every 5 minutes). This table is used for the historic drill-down graphs (and a few others). See https://tillyspaws.com/vp2waw/graphs_historic.php

The zip has a file that creates the table and another for updating it (a trigger that runs immediately after the monthly update).
You do not have the required permissions to view the files attached to this post.

The it guy
Posts: 8
Joined: Fri 22 Feb 2019 12:46 am
Weather Station: Davis
Operating System: Windows 10

Re: Highcharts Graphs

Post by The it guy »

Ok Billy thank you very much for that code it's a great help I have checked against what I actually need I was trying to strip down the bit I don't need to go in the database but my knowledge is way out of lead with this!!!
and I look at your site and I can see u have the UV ones can you mop the code as all the rest are working because I am absolutely useless with SQL and just send me the UV

i did try and take out the bits i dont need but as i said it all went Wrong im sorry for the exra work for you

I only need the UV ones

The daily one

And by Month

User avatar
billy
Posts: 155
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Davis VP2+
Operating System: RPi buster
Location: Gooseberry Hill, Western Australia

Re: Highcharts Graphs

Post by billy »

Well the data for the historic UV graphs just come from the dayfile table - see the zip
You do not have the required permissions to view the files attached to this post.

Post Reply