Borehole Manager | File | Import | Tobin WCS
This program is used to import data from a Tobin Well Coordinate Service (WCS) file into the RockWorks Borehole Manager. WCS files contain well location and other miscellaneous well information which is imported into the borehole Location tabs. Assigning well names can be based on several data fields, and well symbol is based on the listed well status (D&A, GAS, etc.). Well coordinates will be converted to the current project coordinate system.
Menu Options
Step-by-Step Summary
File Selection Tab
- Import Filename: Click here to browse for the Tobin WCS file to be imported. This file may have the file name extension ".wcs".
Borehole Options Tab
- Borehole Name Field Uses: This setting will determine how the well names will be imported. The default well name will be the API number, such as "10092".
Click on this button if you want to append any additional fields, should you want more recognizable or unique information to be recorded for the name. Just be wary of unmanageably long names.
! The borehole name field is limited to 80 characters in the RockWorks database.
- However, you can also choose to append the following fields should you want more recognizable or unique information to be recorded for the name. Be warned that if you turn on all fields, the names may become unmanageably long. (We've shown relatively short examples below.)
- Lease: Insert a check here to include the lease name after the API number, such as
- Well Number: Insert a check here to include the well number after the API number (and optionally the Lease name), such as:
- 10092 2 or
- 10092 WILSON 2
- Operator: Insert a check here to include the operator name after the API number (and optionally the Lease name and/or well number), such as:
- 10092 SEECO or
- 10092 WILSON SEECO or
- 10093 WILSON 2 SEECO
- In the Borehole Name Field window, you can use the arrow buttons to move fields from the Source List to the Destination List (and vice versa). The fields in the Destination List will be used to define the well names, in the order in which they are listed. For example, if API Number and Operator are shown in the Destination List, you'll get well names that could look like: 10092 SEECO where the "10092" is the API number and "SEECO" is the Operator name.
- You can click and drag fields in the Destination List up or down to rearrange their order and (hence) their order in the well name.
- Field Delimiter: The character(s) defined here will be used to separate the fields in the well name. For example, a "_" character would generate names like "10092_SEECO".
- Easting/Northing Values: Use this setting to decide which of the Tobin well location coordinate systems - Longitude/Latitude or Public Land Survey System - will be used to compute the Easting and Northing coordinates for the well (Collar Coordinates tab) in your project coordinate system. Typically the Longitude/Latitude would be the more accurate of the two.
! Note that both the Longitude/Latitude and the PLSS coordinates will be imported into the Other Coordinate Projections tab in the Borehole Manager's Location table, so you'll have them for reference.
- Set the Symbol from Well Status: Check this box if you want RockWorks to choose the well symbol for each well based on the status for each which is listed in the import file. It will match that status to the Well Status definition table in RockWorks. Note that you can update the symbol after import, as noted at the end of this topic.
- Overwrite Options: Specify what should happen if the import file references the same well names as already exist in the current project folder.
- Skip Existing Record: If a well ID exists in the RockWorks database, the importer will skip all import records with the same well ID.
Example: If there is already a well named "Smith-01" in the project, the program should not import any new data flagged for a "Smith-01" well, and the original well will be left intact.
- Create New Record: If a well ID exists in the RockWorks database, the importer will create a new well record (with a new name, appending "_1") for all import records you've mapped for import that have the same well ID.
Example: If there is already a well named "Smith-01" in the project, and you're importing data for a well named "Smith-01," the program will create a new record named "Smith-01_1" and import the data into that new record, leaving the original well record unchanged.
- Replace Existing Record: If a well ID exists in the RockWorks database, the importer will delete all existing data for that well and replace it with the Tobin records you've mapped for import with the same well ID.
Example: If there is already a well named "Smith-01" in the project, the importer will delete all data for that well from the database, and then import the Tobin data for Smith-01. The original well record will be completely replaced.
! Be sure about this. All existing data for existing wells will be lost.
! You can activate Warn on Existing Record (the check-box below these options) to have the program display a confirmation dialog box for each existing well, so that you can choose to replace, update, skip, or create a new record, on a well-by-well basis.
- Update Existing Record: If a well ID exists in the RockWorks database, the importer will not delete that well's data before import. Instead it will add new data types to the well. Any existing data types in the well will be replaced.
Example: There is already a well named "Smith-01" in the project, with basic well location information. This run-through you map several additional header fields to custom fields you've created in the Location tabs, and these new data fields are appended to the Smith-01 well record.! However, note that the basic location information for that well will be replaced with the new.
Location Fields Use this tab to select which IHS fields are to be mapped to the RockWorks Location fields.
- Use the Select check-boxes to select which fields are to be imported into the RockWorks database.
- Input Field: These are the fields that RockWorks found in the Tobin file.
- Data Field: These are the fields in the RockWorks database. The importer will try to match up as many input fields to data fields as it can. To select a different database field, just click on the cell to activate the field, and then click on the down-arrow to browse for a different database field. Because the Tobin data contains many more general well information fields than does the default setup of the RockWorks database, many of the input fields will be mapped to the Comments section.
To add a new field to the database, click on the cell, and choose <new field> at the top of the list. RockWorks will display a Create New Field window, where you can set up a new field to add to the project's Location table for this data.
- Open the project folder (if necessary) in which the boreholes are to be created.
- Access the Borehole Manager program tab.
- Choose the File | Import | Tobin WCS option.
- Enter the requested menu options, described above.
- Click OK to continue.
A separate borehole record will be created for each well referenced in the WCS file. The well name will be assigned the API number, plus any of the optional fields you selected. Well symbol is selected based on the associations listed in the Well Status Table. Additional well fields you've requested will be recorded in the Optional Fields section of the Location tabs, or in the Comments pane.
- Update Project Dimensions: You will be prompted whether you want to establish or update the Project Dimensions based on the imported data. Be sure to do so at some point before generating maps.
- Once the well information has been imported, you can use the Maps | Borehole Map program to create a map of the well locations.
Back to Importing Data
RockWare home page