Innova Data Bridge: Importing Schlumberger Data

1.0 - Introduction

To maximize the value of your operational data, all information must be stored in a single database using a consistent format.

As different service companies use different systems, this data often needs to be converted and re-entered manually - a time-consuming process.

To streamline this, Innova now supports importing planning and operational data exported from Schlumberger’s Drill Plan and Drill Ops.

Additional files/data can also be automatically imported into the Innova system:

• Survey updates

• Image files

This document explains how to import these files into the Innova Suite.

2.0 – Prerequisite Requirements

Before importing files, you must have:

• An Innova Server Database

• Access to Innova Vantage

• Login credentials to Innova Vantage which have Admin permissions

3.0 – Email Setup

Before files or data can be imported via email, the sender’s email address must first be authorised within Innova Vantage.

1. Log in to Innova Vantage using an Admin account

2. Click the burger menu (top left) and select Data Bridge

1. In the Settings tab, add the email addresses that will be sending the files/data to the Email column. When an email has been received by Data Bridge, a processing email will be sent to the Reply To email address, followed by a completion/failure email to the Reply To email address.

2. For each email address, select the relevant import types to be authorized from the dropdown list. Note, if the import type is SURVEY, CADENCE, WELLARCHITECT, COMPASSEDM, OPENWELLS – CASING TALLY, DRILLPLAN, or DRILLOPS ensure that the correct Survey Units are also selected.

Important: If a file/data is sent from an unregistered email address, or the actions have been set incorrectly, then the import will fail.

4.0 – Schlumberger Data

Schlumberger data is split into two types — planning and operations.

Important:

• Import the planning (Drill Plan) file first, otherwise the operational data import will fail.

• The API number must be entered in Drill Plan before the export file is created. This is required for any well that Drill Ops data will be imported into, as the API number is used as the common well identifier between Drill Plan and Drill Ops during the import process.

4.1 – Planning – Drill Plan Files

Drill Plan exports a zipped folder containing several files (various formats) with well planning data (locations, CRS, elevations, targets, plans, offsets).

4.1.1 – Importing a Drill Plan File

You can import a Drill Plan files in two ways:

Option 1 – Via Innova Vantage:

1. Go to the Dashboard page Wells tab.

2. Select Import > Drill Plan

1. Select the zipped file → click Import

Option 2 – Via Email:

1. Email the file to [e-mail]

2. Replace OrganizationName with your organization’s name as shown in Vantage.

   1. To find this: open Vantage, hover over the user profile icon, and check the organisation name displayed under your email/login.

1. Your email address must be registered in Innova Vantage (see Section 3.0: Email Setup)

2. Email title must be: Drill Plan - API: api#

   1. Wells will be pulled in with the Well Status set to Active.

   2. Add the word Historical if submitting a completed well e.g. Drill Plan - API: api# Historical

   3. Adding Historical, will set the Well Status to Complete in the Innova system

   4. Attach a single zipped file

4.2 – Operations – Drill Ops Files

Drill Ops exports multiple unzipped files:

• Daily Journal as .html

• Steering report as .csv

• BHA report as .csv

• Survey report as .csv

4.2.1 - Importing a Drill Ops File

It is only possible to import Drill Ops files via email:

1. Email all four unzipped files to [e-mail]

   1. You can add more than 4 files if you have them

2. Replace OrganizationName with your organization’s name as shown in Vantage.

3. Your email must be registered (see Section 3.0: Email Setup)

4. Before Drill Ops files can be imported, the corresponding Drill Plan file for the well must already have been imported.

5. Email title must be: Drill Ops – API: api# (api# must match the Drill Plan file)

5.0 – Surveys

Individual survey updates can be imported to a well. This is especially relevant when using the Innova Suite in a real time operations capacity.

1. Email sent to [e-mail]

2. Replace OrganizationName with your organization’s name as shown in Vantage.

   1. To find this: open Vantage, hover over the user profile icon, and check the organisation name displayed under your email/login.

   
3. Your email address must be registered (Section 3.0: Email Setup).

4. Email title must meet the following formatting criteria to be recognized as a survey email and successfully imported:

   1. Includes the Well name, EXACTLY as it appears in the Innova system.

   2. Includes the fields:

      1. MD:

      2. INC:

      3. AZI:

   3. As an example the below email title is acceptable as it fulfils the above criteria

      1. Note: The email title does not need to be in exactly the same format as below. As long as it contains the 4 key details in any order, then it should work.

FW: [EXTERNAL] Survey – Cerberus 14-28 - 3H (LH) - Lateral - SURVEY MD: 153' INC: 0.07° AZM: 350.66° TVD: 153.00' VS: 0.09' DLS: 0.05

6.0 – Image Files

Image files can be imported and assigned to specific BHAs.

1. Email sent to [e-mail]

2. Replace OrganizationName with your organization’s name as shown in Vantage.

   1. To find this: open Vantage, hover over the user profile icon, and check the organisation name displayed under your email/login.

   
3. Your email address must be registered (Section 3.0: Email Setup).

4. Email title must meet the following formatting criteria to be recognized as an image import email and be successfully imported:

   1. Includes the word Image

   2. Includes the fields:

      1. BHA:

      2. API:

   3. As an example the below email title is acceptable as it fulfils the above criteria

image api:1234567890 bha:4

1. Attach one or more unzipped image files.

7.0 – Updating Well Status to Complete

In addition to the automatic update of the well status when the word Historical is included in the email title, as explained above, a well status can also be updated to Complete if the email title contains the word Finals.

1. Email a file to [e-mail]

2. Replace OrganizationName with your organization’s name as shown in Vantage.

   1. To find this: Open Vantage, hover over the user profile icon, and check the organisation name displayed under your email/login.

1. Your email address must be registered in Innova Vantage (see Section 3.0: Email Setup)

2. Email title must meet the following formatting criteria to be recognized as a completed well:

   1. Includes the word Finals

   2. Includes the API #

      1. The API # needs to match an existing well in the Innova System.

   3. As an example, the below email title is acceptable as it fulfils the above criteria

Finals | 113001333 | Innova Natural Resources, LLC | H&P 426 | Cerberus 14-28 – 5H(AN) - Curve | API: 42301376880000