Importing Text Data into the Borehole Manager

Borehole Manager | File | Import | Text

This option is used to bring data into Borehole Manager from an external text file. In addition to the borehole data, the program can also import other project information such as the project dimensions, lithology type table, stratigraphy type table, column titles, etc. The basic idea is to create a means for importing everything about a project from other applications.

A few important notes:

• The text import tool can append to existing borehole records.  This means that any data being imported that references existing borehole names (records) will simply be written to the existing record's fields.  For example, if your existing database contains Location records for DH1 and DH2, you can append Lithology data for those same boreholes.
   
• You cannot, however, append to individual data tables. For example, if you already have lithology data stored in the borehole database, importing lithology data from the text file will replace all of the existing lithology data.  Or if you already have a Resistivity track for P-Data, importing Resistivity data from the text file will replace all of the existing Resistivity data for that borehole.
   
• The format of the imported data must be the same as that produced by the export-to-text (File | Export | Multiple Tables | Text) program, which exports the database tables to a single text file. 
  
  
• The format used for noting real numbers in the text file to be imported must match the number format you have assigned in Windows. For example, if your Windows system is set up to use U.S. number format (123,456,789.00), then RockWorks assumes the import file uses this format. If your Windows system is set up to a European number format (123.456.789,00) then you need to be sure the import file uses this as well.
   
• Because of the relational nature of the RockWorks database tables, it is necessary for the data types to be defined so that the import tool will be able to bring all of your text data into the database.  For example, if you are importing downhole interval measurements for "Benzene" and "Toluene", these I-data field names need to be defined so the import tool knows where to put them.  There are three ways to do this:
  1. (Recommended) Include the Type definitions - lithology, stratigraphy, well construction, I-Data, I-Text, T-data, P-Data, P-Text - in the import file itself.  See the discussion of the Types worksheets in the Text File Format topic.
  2. Define them in RockWorks before you import the ASCII data. Use the Project Manager to access the Borehole Database / Lithology Types, Stratigraphy Types (etc) Tables where you can create/modify the defined data types.  (You can also access the Types tables using the buttons on the data tabs themselves.)
  3. Let the import tool define them on the fly.  Note that you will then need to view the Types Tables to establish patterns, colors, data ranges, etc.

Topics

• Overview: What are you trying to do?
• Step 1: Get ready and select the import file
• Step 2: Map the data blocks
• Step 3: Set up the Coordinates
• Step 4: Map the Location fields & define how duplicate records should be handled.
• Step 5: Import the data and follow up

See also

• Lithology Type Tables
• Stratigraphy Type Tables
• Well Construction Type Tables
• Defining the I-Data Columns
• Defining the I-Text Columns
• Defining the T-Data Columns
• Defining the P-Data Columns
• Defining the P-Text Columns
• Summary of the RockWorks Database Tables

RockWare home page