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:
No Format |
---|
as external parameter ID. h3. Example {config} <general> <importType>ARCWAT_DBF</importType> <folder>$IMPORT_FOLDER$/arcwat</folder><folder>.... ..... </general {config} |
Example