Define the I-Data Columns

In the Borehole Manager's I-Data table you can define a (virtually) unlimited number of columns for the different components you've recorded. Before you start entering the depth intervals and measured values, you need to define the column headings or data "types."

There are several methods you can use to access the I-Data Column definition window:
- Double-click on the I-Data Types entry in the Project Manager tab, under Project Tables | Types Tables.
- Click on the "I-Data Types" button at the top of the I-Data table.
- Right-click anywhere in the I-Data table for any of the existing boreholes, and choose Show Column Names dialog from the pop-up menu.
- Select the View | Tab Manager menu option, click on the I-Data item in the list, and click the Edit Fields button.
The program will display the Interval Data Columns dialog box.
Define the I-Data record types:
1. Visible: Use these check-boxes to define whether the column will be visible in the Borehole Manager interface. Removing the check-box here will not delete the data from the database, instead it will simply remove the column from display within the program interface. See the Tips, below, for deleting a type from the database.
2. Order: The order of the I-Data components is assigned automatically (using integer values) as you add rows to this listing. The Order value simply defines the order in which the components are listed in the Types table, though initially it will also define the left-to-right order in which the columns are displayed in the I-Data table in the Borehole Manager. However the Types Table order and the column order operate independently - the Types Table order is stored in the project database, and the column order is stored in the project's data dictionaries.
  - You can change the Order numbers, and hence the order of the items in the Types table, by editing the Order values. This will not automatically affect the left-to-right column order in the I-Data table.
  - You can click and drag the columns in the I-Data table to rearrange them within the Borehole Manger view, and that column order will be remembered. That rearrangement will NOT affect the Order number in the Types table.
  - However, if you want the I-Data column order to match the Order number in this Types table you can force that to happen: right-click on the "I-Data" tab in the Borehole Manager, choose Reset Tab Columns, and the columns will be sequenced based on the Order value here.
3. Column Name: Enter the name of the measured value you'll be recording, such as Benzene or Percent Sand or Gold. The Name will become the column heading. This field is limited to 31 characters, including spaces. (We recommend keeping the names as short as you possibly can live with, for simplity's sake.)
4. Min Value, Max Value: The program will use these columns to list the minimum and maximum values for the component in the current project database. You can use the Set Min Max Values button to refresh this listing.
5. Units: Type in the units you are measuring, such as PPM or Percent. This is for your reference only.
6. Description: Here you can list descriptive information about the measurements, for your reference.
Repeat this for as many columns as you want in your I-Data table.
Click the Close button to accept your entries.

To add a new row to the end of the listing, click in the lowest row and press the down-arrow key on your keyboard.
To delete a row in the I-Data Types table, and remove the column from the database, click in the row and type Ctrl+Del.
! If there is data stored under this record type in the database, you'll be warned as such. Click OK to continue with the deletion and all data will be lost or click Cancel to cancel the deletion.

Back to Entering I-Data

RockWare home page