...
Imports time series data in csv format from the Woodleigth System Control Centre in Singpore. These file ar in a csv format. The first line is a header for each column indicating the location. The filename encodes the parameter. eg. in the file Aname_RF.txt is parameter is RF (rainfall).
Configuring the Import
The reader is named WSCCCsv which should be configured in the general section of the import. An example import configuration is shown below:
| Note |
|---|
As the file format does not include geographical datum information you must configure the geoDatum field in the general section |
The file format
...
| No Format |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2006 rel. 3 sp1 (http://www.altova.com) by Jaap S (WL | Delft Hydraulics) -->
<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>WSCCCsv</importType>
<folder>$IMPORT_FOLDER$/WSCC</folder>
<failedFolder>$IMPORT_FAILED_FOLDER$</failedFolder>
<idMapId>IdImportWSCC</idMapId>
<importTimeZone>
<timeZoneOffset>+08:00</timeZoneOffset>
</importTimeZone>
</general>
<timeSeriesSet>
<moduleInstanceId>ImportWSCC</moduleInstanceId>
<valueType>scalar</valueType>
<parameterId>H.obs</parameterId>
<locationSetId>WSCC_Level</locationSetId>
<timeSeriesType>external historical</timeSeriesType>
<timeStep unit="minute" multiplier="10"/>
<readWriteMode>add originals</readWriteMode>
<synchLevel>1</synchLevel>
<expiryTime unit="day" multiplier="3650"/>
</timeSeriesSet>
</import>
</timeSeriesImportRun>
|
An example IdMapping (that maps the first column of the also attached example input file) is shown below:
| No Format |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2006 rel. 3 sp1 (http://www.altova.com) by Jaap S (WL | Delft Hydraulics) -->
<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="H.obs" external="LEV"/>
<parameter internal="Q.obs" external="FLW"/>
<parameter internal="P.obs" external="RF"/>
<parameter internal="Q.rated" external="VOL"/>
<!-- vlume -->
<location internal="LowerPierce" external="S23-USR-LEV-RES-1"/>
</idMap>
|
The file format
| No Format |
|---|
Date Time TN-1 QF-1 TN-2 QF-2 TN-3 QF-3 TN-N QF-N
DataType date time float Char(1) float Char(1) float Char(1) float Char(1)
DataFormat ddmmyyyy hh:mm xxxx.xxxxxx xxxx.xxxxxx xxxx.xxxxxx xxxx.xxxxxx
|
NOTE :
+ All the columns in text file will be separated by comma(,) character
...