Overview
TimeSeries reader for a FEWS Master Controller database. The identifier for this reader is "Fewsdatabase". This import allows a FSS or stand alone system to import data from another FEWS master controller database. The import reads the database directly and does NOT communicate with the MC. The following limitations apply:
...
An example configuration file is attached to this page. This file imports one timeseries from the eami00 database on the fewdbsvr04 server; the figure below shows this file in XML-SPY grid format:
For this import there must be either time series sets, a location set id or location id's configured:
| Code Block | ||||
|---|---|---|---|---|
| ||||
<import>
<general>
<importType>Fewsdatabase</importType>
<folder>$IMPORT_FOLDER$/fewsldb</folder>
<deleteImportedFiles>false</deleteImportedFiles>
<idMapId>IdImportCAWFirebird</idMapId>
<dataFeedId>CAW</dataFeedId>
</general>
<timeSeriesSet>
<moduleInstanceId>ImportCAW_AQUO</moduleInstanceId>
<valueType>scalar</valueType>
<parameterId>Q.meting.sec</parameterId>
<locationId>62079_Actuele_debiet_aflaat</locationId>
<locationId>62079_Actuele_debiet_inlaat</locationId>
<timeSeriesType>external historical</timeSeriesType>
<timeStep unit="nonequidistant"/>
<relativeViewPeriod unit="day" start="-3" end="0" startOverrulable="true" endOverrulable="true"/>
<readWriteMode>read only</readWriteMode>
</timeSeriesSet>
</import>
|
database types
Syntax for SQL Server:
...