Dayfile.txt: Difference between revisions

64 bytes added ,  09:27, 7 November 2013
m
→‎Manipulation outside Cumulus: added sub-folder name
m (→‎Manipulation outside Cumulus: make cross-ref to list of fields work)
m (→‎Manipulation outside Cumulus: added sub-folder name)
Line 46: Line 46:


==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 never attempt to work on it either when Cumulus has just been restarted and is checking/updating the logs, or around the midnight/9am/10am local rollover time when Cumulus is writing a new row.
The file is <tt>data\dayfile.txt</tt> within the directory holding the Cumulus excutable, it can be viewed in a text editor, or imported into various database systems, or imported into spreadsheets, to manipulate as you wish.  Just remember that Cumulus updates it as part of the rollover process, so never attempt to work on it either when Cumulus has just been restarted and is checking/updating the logs, or around the midnight/9am/10am local rollover time when Cumulus is writing a new row.


'''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).
'''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).
5,838

edits