Dayfile.txt: Difference between revisions

 

== Changes in different releases of Cumulus ==

 

{{Version badge 1}}

 

=== File specific Editing Rules ===

[[File:Open office (editing cumulus log files).png| right]]

# The file should be saved without "Byte Order Mark", specialised text editors will include a menu where you select the encoding and can select not to include BOM.

 

=== Using the Cumulus 1 editing feature ===

{{Version badge 1}}

'''This section applies to Cumulus 1.x.y only'''. The last command in '''Edit''' [[Cumulus_Screenshots#File.2FEdit.2FHelp_Menu |menu]] is ''dayfile.txt''. ''This is how you view'' the dayfile.txt from within Cumulus. This is a text editor, so you can type new values over those currently displayed, insert and delete rows, and it works best when at full screen. Click the ''Help'' button for detailed instructions. Cumulus Help is comprehensive.

The Cumulus 1 editor provides a "Create Missing" option where it will, for any dates for which a line does not exist, create a line if it can from reading the [[Monthly log files|detailed log file]] to extract all values relevant to that day and do the necessary minimum/maximum/total/average calculation for each dayfile.txt field, storing the time from the relevant other log file in any time-stamp field in dayfile.txt. If a particular day does not exist as a row on the daily summary log, then 'create missing' can search the observations in the relevant monthly log, and calculate approximate highs, lows and totals to insert as an extra row in the daily summary log. These are approximate because the actual highs and lows for that day are quite likely to have occurred at moments in-between those that were logged. For ''Create missing'' a list of inserted records is produced in [[dayfileeditlog.txt]]. If just some fields are wrong in a particular row (meteorological day) on day file, then there is a [[Standard_log_files#Using_Standard_logs_to_deal_with_shorter_.28or_incomplete.29_dayfile.txt_records_for_particular_dates | work around]] as at all current versions (up to 1.9.4) you can only use 'Create missing' to read from the [[Standard_log_files]] if the whole day (a line starting with that date) is missing in ''dayfile.txt''. Although Cumulus does not recognise the concept of a sensor not being available, it will write solar information even if you don't have a solar sensor; it does have to cope with reading a monthly log file that might have fewer derivatives than it wants (when using Create Missing) and therefore it may not know what to write into dayfile.txt as the calculated value. Cumulus 1 can't write a null value, so it writes zero for values, and "00:00" for time stamps. If you are using a 9am or 10am rollover time, be aware that create missing in Cumulus 1 always inserts 00:00 for null time-stamps, but in normal running Cumulus uses the rollover time for null time-stamps.

 

 

'''WORKAROUND if required dates are present in both the standard log and dayfile.txt, but not all fields for that date exist in dayfile.txt'''

 

The only method available at the time of writing involves multiple steps:

#*Or if you already have the table and have MX updating the standard logs into that database table

#Then, you can fairly easily update to add any missing values into existing columns in this monthly table, and from it update columns in a daily summary table. See [https://cumulus.hosiene.co.uk/viewtopic.php?f=18&t=18096 this post in support forum] where I describe two PHP scripts designed for this type of task.

 

== Cumulus MX ==

 

[[File:Badge vMx.png]]For Cumulus MX, when you select a line, both '''Edit''' and '''Delete''' buttons are enabled. There is no way of inserting new lines into dayfile.txt from within MX, nor of changing the dates in the file.

 

=== Editing inside MX ===

=== Editing externally ===

 

 

MX does not have the capability to recalculate, the values and time-stamp for any entry in dayfile.txt, by reading the [[Monthly log files|detailed log file]] to extract all values relevant to that day and do the necessary minimum/maximum/total/average calculation. It can be done in a script if you are a programmer. I have done this, but it was not as easy as I thought, the log file you read from may have duplicate times potentially making the calculation harder, and you cannot edit the file as you go along, you basically rename the old file and create a new file with original name as you work through all days changing individual fields whenever you need to.

== Information shown in the table ==

 

*The alphabetic column identifiers used by many spreadsheets are shown, please see warnings about using spreadsheets for editing earlier on this page

*The type of field is shown, you must not put a sign for an unsigned field, you can not specify a decimal point in an integer field, all time fields must use HH:mm format

!style="width:200px" | Field type

!style="width:600px" | Description

|-

|0

|A

|8 characters

|Date as ''2 figure day [separator] 2 figure month [separator] 2 figure year'' - the separator is that set in the windows system short date format (see [[setup]])

|-

|B

|Unsigned number

|Highest wind [[Wind_measurement#Weather_Stations_and_Cumulus|gust]] speed

|-

|C

|unsigned integer

|[[Wind_measurement#Wind_Direction | Bearing]] of highest wind gust

|-

|D

|5 characters

|Time of highest wind gust

|-

|E

|signed decimal

|Minimum [[Temperature_(and_humidity)_measurement#Cumulus_Calculated_Parameters | temperature]]

|-

|F

|5 characters

|Time of minimum temperature

|-

|G

|signed decimal

|Maximum temperature

|-

|H

|5 characters

|Time of maximum temperature

|-

|I

|Unsigned number

|Minimum [[Pressure_Measurement | sea level pressure]]

|-

|J

|5 characters

|Time of minimum pressure

|-

|K

|Unsigned number

|Maximum sea level pressure

|-

|L

|5 characters

|Time of maximum pressure

|-

|M

|unsigned number

|Maximum [[Rain_measurement#Rain_Rate | rainfall rate]]

|-

|N

|5 characters

|Time of maximum rainfall rate

|-

|O

|unsigned number

|Total rainfall for the day

|-

|-

|-

|P

|signed decimal

|colspan="4" style="background:lightgray;"|(Wind run was added from version 1.8.4)

|-

|Q

|unsigned number

|Daily [[Windrun | wind run]]

|-

|-

|R

|unsigned number

|Highest [[Wind_measurement#Weather_Stations_and_Cumulus|Average Wind Speed]]

|-

|S

|5 characters

|Time of Highest Avg. Wind speed

|-

|-

|T

|unsigned integer

|Lowest [[Temperature_(and_humidity)_measurement | humidity]]

|-

|U

|5 characters

|Time of lowest humidity

|-

|V

|unsigned integer

|Highest humidity

|-

|W

|5 characters

|colspan="4" style="background:lightgray;"|(The next two entries were added from version 1.9.0)

|-

|X

|(not documented)

|Total evapotranspiration (Only valid for Davis stations, shows zero otherwise)

|-

|Y

|unsigned

|Total hours of sunshine (only valid if sunshine sensor connected)

|-

|-

|Z

|signed decimal

|High [[Heat index]] (added to Cumulus in 1.7.11 only as spot value, not stored)

|-

|AA

|5 characters

|Time of high heat index

|-

|AB

|Signed decimal

|High [[Apparent temperature]]

|-

|AC

|5 characters

|Time of high apparent temperature

|-

|AD

|signed decimal

|Low apparent temperature

|-

|AE

|5 characters

|Time of low apparent temperature

|-

|AF

|unsigned number

|High hourly rain

|-

|AG

|5 characters

|Time of high hourly rain

|-

|AH)

|signed decimal

|-

|AI

|5 characters

|Time of greatest wind chill

|-

|-

|AJ

|signed decimal

|High [[Temperature_(and_humidity)_measurement#Cumulus_Calculated_Parameters | dew point]]

|-

|AK

|5 characters

|Time of high dew point

|-

|AL

|signed decimal

|Low dew point

|-

|AM)

|5 characters

|colspan="4" style="background:lightgray;"|(The next three entries were added in version 1.9.2 Build 1004)

|-

|AN

|unsigned integer

|Today's dominant/average wind direction

|-

|AO

|unsigned decimal

|[[Heat/cold degree days and Chill hours | Heating degree days]]

|-

|AP

|unsigned decimal

|colspan="4" style="background:lightgray;"|The next two pairs were added in version 1.9.3 build 1036 (these only show valid values if appropriate sensors exist)

|-

|AQ

|unsigned decimal

|High solar radiation

|-

|AR

|5 characters

|Time of high solar radiation

|-

|AS

|unsigned decimal

|High UV Index

|-

|AT

|5 characters

|Time of high UV Index

|-

|-

|AU

|signed decimal

|High [[Feels Like]] temperature

|-

|AV

|5 characters

|Time of high feels like temperature

|-

|AW

|signed decimal

|Low Feels Like temperature

|-

|AX

|5 characters

|Time of low feels like temperature

|}