Text Import File Format

The Borehole Manager's File | Import | Text option will import data from a text file into the RockWorks borehole database (.SQLite).  In addition to the borehole data, the program can also import other project information such as the project dimensions, lithology definition (types) table, stratigraphy types table, column titles, etc. The basic idea is to create a means for importing everything about a project from other applications such as a corporate database.

This section discusses the required format for the text file.

General formatting requirements: 

• This file can have any file name. 
• The file must be text in format. 
• It can contain any combination of the data blocks that are listed below, though the <LOCATIONS> block is required.
• Data blocks are started with the appropriate flag (such as "<LOCATIONS>"). After the data listing is the ending flag (such as "</LOCATIONS>").
• The starting and ending flags must be typed in upper-case characters.
• You need to list only those blocks for which you have data. (Starting and ending flags are not required for data blocks that have no information.)
• If you use a different starting and ending flag for the data blocks, that's actually ok.  The import tool allows you to map the different blocks to specific database tables.
• It IS important, however, that you comply with the column order we list.
• Each block can have (but is not required to have) a "header" line, right below the starting flag, that labels the data columns. This header line can be ignored during import.
• Columns must be separated by tab characters. 
• The format of any real numbers (123,456,789.00 versus 123.456.789,00) must match the number format you have set up in your Windows system.

The data blocks are listed below; click on a link for information about the block setup. Only the location block is required.

! Tip: For a quick overview of how to set up this text file, try exporting one of the sample data sets, such as the Samples data, to a single file. The exported file will display the required format of the imported file.

Data tables

Well Locations 
Downhole Survey 
Lithology Data 
Stratigraphy Data 
Well Construction Data
I-Data (Intervals)
I-Text Data
T-Data (Time Intervals)
P-Data (Points) 
P-Text Data
Color Data
Fracture Data 
Vector Data
Water Level Data 
Special Log Symbols 
Special Log Patterns 
Bitmap Data
 

Types tables

Lithology Types
Stratigraphy Types
Well Construction Types
Aquifer Types
Interval Data Types
I-Text Types
Time Interval Data Types
Point Data Types
P-Text Types

Misc Project Tables

Color Fill Table
Contour Table
Point Map Range Table
3-D Point Map Range Table
XY Coordinate Table
XY Pair Table
Fault Table
Polygon Table
Bargraph Scale Table
3D IDW (Solid Modeling) Sector Table
2D IDW (Gridding) Sector Table
Synonym Table

Reference Information

Output Dimensions
Project Units
Color Numbers
Comments

Back to Importing Text Data into the Borehole Manager 

RockWare home page