Import Data from Excel or Text into the I-Text Table
Borehole Manager | File | Import | Excel | Column Based | I-Text
Borehole Manager | File | Import | Text | Column Based | I-Text

This Borehole Manager program is used to read row and column data from a single worksheet in Excel file or from a single text (CSV, tab-delimited) file, and import the rows and columns into the I-Text table for a single borehole, or for multiple boreholes if the borehole IDs are listed in the spreadsheet. This is primarily designed for users who have data for multiple interval-text components, by depths, that can't be easily brought into the RockWorks database using the Row Based Excel Import program. The import works with XLSX, XLS, CSV, and TXT files, provided that Microsoft Excel is installed on the user's machine.

! The Borehole Manager I-Text table can read both alphabetic and numeric values, but I-Text data can be plotted only on striplogs as textual labels. If you need to import numeric data for modeling, use the I-Data import program.

Here is an example of the kind of Excel data that can be brought into RockWorks using the I-Text program; this subset lists borehole ID in the first column, measurement depth intervals in columns 2 and 3, and alphanumeric color and sample ID entries in columns 4-5. The columns can be in any order.

I-Text Import

! This import program allows you to import one or many columns from the spreadsheet.
! It also allows you to append new I-Text columns to existing boreholes. For example, if the borehole already lists a "Notes" column, you can add new Color and Sample ID columns to the hole, with the result being all 3 I-Text columns for the borehole.
! This program also allows you to append new data to an existing column. For example, if the borehole already lists Color and Sample ID columns for depths 0 - 50 and you import Color and Sample ID data again for depths 51 - 100, the original data can be retained. Be sure to activate the Append to Existing Data option.

Menu Options
Step-by-Step Summary

  1. Access the Borehole Manager program tab.
  2. If necessary, browse to the project folder in which you want to work.
  3. Select the File | Import | CSV | Column Based | I-Text menu option to import from CSV.
    Select the File | Import | Excel | Column Based | I-Text menu option to import from XLS or XLSX.
  4. Select the name of the XLS or CSV file to be imported. The program will scan the file and load the names of the columns in the Input Column Name listing.
  5. Next, specify whether you are importing for a single borehole or for multiple holes using the Import for One Borehole checkbox (as described above).
  6. If you need to define the column names for your borehole project (or add to existing names) click the Type Table button and make the necessary changes to the I-Text Types table.
  7. Map the project's column names to the spreadsheet columns, as described above. Be sure to map the borehole name column to the Borehole ID field. You only need to map those columns you wish to import.
  8. Click the OK button to proceed.

The program will read the specified XLSX, XLS, CSV, or TXT file. It will extract the data from the requested data columns and map them to the indicated database fields. Any existing I-Text for the requested columns will be appended to or overwritten (as you specified); all new I-Text columns will be added.

Back to Importing Data

RockWare home page