Importing Analytical Results

Create and modify import workflows for analytical results received from the laboratory, in order to ensure that your GIM Suite is the single source of truth across teams.

Who should attend?

Database managers who are responsible for maintaining a GIM Suite database to support the import of analytical results.
Users who want to learn how to create and configure an import object in GIM Suite desktop, so they can import analytical results into a GIM Suite database.

Learning Outcomes

1. Discuss the fundamental concepts of geological sampling.

Discuss the different types of geological samples and explain how they are created.
Describe the analytical results and despatch workflow.

2. Discuss how the Acquire Data Model (ADM) is designed to store analytical results and despatch data in a GIM Suite database.

Identify the compound definitions used to populate the analytical results and despatch tables.
Discuss the role of reference and meta tables in maintaining data integrity across the analytical results and despatch tables in a GIM Suite database.
Identify the data that must exist in a GIM Suite database before importing data from an analytical results file.
Explain how to populate the CHECKSAMPLE table for different types of check samples.
Discuss how the ADM manages analytical results for the QAQC approval process.

3. Discuss the key features of an import object in GIM Suite desktop, which is designed to import data from an analytical results file.

List the object’s sheets and the role they play in the import process.
Explain the relationship between the sheets and the Data Load Order (DLO).
Explain the subsystem smart functionality.
Discuss the Import Definition dialog and its role in the sheet creation process.
Explain the Dynamic Destination Field Template and its role in the sheet creation process.
Compare and contrast static, dynamic and working columns.

4. Create and configure an import object in GIM Suite desktop, so it can be used to import data from an analytical results file.

Demonstrate how to create an import object in GIM Suite desktop, so it can be used to import analytical results.
- Create the sheets that are required to populate a GIM Suite database.
- Assign the appropriate form definition to each sheet.
- Define the columns required for each sheet.
- Configure the object appropriately.

5. Use an import object in GIM Suite desktop to populate a GIM Suite database with data from an analytical results file.

Demonstrate how to use an import object to complete a test import of data from an analytical results file.
Demonstrate how to review an error report and resolve errors associated with a test import.
Demonstrate how to use an import object to complete a live import of data from an analytical results file.