Overview
Imports time series data from Scottish & Southern Electric (SSE) ASCII files.
SSE file characteristics
- SSE File format is expected to contain 4 columns with information (location, value, date-time, unit)
- File must be ',' seperated
- All comment lines start with a '*'
- Date format in the files must be of the form 'dd/MM/yyyy HH:mm:ss'
- The data have a fixed FEWS parameter 'Water Level'
Configuration (Example)
A complete import module configuration consists of an ID Mapping file, an Import Module Instance file. Unitconversion can also be included while importing. A complete set of configuration files for importing SSE files with unit conversion is attached SSE_Import.zip.
ModuleConfigFiles/
The following example of an Import Module Instance will import the time series as non-equidistant series.
<?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>SSE</importType> <folder>$IMPORT_SSE_FOLDER$</folder> <failedFolder>$IMPORT_FAILED_FOLDER$</failedFolder> <backupFolder>$BACKUP_SSE_FOLDER$</backupFolder> <idMapId>IdImportSSE</idMapId> <unitConversionsId>ImportUnitConversions</unitConversionsId> <importTimeZone> <timeZoneName>GMT</timeZoneName> </importTimeZone> </general> <timeSeriesSet> <moduleInstanceId>ImportSSE</moduleInstanceId> <valueType>scalar</valueType> <parameterId>H.obs</parameterId> <locationId>115304</locationId> <locationId>336370</locationId> <locationId>335609</locationId> <locationId>335612</locationId> <timeSeriesType>external historical</timeSeriesType> <timeStep unit="nonequidistant"/> <readWriteMode>add originals</readWriteMode> <synchLevel>1</synchLevel> <expiryTime unit="day" multiplier="100"/> </timeSeriesSet> </import> </timeSeriesImportRun>
IdMapFiles/
Defines mappings between DINO and FEWS parameters and locations.
<?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"> <map internalParameter="H.obs" internalLocation="115304" externalParameter="Water Level" externalLocation="Level in Loch Benevean"/> <map internalParameter="H.obs" internalLocation="336370" externalParameter="Water Level" externalLocation="Level in Loch Cluanie"/> <map internalParameter="H.obs" internalLocation="335609" externalParameter="Water Level" externalLocation="River Moriston Level at Torgoyle Bridge"/> <map internalParameter="H.obs" internalLocation="335612" externalParameter="Water Level" externalLocation="Level in Loch Glascarnoch"/> </idMap>
Important in this configuration is that the external locations are location names.
Example File/
Level in Loch Benevean,220.2866,17/05/2007 09:29:10,m.o.d. Level in Loch Cluanie,-7.680007,04/06/2008 13:43:34,metres River Moriston Level at Torgoyle Bridge,112.4008,16/04/2008 10:51:25,metres Level in Loch Glascarnoch,-7.945127,04/06/2008 12:17:53,metres Level in Loch Glascarnoch,243.7449,04/06/2008 12:17:54,m.o.d.