2.3 Define file type, paths and options
In this form you specify which file(s) should be read and where they can be found. The type of file determines what information the HYMOS Import Wizard needs to read from the data contained in the file. The file types that can be selected are:
- Text files , containing a data block and possibly a header. Text files are the type of files you are able to read when you open them with Notepad. Usual extensions for this kind of file are .asc, .csv and .txt, but the files you use may have a different extension.
- Microsoft Excel sheets within a workbook. The selected sheet is treated in a similar way as a text file.
- DELFT FEWS published interface files . FEWS Published Interface files are XML files that follow the rules as defined for the Delft-Flood Early Warning System.
The file path and file mask determine which files the import wizard will try to read. The buttons can be used to browse. In the field you specify the mask for the files. Use wildcard *to include more than one file, e.g. *.*for all files, *.txt for all files with extension .txt, etc. It is important that you check the contents of the folder before executing the actual import, as all files that comply with the mask defined here will be imported. In case you store old files in this directory, they might overwrite records already imported. In case there are other files that do not contain import data meet the selection criteria, import may result in an error.
The HYMOS database that you want to import to is defined by the HYMOS database definition file (*.hdb). You may type the full path to this file or use the button to the right to browse for the file. For HYMOS 4.03 and 4.02 database versions the default.hdbfile from the folder HYMOS 4\Fixed\New\New Databasemay be used. Copy this file to the database folder (the folder containing the db and mapssubfolders). The HYMOS Database Definition file contains specifications for the database connection that HYMOS uses. The default file will be correct for HYMOS 4.0 databases.
The log file will contain messages that are generated during the import. You may limit the size of the log file by entering the allowed maximum size in the text field Max log size (kB) . If no value is given, the log file will continue to grow. The amount of information that is written to the log file may be reduced by unchecking the box Verbose log output . If this box is checked detailed information is written to the log file, if it is unchecked only errors and a summary are written. In the name of the log file you may use the aliases %DATE% and %TIME%. They will be replaced by the date and time of the import.
Example file
The example file is located in file path: d:\HYMOS\HYMOS_Databases\MyDB\MyData.
The file reads 001_data.txt and in the example all files which are called *_data.txtare read in the file path and in its sub folders.
The database to import to is located at:
d:\HYMOS\HYMOS_Databases\MyDB\default.hdb.
Log output is verbose and unrestricted in its size. The format of the output will be import_today_now.log.
Next chapters
In chapter 3 the next steps for importing Asci-files and excel files are described. In chapter 4 the import template specifications for FEWS-PI files are described.
