Import Data dialog box

This dialog box is commonly used when you import well data from a file. The main purpose of this dialog box is to assign column headers (by clicking the drop-down arrows) to your data, which brings this data into Harmony Enterprise.

Toolbar

This dialog box has these buttons on its toolbar:

Options — opens the Import Options pane.
Separate (Production data only with multiple wells in one file; not applicable to attributes) — if you specify a Well Identifier for your first column and click Separate, multiple wells in the same file are listed as tabs, which divides the single import file into multiple entities for import.
Apply To — applies the column headers you have set in one worksheet to all of the other worksheet tabs in the spreadsheet file. The single import file generates multiple entities for importing, with each one named according to the original worksheet name.

Context menu

Right-clicking any of the headers lists these options:

Remove Title — reverts this column to the initial “Not Selected” state.
Remove All Titles — reverts all columns to the initial “Not Selected” state.
Filter Values — prevents the import of a specified value for that column.
Combine Date / Time — takes a date column and a time column and combines them into a single column before importing.

Import Options pane

This pane opens when you click the Options button.

You can change import options, including the standard operating conditions of the file to be imported, and the configuration of the unit list.

Rows

(You can also right-click rows to set this range.)

Start Import from row — set the first row number in the table that you want to import.
End Import at row — set the last row number in the table that you want to import.

Template

Save format for this file while importing — saves your column and row mapping for this file.
Save current format as default while importing — saves your column and row mapping as the default setting for other files.
Remove default format (if it exists) while importing — resets your settings, so you can remap columns and rows.
Save current format as — saves your current mapping as a template.
Saved Formats — select the saved formats you want to apply or delete.
Multi-level unit picker — when selected, the column-mapping menus display the menu items horizontally in multiple columns, instead of the default setting of a single vertical column.
Continuous time track — this option is selected by default for cumulative time. If you deselect this option, gaps in your order, as determined by irregularities in the data sampling interval, are interpreted as shut-ins. For additional information, see continuous time track.
Sample interval for Date / Time matching — we recommend keeping the default setting. This option specifies the interval for comparisons. For example, every 50 rows a comparison is performed on the date / time column to verify if the format is acceptable.
Date / Time Sensitivity Level — we recommend keeping the default setting. You can use the slider to specify how closely a format has to match. For example, a 100% setting means that the imported file has to match your format exactly.

Import Plot section

Data is plotted for a single well import, if you have a time column (x-axis) and appropriate data (y-axes). Note that the preview plot does not display data, if you are importing multiple wells in the same worksheet, or if you are importing attributes.