Importing Bulk Well Data

In addition to importing traces, checkshots, deviations and markers individually, all well data (OWX or ASC format) can be bulk imported into Insight.

Insight will search for wells with a matching UWI in the project and update them. If no matching UWI is found, then new wells can be created from the imported well data.

Importing well data

Import well
  1. In the Control Panel, select the Import menu.
  2. Click Well Data...
  3. Select the file format to import.
  1. When selecting LAS format, choose either UWI or API as the unique identifier.
  1. For other formats, a warning window will appear if there are wells in the database with no UWI or with duplicate UWI.
  2. Clicking OK will automatically resolve issues by applying a generic fix:
    1. For wells in the database with no UWI: Insight will apply a generic name ‘DUG’ followed by a random alphanumeric value appended to the well name to be used as the UWI
    2. For wells in the database with duplicated UWI: Insight will apply a generic name DUP followed by a random alphanumeric value appended to existing UWI to be used as the new UWI
  3. Clicking Cancel will not apply the generic fix but will allow you to manually fix wells via Insight control panel or in the well manager tool

Note: Due to changes in well identification in Insight  4.9, all wells in Insight must have a truly unique UWI. Importing of well data is permitted if there are any well in the database with no UWI or with duplicated UWI.

  1. In the Import Wells window, select the OWX or ASC file and click Open.

Importing OWX file

Note: ONLY UWI is used to match the well in the file to the well in the project for update. This applies to both OWX and ASCII files.

  1. In the following drop-down boxes, select Update/Skip existing wells and/or Add/Skip new wells.
  2. Insight will read the well data file and allow you to choose which data to import. 
  3. Select the checkboxes under Import. If the well file does not include a particular data, the check box will be greyed out.
    • Markers - Duplicate markers MUST HAVE suffix _1, _2, _3, etc... added during bulk import.
    • Curves
    • Checkshot
    • Well Paths (from inclination/azimuth)
    • Well Paths (from relative X/Y)
  4. In the Units and Datums section, select the units and datums for MD and TVD. You will not be able to proceed until the units have been specified.
  5. Under the Checkshot Settings section, define the Depth Mode and Time units. This is particularly important when transferring data between software (Insight works in ms).
  6. Finally, select the Offset Type relative to the previous point or to the surface location.
  7. Click OK.
  8. The Coordinate Reference System conversion window will be displayed.
  9. Select the Types of Coordinates and convert the CSR if required (see Converting CRS When Importing a Well).
  10. Click OK.

Importing ASCII file

Importing ASCII file

When importing ASCII files (.dat or .csv) the user must configure import parameters separately.

  1. At the Import menu, select the data type the file represents.
  2. Click on the spanner icon to configure import parameters.
  3. Click Separated by delimiter and select the delimiter value from the dropdown box.
  4. At the column headers, click the drop-down box and select the header.
  5.  Select the necessary Depth Datum and Depth Unit if using elevation or depth column headers.
  6. The error icon will turn green when there are no more errors.
  7. Click OK to import the well.

Manually set column headers

  1. In the Import window, select the Fixed width button.
  2. Adjust the column width to the preferred size; OR
  3. Click the Use mouse adjuster link to set the column width via the mouse arrow.
  4. In the Original tab, place the mouse arrow on a divider and drag left/right to the correct column width.
  5. Click the Parsed tabto see the result after adjusting the column width.
    • If the result is incorrect, return to the Original tab again and make the necessary adjustment.
  6. At the column headers, click the drop-down box and select the correct header. When there are no more errors, the icon at the bottom will turn green.
  7. Click OK to import the well.

Importing LAS file

  1. At the Import Wells window, select the LAS file.
  2. The Import: Configure LAS depth curve window displays a table containing the imported well(s).
  3. Select values from dropdown menus for Depth Curve, Type, Datum and Unit.
  4. The error icon will turn green when there are no more errors.
  5. Click OK to import the well.

Well Data Import Summary

  1. The Well data import summary window will appear to show:
    • any problems with the import.
    • tabled information of well added successfully
    • tabled information on well updated successfully. 
  2. Click the Export Table button to export this table as a tab-separated value (.tsv) file.
  3. Check the Details Panel of the well for more information on the warnings.