Database Import - Locations

Step 3: Set up the Location Information.

This step is used to define the location fields for the drillholes and (very important) the primary key for these drillholes. 

1. Click the Choose the Table for Location Data button to select the table in the input file that contains the borehole location information.  For acQuire database exports, this may be titled "Collar".

The program will load the Available Fields into the pane to the right.

2. Click the Primary Key for this Table button at the bottom of the screen to specify which field within the table is the primary key.  For acQuire database exports, this may be titled "HOLEID". 
   ! This field is really, really important.  It is the "key" field to which the other data tables will reference the borehole.  If you are not sure, click the View Table Data button to view the source data table.

3. Now, map the available fields, in the list to the right, to the RockWorks fields to the left, by dragging them with your mouse.  You can also use the arrow buttons.
   ! If these drillhole locations have already been imported into the  RockWorks database, and you're appending assay or other data at this time, you need only map the Name field.  You can then skip directly to #6.

Be sure to map the import fields to the required fields: Name (the borehole ID), Easting (X), Northing (Y), Elevation (Z), and Total Depth ("DEPTH" in this example).  If you don't have an Enabled field in the data source, the boreholes will be imported as disabled - you can just enable all/some of them after import in RockWorks itself.

! Not sure what's what?  Click the View Table Data button to view the source data table.

4. If you need to create a new field in the RockWorks database to match a field in the import file, click the New RW Field button at the top of the window.
   • In the New Field window, enter the Field Name and select the Field Type from the list.  The Display Label and Description fields will be populated automatically with the Field Name; you can add/replace information as you wish.
   • Click OK to accept the new information, and this new field will be added to the bottom of the Field to Import list.
      
5. Once you have mapped the location fields to your satisfaction, click the Import Locations button to import the location data.
   ! This is really important.  This import tool processes one table at a time, not all at once.  If you don't click the button, the Locations will not be brought into the RockWorks database, and none of your remaining data (Steps 4 - 6) will, either. 

6. Click the Next button to proceed to the survey data import.
   Or, click on the small drop-down arrow by the Next button to jump directly to the next import screen of interest.
   

  Back to main topic     |     Next ( Survey Data ) 

RockWare home page