Page 21 of 28

Re: Highcharts Graphs

Posted: Mon 05 Dec 2016 5:21 pm
by dazza1223
hi is there any way some one can help me to set all this up plz!!!

Re: Highcharts Graphs

Posted: Tue 20 Dec 2016 8:04 pm
by ternzer
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

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 11:03 am
by Bridger
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/s ... graphs.php

Thanks

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 12:12 pm
by Mapantz
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

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 1:55 pm
by Bridger
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.

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 3:51 pm
by dazza1223
lol i dont know where to start to set all this up Highcharts Graphs

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 7:17 pm
by PaulMy
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

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 7:31 pm
by mcrossley
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

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 8:16 pm
by Mapantz
Aha! Yes, I totally forgot about that! :)

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 10:34 pm
by dazza1223
what this erro mean

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

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 10:36 pm
by mcrossley
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.

Re: Highcharts Graphs

Posted: Mon 30 Jan 2017 10:54 pm
by dazza1223
bye the url

Re: Highcharts Graphs

Posted: Tue 31 Jan 2017 1:05 pm
by Bridger
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/s ... graphs.php

Re: Highcharts Graphs

Posted: Tue 31 Jan 2017 9:30 pm
by mcrossley
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/s ... graphs.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...

Re: Highcharts Graphs

Posted: Tue 31 Jan 2017 11:33 pm
by Bridger
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/s ... graphs.php
Test Graphs :-http://www.fordingbridgeweather.co.uk/s ... graphs.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.