Importing Assay Results

Before you jump right in and import your assay results, I recommend that you read this page first on setting up your QA/QC : QA/QC Management

Also you need to have captured your samples to you assay or sampling table, so that the samples can be correctly matched to the interval on the borehole.


Importing Assay Results

Since laboratories report their assay results using a variety of formats, Visual Geobase uses a generalised import format which should be able to import any type of assay results, providing they are reported in columns containing the sample number and associated results.

Before you start!

Check that the sample number format you are using is the same as that reported by the lab, i.e if you have called your samples A1,A2,A3 etc, make sure that the lab has not called them A-1,A/2,A_3,A 1,1A as the results will no be matched with the correct sample interval.


Click File-Import-Assay Results


Select the laboratory assay results file (.CSV, .XLS or .XLSX)

The file will be imported and displayed in a datasheet.

You now need to select the following (select the cells with your mouse, and click the category button):

1. Result Column Headers (Green) - These are the data columns. These need to be mapped to the correct field in the table containing your sample intervals. At least 1 data column must be identified.

2. Sample Numbers (Red) - Sample numbers - check that the format is the same as the sample numbers in the sample interval table

3. Blanks (blue) - Laboratory blanks (if reported)

4. Standards (pink) - Laboratory standards (if reported)

5. Duplicates (pink) - Laboratory duplicates/replicates (if reported) . Note that if comparison graphs are to be created, the duplicate sample number and the original sample number need to be the same.

6. Assay Results Table - By default use AssayResults

7. Sampling Table - The table containing your borehole samples

8. Project

9. Batch number

Once all of these have been selected, click 'Import' and the data will be imported and matched against the samples, standards, blanks etc.


Assays are imported into the AssayResults table, and then matched with the corresponding interval or control sample. The import action is recorded for reference as well as the borehole or control name.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License