Importing Collar Data

When entering data in the Drillhole system, 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. The Drillhole system enables the import of data stored in CSV/text or XLS/database data format.

  • The steps below describe the import of collar data in ASCII format.

    • To Import Collar Data:

    1. On the DH-Data menu, click Importand select Text File.
      The Drill Hole – ASCII Import dialog is displayed:

    2. Using the browse button, select the collar data (.csv) file from your working directory.

    3. The Import Mode enables either a previously created database to be overwritten (Overwrite) or new and/or updated Drillhole information can be added to a previously created database (Append/Merge). For more information, click the Help button.

    4. Click the Wizard button. The Drill Hole Import Wizard is displayed.

    5. The system will determine your Data Input format as Ascii Data and intuitively predict the Types of Data to import as Hole Collar Data.

    6. The Drill Hole Import Wizard enables you to easily import data from any ASCII spreadsheet or data file. The Import Wizard supports both Delimited and Fixed Field ASCII files. The Import Wizard also imports Microsoft Excel Comma Separated 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 click the Helpbutton on the individual Wizard dialogs.

    7. 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.

    8. In the four fields in the middle of the dialog box, specify 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.

    9. Click the Next> button. The system displays the third dialog box in the Drill Hole Import Wizard.

    10. Specify the Column delimiters as Microsoft Excel CSV for the type of character used to separate the column text.

    11. Click the Next> button to continue. The system displays the fourth and final dialog box in the Drill Hole Import Wizard.

    12. 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 section shows the name and type of data of the column highlighted in the preview window.

    13. The grey checked boxes, to the right in the Channel Type section, indicate the required fields, (Hole ID, Easting, Northing, Elevation and Total Depth (EOH)).

    14. In the Parameters section, the Data Type for channels that contain alphanumeric data (for example, sample numbers, rock codes etc.) must be classified as "String".

    15. In the Dummy field you can specify alpha/numeric characters to be used as the dummy. For example, Assay data often has a dummy value of -99999. You can enter this number here for all assay fields.

    16. Click the Finish button. The system imports the collar data and displays it in the spreadsheet window.

    See Also: