evapotranspiratie MySql

[Gerrit]

Good day to you,

I am trying to get the evapotranspiration into my database, so far without success.
They should come along from Meteobridge though.
I have already created a column with EV0, but no data is coming in.

https://waskolkweer.nl/meteotemplate/indexDesktop.php

Gerrit

[davidefa]

You can install this mod
It already adds evapotranspiration to alldataExtra table ( calling it ET ).
In this way you can use 'evapotranspiration compatible' blocks ( interactiveGraph, graphCombined, customGraph and stationData ).
I'm currently working on extending other pages/plugins too

[Gerrit]

Good day to you,

I have created an extra table, ET, and entered a few values there myself, which I can also read back in the graph.
There is really no data being written to the ET table.

Gerrit

[davidefa]

In your cache/apiLog.txt there is no ET field ( this file is generated by api.php and contains a lot of infos about data import phase ).
Is the ET field sent continuously by your meteobridge, or is it sent only 'once in a day'?
( for example my ecowitt plugin calculates ET and sends it to api.php only at the end of each day )

Code: Select all

2022-03-28 12:59:00
INFOS:
Authorized access.
Current date/time: 2022-03-28 12:59:00
api called by http
update U: 1648465140
update SW: meteobridge
update T: 9.2
update TMX: 9.3
update TMN: 9.1
update H: 82
update P: 1021.8
update W: 2.1
update G: 6.5
update B: 338
update R: 0.0
update RR: 0.0
update S: 650.8
update UV: 2.1
update TIN: 13.1
update HIN: 66
update TS1: 7.8
update TS2: 7.8
update TS3: 7.8
update TS4: 8.3
update SM1: 42.0
update SM2: 36.0
update SM3: 26.0
update SM4: 12.0
update SM5: 0.0
update SM6: 255.0
update LW1: 0.0
update LT1: 7.8
update LW2: 255.0
update LT2: 7.8
Begin of common part of api script
Start handling live data
Checking if extra sensors should be logged
Extra sensors data to save in db: UV, ET, TS1, LW1, SM1, TS2, SM2, TS3, SM3, TS4, SM4
add live data: D: 6.2
add live data: DTime: 1648464841
add live data: A: 7.9
add live data: ATime: 1648464841
calculated D: 6.3
calculated A: 7.9
Save meteotemplateLive.txt: {"U":1648465140,"SW":"meteobridge","T":9.2,"TMX":9.3,"TMN":9.1,"H":82,"P":1021.8,"W":2.1,"G":6.5,"B":338,"R":0,"RR":0,"S":650.8,"UV":2.1,"TIN":13.1,"HIN":66,"TS1":7.8,"TS2":7.8,"TS3":7.8,"TS4":8.3,"SM1":42,"SM2":36,"SM3":26,"SM4":12,"SM5":0,"SM6":255,"LW1":0,"LT1":7.8,"LW2":255,"LT2":7.8,"UTime":1648465140,"SWTime":1648465140,"TTime":1648465140,"TMXTime":1648465140,"TMNTime":1648465140,"HTime":1648465140,"PTime":1648465140,"WTime":1648465140,"GTime":1648465140,"BTime":1648465140,"RTime":1648465140,"RRTime":1648465140,"STime":1648465140,"UVTime":1648465140,"TINTime":1648465140,"HINTime":1648465140,"TS1Time":1648465140,"TS2Time":1648465140,"TS3Time":1648465140,"TS4Time":1648465140,"SM1Time":1648465140,"SM2Time":1648465140,"SM3Time":1648465140,"SM4Time":1648465140,"SM5Time":1648465140,"SM6Time":1648465140,"LW1Time":1648465140,"LT1Time":1648465140,"LW2Time":1648465140,"LT2Time":1648465140,"D":6.3,"DTime":1648465140,"A":7.9,"ATime":1648465140}

[Gerrit]

That could be it, just wait until tomorrow.
The attachment also only states the current value.

Gerrit

[Gerrit]

Good morning,

Unfortunately it didn't work, I have already rebooted.
I'll try to dig a little deeper this afternoon.
Could it be that I need to upload shortly, it happens every 5 minutes now


Gerrit

[davidefa]

Could it be that I need to upload shortly, it happens every 5 minutes now

Gerrit

If you mean to reduce the upload interval, I think it should not be related to your issue ( 1min to 5mins should be ok ).
I think meteobridge is not sending evapotranspiration data to api.php script ( so you need to verify the meteobridge sending configuration, but I don't know how )

[Gerrit]

I will have a look at it soon.
Hopefully I can solve it.

[Gerrit]

Good day to you,

It was a bit of a hassle, but with some excellent help on themeteobridge forum now the data is loaded via the api, an extension to for example thunderstorm sensors is now possible.

Gerrit

[davidefa]

Good... only a question what is a thunderstorm sensor?
To add a new sensor the three scripts ( linked in the above mod ) have to be updated

[Gerrit]

Actually, I should have written lightning

I want to buy a lightning sensor, which is currently not available from Ecowitt.
With the API I should be able to get it easily into Meteobridge, and from what I saw Bu has already made some things for that.