5,838
edits
Dayfile.txt: Difference between revisions
m
→Manipulation outside Cumulus: explain connection between low/high value and timestamp as mentioned by Steve Loft in forum reply
m (→Format of the file: cross reference to downloadable list) |
m (→Manipulation outside Cumulus: explain connection between low/high value and timestamp as mentioned by Steve Loft in forum reply) |
||
| Line 41: | Line 41: | ||
'''Important''': | '''Important''': | ||
* The (meteorological) date format uses two digits for the year. Edit this file using an editor that treats all fields as text (a text editor or a spreadsheet program that can be instructed ''not'' to recognise special field types). - ''Do not edit this file using Excel'' or any similar tool that recognizes dates, as it is likely to change the dates to have four figure years, and then Cumulus will no longer be able to use the file. | * The (meteorological) date format uses two digits for the year. Edit this file using an editor that treats all fields as text (a text editor or a spreadsheet program that can be instructed ''not'' to recognise special field types). - ''Do not edit this file using Excel'' or any similar tool that recognizes dates, as it is likely to change the dates to have four figure years, and then Cumulus will no longer be able to use the file. | ||
* Times are in format hh:mm, and most value fields are in format x.y using your system decimal notation. | * Times are in format hh:mm, and most value fields are in format x.y using your system decimal notation. | ||
* If you insert a lowest or highest value into a day, where there was none before, insert a timestamp too, as a dayfile.txt row is only accepted by the Cumulus editor if a value and any related timestamp are either both present or both absent. | |||
* Also, make sure that any editing does not create any ''blank lines'' in the file, all must start with date and include some of the parameters listed in correct sequence. | * Also, make sure that any editing does not create any ''blank lines'' in the file, all must start with date and include some of the parameters listed in correct sequence. | ||
* Nulls ',,' are not allowed in the line, so if you do not know the value for a particular field within the line, then type in an extreme with opposite value (e.g. -999.9 for a signed decimal maximum, and 999.9 for a decimal minimum - assuming your system decimal format is using full stops). | * Nulls ',,' are not allowed in the line, so if you do not know the value for a particular field within the line, then type in an extreme with opposite value (e.g. -999.9 for a signed decimal maximum, and 999.9 for a decimal minimum - assuming your system decimal format is using full stops). | ||