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_NITG_EXCHANGE_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"

When no filters are present, there is also a possibility to skip the column 

\#COLUMN_INFO= 2, OBJECT_SUB_ID

This can be configured with a boolean property in the export as follows: 

<export>
	<general>
		...
	</general>
	<properties>
		<bool key="FILTERS_COLUMN" value="false"/>
	</properties>

Or as an interactiveExportFormat in Explorer.xml as follows: 

<interactiveExportFormat>
	<name>DINO Tuf (peilschalen)</name>
	<serializerClassName>nl.wldelft.fews.system.plugin.dataExport.DinoTufTimeSeriesSerializer</serializerClassName>
	<fileFilter>tuf</fileFilter>
	<properties>
		<bool key="FILTERS_COLUMN" value="false"/>
	</properties>
	<IdMapId>IdExportDINO</IdMapId>
	<unitConversionsId>ExportDINOUnits</unitConversionsId>
</interactiveExportFormat>

The format will look like:

#TNO_NITG_EXCHANGE_FILE=
#VERSION= 1, 1, 0
#FILE_SOURCE= Waterleidingmaatschappij Oost-Brabant
#FILE_DATE= 29/08/2000
#DATA_SET_NAME_IN= DINO
#DATA_SET_NAME_OUT= DAWACO
#REMARK= Dit is een voorbeeld
#OBJECT_MEASUREMENT_TYPE= SWL
#COLUMN= 8
#COLUMN_INFO= 1, OBJECT_ID
#COLUMN_INFO= 2, DATE, YYYY/MM/DD
#COLUMN_INFO= 3, TIME, HH24:MI:SS
#COLUMN_INFO= 4, VALUE, CM, MP
#COLUMN_INFO= 5, REM
#COLUMN_INFO= 6, QLT
#COLUMN_INFO= 7, REL
#COLUMN_INFO= 8, NOTE
#COLUMN_SEPERATOR= ;
#DATA_INSERT_METHOD=
#DATA_UPDATE_METHOD=
#EOH=
51ES0158;2000/05/14;12:55:00;77;;;;
51ES0158;1999/01/14;13:10:00;5;B;;;
51ES0158;1999/01/28;;1;;;;
51ES0158;1999/02/12;;;D;;;
P51E0159;2000/05/14;12:55:00;77;;;;
P51E0159;1999/01/14;13:10:00;5;B;;;
P51E0159;1999/01/28;;1;;;;
P51E0159;1999/02/12;;;D;;;
  • No labels

1 Comment

  1. Unknown User (ooms)

    (FEWS-4308) second column is equal value of qualifier in idMapping

Disclaimer