The article explains creating a Drillhole Database file (.DHDB) directly from a folder of .CSV or Excel files using a subscription tool. Users prepare Excel files referencing drillhole collar names, store them in one folder, and import various file types. The importer previews automatic assignments of data types, allows field mapping, and lets users configure output options before generating the .DHDB, which integrates all drillhole data for use in Origin software.
The traditional method of making a Drillhole Database file (.DHDB) involves importing your drilling data to create several .DAT files, then creating a .DHDB and manually mapping the related .DAT files to it. Subscription users will have access to a tool that creates a .DHDB directly from a selected folder of .CSV or .XLX files.
The main consideration for preparing your Excel files is ensuring that each file references a drillhole collar name in the collar file. Below we see a typical collar file and assay file:
All my Excel files with drillhole information are stored in one folder and I have multiple files here. You can use files stored in different locations, and use different combinations of .CSV/.TAB/.TXT/.XLSX/.XLSM/.XLSB/.XLS files to create your .DHDB.
The importer will give you a preview of how it has attempted to automatically assign Collar/Survey/Interval/Event designation for each file:
Then you can set the appropriate Hole ID/From/To fields for all the selected files by clicking through the panels on the left:
The final panel lets you choose where to create the .DHDB, give it a name, and select sorting options:
After hitting run, you can use you new .DHDB for all the drillhole functions in Origin! Here, I'm viewing the resulting database and each Excel file has been correctly combined:
Want to learn more?
Online Help Manuals - Click here for the latest version
Learning Management System - Click here to login or here to request access
Comments
0 comments
Please sign in to leave a comment.