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):
  1. 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. 
  2. Select to inform import that Ratios are present: Contained in the property row: { }
  3. Default Datums should read:
  1. Do not select the option to: Exclude columns with no data
  2. The format of Date-Time in the Excel file is not ambiguous:
  1. 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):
  1. 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. 
  1. 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):
  1. Select Indicators are present: Contained in the property row: [ ]
  2. Select Ratios are present: Contained in the property row: { }
  3. Default Datums should read:
  1. Do not select the option to: Exclude columns with no data
  2. The format of Date-Time in the Excel file is not ambiguous:
  1. 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):
  1. Load and apply the linking file provided below
  1. 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):
  1. Set the First and Last header row as: 1
  2. Select Units are present: Contained in the property row: < >
  3. Set the First data row as: 2
  4. Default Datums should read:
  1. 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):
  1. Load and apply the appropriate linking file
  1. 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.

 

© 2022 Integrated Geochemical Interpretation Ltd. All rights reserved.

search exit shift Show/Hide Sidebar Show/Hide Sidebar