Importing Collar Data (CSV/text format)
When entering data in Drillhole, you must start with collar data. The system creates a unique collar database that you can use to view all drillholes in the project at a glance. You can also plot an initial plan map showing all holes for review purposes. A collar file must exist before survey or assay data can be imported, and before plans and sections can be created.
To Import Collar Data:
-
On the DH-Data menu click Import, and then click the Text file. The Drill Hole – Ascii Import Wizard dialog is displayed.
-
Using the [Browse] button, select the collar file from your working directory and click the [Open] button. The system returns you to the Drill Hole – Ascii Import Wizard dialog box and displays the file name you wish to import.
-
Click the [OK] button. The system scans the file and displays the first of four dialog boxes from the Drill Hole Import Wizard. Note that the system determines the Data Input format and has intuitively predicted that the Types of Data to import is Hole Collar Data.
-
The Drillhole Drill Hole Import Wizard enables you to easily import data from any ASCII spreadsheet or text file. The Import Wizard supports both Delimited and Fixed Field ASCII files. The Import Wizard also imports Microsoft Excel Comma Seperated Value (CSV), Comma Delimited, White Space Delimited and Tab Delimited data files. The window at the bottom of the dialog box shows the file that is being imported. For more information about the Drill Hole Import Wizard settings, read the ASCII Import Wizard help topic or click the [Help] button on the dialog box.
-
Use the horizontal scroll bar to see all of the fields in the file or simply click the [Next>] button. The system displays the second dialog box in the Drill Hole Import Wizard.
-
The system determines the File Type and in the four fields in the middle of the dialog box specifies which line in the file contains the data headings (i.e. channel names), data units ("m" or "ft" etc.), which line to begin importing data and the number of lines to display in the preview window.
-
Click the [Next>] button. The system displays the third dialog box in the Drill Hole Import Wizard.
-
Specify the Column delimiters for the type of character used to separate the column text. The system displays the data in columns by drawing lines in the preview window indicating the way in which it is preparing to import your data.
-
Click the [Next>] button to continue. The system displays the fourth and final dialog box in the Drill Hole Import Wizard.
-
The Import Wizard has scanned your data and determined the type of data with which you are working (i.e. Channel Type). It is always good practice to review your data to ensure that the wizard has selected the correct columns. The Parameters area in the dialog box shows the name and type of data of the column highlighted in the preview window.
-
The Data Type of Database Fields that contain alphanumeric data (for example, sample numbers, rockcodes etc.) must be classified as String.
-
Click the [Finish] button. The system imports the collar data and displays it in the spreadsheet window.
-
At this point, we recommend that you examine the database table carefully. Start by confirming that all columns of data in the original CSV file are present in the database.