Overview
This guide lists every field VRIFY accepts in the drilling CSV: collars, surveys, assays, highlights, and lithology.
Fields are split into two tiers:
Required: Core attributes VRIFY needs to validate, transform, and render your drillholes in 3D.
Recommended (Optional): Additional attributes that unlock spatial filtering, richer presentation tools, and compatibility with new features as they roll out.
Following these guidelines ensures smooth processing in VRIFY Explore and accurate 3D modelling in 3D Slides.
Note: Upload your drilling data as one master CSV per data type (such as Collar, Survey, or Assay). Each CSV should contain your complete dataset rather than creating separate files for individual holes or campaigns.
Required and Recommended Fields
Drill Collar
Field | Notes |
Required |
|
Hole Name (ID) | Unique hole identifier. Joins this CSV to all other drilling CSVs. |
Final Depth (m or ft) | End-of-hole depth. |
X / Easting / Longitude | Collar easting (or longitude if geographic CRS). |
Y / Northing / Latitude | Collar northing (or latitude if geographic CRS). |
Z / Elevation (m or ft) | Collar elevation. |
Project Name | Project this hole belongs to. |
Azimuth | Collar azimuth, degrees from north. |
Dip | Collar dip, degrees. |
Recommended |
|
Target Depth (m) |
|
Target |
|
Survey Type |
|
Hole Started |
|
Hole Finished |
|
Core Size |
|
Core Reduced (t/f) |
|
Reduced Depth (m) |
|
Reduced Size |
|
Casing Pulled (t/f) |
|
Casing Depth (m) |
|
Hole Status |
|
Hole Purpose |
|
Hole Type |
|
Re-logged (t/f) |
|
Re-assayed (t/f) |
|
Comments |
|
Sample Drill Collar CSV
In this example: fields highlighted in orange are required, fields highlighted in blue are recommended for filtering capabilities or display accuracy:
Drill Survey
Field | Notes |
Required |
|
Hole Name | Must match a Hole Name (ID) in the Drill Collar CSV. |
Depth (m or ft) | Downhole depth of the survey reading. |
Dip | Dip at this depth, degrees. |
Azimuth | Azimuth at this depth, degrees from North. |
Recommended |
|
Survey Date | Filter drillhole groups by date and type on a 3D Slide. |
Survey Type/Tool |
|
Correction Factor |
|
Accept Values (T/F) |
|
Magnetic Field |
|
Temperature (C) |
|
Comments |
|
Notes:
The survey correction factor is equivalent to magnetic declination. If your values already contain this correction then leave this field blank; the default value is 0.
A Corrected Azimuth is calculated in the backend master database using the Original Azimuth + Correction Factor.
Sample Drill Survey CSV
Drill Assay
Field | Notes |
Required |
|
Hole Name | Must match a Hole Name (ID) in the Drill Collar CSV. |
From (m or ft) | Start depth of the sampled interval, in metres or feet. |
To (m or ft) | End depth of the sampled interval, in metres or feet. |
Recommended |
|
Sample ID | Lab sample identifier. |
Sample Type | Drilling sample type. |
Parent Sample ID |
|
Has QC? (t/f) |
|
QC Type |
|
Control Type |
|
Comments |
|
Data Sources |
|
Lab ID Column |
|
Lab Certificate Date Column |
|
Lab Name |
|
Analytical results (assay values for the elements analyzed — Au_ppm, Cu_pct, etc.) are added as additional columns alongside the required fields.
Notes
All negative and lower detection limit (LDL) values will be converted using the following rules: if greater than -50 they will be changed to 1/2 the value (e.g. -5 becomes 2.5) and if smaller than -50 they will become null (e.g. -99 or -999 is now null).
If a single element column has more than one negative or LDL value then all the LDL values will be replaced with 1/2 the lowest LDL (e.g. Cu_ppm has <1, <0.5 and -2, all these will be replaced with 0.25).
All > values will be converted to the value without the > sign. So >10000 becomes 10000.
VRIFY uses calculated "Best" columns in our database and these are all in "ppm" units. In cases where there is more than one type of assay for an element, Best values will be calculated based on ranking the methods used for assay.
The default sample type is "UNKN".
From and To are required data. If Quality Control (QC) or Standards (STD) do not have intervals listed, fill them in if known, otherwise they will not be imported.
Sample Drill Assay CSV
The element columns here are examples only. Your database may have more or less values and with different units:
Drill Highlights
Field | Notes |
Required |
|
Hole Name | Must match a Hole Name (ID) in the Drill Collar CSV. |
From (m or ft) | Start depth of the sampled interval, in metres or feet. |
To (m or ft) | End depth of the sampled interval, in metres or feet. |
Interval (m or ft) | Length of the highlighted interval, in metres or feet. |
Highlight Label Header | Highlight title to display in Present. To display the Hole Name/ID in the label, enter it here (Hole Name is only used for data linking). |
Recommended |
|
Highlight Label Body | Secondary label description displayed in Present below the Highlight Label Header. |
Image File Name |
|
Comments |
|
Target Zone |
|
Notes
The image file name must match the actual image file provided exactly.
Images are uploaded into a separate folder in the File Uploader and will be accessible in 3D Present using the image file name column.
Sample Drill Highlight CSV
Drill Highlight Label Visualization in VRIFY Present
Drill Lithology
Field | Notes |
Required |
|
Hole Name | Must match a Hole Name (ID) in the Drill Collar CSV. |
From (m or ft) | Start depth of the lithology interval, in metres or feet. |
To (m or ft) | End depth of the lithology interval, in metres or feet. |
Primary Lithology | Lithology code or label for the interval. |
Recommended |
|
Primary Lithology Modifier |
|
Primary Lithology Percent |
|
Secondary Lithology |
|
Secondary Lithology Modifier |
|
Secondary Lithology Percent |
|
Comments |
|
Sample Drill Lithology CSV
Additional Notes
Drilling-related supporting files (e.g. core photos, scanned logs, vertical sections) are accepted as PNG, JPEG, PDF, or GeoTIFF.
Associate each file to a hole using the Hole Name in the file name or via the metadata fields in the uploader.
Learn More
Still Have Questions?
If your data doesn't fit cleanly into the categories above, or if a file fails validation, get in touch before reformatting anything. VRIFY has ingested data from every major mining software ecosystem and can review your raw exports to confirm the best way to package them for upload.
Reach out to your dedicated VRIFY contact or email support@vrify.com.