Database Import - P-Data

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

Step 12: Set up the P-Data Information.

1. Click the Choose the Table for Point Data button to select the table in the input file that contains the downhole P-Data 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-Data this requires two steps. The first is to specify the ID and depth fields by dragging them with your mouse. You can also click on the Field to Import, select the Available Fields item and click the < button.

   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 Point Data to Import tab, behind the current Map Required Fields tab.
   
4. Select the Point 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-Data 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-Data fields to your satisfaction, click back to the Map Required Fields tab.
   
7. When the fields are mapped, click the Import Points 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.

   

8. Click the Next button to proceed to the P-Text 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 ( P-Text ) 

RockWare home page