Import Drillhole Data from ODBC

1. On the Discover ribbon tab, in the Drillhole Project group and click Drillhole Manager.

   The Drillhole Manager window displays.

2. Under Project, expand New and select Import ODBC.

   The Select Data Source window displays.

3. Browse for and select the required ODBC database tables.
4. Click OK.

   The Drillhole Project Setup window displays.

5. Browse for and select the Input ODBC File.

   The ODBC database tables load.

6. Enter a drillhole project Name.
7. If required, enter a drillhole project Description.
8. Select a file Path location to save the drillhole project.
9. To change the Coordinate System (CRS):
   1. Click the button labelled with the coordinate system name. Default—WGS 1984 Web Mercator Auxiliary Sphere.

      The Coordinate System window displays the XY Coordinate Systems Available.

   2. Select the required coordinate system.
   3. Click OK.
10. Update the Depth / Length Units if required.
11. Select whether the project contains Drillholes or Trenches (or both).
12. Click Next.
13. If the project contains Drillholes, the Drillhole Location tab displays. Configure the following fields:
    1. Browse for and select the required Drilling Collar Table.
    2. If required, click Field Selection button to choose which fields to display in the drillhole project.
    3. If required, click Filter Condition button to choose which collars to load into the drillhole project.
    4. Update the following fields in the Drilling Collar Table field group as required.
       • Hole ID
       • Easting
       • Northing
       • Elevation
       • Azimuth
       • Dip
       • Total Depth (Length)
    5. Browse for and select the required Drilling Survey Table.
    6. If required, click Field Selection button to choose which fields to display in the drillhole project.
    7. Update the following fields in the Drilling Survey Table field group as required.
       • Hole ID
       • Depth
       • Azimuth
       • Dip
    8. Select whether Down Dip is negative.
14. If the project contains Trenches, the Trench Location tab displays. Configure the following fields:
    1. Browse for and select the required Trench Collar Table.
    2. If required, click Field Selection button to choose which fields to display in the drillhole project.
    3. If required, click Filter Condition button to choose which collars to load into the drillhole project.
    4. Update the following fields in the Trench Collar Table field group as required.
       • Trench ID
       • Easting
       • Northing
       • Elevation
       • Bearing
       • Total Depth (Length)
    5. Browse for and select the required Trench Survey Table.

       Note: If the trench is not linear and contains multiple bearing changes or inflection points along its length, you must provide a survey table. The survey table must include a Trench ID field that matches the corresponding field in the Trench Collar table.

    6. If required, click Field Selection button to choose which fields to display in the drillhole project.
    7. Select whether the trench is XYZ or Bearing & Distance cumulative.
    8. If XYZ is selected, update the following fields in the Drilling Survey Table field group as required.
       • Trench ID
       • Order
       • X
       • Y
       • Z
    9. If Bearing & Distance is selected, update the following fields in the Drilling Survey Table field group as required.
       • Trench ID
       • Order
       • Bearing
       • Distance
       • Inclination
    10. Select whether the trenches are Cumulative or Segments.
    11. If required, enter the Surface Offset.
15. Click Next.

    The Downhole tab displays.

16. Browse for and select the required Downhole Tables.
17. Update the following fields in the downhole tables as required.
    • Hole ID
    • From
    • To
    • Point Table (only for tables without a from and to column)
18. Click OK.
19. Validate Imported Drillhole Data.