3.5 Station definition

3.5 Station definition

This screen defines to which stations 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.

When Fixed is selected, there is no information in the file or in the name of the file needed to determine the station. The template is used to import to one fixed station in the database. The station is selected from the drop-down combo-box, which lists all stations that are present in the HYMOS database that you are importing to.

With Determine from filename, the name of the file determines the station. For this purpose each of the stations in the database may be coupled to one of the files that meet the file mask criteria. Two features are important:

• When the file names do not contain any of the location IDs in the database, no files will be found.
• It is possible that only part of the filename defines the location 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 station . 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 station 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 station. See exapmle 2.

Example option 1:

 Table 1: Example of a single column where stations are to be read from

Example option 2:

Table 2: Example of separate column per station

It is not possible to import stations 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 station (Table 3). The data will then be imported to the wrong station.

Table 3: Invalid station translation where ID File and ID in DB use the same name for a different station.

Example file

In our general example the location is to be read from the filename: 001_data.txt. The file separator is then: '_'. The HYMOS Import Wizard will look on either side of this sign to find an existing location in the database.