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 an acQuire 4 database to support the import of analytical results.
- General users who want to learn how to create and configure an acQuire 4 import object so they can import analytical results into an acQuire 4 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 an acQuire 4 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 an acQuire 4 database.
- Identify the data that must exist in an acQuire 4 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 acQuire 4 import object that 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 acQuire 4 import object so it can be used to import data from an analytical results file.
- Demonstrate how to create an acQuire 4 import object so it can be used to import analytical results.
- Create the sheets that are required to populate an acQuire 4 database.
- Assign the appropriate form definition to each sheet.
- Define the columns required for each sheet.
- Configure the object appropriately.
5. Use an acQuire 4 import object to populate an acQuire 4 database with data from an analytical results file.
- Demonstrate how to use an acQuire 4 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 acQuire 4 import object to complete a live import of data from an analytical results file.
You can participate in this unit at one of these upcoming courses:
Code
205
Duration
2 days
Medium
Face-to-face 
Virtual Classroom Prerequisites
