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

Highcharts Graphs

Discussion and support for 3rd-party (non-Sandaysoft) tools for Cumulus
User avatar
laulau
Posts: 678
Joined: Tue 13 Oct 2009 10:52 pm
Weather Station: WeatherDuino Pro2
Operating System: Win 7
Location: Meyenheim, Alsace, FR
Contact:

Re: Highcharts Graphs

Post by laulau »

:idea: http://api.highcharts.com/highcharts

This link is very helpfull to understand and try the charts options :!:
Laurent

Image
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Highcharts Graphs

Post by nitrx »

Oke thanks just found the numberformat and wil change the code (heavy :roll: )
User avatar
meteotortosa
Posts: 323
Joined: Thu 04 Dec 2008 12:15 am
Weather Station: Davis Vantage Pro2 Plus
Operating System: Windows XP SP3
Location: Tortosa-Baix Ebre- Catalonia
Contact:

Re: Highcharts Graphs

Post by meteotortosa »

mcrossley wrote:Going wayyy back to the historic Highcharts graphs ;) I had 5 mins to spare and added monthly average temperatures by year, and added station averages to both that and the monthly rain by year graphs - both pretty easy to set up.

http://weather.wilmslowastro.com/highch ... Graphs.htm
Are there any instruccions to do this? I would to include in my web, thanks !!!

Lluís
www.meteotortosa.cat
Weather in Tortosa (NE Spain), updated every 15'
Image Image
kapo
Posts: 246
Joined: Thu 03 Jan 2013 1:59 pm
Weather Station: Davis VP2
Operating System: Windows 10
Location: Vihtavuori, Laukaa, Finland

Re: Highcharts Graphs

Post by kapo »

At last!!!


With best regards from sunny Finland:
Last edited by kapo on Wed 22 May 2013 9:58 am, edited 1 time in total.
User avatar
actioman
Posts: 118
Joined: Sat 20 Mar 2010 1:01 am
Weather Station: Davis Vantage Pro2 Plus
Operating System: Windows XP SP3
Location: Elvas, Portugal
Contact:

Re: Highcharts Graphs

Post by actioman »

So about this great script and its subsequent integration with MySQL database, is there any news? :mrgreen:
There is really meant to be done?

Thank you once more! ;)
Kind Regards, Manuel.

Image
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Highcharts Graphs Importrealtime database

Post by nitrx »

Hi Mark concerning the http://wiki.sandaysoft.com/a/ImportCumulusFile

I get values in the database multiplied by ten .. do you know what's the reason for this ? Clodbase and humidity are only correct I think

output json

Code: Select all

/**
 Export to JSON plugin for PHPMyAdmin
 @version 0.1
 */

// Database 'not mentioned by me'
// ***.realtime

[{"LogDateTime": "2013-05-13 13:14:21","temp": 130.0,"hum": 93.0,"dew": 119.0,"wspeed": 42.0,"wlatest": 17.0,"bearing": 235,"rrate": 0.0,"rfall": 36.0,"press": 9999.99,"currentwdir": "ZW","beaufortnumber": 3,"windunit": "m/s","tempunitnodeg": "C","pressunit": "mb","rainunit": "mm","windrun": 999.9,"presstrendval": 00,"rmonth": 209.0,"ryear": 999.9,"rfallY": 39.0,"intemp": 196.0,"inhum": 99.0,"wchill": 130.0,"temptrend": +04,"tempTH": 135.0,"TtempTH": "12:14","tempTL": 74.0,"TtempTL": "02:58","windTM": 64.0,"TwindTM": "12:42","wgustTM": 99.0,"TwgustTM": "12:40","pressTH": 9999.99,"TpressTH": "00:00","pressTL": 9999.99,"TpressTL": "08:04","version": 194,"build": 1071,"wgust": 58.0,"heatindex": 130.0,"humidex": 152.0,"UV": 0,"ET": 0.0,"SolarRad": 0.0,"avgbearing": 271,"rhour": 9.0,"forecastnumber": 11,"isdaylight": 1,"SensorContactLost": 0,"wdir": "W","cloudbasevalue": 137,"cloudbaseunit": "m","apptemp": 107.0,"SunshineHours": 0.0,"CurrentSolarMax": 849.0,"IsSunny": 0}, {"LogDateTime": "2013-05-13 13:15:21","temp": 131.0,"hum": 93.0,"dew": 120.0,"wspeed": 38.0,"wlatest": 29.0,"bearing": 257,"rrate": 0.0,"rfall": 36.0,"press": 9999.99,"currentwdir": "WZW","beaufortnumber": 3,"windunit": "m/s","tempunitnodeg": "C","pressunit": "mb","rainunit": "mm","windrun": 999.9,"presstrendval": +01,"rmonth": 209.0,"ryear": 999.9,"rfallY": 39.0,"intemp": 196.0,"inhum": 99.0,"wchill": 131.0,"temptrend": +03,"tempTH": 135.0,"TtempTH": "12:14","tempTL": 74.0,"TtempTL": "02:58","windTM": 64.0,"TwindTM": "12:42","wgustTM": 99.0,"TwgustTM": "12:40","pressTH": 9999.99,"TpressTH": "00:00","pressTL": 9999.99,"TpressTL": "08:04","version": 194,"build": 1071,"wgust": 58.0,"heatindex": 131.0,"humidex": 153.0,"UV": 0,"ET": 0.0,"SolarRad": 0.0,"avgbearing": 268,"rhour": 9.0,"forecastnumber": 11,"isdaylight": 1,"SensorContactLost": 0,"wdir": "W","cloudbasevalue": 137,"cloudbaseunit": "m","apptemp": 110.0,"SunshineHours": 0.0,"CurrentSolarMax": 850.0,"IsSunny": 0}, {"LogDateTime": "2013-05-13 13:17:21","temp": 130.0,"hum": 92.0,"dew": 117.0,"wspeed": 34.0,"wlatest": 24.0,"bearing": 303,"rrate": 0.0,"rfall": 36.0,"press": 9999.99,"currentwdir": "WNW","beaufortnumber": 3,"windunit": "m/s","tempunitnodeg": "C","pressunit": "mb","rainunit": "mm","windrun": 999.9,"presstrendval": +01,"rmonth": 209.0,"ryear": 999.9,"rfallY": 39.0,"intemp": 196.0,"inhum": 99.0,"wchill": 130.0,"temptrend": +04,"tempTH": 135.0,"TtempTH": "12:14","tempTL": 74.0,"TtempTL": "02:58","windTM": 64.0,"TwindTM": "12:42","wgustTM": 99.0,"TwgustTM": "12:40","pressTH": 9999.99,"TpressTH": "00:00","pressTL": 9999.99,"TpressTL": "08:04","version": 194,"build": 1071,"wgust": 53.0,"heatindex": 130.0,"humidex": 151.0,"UV": 0,"ET": 0.0,"SolarRad": 0.0,"avgbearing": 264,"rhour": 9.0,"forecastnumber": 11,"isdaylight": 1,"SensorContactLost": 0,"wdir": "W","cloudbasevalue": 133,"cloudbaseunit": "m","apptemp": 112.0,"SunshineHours": 0.0,"CurrentSolarMax": 850.0,"IsSunny": 0}, {"LogDateTime": "2013-05-13 13:23:22","temp": 134.0,"hum": 90.0,"dew": 118.0,"wspeed": 34.0,"wlatest": 29.0,"bearing": 235,"rrate": 0.0,"rfall": 36.0,"press": 9999.99,"currentwdir": "ZW","beaufortnumber": 3,"windunit": "m/s","tempunitnodeg": "C","pressunit": "mb","rainunit": "mm","windrun": 999.9,"presstrendval": 00,"rmonth": 209.0,"ryear": 999.9,"rfallY": 39.0,"intemp": 196.0,"inhum": 99.0,"wchill": 134.0,"temptrend": +06,"tempTH": 135.0,"TtempTH": "12:14","tempTL": 74.0,"TtempTL": "02:58","windTM": 64.0,"TwindTM": "12:42","wgustTM": 99.0,"TwgustTM": "12:40","pressTH": 9999.99,"TpressTH": "00:00","pressTL": 9999.99,"TpressTL": "08:04","version": 194,"build": 1071,"wgust": 63.0,"heatindex": 134.0,"humidex": 155.0,"UV": 0,"ET": 0.0,"SolarRad": 0.0,"avgbearing": 258,"rhour": 9.0,"forecastnumber": 5,"isdaylight": 1,"SensorContactLost": 0,"wdir": "WZW","cloudbasevalue": 199,"cloudbaseunit": "m","apptemp": 116.0,"SunshineHours": 0.0,"CurrentSolarMax": 851.0,"IsSunny": 0}]
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: Highcharts Graphs

Post by mcrossley »

Hi Ron,
Do you have...
$decimal_separator = '.'

set to a comma?
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Highcharts Graphs

Post by nitrx »

Mark I've these settings

$field_delimiter = ';';
$date_delimiter = '-';
$date_format = 'DMY'; //or MDY or YMD
$decimal_separator = ',';
$compassp = array('N','NNO','NO','ONO','O','OZO','ZO','ZZO','Z','ZZW','ZW','WZW','W','WNW','NW','NNW');

But the dayfile does have only points for decimals , aha I should set it to a point ?
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: Highcharts Graphs

Post by mcrossley »

Ah, yes, it should match the input file usage rather than your system usage. :?
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Highcharts Graphs

Post by nitrx »

changed $decimal_separator = ','; to $decimal_separator = '.'; and works thanks, I think I've to make different importfiles ;)
Thanks
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Highcharts Graphs

Post by nitrx »

BTW can I make a bat file for importing toolbox can only import by hour , I've running it local on my pc.
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: Highcharts Graphs

Post by mcrossley »

I used to use a batch file started along with Cumulus to import to my local database...

Code: Select all

:start
@echo off
php importcumulusfilev2.php file=realtime.txt table=Realtime type=realtime key=XXXXX retainVal=7 retainUnit=day
echo sleeping...
sleep -m 59600
goto start
But now I have a scheduled task that runs a batch file once a minute to import the realtime data. It does not need the loop or sleep, and starts with the system...

Code: Select all

@echo off
php importcumulusfilev2.php file=realtime.txt table=Realtime type=realtime key=XXXX retainVal=7 retainUnit=day > realtimelog.txt
exit
EDIT: I remembered having problems getting the batch job to run minimised, it kept popping up on the screen, I ended up creating a 'shortcut' to the batch file, and putting the shortcut link in scheduled task.

Task run field: c:\weather\realtimelog-Shortcut.lnk

Shortcut Target field: C:\weather\realtimelog-scheduled.bat
Shortcut Start in field: C:\weather
Shortcut Run field: Minimised
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Highcharts Graphs

Post by nitrx »

Great I'll try it thanks
User avatar
nitrx
Posts: 1297
Joined: Sun 13 Dec 2009 1:21 pm
Weather Station: WH1080
Operating System: Windows 10
Location: Apeldoorn The Netherlands
Contact:

Re: Highcharts Graphs

Post by nitrx »

@echo off
php importcumulusfilev2.php file=realtime.txt table=Realtime type=realtime key=XXXX retainVal=7 retainUnit=day > realtimelog.txt
exit

php is not recognized ?
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: Highcharts Graphs

Post by mcrossley »

Ron, when you say you are running it locally - you do mean that the web server is on the same box as Cumulus?
Post Reply