Solution
It was requested that customizedwell status attributes be mapped to the OpenSpirit Metadata database mapping. The requirement was to facilitate the transfer of well data into Petrel and have the well status mapped to the correct well symbol in Petrel.
The solution that was agreed upon was, instead of providing custom mappings, the OpenWorks data connector was modified to optionally turn off the reference value service (RVS) handling of the BoreStatus, FlowDirection, FluidType, and ShowType attributes.
A new parameter, in the form of a toggle switch, was added to the Data Source configuration panel. If this option is checked, the OpenSpirit data connector will not use the reference value service (RVS) for the four status attributes. Instead, it will populate the OpenSpirit BoreStatus, FlowDirection, FluidType, and ShowType values with the Data Store's database value for Well Status (that attribute name varies per data store). In other words OpenSpirit will simply pass through the Well Status to the OpenSpirit BoreStatus, FattibutelowDirection, FluidType, and ShowType values which are then read by Petrel. (The default option will be to use the RVS mappings). Using this methodology a client would be able to add new custom status codes to their data store (e.g. OpenWorks, Studio, Kingdom, etc) and they would automatically be recognized by Petrel (providing the Petrel mappings were updated accordingly). NOTE: Enabling this option will likely prevent successful copying of well status information when using OpenSpirit Copy Manager to copy data from one data store type to a different data store type. Copying between dissimilar data store types usually requires well status information to be mapped from the source data store's well status values to the OpenSpirit well status values and then to the target data store's allowable values. Disabling this mapping may cause copied wells to have an UNKNOWN status. The skip option is typically used when importing well status information from a data store to an application such as Petrel. Select this option if you want to preserve the original well status value rather than using the OpenSpirit canonical well status values. Therefore it is recommended to have 2 data store configurations, one with the skip well status mappings option on and one with the skip well status mappings option off. Configuration
- Start the OpenSpirit Desktop.
- Configure a new OpenWorks R5000 data source by making a copy of an existing OpenWorks R5000 data source:
- In the new/copied Data Source configuration panel select the 'Skip well status mapping' checkbox near the bottom to turn on the new feature.
Setup
Basically with this enhancement OpenSpirit reads whatever is in the OpenWorks Current (Well) Status field and populating the Bore Status, Flow Direction, Fluid Type & Show Type fields. See example of data selector below:
Before this enhancement can be used with Petrel the OpenSpiritWellSymbolToWellType.xml file must be modified to include the desired custom well statuses from OpenWorks. This file is located in the following directory:
$PETREL_HOME\Extensions\TIBCO\OpenSpirit Adapter NN.N.N
Using your favorite XML editor, edit the OpenSpiritWellSymbolToWellType.xml to change the value for the four statuses (BoreStatus, FlowDirection, FluidType and ShowType) that will be mapped to the Petrel Well Type code number.
In the example below:
- WATER SUPPLY is mapped to well type 62
- DRY HOLE is mapped to well type 18
- OIL is mapped to well type 20