cloudy cloudy

Author Topic: Forecast vs Actual  (Read 5126 times)

0 Members and 1 Guest are viewing this topic.

Offline Meteomincio

  • Posts: 37
  • OS/Browser:
  • Win NT 10.0
  • Chrome 66.0.3359.181
    • Weather Station MeteoMincio
Re: Forecast vs Actual
« Reply #30 on: May 22, 2018, 07:30:06 AM »
Hi Tony,
you did a nice job with this script, thank you so much for sharing

but I've same error as Alessandro on third step:

Quote
Error creating RealtimeComparevw (view) : Table 'Sql686728_4.realtime' doesn't existError creating WxsimComparevw (view) : Table 'Sql686728_4.RealtimeComparevw' doesn't existError creating WxSimActTempLowHighDelta (view) : Table 'Sql686728_4.RealtimeComparevw' doesn't exist

in first step I've this setup:
Code: [Select]
/* Main Cumulus Realtime Table Settings */
/**************************************************/
$cu_realtimename = "realtime";     // Name of your Cumulus realtime table ( Note : case Sensative ) is it "Realtime" or "realtime" change accordingly
$cu_realtime_datefield = "LogDateTime"; // Name of your Cumulus realtime Date Field ( Note : case Sensative ) is it "LogDateTime" or "DateTime" or "datetime" change accordingly
$cu_realtime_days = "7";     // Number of Days your Cumulus realtime Table retains Data.

I be using Cumulus v. 1.9.4

Regards
Paolo F.


Offline hrvistaweather

  • Posts: 287
  • Tasmania
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 66.0.3359.181
Re: Forecast vs Actual
« Reply #31 on: May 22, 2018, 09:01:13 AM »
Hi Paolo F.

All I can think of : is your (date/Time) field in yor ( realtime / table ) : "LogDateTime" or something else like "DateTime" or "logdatetime" etc.

Sorry aside from that, I am unsure., I am not in my office at present, about to have tea and off to bed.

I will look at scripts after work tomorrow night.

kind regards,
« Last Edit: May 22, 2018, 09:29:47 AM by hrvistaweather »
Tony

Offline Meteomincio

  • Posts: 37
  • OS/Browser:
  • Win NT 10.0
  • Chrome 66.0.3359.181
    • Weather Station MeteoMincio
Re: Forecast vs Actual
« Reply #32 on: May 22, 2018, 09:30:20 AM »
Thanks for you reply

I've tried probably all combinations of "datetime" but without success. is there a way to know the correct name?
Paolo F.


Offline hrvistaweather

  • Posts: 287
  • Tasmania
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 66.0.3359.181
Re: Forecast vs Actual
« Reply #33 on: May 22, 2018, 09:32:17 AM »
Look in phpmyadmin for the actual name or look in your "Import Cumulus " file.
Tony

Online i_fiorentino

  • Alessandro Bardi
  • Posts: 1,700
  • 150 mls Candeglia (Pt), Tuscany, Italy
  • OS/Browser:
  • Win NT 10.0
  • Chrome 66.0.3359.181
    • Meteopistoia.it
Re: Forecast vs Actual
« Reply #34 on: May 26, 2018, 07:18:50 AM »
Hi Tony,
is there a possibility to make it workable for WD users?
Thank you so much.
Regards,



Alessandro

Offline hrvistaweather

  • Posts: 287
  • Tasmania
  • OS/Browser:
  • Win NT 6.3
  • Chrome 67.0.3396.99
Re: Forecast vs Actual
« Reply #35 on: July 31, 2018, 09:27:11 AM »
Hi All,

Or rather specifically to the Cumulus Users (eg. As I stated from the start, this is for Cumulus / WxSim users as I do not use WD) I think there is only one or two of you using it.

Due to recent enhancements with WxSim "latest.csv" (extra fields/columns) The previous scripts you are using will fail if you upgrade to Tom's test wxsim.exe which includes additional fields.

The Current "new version of WXSIM: Version 2018, Build 1.0" https://www.weather-watch.com/smf/index.php/topic,66840.0.html is fine to install, though not the "wxsim.exe" oand "wret,exe" from this post https://www.weather-watch.com/smf/index.php/topic,66840.msg537370.html#msg537370 as it contains the new field outputs. This will result in the current scripts I supplied you with (to fail).

I will work when time permits over this coming weekend to create new scripts incorporating the new fields, it is a big change so please be patient and sorry but there's heaps to change.

Update : As I have not received any form of response = I will not waste my own time re scripting these files.

Kind regards,


« Last Edit: August 06, 2018, 09:27:55 AM by hrvistaweather »
Tony

Offline kocher

  • Posts: 110
  • San Sebastian (Spain)
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 69.0.3497.100
    • San Sebastian - Arriola
Re: Forecast vs Actual
« Reply #36 on: October 14, 2018, 09:42:35 AM »
Regards Tony

Unfortunately, after having updated WXSIM, all your great scripts have stopped working:

                   http://kocher.es/wxsimcsvmysql/realtime_graphs_wxsim_Act_Temp.php

I regretted having made this update that, in my specific case, does not give me anything really valuable.  :?

I have studied the possible failures without having managed to make everything work again.

I am still very interested in your great scripts

           
                   Javier



Offline kocher

  • Posts: 110
  • San Sebastian (Spain)
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 71.0.3578.98
    • San Sebastian - Arriola
Re: Forecast vs Actual
« Reply #37 on: January 18, 2019, 12:58:35 PM »
As I said before, as a result of an update of WXSim, Tony's scripts stopped working for me.
The tables are not activated

Trying to find the error, I have checked the fields of my tables and the "latest.csv":

       http://kocher.es/latest.csv

At first glance, everything is correct; the fields in the tables and views match those in the "latest.csv" file.       

But, looking at the result of the file "latestwxsimsqlsave.txt", I have discovered that a column (the last one) has appeared without a header; naturally, it can not be inserted in any table, since they do not have that type of field:

http://kocher.es/wxsimcsvmysql/latestwxsimsqlsave.txt

Code: [Select]
Average WBGT   ??????????????????
       deg C
 1,5    5,7   2019-01-18_07:00_UTC
 1,6    7,2   2019-01-18_08:00_UTC
2    7,1   2019-01-18_09:00_UTC
 2,2    7,4   2019-01-18_10:00_UTC
 2,5    7,8   2019-01-18_11:00_UTC



               

If the problem is that, you should try to fix it from the WXSim itself, or from the file "4wxsim_cron_csv_import-to-wxsim-table.php"

For now I have not found the solution

« Last Edit: January 18, 2019, 01:38:12 PM by kocher »

Offline kocher

  • Posts: 110
  • San Sebastian (Spain)
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 71.0.3578.98
    • San Sebastian - Arriola
Re: Forecast vs Actual
« Reply #38 on: January 18, 2019, 08:43:37 PM »
I think, finally I found the solution.

The real problem was that the file "4wxsim_cron_csv_import.php" was trying to insert 5 values in fields that did not exist in the tables:

FFDI, FWI, Average, WBGT, DateTime (without header in "latest.csv)

The solution has been to add those 4 fields to these tables.

                   

Now I am very satisfied, because these graphics give me a lot of information.

                            http://kocher.es/wxsimcsvmysql/realtime_graphs_wxsim_Act_Temp.php

I am very grateful to Tony for this wonderful work  :D


« Last Edit: January 19, 2019, 08:51:44 AM by kocher »