5,838
edits
Monthly log files: Difference between revisions
m
→Manipulation outside Cumulus: minor tweak
m (→Manipulation outside Cumulus: Clarification to dealing with unknown fields!) |
m (→Manipulation outside Cumulus: minor tweak) |
||
| Line 29: | Line 29: | ||
===Manipulation outside Cumulus=== | ===Manipulation outside Cumulus=== | ||
Any log files for ''previous'' months can be edited (outside Cumulus) with Cumulus running, and after editing them, you can do further fetch edits within Cumulus as described above. | Any log files for ''previous'' months can be edited (outside Cumulus) with Cumulus running, and after editing them, you can do further fetch edits within Cumulus as described above. The current month log file can also be edited outside Cumulus, but you must stop Cumulus first. | ||
'''Tips''' -- take a copy of the original log file before you work on it outside Cumulus (perhaps give the ''not to be touched copy'' a filename of "<Month><Year>log.csv"). Edit the original file using an editor that treats all fields as text [either any text editor, or a spreadsheet program that can be instructed ''not'' to recognise special field (like date) types]. | '''Tips''' -- take a copy of the original log file before you work on it outside Cumulus (perhaps give the ''not to be touched copy'' a filename of "<Month><Year>log.csv"). | ||
Edit the original file using an editor that treats all fields as text [either any text editor, a CSV 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 ',,' are not allowed in the line, so if you do not know the value for a particular field within the line, then type in a zero or -999 (check the format and range of numbers allowed for particular fields). | '''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 ',,' are not allowed in the line, so if you do not know the value for a particular field within the line, then type in a zero or -999 (check the format and range of numbers allowed for particular fields). | ||
'''Important''': | '''Important''': | ||
* The date format uses two digits for the year. Do not edit this file using Excel 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 file. | * 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 file. | ||
* Times in these files are in the form ''hh:mm'' using the 24 hour clock and local time (system time). Note that the fields related to solar data will only contain valid data if your station has the appropriate sensor(s). | * Times in these files are in the form ''hh:mm'' using the 24 hour clock and local time (system time). | ||
* Note that the fields related to solar data will only contain valid data if your station has the appropriate sensor(s). | |||
* Apart from bearings (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]]. | * Apart from bearings (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]]. | ||