Importing interval data

  

New interval data can be brought into Petra either manually or by a tabular data import.

To add new intervals manually:
  1. Select a well in the Main Module.  
  2. Click on the Interval tab and then select an interval type to edit.
  3. Finally, select “Edit from in the upper right on the Interval tab.
    This brings up the Edit Interval Data window for the selected interval table.
  1. Enter values for the Top and Base.
  2. Select the button to add the interval.
  1. With the interval added, enter in the remaining interval details and select button to save the changes to the interval.
  1. Save the changes to the database, select OK.  

 All the edits to all intervals will be ignored if you select CANCEL.  

Importing tabular interval data

Main: Project > Import > Import tabular Interval Data

Tabular data where each row contains information about a discrete interval can be imported into Petra.

Before attempting to import interval data, verify that the data has a column dedicated to the UWI/API.  Since Petra assigns interval data to specific wells by comparing UW/API numbers, interval data without an identifying API/UWI column can't be imported.  The easiest way to remedy this is to simply open the interval data in a spreadsheet program, and add a new column for well UWI/API.

To import new digital interval data:
  1. From the main module menu bar click Project > Import > Import tabular Interval Data
  1. Select the “Open File” button and navigate to the interval data file location.
When the file is opened, Petra switches to the Data Format tab.  This links the entries in the file to specific kinds of data.  
  1. Select the interval data File Format:
    • Columnar
    • Comma Delimited
    • ~ Delimited.
  2. Establish field definitions.  Essentially this step defines which part of the file is which kind of interval data.  The easiest way is to select and highlight the specific data field in the “Data Record” part of the screen, then select the type of interval data on the left.  Petra can import fields for any interval table.  In order to put interval data with the correct well, the UWI or API # field must be defined.

When loading the TOP and BASE of the interval, Petra assumes that the depths are in MD.  To import other depths, such as SS or TVD, select the appropriate depth on the “Field is not a Depth or is MD” dropdown when establishing a field definition.

  • For user-defined fields (Not the TOP, BASE, DATE1, DATE2, QUALITY, FM NAME, UNITS fields), Petra can store a quality code. To import the quality code,  select the “Store Field Value” dropdown menu and set it to “Store Field Quality Code.”
  • To save the field definitions and options, select the “Save” button.  This option saves a *.FMI file.  Selecting the "Load" button restores all the saved settings.