View Source

Overview

The CHC import function (<importType>CHC</importType>) imports external historical time series from a specific CSV files for FEWS Basque. Since the csv data is specified in local time format, a timezone has to be configured in the importer:

<importTimeZone>
<timeZoneName>CET</timeZoneName>
</importTimeZone>

These files are received each 5 minutes and include all the signals for that interval.
Their name gives the date and time.
Time is local (i.e. +2 hr GMT in summer and +1hr GMT in winter)
Each line of the file represents one signal
There are 5 fields per line separated by ; They are:
- Type of station (A: river gauge station)
- Code of station and signal.
  - he first 4 characters represent the code of the station (for example 1080)
  - the last 5 characters represent the type of signal:
    - NRIO1 or NRL7S: level in river in m;
    - QRIO1: discharge in river in m3/s,
    - PCINC: precipitation in mm
    - TEMEX: temperature in ºC
- Date (day/month/year) and time (hour:minutes:seconds)
- Value of the signal. The “,” represents the decimal point
- Quality of the signal:
  - BUENO/BUENA: good; FEWS quality flag: ORIGINAL_RELIABLE
  - MALO/MALA: bad; FEWS quality flag: ORIGINAL_DOUBTFUL
  - NO DATO: no data; FEWS quality flag: ORIGINAL_MISSING

Configuring the Import

To make the importer known to FEWS, the import module has to be declared in the moduleInstanceDescriptors.xml in the RegionConfigFiles directory of the FEWS configuration:

<?xml version="1.0" encoding="UTF-8"?>
<moduleInstanceDescriptors xmlns="http://www.wldelft.nl/fews"
		xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
		xsi:schemaLocation="http://www.wldelft.nl/fews
		http://fews.wldelft.nl/schemas/version1.0/moduleInstanceDescriptors.xsd" version="1.0">
...
	<moduleInstanceDescriptor id="ImportCHC">
		<moduleId>TimeSeriesImportRun</moduleId>
	</moduleInstanceDescriptor>
...
</moduleInstanceDescriptors>

An example of the CHC import configuration will be given here. The importType is named CHC which should be configured in the general section of the import.
Special attention should be given to the timezone since CHC data is stored in local time;

<?xml version="1.0" encoding="UTF-8"?>
<timeSeriesImportRun xmlns="http://www.wldelft.nl/fews" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xsi:schemaLocation="http://www.wldelft.nl/fews 
	http://fews.wldelft.nl/schemas/version1.0/timeSeriesImportRun.xsd">
	<import>
		<general>
			<importType>CHC</importType>
			<folder>$IMPORT_FOLDER$/import/chc</folder>
			<idMapId>chcMapId</idMapId>
			<importTimeZone>
				<timeZoneName>CET</timeZoneName>
			</importTimeZone>
		</general>
		<timeSeriesSet>
			<moduleInstanceId>ImportCHC</moduleInstanceId>
			<valueType>scalar</valueType>
			<parameterId>Q.m</parameterId>
			<locationId>FewsLocation</locationId>
			<timeSeriesType>external historical</timeSeriesType>
			<timeStep unit="minute" multiplier="5"/>
			<relativeViewPeriod unit="minute" start="0" end="100"/>
			<readWriteMode>add originals</readWriteMode>
		</timeSeriesSet>
	</import>
</timeSeriesImportRun>

The IdMapping configuration chcMapId.xml is very important because this maps the internal FEWS Id's to the CHC Id's. An example IdMapping file for the CHC importer is shown below.:

<?xml version="1.0" encoding="UTF-8"?>
<idMap version="1.1" xmlns="http://www.wldelft.nl/fews"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.wldelft.nl/fews
http://fews.wldelft.nl/schemas/version1.0/idMap.xsd">
	....
	<parameter internal="Q.m" external="QRIO1"/>
	<location internal="FewsLocation" external="1080"/>
	....
</idMap>

Example CHC file

A;1080_AINRIO1;15/05/2014 13:05:00;1,830000;BUENO
A;1080_AINRIO1;15/05/2014 13:10:00;1,830000;BUENO
A;1080_AINRIO1;15/05/2014 13:15:00;1,830000;BUENO