Monthly log files: Difference between revisions

503 bytes added ,  17:56, 10 September 2013
m
→‎Manipulation outside Cumulus: Change cross-ref for where to see if integers or x.y decimals
m (→‎Manipulation outside Cumulus: Change cross-ref for where to see if integers or x.y decimals)
Line 53: Line 53:
Edit the original file using an editor that treats all fields as text [either any text editor, a Comma Separated Value editor, or a spreadsheet program that can be instructed ''not'' to recognise special field (like date) types].  
Edit the original file using an editor that treats all fields as text [either any text editor, a Comma Separated Value editor, or a spreadsheet program that can be instructed ''not'' to recognise special field (like date) types].  


'''Rules''' -- Each line must contain the fields in correct sequence (since new versions/builds can add to number of fields, Cumulus will accept lines of various lengths without the more recent fields at the end). Nulls (',,' if your field separator is a comma, ';;' if your field separator is a semicolon) are not allowed in the row, so if you do not know the value for a particular field within the row, then type in a zero, -999, or -999.9 (check the format and range of numbers allowed for particular fields).
'''Important Rules'''
 
*Each line must contain the fields in correct sequence (since new versions/builds can add to number of fields, Cumulus will accept lines of various lengths without the more recent fields at the end).
'''Important''':
* The date format uses two digits for the year and should be treated as text. Do not edit this file using software (e.g. Excel) with default of recognising formats, as it is likely to change the dates to have four figure years, and then Cumulus will no longer be able to use the log file. (Also the month must be the middle figure, USA convention cannot apply within logfiles).
* The date format uses two digits for the year and should be treated as text. Do not edit this file using software (e.g. Excel) with default of recognising formats, as it is likely to change the dates to have four figure years, and then Cumulus will no longer be able to use the log file.
* Times in these files are in the form ''hh:mm'' using the 24 hour clock and local time (system time). See [[FAQ#How_does_Cumulus_handle_Daylight_Saving_Time.3F]].
* Times in these files are in the form ''hh:mm'' using the 24 hour clock and local time (system time).  
*See [[#List_of_fields_in_the_file]] to identify if the value you enter for a particular field is an integer (like bearings and humidity values) or a real number (like pressure and rainfall values) in format x.y using your system decimal notation for the decimal point.
* Note that the fields related to solar data will only contain valid data if your station has the appropriate sensor(s), but if they apply make sure you note which are stored as integers.
*Negative values are allowed for temperatures, all others must be zero or positive.  Humidity has a maximum of 99, bearing has a maximum of 360.
* Apart from bearings and humidity values (these are stored as integers), most value fields are in format x.y using your system decimal notation.  See [[Monthly_log_files#Example_lines_from_the_file|Monthly log files: Example lines from the file]].
*Nulls (',,' if your field separator is a comma, ';;' if your field separator is a semicolon) are not allowed in the row, so if you do not know the value for a particular field within the row, then type in a zero, -999, or -999.9 (check the format in the middle column of [[#List_of_fields_in_the_file]] and think about the range of numbers allowed for particular fields as per examples in previous bullet).
* Note that some fields (e.g. those related to evaporation, UV, solar data) will only contain valid data if your station has the appropriate sensor(s) (without the sensor they contain the default value of zero), but if they apply make sure you note which are stored as integers.


===Importing pre-Cumulus data===
===Importing pre-Cumulus data===
5,838

edits