Transferring Stratigraphic Elevations from the Datasheet to the Borehole Manager
RockWorks | Datasheet | File | Transfer | Strat -> Borehole Manager

This program is used to read specific data fields from the RockWorks datasheet and record them in the Borehole Manager Stratigraphy tables. This can be useful if you have done some manipulation of the stratigraphic elevations in the datasheet and want the modified data to be represented in the Borehole Manager.

! This is not meant to be a means of entering stratigraphic data, but instead as a means of modifying data that has already been brought over from the Borehole Manager for editing purposes. A typical scenario might go like this: The user transfers stratigraphic top and bottom elevations from the Borehole Manager to the RockWorks datasheet. Next, the user manipulates the stratigraphic elevations (not the easting, northing, elevation, or symbol data) and/or uses various programs within the menus to process this data. Then, the user may wish to transfer these modified elevations back into the Borehole Manager (which will convert them back to depths). See Transferring Borehole Stratigraphy to the RockWorks Datasheet for information about that transfer tool.

! This transfer program assumes vertical boreholes. Any downhole survey information in the Borehole Manager database will NOT be taken into account when edited elevations are transfered back to the database and translated back into depths. (The Borehole Manager's transfer tool TO the datasheet does take downhole survey into account, but this transfer-back tool does not.)

! For the transfer to be successful, it is required that all boreholes referenced in the datasheet already exist in the Borehole Manager.

! It is required that the data in the datasheet be listed in a specific order. See Required Structure of the RockWorks Stratigraphy Data.

Menu Options
Step-by-Step Summary

Menu Options

There are none.

 

Step-by-Step Summary

  1. Access the RockWorks Datasheet program tab.
  2. If necessary, open the project folder in which the stratigraphic data already resides and in which the borehole database resides.
  3. If necessary, open into the datasheet the stratigraphic elevation data to be posted back to the Borehole Manager.
  4. Check that the data is listed in the same column order as when originally transferred from the Borehole Manager.
  5. Select the File | Transfer | Stratigraphy -> Borehole Manage option.
  6. When prompted whether you wish to back up your current database, answer Yes or No as desired.

The program will read the borehole ID’s from column 1 in the datasheet. For each row in the datasheet, it will check whether a borehole record with that ID already exists. If it does, it will translate all listed stratigraphic elevations back to depths and post the data to that borehole's records (overwriting any existing data – be careful).


RockWare home page