Overview of ArcWat DBF import functionality
Arcwat provides DBF IV files that can be imported through the data import module of Delft-FEWS. The file is rather basic:
it contains two fixed colums, named "STAMP" and "WAARDE". The STAMP column contains the date-time and the "WAARDE" column contains the data value.
The STAMP column should be defined as numeric value (19.1) with the next format: yyyyMMddHHmmss.0
for example: 20080830080718.0, which is read as the next date-time: August 30th, 2008, 08:07:18
The WAARDE column should contain the values in a string, with a dot as decimal seperator.
An error will be raised in case the STAMP or WAARDE column does not contain a value that meets these requirements.
The missing value is defined as "-999.99"
The importType should be "ARCWAT_DBF".
The location and parameter ID are derived from the file name. If the file name is "LOC_PAR_INFO.DBF", the base file name will be splitted by the underscore character. The first token of the file name is used as external location and the second as external parameter ID.
The attached example file "Station1_Parameter1_20081004_1600.dbf" will be parsed into external location ID "Station1" and external parameter ID "Parameter1".
The DBF files can not be supplied in a ZIP file.
Configuration
In the import moduleInstance the next definition should be used to import ArcWat DBF files:
<general>
<importType>ARCWAT_DBF</importType>
<folder>....
.....
</general
Example
