3.6 Parameter definition
Similar to the station definition, this screen defines to which parameters in the database the import data should be imported. There are four possibilities: fixed , by using the file name or determine from contents or determine from the header.
Manual HYMOS Import Wizard^image025.jpg!
When F_ixed_ is selected, there is no information in the file or in the name of the file needed to determine the parameter. The template is used to import to one fixed parameter in the database. The parameter is selected from the drop-down combo-box, which lists all parameters that are present in the HYMOS database that you are importing to.
With Determine from filename , the name of the file determines the parameter. For this purpose each of the parameters in the database may be coupled to one of the files that meet the file mask criteria. Two features are important:
- When the filenames do not contain any of the parameter IDs in the database, no files will be found.
- It is possible that only part of the filename defines the parameter ID (and the other part indicates e.g. the date). For these cases a separator can be defined. When the separator is defined, the HIW will look at either side of the separator characters. The available separator characters include all characters allowed by MS Windows in a filename.
When determine from contents is selected, one can choose - Either there is a single column in the import file which contains unique IDs for each parameter . If all the ID's in the file are equal to the ID's in the database, you may enter a column number after ID DB = *, otherwise you will have to match the ID as used in the file with the column after the appropriate ID from the database. See example 1.
- Or there must be a column containing a value for each parameter you want to import. If there is a separate column with a quality indicator (e.g. < or <=), you may enter the number of that column under Column Quality . Otherwise leave this field blank. Normally the column numbers are different for each parameter. See exapmle 2.
Example option 1:
Manual HYMOS Import Wizard^image026.gif! Manual HYMOS Import Wizard^image021.gif!
Table 4: Example of a single column where parameters are to be read fromID DB
Name
ID File
Column
Quality
(all)
3
P01
Parameter1
Par1
P02
Parameter2
Par2
P03
Parameter3
Par3
P04
Parameter4
Par4
P05
Parameter5
Par5
Example option 2:
Manual HYMOS Import Wizard^image027.gif! Manual HYMOS Import Wizard^image023.gif!
Table 5: Example of separate column per parameterID DB
Name
ID File
Column
Quality
(all)
P01
Parameter1
Par1
3
P02
Parameter2
Par2
4
P03
Parameter3
Par3
5
P04
Parameter4
Par4
6
P05
Parameter5
Par5
7
It is not possible to import parameters unknown to the database you are importing to. It is also not possible to use IDs in the import file that have the same name as IDs in the database but indicate a different parameter (Table 6). The data will then be imported to the wrong parameter.
Table 6: Invalid parameter translation where ID File and ID in DB use the same name for a different parameter.
ID DB
Name
ID File
Column
Quality
P01
Parameter1
P02
3
P02
Parameter2
Par2
4
When fixed is selected, there is no information in the file or in the name of the file needed to determine the parameter. The template is then used to import one parameter into HYMOS. This parameter is selected from the drop-down combo-box, which lists all parameters that are present in the HYMOS database.
With Determine from filename , the name of the file determines the parameter. For this purpose each of the parameters in the database may be coupled to one of the files that are found by in the specified directory. If a filename is specified the information in that file is used for that parameter. Click on the line for which you want to specify a file to open a Windows file open dialogue. Press the delete key while on a line to remove a definition.
When determine from contents is selected, there - Must be a column in the file which contains a unique ID for the parameter . If all the ID's in the file are equal to the ID's in the database, you may enter a column number after ID DB = *, otherwise you will have to enter the ID as used in the file and the column number after the appropriate ID from the database. Normally the column number is the same for each parameter.
- Or there must be a column containing a value for each parameter you want to import. If there is a separate column with a quality indicator (e.g. < or <=), you may enter the number of that column under Column Quality . Otherwise leave this field blank. Normally the column numbers are different for each parameter.
It is not possible to import parameters unknown to the database you are importing to.
Example file
In our example file each column needs to be mapped to a parameter: option 2 of Determine from contents . Please note that data column 7 is not mentioned in this list and will not be read!ID DB
Name
ID File
Column
Quality
(all)
EG
Evaporation generated
EH
Evaporation historical
6
HA
Maximum water level
HD
Down stream water level
HG
Water level generated
HH
Water level historical
3
...
...
...
...
...
PH
Rainfall historical
4
QG
Discharge generated
QH
Discharge historical
5
