Survey Tab – Drillhole Import – XLS/MS Access Database/ODBC
Use this tab to specify the import parameters for the survey data to be imported into a Drillhole database.
Collar Tab options
Survey View
|
Specify the survey view to import. |
Survey Type
|
Select the survey type to import. Dip-Azimuth survey data includes hole deviation information in Hole ID, Depth, Azimuth, and Dip channels. Easting-Northing survey data includes hole deviation information in Hole ID, Easting, Northing, and Elevation channels. |
Database Fields
|
The database fields that are available for import. Select (highlight) a field to specify the Channel Type and Parameters. |
Filter Conditions
|
Click this button to open the Filter Conditions dialog. |
Channel Type |
Not imported
|
Select the Not imported radio button if you do not want the selected (highlighted) Database Field to be imported. |
Data
|
Select the Data radio button if you want the selected (highlighted) Database Field to be imported as Data. |
Hole ID
|
Select the Hole ID radio button if you want the selected (highlighted) Database Field to be imported as Hole IDs. This is a required channel. |
Depth
|
Select the Depth radio button if you want the selected (highlighted) Database Field to be imported as depth data. This is a required channel for the survey type dip-azimuth. |
Dip
|
Select the Dip radio button if you want the selected (highlighted) Database Field to be imported as dip data. This is a required channel for the survey type dip-azimuth. |
Azimuth
|
Select the Azimuth radio button if you want the selected (highlighted) Database Field to be imported as azimuth. This is a required channel for the survey type dip-azimuth. |
Easting
|
Select the Easting radio button if you want the selected (highlighted) Database Field to be imported as eastings. This is a required channel for the survey type easting-northing. |
Northing
|
Select the Northing radio button if you want the selected (highlighted) Database Field to be imported as northings. This is a required channel for the survey type easting-northing. |
RL
|
Select the RL radio button if you want the selected (highlighted) Database Field to be imported as RL (Elevation) data. This is a required channel for the survey type easting-northing. |
Parameters |
Field name
|
Specify the "Field name". This field is read-only for required channel types. |
Data type
|
Specify the "Data type". This field is read-only for required channel types. |
Data format
|
Specify the "Data format". This field is read-only for required channel types. |
Dummy
|
Specify the alpha and/or numeric characters to be used as the dummy. The default is (*). |
OK
|
Click the OK button to import the data into drillhole databases. |
Application Notes
Once all the required channels are specified, “Ready to import Dip-Azimuth Survey data” or “Ready to import East-North Survey data” will display at the bottom of the tab. OK can only be clicked once the required channels have been mapped to a database field.
Excel Database (XLS) Import
The Microsoft ADO software that we use to read and import XLS files only scans the first 20 rows or so of the data. It then makes a decision about the type of data based on what it sees (it will generally ignore the first row because it is used for titles, etc.)
If there is no data in the first 20 rows of a column, it assumes all values are type "string". This would be fine, but any actual values stored numerically are no longer picked up by the ADO software, and are reported to Oasis montaj as being "VT_NULL" type, that is, blank!
Therefore, to ensure that a numerical column in Excel is imported, there MUST be a value in the first 20 rows or so.
The numeric type entered in the wizard (e.g. string/float) controls only the type of the channel created in the database; it has no effect on whether the data will be recognized or picked up during the import.
We have tried to get around this Microsoft limitation, but with no success.
The workaround is either to re-order the original data so that there are data values in the first 20 rows, or to export to another format (example CSV) and import it that way.