What | How |
---|
Character encoding | UTF-8 |
Field / column separator | Tabulator “\t” |
End of record marker | New line “\n” |
Header | The header must consist of a column named “datetime” and 1-n columns having a valid parameter URN (from Sensor.awi.de) as column header field. The “datetime” column must always be the first column. datetime type:dev:parameter1 type:dev:parameter2
|
Header - Units | Units may be given in square brackets [], following each parameter URN, separated by a space “ “: datetime type:dev:parameter1 [°C] type:dev:parameter2 [] type:dev:stationname [text]
Units are optional depending on the O2A component and application. - Data-WS exports the unit in a data request output (or [] if not defined).
- Data-WS ignores a passed unit when importing data
- NRT Ingester passes units to the Data-WS. Only if a new (not existing) parameter URN
is created in the Data-WS the unit is added to that. Existing parameter URNs and their existing units are not updated by a change of the unit.
|
Quality Flags | Quality flags can be added to each data value. These are numbers from 0 to n defined in document not defined yet. Each data column needs an additional column titled with the same parameter URN followed by “ (quality_flag) ”: datetime vessel:mya:temp temp \[°C\] vessel:mya:temp (quality_flag)
2019-02-28 15:50:00 56.00000 1
2019-02-28 15:50:01 566.0000 2
|
Date time format | Expected time zone: UTC Allowed date formats: yyyy-mm-dd HH:MM:SS.fff
yyyy-mm-dd HH:MM:SS
yyyy-mm-ddTHH:MM:SS.fff
yyyy-mm-ddTHH:MM:SS
|
Decimal symbol | Dot "." |
Data values | Decimal values, integer numbers or characters (just no tabulators!) 34.56556 23 334.43E-2 SAMPLE1
For use of Data-WS only: The Data-WS only accepts numbers as input for each column except when its unit is "text"! For columns which do not have the unit "text" all characters or words (such as “inf”, “NaN”, “SAMPLE1”) will result in an import error. |
Error values | Empty field (simply give a null string, but do not forget to add tabs as data field separator) |