If you use Cumulus, please donate Image

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

Highcharts Graphs

Discussion and support for 3rd-party (non-Sandaysoft) tools for Cumulus
dazza1223
Posts: 170
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Highcharts Graphs

Postby dazza1223 » Mon Dec 05, 2016 5:21 pm

hi is there any way some one can help me to set all this up plz!!!

ternzer
Posts: 19
Joined: Sat Mar 02, 2013 6:28 pm
Weather Station: davis vp2
Operating System: whs 2011
Location: west michigan
Contact:

Re: Highcharts Graphs

Postby ternzer » Tue Dec 20, 2016 8:04 pm

Thanks for all the info in this thread. I have my charts up and running for the most part. However I am having a problem with the dates on the historic daily. the chart ends exactly 9 months ago today. so today my chart ends at 3/20/16. yesterday it ended 3/19/16. The data appears to be correct for today but the label is 9 months old. I am using the CumulusMx SQL uploader. Then I used the import script to back fill the last 3 years of the dayfile. If I revert back to the old dayfile the chart correctly fills the limited amount of data 12/10-12/20 and presents it correctly. when I compare the date formats in mysql they are the same - yyyy-mm-dd
I think it is either it is something with the historictemperaturedaily.php, the data import or the historicgraphs.js.
can someone lend some insight?

my temporary pages are here while I work out the bugs -
http://www.ernzer.com/wx16/graphs_historic.php

thanks

Bridger
Posts: 32
Joined: Fri Jun 01, 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Highcharts Graphs

Postby Bridger » Mon Jan 30, 2017 11:03 am

I am updating my old version of Historic Graphs and need some advice on a couple of issues I have with implementing the new version.
On the temperature graphs the degree symbol displays as ° (A circumflex,degree symbol).
My page has character set as <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />.
I am able to display the degree symbol correctly if I use the numeric code &#176 in historicGraphs.js but suspect there is a more simple solution.

My second issue is getting the Comfort and ByMonth&Hr graphs to load. I seem to need a "fulldata" table in my SQL database - what is populating fulldata? I am currently uploading just dayfile.txt to tables daydata and topten using Cumulus Toolbox.
I am running v1.9.4 b1099 (if it ain't broke...) and my test page is here :- http://www.fordingbridgeweather.co.uk/saratoga/testgraphs.php

Thanks

User avatar
Mapantz
Posts: 429
Joined: Sat Dec 17, 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64 - A beast.
Location: Wareham, Dorset - UK

Re: Highcharts Graphs

Postby Mapantz » Mon Jan 30, 2017 12:12 pm

fulldata equates to the Monthly table, which is the standard that Cumulus MX uploads to. So, if you're not using an SQL database, it would be the equivalent of your monthly text files ie Jan17log.txt
I'm not sure how you would get that to work, because you have a file for each month. Whereas with CMX, the single SQL Monthly database is continuously added to.
Somebody may have already found a way to populate those particular graphs from text files..
The other alternative, is to bite the bullet and switch to CMX and set up the SQL database. I'm not a master at any of that, but I did ask for some help and pointers, and I got it successfully set up. I wouldn't look back now, SQL is the way forward for collecting data, and it means I don't need any programs open, apart from CMX - it does it all. :)

Re the degrees symbol, the slack way that I did it, was to replace °C with °C
Image
Image

Bridger
Posts: 32
Joined: Fri Jun 01, 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Highcharts Graphs

Postby Bridger » Mon Jan 30, 2017 1:55 pm

Thanks for your prompt reply.
I have sorted the °C problem by using Hex code \xB0.
As for the Comfort and ByMonth&Hr graphs,unless I can find a way to to upload the monthly log files I will have to bite the bullet and upgrade to MX.

dazza1223
Posts: 170
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Highcharts Graphs

Postby dazza1223 » Mon Jan 30, 2017 3:51 pm

lol i dont know where to start to set all this up Highcharts Graphs

User avatar
PaulMy
Posts: 1501
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: Highcharts Graphs

Postby PaulMy » Mon Jan 30, 2017 7:17 pm

unless I can find a way to to upload the monthly log files
the ImportCumulusFile.php will do that, for historical one month at a time http://wiki.sandaysoft.com/a/ImportCumulusFile.

Enjoy,
Paul

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

Re: Highcharts Graphs

Postby mcrossley » Mon Jan 30, 2017 7:31 pm

PaulMy wrote:
unless I can find a way to to upload the monthly log files
the ImportCumulusFile.php will do that, for historical one month at a time http://wiki.sandaysoft.com/a/ImportCumulusFile.

Enjoy,
Paul

And in case it isn't clear, you can use it with Cumulus 1

User avatar
Mapantz
Posts: 429
Joined: Sat Dec 17, 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64 - A beast.
Location: Wareham, Dorset - UK

Re: Highcharts Graphs

Postby Mapantz » Mon Jan 30, 2017 8:16 pm

Aha! Yes, I totally forgot about that! :)
Image
Image

dazza1223
Posts: 170
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Highcharts Graphs

Postby dazza1223 » Mon Jan 30, 2017 10:34 pm

what this erro mean

Error: You must supply a 'file' parameter/value

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

Re: Highcharts Graphs

Postby mcrossley » Mon Jan 30, 2017 10:36 pm

How are you calling the script? Have you read the examples in the script header block?
I'd suggest a new thread for this topic, it isn't directly related to Highcharts.

dazza1223
Posts: 170
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: Highcharts Graphs

Postby dazza1223 » Mon Jan 30, 2017 10:54 pm

bye the url

Bridger
Posts: 32
Joined: Fri Jun 01, 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Highcharts Graphs

Postby Bridger » Tue Jan 31, 2017 1:05 pm

I could do with a little more help please.
I have noticed the the daily Humidity and Pressure graphs have an end date of 30th Jan (from the overnight dayfile upload) but the daily Temperature, Wind and Rain graphs have an end date of 27th Jan.
Just in case it was a problem with the historicGraphs.js I had edited, I have uploaded a copy of your historicGraphs.js Mark, but the problem is still there.
Edit: I notice that the historicHumidityDaily.php and historicPressureDaily.php files do not have the 10 minute offset that the 3 problematic files have. Could this be relevant?
Thanks for the info on uploading the monthly log files. Something to look at once I have fixed the current problem.
http://www.fordingbridgeweather.co.uk/saratoga/testgraphs.php

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

Re: Highcharts Graphs

Postby mcrossley » Tue Jan 31, 2017 9:30 pm

Bridger wrote:I could do with a little more help please.
I have noticed the the daily Humidity and Pressure graphs have an end date of 30th Jan (from the overnight dayfile upload) but the daily Temperature, Wind and Rain graphs have an end date of 27th Jan.
Just in case it was a problem with the historicGraphs.js I had edited, I have uploaded a copy of your historicGraphs.js Mark, but the problem is still there.
Edit: I notice that the historicHumidityDaily.php and historicPressureDaily.php files do not have the 10 minute offset that the 3 problematic files have. Could this be relevant?
Thanks for the info on uploading the monthly log files. Something to look at once I have fixed the current problem.
http://www.fordingbridgeweather.co.uk/saratoga/testgraphs.php


Re the 27th Jan, could you have some gaps in your data? The PHP just sends the start date and then the data, a value for each day. If any days are missing then the graph will end early. So even if the day records are present if say the temperature data is missing from any of the rows then...

Bridger
Posts: 32
Joined: Fri Jun 01, 2012 4:58 pm
Weather Station: Davis Vantage Vue
Operating System: Windows XP Pro
Location: New Forest. UK
Contact:

Re: Highcharts Graphs

Postby Bridger » Tue Jan 31, 2017 11:33 pm

My dayfile SQL table appears to be fully populated up to 30 Jan and this would appear to be born out by my original Historic Graphs which all show daily data up to 30 Jan, using the same table.
I will check the situation tomorrow(Wednesday) after the overnight dayfile upload.
Original Historic Graphs:-http://www.fordingbridgeweather.co.uk/saratoga/wxhistoricgraphs.php
Test Graphs :-http://www.fordingbridgeweather.co.uk/saratoga/testgraphs.php
Thanks
Edit: I checked the graphs this morning and the end date on the DailyTemperature graph is now 28 Jan (was 27 Jan yesterday) however, the data on the last plot is for 31 Jan. I have double checked this in the database and yesterday.ini. Min Temp=7.3, MaxTemp=11.2 Avg Temp=9.5.
Daily Pressure and Daily Humidity are OK,showing 31 Jan.
You do not have the required permissions to view the files attached to this post.


Return to “3rd Party Tools”

Who is online

Users browsing this forum: No registered users and 2 guests