# Innova Data Bridge: Importing Schlumberger Data

## 1.0 - Introduction <a href="#toc206749753" id="toc206749753"></a>

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**.

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

## 2.0 – Prerequisite Requirements <a href="#toc206749754" id="toc206749754"></a>

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 <a href="#toc206749765" id="toc206749765"></a>

Before importing files via email, your email address must be authorized in Innova Vantage.

1. Log in to **Innova Vantage** using an **Admin** account
2. Click the **burger menu** (top left)

![](https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2Ffox6DxMFJp7MTbfDFXfH%2F3.png?alt=media)

3. Under **Database Admin Tools**, select **Data Bridge Settings**

<figure><img src="https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2FxV3AlvdJnsjVj4I2I5N2%2FPicture1.png?alt=media&#x26;token=cbde90f1-ce20-4424-9d25-be160e50ea91" alt=""><figcaption></figcaption></figure>

4. Add the email addresses you will send import files *from*
5. For each, select the relevant import type from the dropdown list

<figure><img src="https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2F0HsPud1KFMoZ959K4PNl%2FPicture2.png?alt=media&#x26;token=53e4525d-d7e1-428d-83f1-e6a7738ac45c" alt=""><figcaption></figcaption></figure>

If a file is sent *from an unregistered email address*, the import will fail.

## 4.0 – Schlumberger Data <a href="#toc206749760" id="toc206749760"></a>

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.

### 4.1 – Planning – Drill Plan Files <a href="#toc206749761" id="toc206749761"></a>

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 <a href="#toc206749762" id="toc206749762"></a>

Drill Plan files can be imported by simply sending them via email.

* Email the file to [ OrganizationName@feed.innova-drilling.com](mailto:%20OrganizationName@feed.innova-drilling.com)
  * Replace **OrganizationName** with your organization’s name as shown in Vantage.
  * To find this: Either ask your Innova representative, or open Vantage, click the burger menu, and check the organization name displayed under your email/login. You can copy and paste the organization name directly from there.

<figure><img src="https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2FQeY8k4jAYBgULjnhaFmz%2FPicture1.png?alt=media&#x26;token=1eb82615-bab2-40af-90a3-c1354124458b" alt=""><figcaption></figcaption></figure>

* Your email address must be registered in Innova Vantage (**see Section 3.0**)
* Email title must be: **Drill Plan - API: api#**
  * Add the word **Historical** if submitting a completed well e.g. *Drill Plan - API: api# Historical*
  * This will set the Well Status to Complete in Well Seeker
* Attach a single zipped file

<figure><img src="https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2FJYRFwOE0gEchfRr4wdgd%2FPic%204.png?alt=media&#x26;token=d8c7387e-3e60-4f38-8170-62a7753d1b10" alt="" width="563"><figcaption></figcaption></figure>

### 4.2 – Operations – Drill Ops Files <a href="#toc206749763" id="toc206749763"></a>

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 <a href="#toc206749764" id="toc206749764"></a>

1. Email all four unzipped files to [ OrganizationName@feed.innova-drilling.com](mailto:%20OrganizationName@feed.innova-drilling.com)
   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**)
4. The Drill Plan for the well must already be imported
5. Email title must be: **Drill Ops – API: api#** (api# must match the Drill Plan file)

<figure><img src="https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2FzYQzPshpvB9Y7MOOf0k2%2FPic%205.png?alt=media&#x26;token=6fad81b0-a422-4c84-ad9b-307d3d4d936b" alt="" width="563"><figcaption></figcaption></figure>

## 4.0 – Email Setup <a href="#toc206749765" id="toc206749765"></a>

Before importing files via email, your email address must be authorized in Innova Vantage.

1. Log in to **Innova Vantage** using an **Admin** account
2. Click the **burger menu** (top left)

![](https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2Ffox6DxMFJp7MTbfDFXfH%2F3.png?alt=media)

3. Under **Database Admin Tools**, select **Data Bridge Settings**

<figure><img src="https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2FxV3AlvdJnsjVj4I2I5N2%2FPicture1.png?alt=media&#x26;token=cbde90f1-ce20-4424-9d25-be160e50ea91" alt=""><figcaption></figcaption></figure>

4. Add the email addresses you will send import files *from*
5. For each, select the relevant import type from the dropdown list

<figure><img src="https://100379801-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-McEwHTOM_v4MexTVGSe%2Fuploads%2F0HsPud1KFMoZ959K4PNl%2FPicture2.png?alt=media&#x26;token=53e4525d-d7e1-428d-83f1-e6a7738ac45c" alt=""><figcaption></figcaption></figure>

If a file is sent *from an unregistered email address*, the import will fail.
