Validate Imported Drillhole Tables

To access this screen:

Import drillhole data tables into Drillhole Importer and select the Validate tab.

This screen, part of the Drillhole Importer console, is used to:

Define drillhole data validation rules
Display validation errors, warnings and information for all the imported tables.
Correct errors in imported data and record the status of each correction.
If possible, automatically apply a "quick fix” for easily-resolvable errors.
Export a list of validation errors as a table.

Here's a list of validation errors and their associated statuses.

Errors are split up by table e.g. Collar, Survey and any other folder. These tabs match the folder names on the Import Tables screen. All tables within each folder validated as if they were one table. The numbers on the tabs tell you how many validations have been identified for each table. A star indicates if any of the outstanding validations (errors or warnings) still need to be resolved.

Validation settings are stored in the current scenario. When you export a scenario, these settings are also transferred to the destination system, ensuring a consistent validation approach between team members.

There are three ways to fix validation errors:

You can automatically fix validation errors, if possible, by applying rule-based 'quick fixes'. You can define these rules.
You can manually 'quick fix' a validation, that is, apply the current validation rule set to the selected error.
You can manually edit the table values of conflicting or erroneous values until they are suitable for desurveying.

Note: Drillhole Importer table columns can be dynamically resized.

By default, when you apply fixes, any previously listed errors (resolved by subsequent changes) remain in the grid, but appear in light grey with a "Resolved" status. You can toggle the display of fixed entries by checking or unchecking Show Committed Errors.

To define validation rules:

Complete the import of drillhole database tables.
Display the Validate screen.
Select Rules...

The Edit Rules screen displays.
Define the distance tolerance below which a collar is deemed to be a duplicate of another, using Collars - Duplicate collar location L<. Any collar within the stipulated distance (in a straight line in 3D space) will be considered duplicate and will be reported as a validation failure ("Duplicate Collar Location").
Decide how gaps between sample records are reported by defining what constitutes a gap. As above, this is a straight line distance threshold, below which a gap is deemed to have occurred. This is set using Downhole - Sample interval gaps >.
Report unexpected dip changes in the Surveys input file using Survey - Large dip curvature change >. Set the change of dip in degrees over (per) a nominated distance, e.g. a change of 15 degrees per 10 meters.
Similarly, choose what constitutes an unexpected change in bearing over a given distance using Survey - Large bearing curvature change >.
Click OK to update the validation rule set to be applied during the next validation run. This information is also saved with your project, so a project save is also advisable.

To perform initial validation on imported data tables:

Complete the import of drillhole database tables.
Display the Validate screen.
Define your validation rules (see "To define validation rules", above).
Click Validate.

For each imported table, validation results display.
If validation errors have occurred, they appear on the respective tab on the left of the screen.
Validation errors are categorised as errors, warnings or information. This is reflected in the Status column.
- Errors must be fixed before proceeding to the desurveying stage. Status displays as a red cross.
- Warnings should be reviewed and ideally fixed, but you can continue to desurveying, although unexpected output may occur. Status also displays as a red cross.
- Information is to alert you to a particular situation, but no action is required, or can be taken. Status displays as a an "i" symbol. An example of this could be where assay table contains a BHID with no downhole records.
- Resolved validation errors not yet committed to the loaded data objects (see below) are shown as a green tick.
The Record number indicates the data row at which the error was detected.
The BHID represents the unique drillhole identifier with which the error is associated.
A Validation description provides information about what has gone wrong. This could be "Duplicate collar location", "No Downhole Records" and so on. Text in green is for information only, but may highlight an area of concern. Orange text represents a warning, and red text is a fatal error that will prohibit desurveying later on.
The Action column describes the action to be taken when the next Commit is performed.
Select a validation error and resolve it.

The validation resolution table on the right updates to show the fields relevant to the validation failure. For example, if a duplicate collar position has been detected (which may be normal, say, for fan drilling), the XYZ fields of the duplicate holes, along with their BHID display. In this example, you could edit the coordinates displayed for each hole or choose to ignore one of the duplicates by unchecking Keep.
To automatically apply an obvious fix to the selected error, use Quick Fix. This will only be valid for certain types of validation failure. Quick-fixing will attempt to resolve the error according to the current validation rule constraints.
Review and resolve each validation error as appropriate until all errors on all tabs have been considered and, if required, data value edits performed.

Tip: Use Previous and Next to cycle through the errors displayed in each table.
To remove a previous data edit, use Undo to reinstate the drillhole data as it was last committed.
Click Commit to update the current drillhole data objects. This will not change physical files.