AGS Import - Point Text

This step is used to define the fields for the Point-based alphanumeric data (P-Text) to be imported. You can append new P-Text tracks to existing RockWorks boreholes, or replace existing P-Text tracks with this new data. If you don't want to import P-Text at this time, you can simply click the Next button along the bottom of the window to proceed to the Stratigraphy import screen.

Step 13: Set up the P-Text Information.

1. Click the Choose the Table for P-Text Data button to select the table in the input file that contains the downhole P-Text information.

   

   The program will load the Available Fields into the pane to the right.

2. You need to map the available fields, and for P-Text this requires two steps. The first is to specify the ID and depth fields by dragging them with your mouse.

   Be sure to map items to the required fields: Borehole Reference (the borehole ID), and Depth (DEPTH) in this example.

   

   ! Not sure what's what? Click the View Table Data button to view the source data table.

3. Next, you need to specify which of the downhole data fields to import. Click on the Pick P-Text Data to Import tab, behind the current Map Required Fields tab.
   
4. Select the P-Text Data Format along the right side of this screen. You have two options:
   • Spreadsheet: Choose this if the import file has multiple data columns for a single depth point, as you might see in a spreadsheet.

   • 

     
     
   • Columnar: Choose this option if the import file has one column of measurements for each depth point flagged with a Type column, like the example shown below.

   

   For Columnar layouts, select the name of the column that contains the track names (Column for Name) and the name of the column that contains the measured values (Column for Value).

   ! If you aren't sure, click the Map Required Fields tab again and click the View Data Table button to see the actual data listing.

5. When you've selected the proper data layout, you should see the available measurements listed in the Fields to Choose From list.
   Now, for each P-Text column you wish to bring into RockWorks, click on its name in the Fields to Choose From column, and either drag it to the Fields to Import column or click the "<" button.

   You can import as many of the fields as you wish.
   If you make a mistake, you can return a field to the right-hand pane by dragging it or by clicking on the ">" button.

6. Once you have mapped the P-Text fields to your satisfaction, click the Import Point Text button.
   ! This is really important. This import tool processes one table at a time, not all at once. If you don't click the button, the data will not be brought into the RockWorks database.

   

7. Click the Next button to proceed to the Stratigraphy import.
   Or, click on the small drop-down arrow by the Next button to jump directly to the next import screen of interest.
   

  Back to main topic    |     Next ( Stratigraphy ) 

RockWare home page