Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4017) - 17 March 2024

Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

What's the Webtag for Annual ET

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
kevinTDWX
Posts: 6
Joined: Sun 14 Jun 2020 4:49 am
Weather Station: Davis VP2 Plus
Operating System: Windows 10 Pro 21H2

What's the Webtag for Annual ET

Post by kevinTDWX »

I'm using the Custom Minute MYSQL feature to update the Monthly data table every 5 minutes. The column for AnnualEvapTran does not populate (stays at 0.00) using a webtag <#ETyear> that I guessed would work. I can't seem to find what the actual webtag is, after doing a search of this forum or the wiki. Any clue what that webtag is?
Regards, Kevin
Regards, --Kevin

Image
Mapantz
Posts: 1774
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: What's the Webtag for Annual ET

Post by Mapantz »

There isn't a webtag for that, as far as I am aware?!

The way to get a total in SQL, I would guess..

Is to just populate the AnnualEvapTran table using the custom SQL at rollover function.

You'd have to use:

<#metdateyesterday>

INSERT IGNORE INTO AnnualEvapTran (LogDate,TotalEvap) VALUES ('<#metdateyesterday format=yyyy-MM-dd>',<#ET>);

You could then call back the full total of that table.
Image
kevinTDWX
Posts: 6
Joined: Sun 14 Jun 2020 4:49 am
Weather Station: Davis VP2 Plus
Operating System: Windows 10 Pro 21H2

Re: What's the Webtag for Annual ET

Post by kevinTDWX »

Mapantz wrote: Fri 21 Jan 2022 12:49 pm There isn't a webtag for that, as far as I am aware?!

The way to get a total in SQL, I would guess..

Is to just populate the AnnualEvapTran table using the custom SQL at rollover function.

You'd have to use:

<#metdateyesterday>

INSERT IGNORE INTO AnnualEvapTran (LogDate,TotalEvap) VALUES ('<#metdateyesterday format=yyyy-MM-dd>',<#ET>);

You could then call back the full total of that table.

Okay, thanks.. I'll give that a try :)
Regards, Kevin
Regards, --Kevin

Image
kevinTDWX
Posts: 6
Joined: Sun 14 Jun 2020 4:49 am
Weather Station: Davis VP2 Plus
Operating System: Windows 10 Pro 21H2

Re: What's the Webtag for Annual ET

Post by kevinTDWX »

Thank you Mark, for adding annual ET total <#AnnualET> to build 3169
Regards, Kevin
Regards, --Kevin

Image
User avatar
mcrossley
Posts: 12689
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: What's the Webtag for Annual ET

Post by mcrossley »

:thumbsup:
Post Reply