...
- 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_NITGEXCHANGENITG_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;;;
|