Import from APT-IGI Excel File

Importing APT generated, IGI ready, Excel files

IGI has been working with APT to produce an import-friendly, flat format, Excel file. The information here is intended to assist users who receive geochemical data from APT provided in this Excel file format.

The notes provided below assist users to import their data from these files. Follow the notes which relate to the version of Metis Transform / p:IGI+ you have access to:

How to import APT generated, IGI ready, Excel files (Version 2.1)

Drag and drop the APT provided, IGI ready, Excel file onto the p:IGI+ (or Transform) workspace to start the import.

In the first stage of import (steps to allow the linking template to work):

The import table detector should automatically identify the presence of Indicators and Units contained in the property row: [x] & <x> respectively. If not then check the appropriate header component boxes.
Select to inform import that Ratios are present: Contained in the property row: { }
Default Datums should read:

Mean Sea Level
Drillers Reference
Drillers Reference

Do not select the option to: Exclude columns with no data
The format of Date-Time in the Excel file is not ambiguous:

No action is required here - the default can remain

Click Next to proceed to the property linking stage of import.

In the second stage of import (steps to link properties using a linking template):

Review the property links. With the adoption of IGI's property naming convention in the APT supplied export Excel file, there should not be any linking issues. If you discover any issues with regards to linking APT files then please contact us via support@igiltd.com.

Click Import

How to import APT generated, IGI ready, Excel files (Version 2.0)

Drag and drop the APT provided, IGI ready, Excel file onto the p:IGI+ (or Transform) workspace to start the import.

In the first stage of import (steps to allow the linking template to work):

Select Indicators are present: Contained in the property row: [ ]
Select Ratios are present: Contained in the property row: { }
Default Datums should read:

Mean Sea Level
Drillers Reference
Drillers Reference

Do not select the option to: Exclude columns with no data
The format of Date-Time in the Excel file is not ambiguous:

No action is required here - the default can remain

Click Next to proceed to the property linking stage of import.

In the second stage of import (steps to link properties using a linking template):

Load and apply the linking file provided below

APT_IGI_linking_Version2+.pigi_lnk (unzip to use)

Click Import

Post import project edit:

SARA Fractionation:

During import, the automatic calculations assume 100% of the extract/asphaltene precipitated sample is used during the respective SARA or SAR fractionation process. This is not always the case in APT’s practices. As a result, there might be a reason to manually copy and paste the sample weight data into the Sam Wt.SARA-Wt, Sam Wt.SARA-Un or Sam Wt.SAR-Wt properties post-import.

How to import APT generated, IGI ready, Excel files (Version 1.28.7)

Drag and drop the APT provided, IGI ready, Excel file onto the p:IGI+ (or Transform) workspace to start the import.

On the first stage of import (steps to allow the linking template to work):

Set the First and Last header row as: 1
Select Units are present: Contained in the property row: < >
Set the First data row as: 2
Default Datums should read:

Mean Sea Level
Drillers Reference
Drillers Reference

Click Next to proceed to the property linking stage of import.

On the second stage of import (steps to link properties using a linking template):

Load and apply the appropriate linking file

APT_IGI_linking_Version1_28.pigi_lnk (unzip to use)

Click Import

Post import project edit:

SARA Fractionation: