Page History

From eFrom 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.

...

For an up-to-date list, please inspect the interactiveExportTypeEnumStringType 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

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

Since 2020.02 it is possible to export unreliables using generalCsv when there is a flag column configured. This is to prevent exporting untrustworthy data from FEWS without showing it should not be trusted.

Since 2020.02 it is also possible to specify an explicit time zone that must be used for the interactive export:

Code Block

		<interactiveExportFormat>
			<name>Export Fysische-Chemie beknopt</name>
			<exportType>generalCsv</exportType>
			<IdMapId>IdExport_IMmetingen</IdMapId>
			<timeZoneName>AST</timeZoneName>
			...
		</interactiveExportFormat>
		<interactiveExportFormat>
			<name>Export Fysische-Chemie uitgebreid</name>
			<exportType>generalCsv</exportType>
			<IdMapId>IdExport_IMmetingen</IdMapId>
			<timeZoneOffset>+03:15</timeZoneOffset>

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.

...

Page tree

Versions Compared

Old Version 5

New Version Current

Key