Webtags/Parameters (preserving history): Difference between revisions
m (Corrections) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 138: | Line 138: | ||
Your options are described under the following subheadings: |
Your options are described under the following subheadings: |
||
* [[#Rounding to a specific number of decimal places]] |
* [[#Rounding to a specific number of decimal places]] |
||
* [[Multiple Output Format Modifier parameters for times and dates]] |
* [[#Multiple Output Format Modifier parameters for times and dates]] |
||
===Additional output modification parameters that are only available for MX users=== |
===Additional output modification parameters that are only available for MX users=== |
||
Line 565: | Line 565: | ||
|} |
|} |
||
===Month formats=== |
|||
All locales offer both numerical and alphabetical formats for representing months. |
All locales offer both numerical and alphabetical formats for representing months. |
||
Line 609: | Line 609: | ||
|} |
|} |
||
===Day formats=== |
|||
All locales offer both numerical and alphabetical formats for representing a day. |
All locales offer both numerical and alphabetical formats for representing a day. |
||
Line 648: | Line 648: | ||
|} |
|} |
||
===Date formats=== |
|||
The [[#Year formats]], [[#Month formats]], and [[#Day formats]] listed above can be combined to make up a date output modifier, but there are some other modifiers available that can produce whole dates. |
The [[#Year formats]], [[#Month formats]], and [[#Day formats]] listed above can be combined to make up a date output modifier, but there are some other modifiers available that can produce whole dates. |
||
Line 713: | Line 713: | ||
|} |
|} |
||
=== Literals in scripts=== |
|||
⚫ | If you are considering use of literals (such as a space) within a output format modifier in a script, then don't. Instead include whatever precedes the literal in a tag specification, then concatenate on the literal, and finally concatenate another tag specification for whatever is to follow the literal. An example to make this clearer is <code>$MXDateTime = '<#date format=yyyy-MM-dd>' . 'T' . '<#time format=hh:mm:ss>';</code>, which is written in PHP Hypertext Pre-processor format, the literal 'T' has been inserted by using two separate web tags surrounding the literal. The same approach applies if you wanted to replace that "T" with a space. (The explanation is that Cumulus (1 and MX) requires single quotes round a literal, but the script language requires any string to be enclosed in quotes, and double quotes are required by Cumulus round any complex specifier including any that include a space or other literal). |
||
===Use of spaces=== |
===Use of spaces=== |
||
⚫ | If you are considering use of literals (such as a space) within a output format modifier in a script, then don't. Instead include whatever precedes the literal in a tag specification, then concatenate on the literal, and finally concatenate another tag specification for whatever is to follow the literal. An example to make this clearer is <code>$MXDateTime = '<#date format=yyyy-MM-dd>' . 'T' . '<#time format=hh:mm:ss>';</code>, which is written in PHP Hypertext Pre-processor format, the literal 'T' has been inserted by using two separate web tags surrounding the literal. The same approach applies if you wanted to replace that "T" with a space. (The explanation is that Cumulus (1 and MX) requires single quotes round a literal, but the script language requires any string to be enclosed in quotes, and double quotes are required by Cumulus round any complex specifier including any that include a space or other literal). |
||
[[File:Badge vMx.png]]The first complication is that the parser that interprets time/date characters has two ways of interpreting a space character, depending on what immediately follows. In the tables, below, I have used a "%" in various places. In any of those places with a "%", you can insert a space instead, understanding that space is not a gap between format characters, but simply an alternative to "%" as a special character. To explain the two ways of interpreting spaces consider as an example '''<#TpressTH format=" h:mm tt">'''. In that example the two spaces are interpreted in two different ways! The "space" before "h" is treated as the same as "%", but as the ''mm'' and ''tt'' are multi-character symbols, that does insert a space after the minutes but before the am/pm. I discuss this later in [[#Migrating from legacy Cumulus 1 to MX]] section. |
[[File:Badge vMx.png]]The first complication is that the parser that interprets time/date characters has two ways of interpreting a space character, depending on what immediately follows. In the tables, below, I have used a "%" in various places. In any of those places with a "%", you can insert a space instead, understanding that space is not a gap between format characters, but simply an alternative to "%" as a special character. To explain the two ways of interpreting spaces consider as an example '''<#TpressTH format=" h:mm tt">'''. In that example the two spaces are interpreted in two different ways! The "space" before "h" is treated as the same as "%", but as the ''mm'' and ''tt'' are multi-character symbols, that does insert a space after the minutes but before the am/pm. I discuss this later in [[#Migrating from legacy Cumulus 1 to MX]] section. |
||
Line 729: | Line 730: | ||
Literals are discussed fully in the [[#Including literals in format parameters]] sub-section later. If we want to include other characters not to be interpreted by the date time parameter parser, and spaces, then both double and single quotes must be used, and the spaces must be within the single quotes. An example, that shows all the options that MX allows, with literals is <code> <#TpressH format="\a't 'h:mm' ' tt' <nowiki><small>on 'd/M/yyyy' </small></nowiki>'"> </code>. |
Literals are discussed fully in the [[#Including literals in format parameters]] sub-section later. If we want to include other characters not to be interpreted by the date time parameter parser, and spaces, then both double and single quotes must be used, and the spaces must be within the single quotes. An example, that shows all the options that MX allows, with literals is <code> <#TpressH format="\a't 'h:mm' ' tt' <nowiki><small>on 'd/M/yyyy' </small></nowiki>'"> </code>. |
||
=Some Extra Information= |
=Some Extra Information= |
Revision as of 20:17, 22 June 2022
This Wiki page applies to both flavours of Cumulus currently available.
Introduction
Put simply, a Cumulus tag is included to indicate where Cumulus should insert values when it processes the command/file that quotes the tags.
The general format for every Cumulus tag is: <#tag_name [optional input selection parameters] [optional output modification parameters]>
This page is about those (generally optional) parameters used for modifying Cumulus tags.
- An input parameter is used where the same tag name can represent a value for a number of different past time instants.
- Each of those past time instants is represented by a different value for the input parameter.
- So a combination of a tag name and input modification parameter lets Cumulus select the value you want to see.
- Whether a particular tag name can use input modification parameters will depend on both which tag name has been chosen, and which Cumulus release you are using.
- An output parameter is used when a particular tag name can be fed through a process that alters how the output is shown
- Tag names representing integer values cannot have their output format modified
- Internally Cumulus handles numbers in binary, for numbers that have an integer and a decimal part, there is no exact conversion between the way the decimal part of a number is stored in binary, and the way the decimal part (after the decimal comma/point) appears on output. Therefore, non-integer numbers have to be rounded, and there are some output parameters that modify the output:
- You can modify the number of decimal places shown for some tag names
- With Cumulus MX, you can modify whether number is output with a decimal comma, or a decimal point
- Tag names representing time intervals, clock times, dates or representing both time/date for an extreme record, may have a fixed format that cannot be changed, or may be able to be processed through a date-time routine that changes how either time or date or both are output
All this parameter information was originally on Webtags page, but has been moved to this separate page as part of an attempt to make the Wiki easier to read by shortening pages.
Legacy software
The legacy Cumulus 1 software can only use tag names, and whatever parameters are permitted, within a file. Steve Loft used Cumulus Template File for a file that used tags:
- The legacy Cumulus 1 software, and MX releases up to release 3.9.7 - build 3107, provided a selection of template files (see Customised templates that produced 'standard' web pages, see "IncludeSTD" here.
- A Cumulus user could specify an alternative web page,
- A Cumulus user could transfer data to a web server using a JavaScript Object Notation (.json) file
- A Cumulus user could transfer data to a web server using a JavaScript file,
- A Cumulus user could transfer data to a web server using a PHP script file, or
- A Cumulus user could transfer data to a web server using a eXtensible Mark-up Language (XML) file.
For information on how to process, and upload, non-standard files, see "ExtraProcessxx".
Cumulus MX software
MX can process template files, using Extra web file settings, but tag names (and input/output parameters as permitted) can also be used in:
- standard websitedataT.json template file, or a tailored file that is processed into same destination file
- on demand using Cumulus MX Local API
- standard or custom interval use of "My SQL Connector"
- Customised MQTT commands
Rules
Tag names and parameters must obey certain rules.
Case sensitivity for tag names
The tag_name in the general format above is case sensitive, so please type the tag name exactly as shown in lists of tag names.
Case sensitivity for parameters
The optional input modification parameters always use lower case, so please type them exactly as shown in the section below.
The content of optional output parameters are mostly case insensitive when used in legacy Cumulus 1 (a few are case sensitive as explained in #For the legacy software. For Cumulus 2 and later, so this includes MX, the output parameters are case sensitive and also dependent on what other output formatters are being used if any, so please read the sections on output parameters and study the examples in the tables carefully.
Tag names and Parameters available
Input modification Parameters
Most web tags do not require any input parameters. Luckily, where they are needed, it is quite simple to use them, see table below.
- <#RecentOutsideTemp d=1 h=1 m=1> will give the temperature one day, one hour and one minute ago.
Tag names | Values Available | Input Modification Parameters | Introduced | Examples | Description | |
---|---|---|---|---|---|---|
Tag names listed at Table of Recent History tag names available (see Recent history page for explanation) | One value for each minute in last 7 days | * d specifies number of days ago,
|
Cumulus 1.9.3 beta build 1033 (remain available in MX) | Examples for outside temperature:
| ||
All values supplied for parameters must be whole numbers.
|
monthly all-time extreme records tag names | These tag names represent extreme record values (and corresponding time-stamps) for any particular month (1 =January, and so on, to 12 =December) in all years | Optional input parameter is mon=N where N is the index of the month in which the extreme record occurs considering all years | Cumulus 1.9.3 beta build 1033 (remain available in MX) | * <#ByMonthDewPointH mon=3> is highest monthly dew point for month of March considering all years, and <#ByMonthDewPointHT mon=3> is the related time and date.
|
* If you don't supply an input parameter (or supply an invalid value like zero) the current month will be used.
NOTE: Use without an input parameter in "MySQLConnect", "MQTT", or a template file, and then you don't need to rewrite the instruction when current month changes. If processed at rollover, the current month will change on first day of a month, and so not relate to month that has just finished. |
Only <#SunshineHoursMonth> and Only <#SunshineHoursYear> | Values available for current month/year, and for past month/year | Omit input modification parameter to get value for current month/year. Alternatively include one of the following options:
|
MX release 3.12.0 | Monthly examples:
Yearly examples:
|
Returns the sunshine hours total in selected period
(You need a sensor to be monitoring this throughout selected period) |
Output modification parameters availability by tag name
Each tag name falls into one of these 3 types:
- Some tag names have a fixed output format (so they ignore any output format parameters, although obviously better not to specify any)
- Some tag names always need an output format specifier
- The majority of tag names have a default output if there is no output format modifier, but accept either one or two output format parameters, allowing you to change what they output.
This Wiki page does not include a table showing which tags belong to which type, simply because it is dependent on which Cumulus release you are running. An attempt to indicate some general guidance has been included on another discussion about applicability Wiki page, but contributors need to update that page and start listing tag name and release specific information.
Output modification parameters available in legacy Cumulus 1
Your options are described under the following subheadings:
- #Rounding to a specific number of decimal places
- #Multiple Output Format Modifier parameters for times and dates
Additional output modification parameters that are only available for MX users
offers those listed above for Cumulus 1, plus:
- #Output Modification Parameter for changing any decimal comma into a decimal point
- #Controlling the number of decimal places
- #Two Output (format modifier) parameters for decimal places
- #Truncation of unwanted decimal places
Documentation for Output modification parameters
Use the links above to skip to the particular parameters that you wish to use.
Output Modification Parameter for changing any decimal comma into a decimal point
Note that Cumulus software never uses a comma for separating off thousands, and there is no way to make it output numbers above 999 with a space or comma to separate out thousands.
If the tag name represents a real number with integer and decimal parts, then Cumulus by default will output that number using whatever your locale defines as the separator character (decimal comma or decimal point). The legacy Cumulus 1 provided a few derivatives where a prefix of "RC" before tag name as in <#RCtag_name>
could force the output to use a decimal point (regardless of locale), that option remains available in MX for forward compatibility.
In Cumulus MX (only), you can alternatively use an output modification parameter in format <#tag_name rc=y> to select whether the output should use decimal comma or decimal point:
- From beta release 3.0.0, build 3047 (3 February 2019), up to and including release 3.5.3, only implemented on a few new web tags (#MoonPercent, #MoonPercentAbs, #MoonAge)
- From release 3.6.6 onwards (1 June 2020), it was extended to other web tags that output real numbers.
- From release 3.10.5 onwards (29 March 2021), the use of <#tag_name rc=n> became also possible, to ensure decimal comma shown when locale specifies it
Parameter | Explanation | Example |
---|---|---|
rc=n | This is the default, so does not need to be specified. The output from the web tag will use either decimal comma or decimal point as specified by the locale in which MX is running
For more information about how the computer determines whether decimal commas is your default, see #Locale section later. |
Both <#tempYH> and <#tempYH rc=n> will return yesterday's highest temperature using what is specified by locale to separate integer and decimal parts |
rc=y | the attribute rc takes the value 'y' to replace any commas defined by the locale with full stops to separate integer and decimal parts of the output value. | <#tempYH rc=y> will return yesterday's highest temperature as integer part then full stop then decimal part, regardless of local |
Why would you want to remove decimal commas? Well because the JavaScript language (and some other languages) cannot understand decimal commas, and MX has several scripts written in this language, equally some third party alternative web pages rely on ajax to update them (and Ajax uses JavaScript).
Controlling the number of decimal places
If the tag name represents a real number (with both integer and decimal parts) then there are a number of ways to control the number of decimal places:
- Cumulus 1.x.y: dp=i rounds output to number of decimal places specified by "i"
- All MX releases: dp=i rounds output to number of decimal places specified by "i"
- <#tag_name tc=y> truncates output, display as integer, no rounding, simply ignoring all decimal places
If the tag name gives an output that is defined as text, or as an integer, then none of these can be used. It depends upon which release you are using whether a particular "real number" tag name will accept any of the above output modification parameters, gradually Cumulus has allowed more and more of its output to take an output format modifier that allows people to control number of decimal places shown.
Internally, Cumulus stores numbers in binary. You cannot represent base 10 decimal places exactly in base 2.
Weather stations report values as integers. Cumulus converts these to the user's desired units, and that processing can add decimal places, as it may involve division by a factor of 10, or multiplication by a conversion factor. Obviously, the sensor has a particular accuracy, and this conversion process can introduce additional errors, as can the storing in binary, Cumulus generally (not in every case) stores to a precision that would generally give about 24 significant figures when expressed in base 10.
The handling of each tag name is coded individually, so there are no simple rules for defining the default number of decimal points that will be shown by default. In general, Cumulus does consider the units chosen for outputs. As Cumulus has been developed, people have commented that these defaults do not reflect the precision of their instrumentation (weather stations used with Cumulus tend not to have the accuracy of those used by meteorologists, or are not re-calibrated as often).
From release 3.12.0, you can set the default number of decimal places to output for all derivatives of temperature, pressure, etc. by advanced settings. Those settings can force output as integers, in which case the parameter for controlling number of decimal places have no effect.
Two Output (format modifier) parameters for decimal places
Depending on tag name and release you are using, there may be two ways to control decimal places:
- <#tag_name dp=i> and
- <#tag_name tc=y>
Rounding to a specific number of decimal places
Use dp=i (the value i following the attribute dp is an integer, it represents how many decimal places you want for the output you see):
- Cumulus 1.x.y: only <#latitude dp=i> and <#longitude dp=i> are able to be output with "i" denoting number of decimal places, e.g. <#latitude dp=5> gives "59.24250".
- Depends on MX release:
- From beta releases (3.0.0) onwards, <#latitude dp=i> and <#longitude dp=i> were able to be output with "i" decimal places
- But this output modification parameter could not be applied to any other tags in the MX beta.
- MX when it came out of beta, added this output modification parameter usage in the moon tags <#MoonPercent> and <#MoonPercentAbs>).
- Specifically, <#MoonAge> gives "11" but <#MoonAge dp=3> gives "11.234"
- From release 3.10.5 (which did a big rewrite of web tag handling) any tag names that output as real numbers
- From beta releases (3.0.0) onwards, <#latitude dp=i> and <#longitude dp=i> were able to be output with "i" decimal places
Truncation of unwanted decimal places
tc=y is the truncation parameter, the attribute tc takes the value 'y' to remove decimal places by truncation. e.g. <#MoonAge tc=y>.
This output format modifier is only available in MX:
- If you are using an early release of MX, you will need to research whether this is available for particular tag names
- Later releases of MX implement this for any tag that by default outputs decimal places.
Note, truncation by MX converts real numbers to integers. There is no option to truncate to one decimal place, Airports are expected to report air field level (QFE), and sea level (QNH), pressures truncated to one decimal place rather than rounded.
Multiple Output Format Modifier parameters for times and dates
Output modification parameters for times and dates are highly complicated!
To start with a simple example, suppose you want date/time in ISO 8601 format:
- This means, something like 2019-02-28 06:59:05.
- Take the tag name (from tables on Webtags page)
- Next check in #Which tag names take date/time output formatting modifiers to see if that tag accepts both time and date modifiers
- If your tag name does accept both date and time modifiers, simply modify the web tag as shown here
<#tag_name format="yyyy-MM-dd HH:mm:ss">
where tag_name is set from step 1, but all the rest is typed as shown. - To explain each element in that format value, look in #Time formats, #Year formats, #Month formats, #Day formats, #Use of spaces, #Including literals in format parameters.
Should you want a different date/time format, then the sub-sections just referenced should help you to select a different arrangement, although there are some more options in #Date formats.
Which tag names take date/time output formatting modifiers
When counted some time ago MX already offered a thousand different tag names.
There are a few time-related tag names labelled as being fixed format, that means any time/date output modifiers you might try would be ignored.
Some tag names, although it can be hard to tell which, report durations. You can use time modifiers to change how these are reported. Examples include <#daylength format=H:mm:ss> which reports day length and <#MonthDailyRainHD format=H:mm> which reports how much of a day it was raining.
Time modifiers can also be used to change the way that clock times are reported, you might only want the hour, or you might (if resolution is available) want to also see seconds. The webtags page has columns headed "Time" to clearly identify all tag names that report clock times.
There are some tag names (e.g. moon rise) that relate to an event that does not happen each Earth day, so those tags have to be able to report "--:--", and you cannot modify their output. Equally, many of the tag names that describe extreme records for this month/year/all-time are not defined until the respective period reaches its second day, so again those tags may output hyphens and so any modification parameters will be ignored. For example, highest temperature range in month/year has been coded in Cumulus to report "--" for value, and "--:--" for time, on the first day of that period (because there is only a partial day to consider you might not yet have experienced a true maximum and a true minimum), so modifying the time output can only be done on subsequent days.
It is not practical to indicate which time/date modifiers are accepted on a tag by tag basis. It would involve a lot of repetition. Instead, the following table, explains much more simply, which web tags will accept time and/or date output modifiers:
Cross-reference to table on web tag names page | Tag names that accept only time output modifiers | Tag names that accept only date output modifiers | Tag names that accept both time and date output modifiers |
---|---|---|---|
Any tag names that don't report times nor dates | None | None | None |
Webtags#No_Commas | None | None | None |
Webtags#Date_.26_Time, Webtags#Day/Night/Sun/Moon | Only <#timehhmmss>, <#minute>, <#hour>, <#sunrise>, <#sunset>, <#dawn>, <#dusk> | Only <#LatestErrorDate>, <#date> (but no others) | Only <#LastDataReadT>, <#time>, <#metdate>, <#metdateyesterday>, <#update>, <#LastDataReadT> |
Webtags#Today, Webtags#Yesterday | Any tag name in "Time" column of linked table | None | None |
Webtags#Monthly, Webtags#Yearly | Those tag names in "Time" column of linked table in first column that represent spot value extreme records. For notes see ~ below this table | Any tag name in "Date" column of linked table in first column that represent either daily extremes or spot value extreme records. For notes see † below this table | None of the tag names. For explanation see the ^ below this table |
Webtags#All_Time, Webtags#Monthly_All_Time_Records | None (all tag names combine both time and date) | Those tag names in "Date/Time" column of linked table that represent daily extremes | Those tag names in "Date/Time" column of linked table that represent spot value extreme records |
Webtags#Davis | None | <#StormRainStart> only | None |
~ For rainfall, only <#LastRainTip> can have output modifiers added to report a clock time. † Daily extremes (e.g. wettest day <#MonthDailyRainHD>, and temperature ranges <#MonthHighDailyTempRangeD>) have no time tag. ^ For the monthly and yearly web tags, the date and time are in separate tag names. It is not possible to get both time and date out of either tag name.
Locales
The default format for many tag names reporting date and/or time is dependent on the locale you are using for running Cumulus (1 or MX).
The effect of some output format modifiers is also dependent on locale.
For Microsoft Windows Operating Systems, a Language is defined within the "Region" page of the Settings app. That should be sufficient for the legacy software that uses Delphi. However for MX date and time formats within Windows Operating System, you must use the older Control Panel (go to "Clock and Region" screen, choose "Change date, time or number formats", choose "Language preferences") because it is only there that you can adjust all the defaults used by .NET.
For MX running on most operating systems (other than Microsoft Windows), type locale
to see the default locale that will be adopted when mono-complete is installed as MX will, by default, take locale setting from Mono. When you start MX, you can ask it to use a different locale to that picked up by Mono, by adding the parameter "-lang locale-code", see examples at MX_on_Linux#Parameters. For example, the Australian English language with UTF-8 encoding locale is defined as: en_AU.UTF-8.
The available locales on your computer in Linux are listed by locale -a
. For example, the Russian locale would be selected as the one your computer uses for the current session only by using LANG=ru_RU.utf8
either typed into a terminal session before you start MX, or used as a parameter (preceded by "-") as you start MX interactively.
For permanently changing the locale used by your system, the instructions vary considerably according to the kernel used in your operating system, so you need to look up the instructions for yourself. However, if you have a graphical user interface, such as the full Raspberry Pi Operating System provides, you might have a configuration command in terminal mode and a configuration app accessed (within Preferences) from the "Raspberry" key on the official keyboard. For the Raspberry Pi, please read Raspberry Pi computer page for more details.
Time zones
Before I explain what time/date output modifiers can do, something they can't do.
All web tag outputs are in local time, except <#timeUTC>.
Cumulus 2 internally stored all date/times in UTC, and the development of MX is planned to attach UTC date-times to all data although (at time of typing this) this is not yet implemented so MX maintains compatibility with Cumulus 1 legacy software.
In most MX releases, you can use a script to convert a time to UTC. This is not the place to tell you how to write the script, but taking time of highest pressure today as an example, you would use <#TpressTH format=Hh:mm> and <#TpressTH format=zzz>, the first gives hours and minutes in your local time, and the second gives the offset that needs to be applied to that time to convert it to UTC.
Time resolution
For the legacy software, there may be no point in asking for seconds, as Cumulus 1 did some actions at one minute intervals. For MX, it depends on which tag name you are using whether it supports seconds (e.g. <#LastDataReadT> supports seconds, but <#LastRainTip> is reported rounded back to previous minute and <#TrrateTM> is reported rounded forward to the next minute).
If Cumulus obtained archive data, as part of the catch-up process it can do when it restarts, any time-stamps for that historic period can only be the time of a particular archive record, so that might be every half an hour, but not aligned precisely with hour changes.
Dependency on Cumulus flavour
You have to change all date/time formatting when moving from the original (legacy) Cumulus to MX.
All the tables explaining what is used in each flavour for each type of output, both by including separate columns for each flavour, and by giving examples in each flavour.
For the legacy software
I deal with this first, just because it is simple!
From version 1.9.1, most web-tags that report any form of time or date will accept an optional 'output format' parameter (we have already seen whether this can only affect time, only affect date, or both).
The legacy Cumulus uses Delphi to interpret the output modifiers:
- For most modifiers, a particular character produces the same output regardless whether the output modification specifier is in capitals or lower-case
- There is an exception, the case you use for any am/pm output format modifiers determines the case that is output.
- In general, the context of a modifier does not affect the output it produces
- Again, there is an exception, "m" or "M" has two different meanings (minutes or month) depending on context.
The complications with MX
The *.ini Files in MX have adopted the ISO 8601 date format where year comes first (yyyy-MM-dd), although for compatibility with the legacy software, any lines in these files ported from Cumulus 1 retain their day before month before year format until they are updated. Most dates reported by web tags derive their content from entries in these files.
The *.txt Files have so far stuck to date formats as used in the legacy definitions, the intention to swap to ISO format for the .txt files from September 2020, having been postponed to an unannounced future date, because of the continuing need for compatibility while there is use of the legacy software by a significant number of users.
For Cumulus MX output formatting, the date and time modifiers are complicated by the fact that the same character can have 4 different meanings depending on its case (capital letter or lower-case letter), and depending on whether it is on its own (standard format) or with another modifier (custom format). One more confusion, Microsoft have reversed the use of capital 'M' and lower case 'm' from the standard used very widely, and you may have got to know. Sounds confusing? Well it is complicated.
Consider context first:
- <#tag_name format=x>
- If the x in the above general syntax is a single character, it represents a standard format code
- The standard characters for dates and times are defined at standard-date-and-time-format-strings
- <#tag_name format=xyz>
- If the xyz in the above general syntax is replaced by two or more characters, it becomes a custom format code (combinations of characters, or single characters prefixed by %)
- The custom characters for dates and times are defined at custom-date-and-time-format-strings
Consider case next:
- Cumulus MX (when running on Windows) uses the .NET software which is provided as standard by Microsoft Windows.
- ".NET" was originally operating system independent, later only Microsoft Windows specific components were included, but since November 2020 ".Net" is used for an operating system independent version that originally Microsoft issued under another name!
- (actually it is possible to install and run "Mono" in Windows Operating Systems).
- If Cumulus MX is running on any Linux distribution (including Raspberry Pi Operating Systems) or Mac OS X, or any other device that uses an UNIX derived operating system, then MX uses Mono software for same purposes. (MONO is a operating system independent version of .NET, although they are developed independently, they have common origins).
Time formats
Here context matters, so both standard (single character) and custom (two or more characters) formats are shown in the following table. As explained earlier, time formats can be used with both time-duration reporting and clock time reporting.
In some rows of this table, square brackets [] indicate optional items, they are included just to make it clearer how items can be combined in a single output parameter. If you want to include what is shown in square brackets you don't type the square brackets e.g. <#LastDataReadT format="h:nn am/pm">
Year formats
These are the simplest output format modifiers. We can only choose from 2 options, and because both involve more than one character their context does not matter. Although the legacy Cumulus will accept upper case as meaning same as lower case, it is simplest if we just show the lower case options that are mandatory for MX:
Specifier | Displays | Example |
---|---|---|
yy | Displays the year as a two-digit number (00-99). | 19 produced by <#LastDataReadT format=yy> |
yyyy | Displays the year as a four-digit number (2000-9999). | 2009 produced by <#LastDataReadT format=yyyy> |
Month formats
All locales offer both numerical and alphabetical formats for representing months.
- In the following table "MMM" is shown as producing short month name.
- What language is used, and how many characters appear, depend on what is set up for your language in your settings (by default or by you changing your settings)
- In Australian locale, this would output 4 characters representing a month abbreviation that runs from "Jan." to "Dec."
- In British English (UK) locale, abbreviations do not incude a full stop, so output is a 3 letter abbreviation that starts with "Jan" and runs to "Dec"
- In the following table "MMMM" is shown as producing the full name for a month
- The output you get will depend on the language defined in your locale
- In all English based locales, the output will be in the range "January" to "December"
CAUTION: Cumulus MX has yet another complication, a web tag can return different months depending on whether the output modifier for month is used with, or without, an output modifier for day. Take two examples <#metdateyesterday format=yyyy-MM-dd>
and <#metdateyesterday format=yyyy-MM>
, these can produce different months when processed by MX on same day at near enough same time! Let us assume the first is reporting (in a particular year) the first day of June, the second would report the month of May in same year!
Delphi Specifier for Cumulus 1.9.x | Mono/.NET Specifier for Cumulus MX | Displays | Example |
---|---|---|---|
M (or m) | %M | Displays the month as a number without a leading zero (1-12).
|
2 |
MM (or mm) | MM | Displays the month as a number with a leading zero (01-12). | '03' produced by <#LastDataReadT format=MM> or <#metdate format="MM"> |
MMM (or mmm) | MMM | Displays the month using the strings defined for short month name in the Locale. | 'Jun.' or 'Jun' produced by <#metdate format="MMM"> (varies depending which English locale as explained before table) |
MMMM (or mmmm) | MMMM | Displays the month as a full name using the strings appropriate to the Locale. | 'June' produced by <#metdate format="MMMM"> (English locale) |
Day formats
All locales offer both numerical and alphabetical formats for representing a day.
Again, there are extra complications with MX, the "d" modifier is not shown because it is inconsistent, the format it returns depends on which tag name it is used with - see #Date formats table later! For some tag names it returns just "day of month" (like "%d"), for others it returns the full "Short date format" (like "ddddd")!
The table below is the definitive guide to how to ensure you do specify just the day part of any date specifications.
}Delphi Specifier for Cumulus 1.9.x | Mono/.NET Specifier for Cumulus MX | Displays | Example |
---|---|---|---|
d (single character) | %d | Displays the day as a number without a leading zero (1-31).
Note that Cumulus MX requires a ' ' (space), '%' or another modifier to be included, as 'd' on its own is inconsistent - see #Date formats table). |
27 produced by: |
dd (2 characters long) | dd | Displays the day as a number with a leading zero (01-31). | 07 produced by <#metdate format="dd"> |
ddd (3 characters long) | ddd | Displays the day as an abbreviation (in Australian will output "Sun." to "Sat.") using the strings appropriate to the Locale (see note for month abbreviation). | 'Wed' produced by <#metdate format="ddd"> (UK English locale) |
dddd (4 characters long) | dddd | Displays the day as a full name (Sunday-Saturday) using the strings appropriate to the Locale. | 'Friday' produced by <#metdate format="dddd"> (English locale) |
Date formats
The #Year formats, #Month formats, and #Day formats listed above can be combined to make up a date output modifier, but there are some other modifiers available that can produce whole dates.
#Locales will define a Short Date Format and a Long Date Format. You will see references to those in the table below explaining available output format modifiers, for example the single character output format modifier (G or c) listed at the start of the table below.
If you are in the USA, Cumulus will only use your month first date internally for the start date (see Cumulus.ini (Cumulus 1) and Cumulus.ini (Cumulus MX)), that format will not be used in any files in the data sub-folder, but you can see your preferred format in the settings pages, in the extreme record editing pages, and by default as an output from many (not all) web tags. For any web tags that do permit use of output date modification format parameters, you can can combine any month specifier, with any day of month specifier, in that order, to get an output where the month appears first (see example in table below).
Please could an American contributor please check if the "M" modifier works for their locale as shown and update the table below if necessary, and edit this comment into a confirmation.
Delphi Specifier for Cumulus 1.9.x | Mono/.NET Specifier for Cumulus MX | Displays | Example |
---|---|---|---|
c | G (as single character format) | Displays the date using the format given by the Short Date format, followed by the time using the format given by the Long Time format. The time is not displayed in Cumulus 1 if the date-time value indicates midnight precisely. | '22/03/2019 09:47:25' produced by <#time format=c><#time format=G> |
ddddd (5 characters long) | ddddd (5 characters long) | 'ddddd' will output the date using the format given by the Short Date format.
'd' (when on its own, without space or '%' prefix) may or may not work, it displays inconsistent behaviour as its effect depends on the tag name (sorry, there is no definitive list from the MX author specifying effect by individual tag name) with which it is used (you will need to experiment for yourself and compare with the two examples). |
* Short date format e.g. '22/03/2019' (British Locale) produced by <#metdate format=ddddd> |
dddddd (6 characters long) | D (as single character format) | Displays the date using the format given by the Long Date format.
The MX 'D' parameter cannot be combined with any other parameters. |
e.g. '22 March 2020' (British Locale) |
"D MMMM YYYY" | D | Long date format | e.g.4 December 2009 |
"D MMMM" | M | Day of month followed by Month name.
Note this is different output to format=%M or format=" M" (see #Month formats). Not applicable to USA locales. |
e.g. 22 July (English Locale) |
"MMMM D" | "MMMM d" if M alone does not work | USA format of month before day of month | e.g. July 4 (USA format) |
TT | T (as single character format) | Displays the time using the Long Time format.
Note that this is a full time specifier and "T" is on its own as we are using a single character format. |
'09:47:56' (might not use colon in your locale) produced by |
Literals in scripts
If you are considering use of literals (such as a space) within a output format modifier in a script, then don't. Instead include whatever precedes the literal in a tag specification, then concatenate on the literal, and finally concatenate another tag specification for whatever is to follow the literal. An example to make this clearer is $MXDateTime = '<#date format=yyyy-MM-dd>' . 'T' . '<#time format=hh:mm:ss>';
, which is written in PHP Hypertext Pre-processor format, the literal 'T' has been inserted by using two separate web tags surrounding the literal. The same approach applies if you wanted to replace that "T" with a space. (The explanation is that Cumulus (1 and MX) requires single quotes round a literal, but the script language requires any string to be enclosed in quotes, and double quotes are required by Cumulus round any complex specifier including any that include a space or other literal).
Use of spaces
The first complication is that the parser that interprets time/date characters has two ways of interpreting a space character, depending on what immediately follows. In the tables, below, I have used a "%" in various places. In any of those places with a "%", you can insert a space instead, understanding that space is not a gap between format characters, but simply an alternative to "%" as a special character. To explain the two ways of interpreting spaces consider as an example <#TpressTH format=" h:mm tt">. In that example the two spaces are interpreted in two different ways! The "space" before "h" is treated as the same as "%", but as the mm and tt are multi-character symbols, that does insert a space after the minutes but before the am/pm. I discuss this later in #Migrating from legacy Cumulus 1 to MX section.
If you want spaces to appear between symbols in an output format:
- Cumulus 1.x.y: Add double quotation marks around everything after equals sign if spaces are present anywhere after that equals sign.
- In MX, add double quotation marks around everything after equals sign if spaces are wanted as separators, but you also need to add single quotation marks around the included space.
- If the first symbol after equals sign is a single character modifier, then it has a different meaning depending on whether it is first specificatiion or is preceded by a "%" or "space" as in example above. If the first modifier inclues more than one letter, then it does not ever take a prefix.
- If the space appears after double characters and the symbol that appears after the space is also double characters (as in example above) the single quotes round the space are optional.
- If we have single character specifiers, then a space has to be enclosed in single quotes to mark it as a literal, not a modification of the subsequent single character.
Literals are discussed fully in the #Including literals in format parameters sub-section later. If we want to include other characters not to be interpreted by the date time parameter parser, and spaces, then both double and single quotes must be used, and the spaces must be within the single quotes. An example, that shows all the options that MX allows, with literals is <#TpressH format="\a't 'h:mm' ' tt' <small>on 'd/M/yyyy' </small>'">
.
Some Extra Information
Having covered the basics of both date and time modifiers above, it is time to talk about incorporating other information in an output modifying date/time format specification.
Basically, we can include literal characters, and we can include HyperText Manipulation Language tags, in our specifiers.
Finally, there will be a section on migrating from the legacy Cumulus to MX and how to modify the web tags in your templates to keep them working.
Including literals in format parameters
#Use of spaces explained how double quotes were needed for date/time output specifiers containing spaces. It briefly talked about including literals, and we will expand on that now.
Consequently, you cannot include double quote characters in any other position (see here for work-around).
You should put anything that is additional, to the defined format modifier specification below, into single quotation marks to prevent it being interpreted as a date or time format modifier. In MX, such single quotation marks should include the spaces round the additional literal text.
- For example, the word "on" contains the character "n", which for Cumulus versions 1.9.1 to 1.9.4 will be interpreted as a time format modifier unless you put it into single quotation marks. Example of valid Cumulus 1 syntax: <#TtempH format="'at' hh: mm 'on' dd / mm / yyyy">.
- You can include HTML tags (but they cannot have any attributes because both single and double quote characters have defined meanings) and special characters as quoted text within the 'format' parameter.
Example of valid syntax: <#TapptempH format="'at 'h:nn' 'am/pm '<small>on' d/m/yyyy'</small>'">.- See next sub-section for more information on incorporating HTML if you are using MX.
Note for MX - you can use single quotation marks round spaces and text (e.g. ' on '), but you can also use '\' as escape character (e.g. for 'on' use \o\n). However for at the only alternative is \a't' because the character t has another meaning and escape followed by a "t" i.e. "\t" becomes a tab!
Using HTML tags within format parameters (available in MX only)
Example using a class to change the look of part of the output
<#TapptempH format="dd' 'MMM' 'yyyy'<span class=\'xx\'> at 'HH:mm'</span>'">
the output from this will look like 04 Dec 2018 at 10:12
Note where the quotes are, and where you need to use '\' escape characters.
Example using HTML tags
<#RecentTS d=2 format="h:mm' 'tt'<small>on' d/M/yyyy'</small>'">
This puts the date in a smaller font than the time
Migrating from legacy Cumulus 1 to MX
If you have created any legacy cumulus template files, then in each template, you will need to do some editing. Everywhere a web tag appears with an output modifiers that is used to specify a date and/or time format, has to be edited before that template will work for MX.
Here are the main reasons:
- the reserved characters are different in C1 and MX (affecting use of literals like "on" and "at" that appear in many English time-stamps)
- the Delphi in legacy Cumulus is case insensitive, so for example "H" and "h" have the same meaning
- MX is case sensitive, and symbols mostly have different meanings when one symbol is used to when that symbol is used with others, so for example "H" and "h" have different meanings, and if not used with other symbols will need to be preceded with a "%" to have same meaning as they have in combination with other symbols
- In the legacy cumulus, a symbol like "d" has the same meaning for any tag
- MX is inconsistent, a symbol like "d" changes its meaning depending on the tag it is used with (e.g. the script conditional '<#metdateyesterday format=d>' == '<#yesterday format=d)>' will never be equal as the LHS returns a full date and the right hand side returns day of month only)
- the symbols used for representing such modifiers as minutes, month, am/pm, are different between C1 and MX.
- MX introduces the concept of escaping characters (a \ placed before a character can be either a control sequence or an instruction to display the character)
- In the legacy Cumulus, a space is a gap between characters
- In MX, a space must be within a literal, as a space before a symbol has the same effect as "%", (it changes the interpretation of a modifier character).
Confused even more now? I'm not surprised, but maybe some examples will help.
Examples
- Examples related to case selection
- In Delphi, "nn" means "minutes" for Cumulus 1, but "minutes" is "mm" for .NET or MONO in Cumulus MX.
- The hour in 24-hour format with leading zero, in non case sensitive Delphi (Cumulus 1) 'HH' or 'hh' would be treated as same, but in .NET or MONO it must be "HH" (Cumulus MX).
- The hour in 24-hour format without leading zero, in non case sensitive Delphi (Cumulus 1) 'H' or 'h' would be treated as same, but in .NET or MONO it must be "%H" (Cumulus MX).
- For 12-hour specifiers, please see the table, as this is far more complicated.
- You might be put off by references within .NET and MONO (Cumulus MX) to single/standard characters and custom modifiers, the following 3 examples may add clarity:
- For example, <#MonthTempHD format="d"> is a single character format modifier, therefore the 'd' acts as a standard modifier, and causes for a date of 22 July 2014 for the highest temperature in the month to be returned in the standard short date format e.g. '22/07/2014' (exact contents for any one date vary by locale).
- Similarly, <#MonthTempHD format="M"> is a single character format modifier and therefore the 'M' acts as a standard modifier and causes the date for the highest temperature in the month to be returned in the standard day and month format e.g. '22 July' (exact contents for any one date vary by locale).
- Whilst <#metdate format="d M"> is not a single character format modifier and therefore both the 'd' and the 'M' are interpreted as custom modifiers and cause the current date to be returned as a digit(s) for the day and a digit(s) month (in a without leading zeroes format) e.g. '6 7' would be returned for 6 July.
- Alternatively, <#MonthTempHD format="%d"> is NOT a single character format modifier, therefore the 'd' acts as a custom modifier, and causes a date of 22 July 2014 for the highest temperature in the month to be returned as the day of the month only '22' in all locales.
- Similarly, <#MonthTempHD format="%M"> is NOT a single character format modifier and therefore the 'M' acts as a custom modifier and causes the same date for the highest temperature in the month to be returned as the month number '7'.
In both Cumulus 1 and MX if you want a space character within your output, the output specifiers must be enclosed in double quotes. If that space character is next to a non modifier (e.g. around word "at") then the single quote needing to surround the at should be widened to include the spaces in MX, but Cumulus 1 does not care if single quotes excluded spaces. However, with MX, single quotes enclose multiple characters, but there is an alternative way to deal with some single verbatim characters to cover next.
So let us compare these two alternative ways that MONO and .NET escape any characters that are not being used as format specifiers.
- In Delphi you can put the 'verbatim' characters inside single quotes (Cumulus 1); this is often used to (in English) include words like ' on ' and ' at ' in the formatted output.
- in .NET or MONO you can still use single quotes (as mentioned above extended to include adjacent spaces),
- but alternatively you can escape each verbatim character with a backslash as prefix (Cumulus MX).
- You may need to use both single quotes and back slashes in some format specifiers, depending whether the characters you want to include can be interpreted as control characters (yes, backslash is also used to escape control characters, so backslash will NOT work for some characters such as those in "on" and "at" [\n will produce new line not the letter n, \t will produce a tab not the letter t]), consequently for some characters you must use the literal approach to include them in your format.
Past history for this page
This page is a complete redesign of how to present information that was previously on the Webtags page, so look there for past content by selecting "history" tab.
Trying to make the old design made for the original Cumulus software, work for MX which is now very different, made the old page unwieldy.
Forum reference
Steve Loft published a table showing comparison between output date modifiers for Cumulus 1 and MX at Cumulus MX forum. The table there was based on the table that appeared in this Wiki when only the original Cumulus existed, so it was designed to help people migrate to his MX beta, it was not intended as a definitive list of what modifiers were available for MX (Steve instructed people to look them up on some Microsoft sites).
The subsequent comments in the forum suggested his layout got people confused. Most of that confusion came in two circumstances:
- When someone wanted to use one date or time modifier on its own
- When someone who had been using Cumulus 1 swapped to MX and wanted to replace a combination of output modifier characters that was not explicitly shown in his table.
That all comes from the fact that when a MX modifier consists of a single character it can mean something different to when it appears with other characters.
In Cumulus 1, "m" or "M" had two meanings depending whether it was combined with "H" or "h" (when it represented minutes), or on its own or with any other code (when it represented month). But for Cumulus 1, there is no other case where it matters what context a modifier is put in by the use of other modifiers, and no other modifier takes more than one meaning.
In MX it is much more complicated, to take a few examples "D", "H", "M" represent different items on their own to what they represent when combined with other characters. That other character can be as simple as using a space or a "%" to modify the meaning of the character.
Looking at the tables, now included above, you can see "G" is used on its own because it represents a full date-time specifier. "D" is similarly used on its own represents the long date format. If we only want the day of month number we must use "%d" to avoid the meaning of short date format that "d" on its own represents.
If we want the typical Cumulus date-stamp of day of month number and month, then we have two choices, because both "d M" and "M" will work. This illustrates how "M" has a different meaning on its own and with another modifier.
Hopefully, the way that information is now presented on this page makes any use of parameters for web tags much easier now.