Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Code Block
<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:

Code Block
<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>

 

Anchor
GeneralCSV_InteractiveExport
GeneralCSV_InteractiveExport
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.

Code Block
<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:

Code Block
<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.

Code Block
		<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>



Warning

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.