5,838
edits
Category:Files with Comma Separated Values: Difference between revisions
Category:Files with Comma Separated Values (view source)
Revision as of 05:55, 9 April 2022
, 9 April 2022Minor resequencing of page
m (add category) |
m (Minor resequencing of page) |
||
|
[[Category:Cumulus Files]]▼
Cumulus software uses a number of files with a '''.txt''' extension that can be described as being in comma separated value format (CSV).
Cumulus normally simply appends new lines onto the end of these files, although there is some functionality to read (and in some versions) edit these files. ▼
▲Cumulus normally simply appends new lines onto the end of these files, although there is some functionality to read
None of the files hold a header line, although the appropriate header labelling the fields can be found in a different file. Although these files are described as CSV format, that does not mean that the character separating one field from the next field has to be ",". In some locales, the comma character might separate the integer and decimal parts of a number, so the field separator character might be a semi-colon ";".▼
None of the files hold a header line, although the appropriate header labelling the fields can be found in a different file. (Links to those files included in list below).
▲[[Category:Cumulus Files]]
==Field separator==
▲
This sub-category provides links to pages that give explanations for all of the Log files with a '''.txt''' extension within Cumulus MX.▼
The files linked below all use plain text, so that they can be edited outside Cumulus, but there are rules about content, so be very careful about editing outside Cumulus. A "CSV editor", or a simple text editor designed for those writing code, is safer to use than a spreadsheet (if you use a spreadsheet, ensure all columns are set to be "text", don't let it recognise dates, times or numbers), and you must never use a word-processor.▼
==Editing these files==
The files will be different depending on the device running MX. So on Microsoft Windows Operating System each line is terminated by a pair of characters (CR and LF), on a UNIX-derived system where Linux uses just LF to end a line, and some versions of Mac Operating System use just CR to terminate each line. If you edit a file on a different device to where any MX executable (CumulusMX.exe, CreateMissing.exe, or ExportToMySQL.exe) runs, beware the line endings might get changed. Recent releases of MX are coded to recognise which line ending was previously used, and will maintain that even if you run an executable on another device.▼
▲The files linked below all use plain text, so that they can be edited outside Cumulus, but there are rules about content, so be very careful about editing outside Cumulus. A "CSV editor", or a simple text editor designed for
'''For Legacy Cumulus 1''', a subset of the files listed here are used with some content differences between MX and the legacy software. ▼
You may wish to edit into a data file a header line, to make life easier when editing values, but remember to remove that header line before saving the file.
▲The
If you move a file between different devices, beware the line endings might get changed (although an editor designed for programmers includes ability to select line ending).
Recent releases of MX are coded to recognise which line ending was previously used, and will maintain that even if you run an executable (CumulusMX.exe, CreateMissing.exe, or ExportToMySQL.exe) on another device.
==Note for anyone using the Legacy Cumulus 1==
This Wiki page was created as part of documenting Cumulus MX, and is not therefore written for you.
▲'''For Legacy Cumulus 1''', only a subset of the files listed here are used.
Please note that descriptions of those files that are used by the legacy software, and tips, can be found in the Help file within the Cumulus 1 software, it can be read at [https://cumuluswiki.org/Downloads/Cumulus.chm Cumulus.chm] although that help file is formatted to only open if your computer is using a Microsoft Windows Operating System.
==Cumulus MX users should read this==
▲This sub-category was created specifically for Cumulus MX. It provides links to pages that give explanations for all of the Log files with a '''.txt''' extension.
# MX software normally ignores any data for dates before the first use of MX, please see [[Migrating_from_Cumulus_1_to_MX#Start_date]] for further advice
# MX software creates more fields in each line of each of the files, than the fields created by Cumulus 1, please see [[Calculate_Missing_Values#CreateMissing.exe]] for further advice
| |||