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:

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