Page tree
Skip to end of metadata
Go to start of metadata

From the FEWS Explorer File menu it is possible to export selected time series to a subset of the export file formats. To enable the Export Timeseries file menu option, it should be enabled in the Explorer.xml file.

Example:

<fileMenu>
	<exportTimeSeries visible="true"/>
</fileMenu>

By default the exported time series will not do any ID mapping on exporting. Pre-defined ID mapping configuration files can be configured in the interactiveExportFormats element. In the example below the export type iBever will always use the ID Mapping configuration file IdExportKwaliteit. For each export type a default ID mapping file can be configured. InteractiveExports will always export missing values.

The following exportTypes are available:

  • pi-xml
  • gin-xml
  • csv
  • dutch-csv
  • csvdutch
  • csvwithquality
  • csvdutchwithquality
  • generalCsv (with the use of Table Layout)
  • iBever
  • kwaliteit-csv
  • Hymos 4.03
  • Hymos 4.5
  • Menyanthes
  • dino-tuf

There are 2 exportTypes that are no longer supported. They can be configured using a serializerClassName:

  • UM-Aquo
  • UM-Aquo-2009

For an up-to-date list, please inspect the interactiveExportTypeEnumStringType in the explorer.xsd: http://delft-fews-xml.avi.deltares.nl/schemas/version1.0/explorer.xsd

Example:

<interactiveExportFormats>
	<interactiveExportFormat>
		<name>iBever Export</name>
		<exportType>iBever</exportType>
		<IdMapId>IdExportKwaliteit</IdMapId>
	</interactiveExportFormat>
	<interactiveExportFormat>
		<name>HYMOS Transferdatabase 4.03</name>
		<exportType>Hymos 4.03</exportType>
		<IdMapId>IdHYMOS</IdMapId>
		<flagConversionsId>ExportHYMOSFlagConversions</flagConversionsId>
	</interactiveExportFormat>
	<interactiveExportFormat>
		<name>HYMOS Transferdatabase 4.50</name>
		<exportType>Hymos 4.5</exportType>
		<IdMapId>IdHYMOS</IdMapId>
		<flagConversionsId>ExportHYMOSFlagConversions</flagConversionsId>
	</interactiveExportFormat>
	<interactiveExportFormat>
		<name>General CSV Sample Export</name>
		<exportType>generalCsv</exportType>
		<IdMapId>IdImport_HydroBiologie</IdMapId>
		<table>
			<dateTimeColumn name="DATE_SMP" pattern="dd-MM-yy HH:mm"/>
			<locationColumn name="LOC_CODE"/>
			<unitColumn name="Eenheid"/>
			<parameterColumn name="PARAMETER_ID"/>
			<qualifierColumn name="PAR_REF" prefix="PAR_REF_"/>
			<qualifierColumn name="PROD_CODE" prefix="PROD_CODE_"/>
			<qualifierColumn name="ANAL_CODE" prefix="ANAL_CODE_"/>
			<qualifierColumn name="TYPE" prefix="TYPE_"/>
			<propertyColumn name="COST_CODE" key="COST_CODE"/>
			<attributeColumn name="Groep" id="Groep"/>
			<valueColumn name="Waarde"/>
		</table>
	</interactiveExportFormat>       
 </interactiveExportFormats>

 

An example of the generalCsv export format configuration with the use of Table Layout is given below. Note that in this example certain flagSourceColumns are also exported. This is possible since FEWS version 2015.02.

<interactiveExportFormats>
	<interactiveExportFormat>
		<name>General CSV</name>
		<exportType>generalCsv</exportType>
		<IdMapId>GeneralCsv</IdMapId>
		<table>
			<dateTimeColumn pattern="dd-MM-yy HH:mm"/>
			<locationColumn name="Location"/>
			<parameterColumn name="Parameter"/>
			<flagSourceColumn name="A" id="A"/>
			<flagSourceColumn name="B" id="B"/>
			<flagSourceColumn name="C" id="C"/>
			<flagSourceColumn name="D" id="D"/>
			<flagSourceColumn name="E" id="E"/>
			<valueColumn name="Value"/>
		</table>
	</interactiveExportFormat>
</interactiveExportFormats>

It is also possible to configure your own serializer class as long as this class implements the interface Serializer<TimeSeriesContent>. An example is given below for the UmAquo CSV serializer:

<interactiveExportFormat>
    <name>Umaquo 2011 CSV files</name>
    <serializerClassName>nl.wldelft.webservice.umaquo.timeseriesserializers.UmAquoCsvTimeSeriesSerializer</serializerClassName>
    <!-- Configure the binDir if jars of serializer are not located in FEWS bin directory -->
    <!-- <binDir>%RegionHome%/Modules/aquo-bin</binDir>-->
    <fileFilter>csv</fileFilter>
    <exportUnreliable>true</exportUnreliable>
    <properties>
        <int key="SCHEMA_VERSION" value="2011"/>
    </properties>
    <IdMapId>IdExportUmAquo</IdMapId>
    <unitConversionsId>ExportUmAquoUnits</unitConversionsId>
    <flagConversionsId>ExportUMAquoFlagConversions</flagConversionsId>
</interactiveExportFormat>

Example of the UM-Aquo-2009 serializer.

		<interactiveExportFormat>
			<name>Umaquo 2009 XML files</name>
			<serializerClassName>nl.wldelft.webservice.umaquo.timeseriesserializers.UmAquoXmlTimeSeriesSerializer</serializerClassName>
			<binDir>$MODULE_UMAQUO_FOLDER$</binDir>
			<fileFilter>xml</fileFilter>
			<exportUnreliable>true</exportUnreliable>
			<properties>
				<int key="SCHEMA_VERSION" value="2009"/>
			</properties>
			<IdMapId>IdExportUmAquo</IdMapId>
			<unitConversionsId>ExportUmAquoUnits</unitConversionsId>
			<flagConversionsId>ExportUMAquoFlagConversions</flagConversionsId>
		</interactiveExportFormat>



For the Umaquo exports, make sure the correct version is available in the bin folder. The latest umaquo binaries are part of the Delft-FEWS WebServices package.


  • No labels