Import Wells

Introduction

Import Wells allows user to load a well in tabular formats (csv, xls, xlsx) formats into AFA. Wells don ot have to be imported, AFA can connect to a database.

STEP 1: Selecting Import Wells from the Main Menu

This command import well data from individual CSV or Excel file(s), where each file represents a single well or one file^{Note 1} may have a number of wells. It also support the simultaneous import of multiple files. The Excel files are

• xls file - Microsoft Excel 97-2003 worksheet

• xlsx file - Microsoft Excel Open XML Format Spreadsheet file

To import a well or a group of wells, select File > Import > Wells

STEP 2: Select Either a Single Well File of Multi-Well File

Now choose between the following two options.

	The well name will be the file name. Each file is a separate well.
	Select a single file, that contains a column that indicates the well name

The file explorer will now open.

STEP 3: Choosing the Various Options

The importer will:

• Map the columns of each file to corresponding fields, specifying units where applicable.

• Automatically populate column mappings if they match recognized fields. Identify and autofill standard date formats.

Referring to the image below:

1. This is a preview of all the data and columns within the csv or excel, and shows the column headers and the first 3 to 4 rows.

2. If not in the file, a fluid (AFA Well Type) must be specified. AFA will try and identify it automatically, but user might have to specify the dominate fluid (although all phases are imported for any kind of analysis).

   1. The “Field” column is a drop-down box of all the physical properties that may be linked to the file columns.

   2. The “Unit“ column allows the user to pick the appropriate unit. For example

      1. The .csv column “Oil” can be matched to the AFA variable “Oil Volume “

      2. The unit for Oil volume was selected by the user to be “bbl/d“

3. More than one variable can be imported. For example, and with different units

   1. The .csv column “Water“ is also imported as “Water Volume“

   2. The unit for Water Volume was chosen to be m3/d (metric) by the user.

4. The file name will represent the well name in the AFA platform. In this example, this will be Blue_Rock_1H

5. When the user is satisfied with there selection(s), they can hit the “Submit” button.

Minimum Data Requirements

For AFA to work, the importer requires

1. at least one data/time column must be imported

2. at least one fluid (oil, gas, or water) production column.

3. AFA-well type must also be selected, otherwise the importer will not proceed

or the following error message

Overriding Existing Wells

During the import, if there are wells with the same name already exists, it will ask if you wish to overwrite the file

Confirmation of Successful Import

Once all files are successfully imported, it will confirm with

Previewing a Wells Data

Once imported, you can preview the well. In this example, the user filtered a well based on an associated TAG (Producing Formation = THREE FORKS.) The result was well “330610000”

1. Select the Filter option

2. Select the user defined Tag - Reservoir and then THREE FORKS

3. Click on the three dots to the right of “330610000“, the Preview Well option will pop up. Now click on it to Preview the well and you will see all the imported data

Note:

1. Functionality is scheduled for 2.6 release

See Also:

Removing a Well from a Project