day for the validity of the location attributesdbServerType
| scrollbar | ||
|---|---|---|
| Excerpt | ||
| ||
Functionality to define Locations, LocationSets, IdMaps, DisplayGroups, ThresholdValueSets and ValidationRuleSets from a DBF file |
Function: | _Functionality to define locations and to generate locationSets from a CSV file /Shape-DBF file / DB Table |
Where to Use? | Locations, LocationSets, IdMaps, DisplayGroups, ThresholdValueSets and ValidationRuleSets |
Why to Use? | To have only one file or a set of files where all region specific information is stored. |
Description: | Based on the CSV, DBF-Shape file or DB table you can easily manage the configuration |
Available since: | DelftFEWS200803 |
Contents
| Table of Contents |
|---|
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<locationSet id="grondwater"> <table> <databaseServer> <url>jdbc:oracle:thin:@oraclex02@dummy_hostname:1521:FEWS<dummy_databasename</url> <user>fews<<user>dummy_username</user> <encryptedPassword>***<<encryptedPassword>dummy_password_encrypted</encryptedPassword> </databaseServer> <name>PEILBUIZEN</name> <geoDatum>Rijks Driehoekstelsel</geoDatum> <id>ult_%FEWS_ID%</id> <name>%NAAM%</name> <description>Gebiedsnaam: %GEBIEDSNAA% </description> <x>%X_COORDINA%</x> <y>%Y_COORDINA%</y> <attribute id="DOMMEL_ID"> <text>%MEETPUNTCO%</text> </attribute> <attribute id="TMX_ID"> <text>%TMX%</text> </attribute> <attribute id="HARD_MAX"> <number>%HARD_MAX%</number> </attribute> <attribute id="HARD_MIN"> <number>%HARD_MIN%</number> </attribute> </table> </locationSet> |
In this example the above database table PEILBUIZEN is read from the database and completely converted to a zipped DBase file, named PEILBUIZEN.dbz. This file is used by FEWS to read all the required data.
To use a Firebird/Derby database file you should use the element <databaseFile> instead of <dbServerName>. Other connection strings:
- jdbc:postgresql://hostdummy_hostname:port/databasedummy_databasename
- jdbc:oracle:thin:@//host@dummy_hostname:port/servicedummy_nameservicename
- jdbc:oracle:thin:@host@dummy_hostname:port:SID
- jdbc:oracle:thin:@TNSName
- jdbc:sqlserver://hostdummy_hostname:port/databasedummy_databasename
To encrypt the password, use F12 menu (clipboard - > encrypt password, available since 2016.01)
...
It is possible to reference an attribute that is available at a related location by prefixing an attribute id with a location relation id.
@relationId:attributeId@
examples
@CITECTLOC@_@IDMAP_DEBIET@
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<transformation id="pump with head-discharge table with coefficient set functions">
<structure>
<pumpHeadDischargeTable>
...
<coefficientSetFunctions>
<headDischargeTableRecord head="@head@" discharge="@discharge@ * 1000"/>
</coefficientSetFunctions>
...
</pumpHeadDischargeTable>
</structure>
</transformation>
|
...
Sample input and output
...
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<locationSet id="locations">
<csvFile>
<file>locations.csv</file>
<id>%ID%</id>
<x>%X%</x>
<y>%Y%</y>
<attribute .....// first here your normal attributes
</attribute>
<attributeFile>
<csvFile>pumpcurves.csv</csvFile>
<id>%LOCID%</id>
<attribute id="head">
<number>%dH%</number>
</attribute>
<attribute id="discharge">
<number>%Q%</number>
</attribute>
</attributeFile>
</csvFile>
</locationSet> |
...
| Code Block | ||
|---|---|---|
| ||
LOCID,dH,Q 0001,0,0 0001,0.1,1 0001,0.2,1.9 0001,0.3,2.5 0001,0.5,3.5 0001,1,5 |
...
Error and warning messages
...
Description of errors and warnings that may be generated
Error: | Error message |
|---|---|
Action: | Action to fix |
...
Known issues
...
Describe all known issues and unexpected behaviour
...
Links to related parts of the system
...
Technical reference
...
Entry in moduleDescriptors: | Specification of: ENTRY and DESCRIPTION in the SystemConfigFiles\ModuleDescriptors.xml |
|---|
| No Format |
|---|
<moduleDescriptor id="ENTRY"> <description>DESCRIPTION</description> |
...