...
- 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
No Format |
---|
\#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:
No Format |
---|
<export> <general> ... </general> <properties> <bool key="FILTERS_COLUMN" value="false"/> </properties> |
Or as an interactiveExportFormat in Explorer.xml as follows:
No Format |
---|
<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:
No Format |
---|
#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;;;
|