Skip to main content

Validate and Process Drilling Data

Learn how to validate and process Drilling data in VRIFY Prepare so it is available for use in VRIFY Present.

Overview

Before Drilling data can be added to a 3D Slide in VRIFY Present, it must first pass validation and data quality checks in VRIFY Prepare.

Drilling data is organized into three subfolders. Drillholes require an additional field mapping step. Using the Field Mapper, you match the columns in your CSV files to the required fields in VRIFY Prepare. The Collar file must be mapped before all others. Drill Photos and Drilling Sections are published directly without validation.

Prepare and Upload Data

Tabular data includes required and recommended fields — see Drillholes: Required & Recommended Fields before uploading.

Upload and sort your files into the correct subfolders in Files before starting this workflow. See Upload Files to VRIFY.

Subfolder

Preferred Formats

Drillholes

.csv

Drill Photos

.png, .jpeg, .pdf, .GeoTIFF

Drilling Sections

.png, .jpeg, .pdf, .GeoTIFF

Step by Step Instructions

Drillholes

  1. Select Drilling from the left sidebar.

  2. Drag your files into the correct categories: Collar, Survey, Assays, Lithology, and Highlights:

    Categorize drilling data

  3. Drag the Collar file into the workspace first.

    • Note: VRIFY Prepare automatically adds Field Mapper and Data Quality steps to the workspace. The Collar file must be mapped, validated, and published before all other files. Once the Collar file is published, you can drag the remaining files into the workspace at once.

  4. Click the Field Mapper step to open the Step Details sidebar on the right.

    • Note: A preview of your CSV data will appear in the workspace.

  5. Map the required fields to the corresponding columns in your CSV:

    • Toggle Depth Unit between metres and feet as needed.

    • Project Name

    • Hole Name (ID)

    • Final Depth (m or ft)

    • X / Easting / Longitude

    • Y / Northing / Latitude

    • Z / Elevation (m or ft)

    • Azimuth

    • Dip

  6. Down Dip is Negative is checked by default. Uncheck if your data uses a different convention.

  7. To map additional columns, click Additional Columns.

  8. To save your field mapping as a template for other data files, click Presets, enter a name, and save.

  9. Click Map.

    • Note: A notification will appear confirming that mapping is running in the background.

Review Results and Publish

  1. Once all Field Mapper steps show Succeeded, click each step to review the results in the right sidebar.

    • Note: If issues are found, click the issue to filter the CSV preview in the workspace to only view the affected rows. Correct the data in your preferred software and re-upload the file, then repeat the mapping steps before publishing.

  2. Click the Data Quality step to open the right sidebar.

  3. If no issues are found, or only non-blocking issues are present, click Publish File.

    • Note: If you are updating existing Drilling data, a prompt will appear asking whether you want to update or replace the existing data. Updating is recommended. Use replace with caution as it will overwrite your existing data.

Confirm Data is Available in VRIFY Present

  1. After publishing, most files are available immediately with a status of Accepted. Large files can take an hour or more. See Understanding File Statuses.

  2. Once the file status shows Accepted, open a 3D Slide in edit mode in VRIFY Present and open the Add Objects & Assets panel. The data will appear under the corresponding folder.

Complete the same workflow for Surveys, Assays, Lithology, and Highlights.

You can include a Drill Photo with your Highlights data on a 3D Slide, along with a title and description. If you want to include an image, publish your Drill Photos before mapping and publishing Highlights data.

Drill Photos and Drilling Sections

  1. Select Drilling from the left sidebar.

  2. Drag the file into the workspace.

    • Note: VRIFY Prepare automatically adds a Submit step to the workspace.

  3. Click the Submit step to open the right sidebar.

  4. Click Submit All Files.

    • Note: A notification will appear confirming that processing is running in the background.

Confirm Data is Available in VRIFY Present

  1. After submitting, most files are available immediately with a status of Accepted. Large files can take an hour or more. See Understanding File Statuses.

  2. Once the file status shows Accepted, open a 3D Slide in edit mode in VRIFY Present and open the Add Objects & Assets panel. The data will appear under the corresponding folder.

Learn More

Still Have Questions?

Reach out to your dedicated VRIFY contact or email support@vrify.com for more information.

Related Articles
Did this answer your question?