Introduction
Export scalar timeseries to DINO Tuf type format (example config).
The DINO-format is a text file with the extension .tuf.
It consists of a fixed block of text with information on the file.
Te lines in the text block are marked with a #.
The following lines contain the the information as specified below in 9 columns separated by a ,
Kolom 1: NITG code van het meetpunt
Kolom 2: Volgnummer van de meetreeks of filter
Kolom 3: Opnamedatum formaat: jjj/mm/dd
Kolom 4: Opnametijd formaat: hh:mm:ss
Kolom 5: De opname in cm (dus niet de berekende stand)
Kolom 6,7,8 worden door ons niet gebruikt maar wel de ; scheidingstekens worden geplaats
Kolom 9: Opmerking
NOTES:
- assumed that the file always contains just 1 parameter for one or more locations;
- parameter id or name is not mentioned in the file;
- only non-missing values are written;
- Number of decimals is zero
- second column should contain the external parameter qualifier (Which is 01 in this example)
- missing values are indicated with an empty position (, ,)?
Example
\#TNO_NITGEXCHANGE_FILE= \#VERSION= 1, 1, 0 \#FILE_SOURCE= \#FILE_DATE= \#DATA_SET_NAME_IN= DINO \#DATA_SET_NAME_OUT= \#REMARK= \#OBJECT_MEASUREMENT_TYPE= GWL \#COLUMN= 9 \#COLUMN_INFO= 1, OBJECT_ID \#COLUMN_INFO= 2, OBJECT_SUB_ID \#COLUMN_INFO= 3, DATE, YYYY/MM/DD \#COLUMN_INFO= 4, TIME, HH24:MI:SS \#COLUMN_INFO= 5, VALUE, CM, MP \#COLUMN_INFO= 6, REM \#COLUMN_INFO= 7, QLT \#COLUMN_INFO= 8, REL \#COLUMN_INFO= 9, NOTE \#COLUMN_SEPERATOR= , \#DATA_INSERT_METHOD= \#DATA_UPDATE_METHOD= \#EOH= B58G0294,01,2007/09/14,08:00:00,134,,,, B58G0294,01,2007/10/01,08:00:00,137,,,, B58G0294,01,2007/10/14,08:00:00,134,,,, B58G0294,01,2007/10/29,08:00:00,131,,,, B58G0294,01,2007/11/15,08:00:00,120,,,, B58G0294,01,2007/11/30,08:00:00,102,,,, B58G0294,01,2007/12/18,08:00:00,109,,,, B58G0294,01,2008/01/14,08:00:00,106,,,, B58G0294,01,2008/01/28,08:00:00,105,,,, B58G0294,01,2008/02/15,08:00:00,105,,,, B58G0294,01,2008/03/03,08:00:00,116,,,, B58G0294,01,2008/03/14,08:00:00,109,,,, B58G0294,01,2008/03/31,08:00:00,84,,,, B58G0295,01,2007/09/14,08:00:00,93,,,, B58G0295,01,2007/10/01,08:00:00,82,,,, B58G0295,01,2007/10/14,08:00:00,98,,,, B58G0295,01,2007/10/29,08:00:00,98,,,, B58G0295,01,2007/11/15,08:00:00,87,,,, B58G0295,01,2007/11/30,08:00:00,89,,,, B58G0295,01,2007/12/18,08:00:00,77,,,, B58G0295,01,2008/01/14,08:00:00,75,,,, B58G0295,01,2008/01/28,08:00:00,73,,,, B58G0295,01,2008/02/15,08:00:00,67,,,, B58G0295,01,2008/03/03,08:00:00,70,,,, B58G0295,01,2008/03/14,08:00:00,70,,,, B58G0295,01,2008/03/31,08:00:00,58,,,, B58D0446,01,2007/09/14,08:00:00,287,,,, B58D0446,01,2007/10/01,08:00:00,292,,,, B58D0446,01,2007/10/14,08:00:00,292,,,, B58D0446,01,2007/10/29,08:00:00,293,,,, B58D0446,01,2007/11/15,08:00:00,280,,,, B58D0446,01,2007/11/30,08:00:00,288,,,, B58D0446,01,2007/12/18,08:00:00,280,,,, B58D0446,01,2008/01/14,08:00:00,278,,,, B58D0446,01,2008/01/28,08:00:00,282,,,, B58D0446,01,2008/02/15,08:00:00,271,,,, B58D0446,01,2008/03/03,08:00:00,272,,,, B58D0446,01,2008/03/14,08:00:00,278,,,, B58D0446,01,2008/03/31,08:00:00,263,,,, B58G0296,01,2007/09/14,08:00:00,83,,,, B58G0296,01,2007/10/01,08:00:00,80,,,, B58G0296,01,2007/10/14,08:00:00,85,,,, B58G0296,01,2007/10/29,08:00:00,73,,,, B58G0296,01,2007/11/15,08:00:00,69,,,, B58G0296,01,2007/11/30,08:00:00,66,,,, B58G0296,01,2007/12/18,08:00:00,80,,,, B58G0296,01,2008/01/14,08:00:00,78,,,, B58G0296,01,2008/01/28,08:00:00,78,,,, B58G0296,01,2008/02/15,08:00:00,78,,,, B58G0296,01,2008/03/03,08:00:00,79,,,, B58G0296,01,2008/03/14,08:00:00,76,,,, B58G0296,01,2008/03/31,08:00:00,63,,,, B58G0297,01,2007/09/14,08:00:00,80,,,, B58G0297,01,2007/10/01,08:00:00,73,,,, B58G0297,01,2007/10/14,08:00:00,80,,,, B58G0297,01,2007/10/29,08:00:00,70,,,, B58G0297,01,2007/11/15,08:00:00,56,,,, B58G0297,01,2007/11/30,08:00:00,68,,,, B58G0297,01,2007/12/18,08:00:00,76,,,, B58G0297,01,2008/01/14,08:00:00,76,,,, B58G0297,01,2008/01/28,08:00:00,77,,,, B58G0297,01,2008/02/15,08:00:00,63,,,, B58G0297,01,2008/03/03,08:00:00,65,,,, B58G0297,01,2008/03/14,08:00:00,62,,,, B58G0297,01,2008/03/31,08:00:00,48,,,, B58D1904,01,2007/09/14,08:00:00,102,,,, B58D1904,01,2007/10/01,08:00:00,101,,,, B58D1904,01,2007/10/14,08:00:00,100,,,, B58D1904,01,2007/10/29,08:00:00,97,,,, B58D1904,01,2007/11/15,08:00:00,88,,,, B58D1904,01,2007/11/30,08:00:00,86,,,, B58D1904,01,2007/12/18,08:00:00,55,,,, B58D1904,01,2008/01/14,08:00:00,79,,,, B58D1904,01,2008/01/28,08:00:00,79,,,, B58D1904,01,2008/02/15,08:00:00,77,,,, B58D1904,01,2008/03/03,08:00:00,86,,,, B58D1904,01,2008/03/14,08:00:00,71,,,, B58D1904,01,2008/03/31,08:00:00,51,,,, B58G0298,01,2007/09/12,08:00:00,199,,,, B58G0298,01,2007/10/01,08:00:00,195,,,, B58G0298,01,2007/10/16,08:00:00,204,,,, B58G0298,01,2007/10/30,08:00:00,190,,,, B58G0298,01,2007/11/15,08:00:00,176,,,, B58G0298,01,2007/11/28,08:00:00,183,,,, B58G0298,01,2007/12/28,08:00:00,0,,,, B58G0298,01,2007/12/17,08:00:00,177,,,, B58G0298,01,2007/12/28,08:00:00,,,,, B58G0298,01,2008/01/15,08:00:00,166,,,, B58G0298,01,2008/01/29,08:00:00,169,,,, B58G0298,01,2008/02/18,08:00:00,168,,,, B58G0298,01,2008/02/28,08:00:00,174,,,, B58G0298,01,2008/03/12,08:00:00,175,,,, B58G0298,01,2008/03/31,08:00:00,170,,,, B58G0299,01,2007/09/12,08:00:00,194,,,, B58G0299,01,2007/10/01,08:00:00,193,,,, B58G0299,01,2007/10/16,08:00:00,194,,,, B58G0299,01,2007/10/30,08:00:00,189,,,, B58G0299,01,2007/11/15,08:00:00,168,,,, B58G0299,01,2007/11/28,08:00:00,177,,,, B58G0299,01,2007/12/17,08:00:00,165,,,, B58G0299,01,2007/12/28,08:00:00,,,,, B58G0299,01,2008/01/15,08:00:00,166,,,, B58G0299,01,2008/01/29,08:00:00,171,,,,"aflezing was 1,17"