Importing Borehole Data from an AGS File

Borehole Manager | File | Import | AGS Data Format

The program is used to import into the Borehole Manager a variety of geotechnical and geoenvironmental data from text files that use an AGS data structure. The process involves selecting the data file to be imported, mapping the import fields to the Borehole Manager fields, and importing the data, table-by-table.

(See http://www.ags.org.uk/ for general information; see http://www.ags.org.uk/datatransferv4/intro.php for formatting information.)

Introduction
Step-by-Step Summary

Introduction

Some important notes about this import tool:

• This wizard imports table by table.  This is in contrast to the Excel import which gathers up all the information then does the import all at once. This tools' table-based approach gives you more control over the data that is imported and the sequence.  You only need to import the tables you want.
• If you import regularly from the same source or from a different source with a similar layout, you can save the import settings as a template for future use.
• The I-Data, I-Text, T-Data, P-Data, and P-Text can be imported in multiple passes since new data types can be appended to an existing table as a new column in RockWorks.

The following are the steps to import from an AGL file.

Step-by-Step Summary

• Step 1: Select the Data Source
• Step 2: Set up the Coordinate Information
• Step 3: Set up and Import Location Data
• Step 4: Set up and Import Survey Data
• Step 5: Set up and Import Bitmap Data
• Step 6: Set up and Import Color Data
• Step 7: Set up and Import Fracture Data
• Step 8: Set up and Import Interval Data
• Step 9: Set up and Import Interval Text Data
• Step 10: Set up and Import Lithology Data
  
• Step 11: Set up and Import Pattern Data
  
• Step 12: Set up and Import Point Data
• Step 13: Set up and Import Point Text
• Step 14: Set up and Import Stratigraphy
• Step 15: Set up and Import Downhole Symbols
  
• Step 16: Set up and Import T-Data
  
• Step 17: Set up and Import Vectors
• Step 18: Set up and Import Water Level Data
• Step 19: Set up and Import Well Construction Data
• Step 20: Save the Setup as a Template File

  Back to Importing Data

RockWare home page