AGS Import - Locations

 Step 3: Set up the Location Information.

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

1. Click the Choose the Table for Location Data button to select the table in the input file that contains the borehole location information.  In AGS files, this is often titled "LOCA".

If you need to see a list of the blocks of data in the input file, click the small View Data button, shown with the blue arrow above.

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

2. RockWorks will typically map the LOCA_ID field automatically, to the Borehole Name field in RockWorks. If it does not do so, grab that field from the Available List and drag it to the left, to the Borehole Name row.
   ! This field is very important.
   
   
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 borehole locations have already been imported into the  RockWorks database, and you're appending 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.

! Not sure what's what?  Click the View Table Data button to view the source data block. From there, you can click on the View Structure button to view the field definitions.

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. Use the Borehole Overwrite Options to tell the program what to do if location data already exists in the RockWorks project database for boreholes that are listed in the import file.
   ! This is really important.
   
   • Create New Record:  If a borehole ID exists in the RockWorks database, the importer will create a new borehole record (with a new name, appending "_1") for all import records you've mapped for import that have the same borehole ID. 
     For example, if there is already a borehole named "BH-01" in the project, and you're importing locations for a borehole named "BH-01," the program will create a new borehole record named "BH-01_1" and import the location data into that new record, leaving the original borehole record unchanged.
   • Skip Existing Record:  If a borehole ID exists in the RockWorks database, the importer will skip all import records with the same borehole ID. 
     For example, if there is already a borehole named "BH-01" in the project, the importer will not import any new locatoin data flagged for a "BH-01" boring, and the original borehole data will remain unchanged.
   • Replace Without Warning:  If a borehole ID exists in the RockWorks database, the importer will delete all existing location data for that borehole and replace it with the import records you've mapped for import with the same borehole ID. 
     For example, if there is already a borehole named "BH-01" in the project, the importer will delete all existing location information for that borehole from the database, and then import the mapped ASCII data for BH-01.  The original borehole record will be completely replaced.
     ! Be sure about this. All existing data for existing boreholes will be lost. 
   • Replace With Warning: This behaves like the previous option, but will display a warning for each hole, allowing you to select the overwrite options manually. 
6. 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