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 bottom 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. The user can specify a filter to limit the records imported to the Location table, specially from a large external databases. The filter looks like what might be in a SQL WHERE clause. For instance to filter to a range of Longitude and Latitude values: ([Longitude] between -105.21038 and -105.209168) and ([Latitude] between 39.749242 and 39.7528)
   
   You can use standard SQL wildcards such as percent ('%' - zero or more characters) and underscore ('_' - a single character) in the condition when you use the LIKE operator. So a filter on the Well Id to those that begin with DH-1 (ids like DH-11, DH-12, ...) would look like:
   
   
   [Well_Id] LIKE 'DH-1%' When the filter is set, Blank records do not appear unless explicitly included in the filter. For example:
   
   
   [State] <> 'CA' or [State] = NULL When a field name contains spaces, you must enclose the field name in brackets. For example:
   
   
   [Home State] = 'CA' or [Home State] = 'MA'
   
   
7. 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