Page History

3.6 Parameter definition

Anchor_Ref160268081_Ref160268081Similar 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!

Image Added

When F_ixed_ 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 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:

...

Image Added 
Table 4: Example of a single column where parameters are to be read from

Example option 2:

...

Image Added
 

Table 5: Example of separate column per parameter

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.

...

...

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!