Dayfile.txt: Difference between revisions

219 bytes added ,  17:06, 7 April 2013
m
→‎Manipulation outside Cumulus: add reference for earlier versions
m (→‎Editing in Cumulus: add reference to create Missing and Monthly log files)
m (→‎Manipulation outside Cumulus: add reference for earlier versions)
Line 6: Line 6:


==Manipulation outside Cumulus==
==Manipulation outside Cumulus==
The file is called <tt>dayfile.txt</tt> which can be viewed in a text editor or imported into various database systems or spreadsheets to manipulate as you wish.  Just remember that Cumulus updates it as part of the rollover process, so it is not a good idea to work on it when Cumulus has just been restarted or around the midnight/9am/10am local rollover time.
The file is called <tt>dayfile.txt</tt> which can be viewed in a text editor or imported into various database systems or spreadsheets to manipulate as you wish.  Just remember that Cumulus updates it as part of the rollover process, so do not work on it when Cumulus has just been restarted or around the midnight/9am/10am local rollover time.


Tip -- take a copy of the file before you work on it outside Cumulus (perhaps call it dayfile.csv).
Tip -- take a copy of the file before you work on it outside Cumulus (perhaps call the copy 'dayfile.csv' so Windows can recognise its structure).
 
'''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. Times are in format hh:mm, and most value fields are in format x.y using your system decimal notation. 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 (i.e. nulls ',,' are not allowed in the line, but since new builds add to number of fields, Cumulus can accept lines without the more recent fields at the end).


'''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.
* Times are in format hh:mm, and most value fields are in format x.y using your system decimal notation.
* 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 (i.e. nulls ',,' are not allowed in the line, but since new builds add to number of fields, Cumulus can accept lines without the more recent fields at the end). [Additions for the last few builds only are indicated below, you can explore details of earlier versions via the official [http://sandaysoft.com/products/cumulus product] page].


==Format of the file==
==Format of the file==
5,838

edits