evapotranspiratie MySql

Post Reply
Gerrit
Observer
Observer
Posts: 32
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

evapotranspiratie MySql

Post by Gerrit » Mon Mar 28, 2022 4:59 am

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
Expert
Expert
Posts: 652
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: evapotranspiratie MySql

Post by davidefa » Mon Mar 28, 2022 7:52 am

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
Image

Gerrit
Observer
Observer
Posts: 32
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Re: evapotranspiratie MySql

Post by Gerrit » Mon Mar 28, 2022 10:48 am

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
Expert
Expert
Posts: 652
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: evapotranspiratie MySql

Post by davidefa » Mon Mar 28, 2022 11:07 am

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}
Image

Gerrit
Observer
Observer
Posts: 32
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Re: evapotranspiratie MySql

Post by Gerrit » Mon Mar 28, 2022 11:22 am

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

Gerrit
Attachments
Schermafbeelding 2022-03-28 om 13.10.34.png
Schermafbeelding 2022-03-28 om 13.10.34.png (10.63 KiB) Viewed 1373 times
Schermafbeelding 2022-03-28 om 13.16.34.png
Schermafbeelding 2022-03-28 om 13.16.34.png (119.87 KiB) Viewed 1373 times

Gerrit
Observer
Observer
Posts: 32
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Re: evapotranspiratie MySql

Post by Gerrit » Tue Mar 29, 2022 5:25 am

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
Expert
Expert
Posts: 652
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: evapotranspiratie MySql

Post by davidefa » Tue Mar 29, 2022 9:55 am

Gerrit wrote: Tue Mar 29, 2022 5:25 am 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 )
Image

Gerrit
Observer
Observer
Posts: 32
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Re: evapotranspiratie MySql

Post by Gerrit » Tue Mar 29, 2022 12:02 pm

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

Gerrit
Observer
Observer
Posts: 32
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Re: evapotranspiratie MySql

Post by Gerrit » Mon Apr 04, 2022 4:48 pm

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
Expert
Expert
Posts: 652
Joined: Tue Jan 12, 2021 8:03 am
Location: Italy
Station model: WH2650
Software: WH2650 (direct upload)
Contact:

Re: evapotranspiratie MySql

Post by davidefa » Tue Apr 05, 2022 7:49 am

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
Image

Gerrit
Observer
Observer
Posts: 32
Joined: Wed Feb 06, 2019 1:31 pm
Station model: Vantage pro 2 plus
Software: Meteobridge
Contact:

Re: evapotranspiratie MySql

Post by Gerrit » Wed Apr 06, 2022 11:13 am

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.

Post Reply