Specify the name of the file to import or use the browse button to select the file from your working directory.

Script Parameter: DHIMPORT.FILE

Select from one of the following options:

Overwrite: Start from scratch; if the database exists, it is first deleted.

Append/Merge: The existing database is preserved. If the import data contains a hole that did not previously exist in the database, the hole is added.

If data is imported into a hole that already exists in the database, the following process is followed:

• If the From-To intervals (or Depth values for point data) are identical in both the existing and in imported data, the different fields/channels are overwritten in place. Pre-existing channels that are not imported are preserved.

• If the depths in the input data are greater than those in the original data, the new data is appended to the original data

• However, if the From-To or Depth values in the imported data do not match the pre-existing hole data, or are not entirely greater than the originals, the original data is deleted, and the new data is imported into a newly created database table.

Script Parameter: DHIMPORT.OVERWRITE

Click the Wizard button to run the specific import wizard. This wizard creates an import template, which is used to import the data, and guides you through the import process. The template name uses the file name with the extension ".i3" for ASCII imports or ".i4" for XLS/Database imports. For example, importing "collars.csv" creates the template "collars.i3". For ODBC imports, the template name is created using the imported table name, e.g., "HOLELOCATION.i4".

Once the import is completed, the data is automatically displayed in the active database, in the spreadsheet window.

Click Reconnect to run the ODBC connection dialog before the import wizard to establish or re-establish the connection with the ODBC database.

See the Application Notes below for more details on ODBC drivers.

Click the Template button to use a pre-existing template for importing your data. This is particularly useful for re-importing data or importing new data with the same formatting. The Import Using Template(s) dialog will then open.

For more details on templates, refer to the following topics:

• I3 Import Template Files

• I4 Import Template Files

If a template matching the input file is found, it will be used as the default template name with the appropriate extension, either ".i3" or ".i4". Click the browse button to locate and select a pre-existing template for importing data. If multiple templates are specified, the import will proceed on each template in turn, with the collar table (if present) processed first.

Script Parameter: DHIMPASC.TEMPLATE, DHIMPDB.TEMPLATE or DHIMPODBC.TEMPLATE

A read-only field with the name of the template file entered by the user. For information only.

The name of file to import.

Script Parameter: DHIMPASC.FILE or DHIMPDB.FILE

Select from one of the following data types: Collar, Dip-Azimuth Survey, East-North Survey, From-To Data or Point Data.

Script Parameter: DHIMPASC.TYPE, DHIMPDB.TYPE or DHIMPODBC.TYPE (0: Dip-Azimuth, 1: East-North, 2: From-To, 3: Point, 4: Collar)

The component drillhole project database is created using the project name and the table name, using the format: Project_Table.gdb. The table name should consist of only letters and/or numbers, with no spaces or special characters.

Script Parameter: DHIMPASC.TABLE, DHIMPDB.TABLE or DHIMPODBC.TABLE