A man is to suffice his salary rather than salary to suffice the man.
|Longitudinal faults||Cross-sectional fault||Terrain isolines ACAD||Terrain strings DM||Drillhole database|
|Datamine 3D Holes|
|1)||If anything you do works, continue doing it.|
|2)||If anything you do does not work, stop doing it.|
|3)||If you are not sure what to do, do nothing.|
Select the digital key and copy it to the clipboard. It comes in e-mail text, ASCII, *.txt or any other text file.
Go to Start | All Programs | Datamine | Licence Services | Licence Manager
Wait for the License Manager to open. Press F1 to bring up the Register New Key dialogue. Most likely you will see the key pasted in the window cell appeared. This happens if your machine clipboard contains the key. If the cell is blank, that is the clipboard is empty, copy the code from Notepad and paste it into the space provided and press OK.
Launch Studio 3 either clicking it's icon on the desk top, or choose Start | Programs | Datamine | Studio 3
Select Create Project to open Studio Project Wizard
Press Next > to open Project Properties
While you pick up a new name for the project in the Name cell, it's name changes in the Location cell, too, as you type it in the Name cell. Project file name may depend on your mining project name, it can also take your favourate car model or pet's name, etc. We leave the default name for it since we have no special preferences yet. You may press Next > with Create Extended precision project ticked off, should you go further with no changes to Project Settings. But for now, just make sure Create Extended precision project and Automatically add files currently in this directory when the Next > is clicked are ticked off and press Project Settings... button to change Project Settings
Tick off the boxes as highlighted on screen shot. By doing this you will make sure the files are added to the project automatically. We will discuss later what it means. For now, press O'K to return back to the Project Properties
Tick off Create Extended precision project again (it comes out blank after you choose to change Project Settings in previous steps), and press Next >
We have no files yet to add to the project in the Project Files window. For this moment, just press Next >
You will see a Design Window. By default it is set with black background.
By default, Studio 3 displays the following window tabs: Start, Design, Visualizer, Files, Plots, VR. You can activate a window by pressing on the tab. If you axidentally closed any of the windows or want to display additional windows, go Views | Windows , and select from the menu.
Now press the Start tab. Click either on the Current Profile or Select images in the Getting Started section.
By default, Studio 3 offers Profile 1. But you can scroll down and pick up any of the profiles you feel more comfortable with and press Load.
In project session, Datamine files are variably devided into 2 categories: internal and external. If a file is added to a project, it is considered internal. Certain manipulations in Studio 3 require files to be added into the project before performing calculations or operations. Any datamine file, which is not added into the project is considered external. Technically there is no difference between the files. One and the same file may be external for one project and internal for the other.
In this tutorial we will use the following types of Datamine files:
In Studio 3 the term
external file is rerserved for Datamine files. From Studio 3 point of view,
CAD or TXT file being
imported, manipulated, or exported, can not be considered internal or external. If you have not yet downloaded
sample files, go to sample files section to download them, or else
download a single sample file,
a wireframe of a tectonic faults, used in this exercise.
Un-RAR it within the directory it is saved on you hard disk (should be C:\\Downloads)
To import it into Design window as an external file, go to
Instrument panel, Data | Load | External Datamine File | Wireframes
Browse for the file tm_quartz_fault_wfTR.dm on you hard disk, select it and press Open.
In the next window select tm_quartz_fault_wfPT.dm and press Open
Press OK in the next window. A wireframe file of a tectonic fault will appear in Design window
|Once you have Studio 3 installed on your machine, you would already have Datamine official training files available on your hard disk before you start the program first time. However in this training course I will be using files I had made while working on a TUXMANNEWK project near Broken Arrow, CUSIANA, CASANARE, COLOMBIA.|
Click on the image below to view high resolution vintage map.
IT IS TO BE REGRETTED THAT VISUALISER WINDOW IS OBSOLETE IN STUDIO RM.
While in Design window, type uv, the abbreviation for Update Visualizer, to activate Visualizer window. Rightclick on the Visualizer window and pick up the options to change view angle, rotate, perspective, etc.
Users of STUDIO RM can still use the uv (Update Visualizer) key combination in Design Window
to update current view in 3D Window.
Press Design tab to return to Design Window. Depending on the coordinates of the view point, the file loaded in Design window may not fit into the screen area and not appear immediately. Or when you unload a file, it still might look present on the Design window, though absent in memory. In this case type rd to redraw the screen.
Regeneration of the screen is common procedure in CAD systems. Some of them, like AutoCAD, have, if engaged, a function of automatic regeneration of the screen to clean it up from the traces left by removed or unloaded objects. In Datamine Studio 3 you can use manual regeneration only.
You can change view angle interactively right in the Design window by holding Shift key and moving the pointer around with left button on (Shift+Left Button). Remember, you are not rotating the object. You are just moving the view point around.
To return to plan view, type 1 and click on the window anywhere within the empty area and select Plan from the menu. Press OK
You can change the view plane in Design window by picking up options from the Set Viewplane menu after selecting View | Set Viewplane.
By default, Studio 3 creates Database folder on disk C:, C:\Database. As mentioned above, when creating
a new project, the program also offers you to save it in a Project folder in Database folder. In a project folder
it is recommended
to create CAD folder for supported vector drawing formats (
*.dwg, *.dxf, etc.) other than
ODBC folder for
Excel, Access, text and CSV files. Studio 3 session file
files are kept directly
in the project folder.
If you have not yet downloaded
sample files, go to sample files section to download them, or else
download RAR file either by
clicking here or on the picture below.
The file contains digitized isolines of a mine site terrain map. Un-RAR it into
We will add previously downloaded AutoCAD file to the project. It is important to categorize the file
based on the type of objects included in it -- poitns, strings, or wireframes. This time the objects are strings.
It does not matter where the CAD file is located -- in CAD folder of your project, somewhere else on
the hard disk, or on the memory card. By
Adding To Project you create Datamine
files out of CAD files -- In Design window go to Menu bar > File | Add To Project | Imported From Data Source....
In Import Data window, Driver Category pick CAD, pick AutoCAD(strings) in Data Type. Press OK
In the Open Source File window locate and select the desired file an press Open
In the Read drawing file tick off Load All Layers to view the AutaCAD layers you would want to use. This time we use all of them. Press OK
Tick off Table file box and leave Point file and String file boxes intact. If you do not want to keep Autocad file name for your Datamine files, you should enter a new one in Base file name field. Press OK.
Two new Datamine files are created in your project folder -- string file and point file. They share names with the same root, but different ending -- ST for strings file and PT for points file.
If you have not yet downloaded sample files, go to sample files section to download them, or else download a single sample file, compressed file of digitized isolines in *.dm format. Remember, Datamine creates 2 files of sting objects -- point and string file. Unpack the RAR file. Go to Instrument panel, File | Add to Project | Existing files...
Select _tuxmanook_topoST file and click Open.
The file will be added to the Project. You can check its availability in the Project Files tab on the left of the Design window.
Computer program makes what we tell it to do, and not what we would like to be done.
To remove files from Studio 3 seeion, go to Data | Unload | Select
Select file to be unloaded and press OK. The file will be unloaded from the session only, but will remain in the project files list had it been added there previously .
Project Files tab lists all the Datamine files added to the project.
Rightclick a file in the Project Files tab to initiate a context menu and choose one of the options.
You can download a file into Design window by draging and dropping it from the Project Files tab into the window.
Note that if you pick Delete option, the file will be deleted from you hard disk entirely -- that is you will not find it in the Recycle Bin.
Remove From Project option removes the file from current project thus changing the file status from
external, but the file is retained on your hard disk.
Sheets tab lists files of objects, loaded into the windows. You can hide or display the objects by ticking on or off the boxes. Objects with boxes ticked off will hide from the window, but remain in the session and could be displayed on demand.
You will need to regenerate your screen by pressing rd to view changes.
Loaded Data tab displays loaded files and attributes they hold.
Very often you will need to export Datamine files you created in Studio 3 session into other CAD system to share your work with other individuals or groups which may not necessarily use Studio 3 in their work, such as surveyors, geotechnical or civil engineers, etc. The most popular file exchange format is DWG and DXF (drawing exchange format) by Autodesk. DXF can be imported in any CAD platform.
In design window, go to Data | Export
Select the object you created in Design window from the list in the Object to Export window and press O'K
By default, Studio 3 selects CAD in Driver Category, but you can pick up other platforms if needed. Press O'K.
In Save in: box, go to CAD folder in your project directory C:\Database\ProjectName\CAD. Fill in File name: box and press Save.
WHEN YOU SAVE SOMETHING ON YOU COMPUTER HARD DISK, DO NOT FORGET WHERE YOU SAVE IT.
You can preview Datamine files directly from the Windows Explorer without opening Studio 3 session. Rightclick the file, choose Preview
Datamine Table Preview program opens. You can manipulate with the view point by holding left button on and dragging the mouse. Rightclick opens a context menu, where you can choose additional visualisation options. You can not modify or save objects in Table Preview
Datamine Studio 3 is a typical Windows praphics program that makes use of menus, toolbatrs, panels and paletts. However, every program has its own peculiarities you have to remember. To make sure you mastered the procedures you learnt, it is recommended for you to follow the exercises at the end of each chapter.
Information about the ore body geometry has been obtained from the drillhole data analyses. The sketch below shows what we will be modeling.
Studio RM offers an advanced automated method of ore body wireframe construction, especially useful for narrow vein wireframe modelling. However it does not give straightforward results and need further adjustment, which requires betters skills. Therefore at this stage the tutorial will go through traditional string modeling, which is applicable for any kind of ore body geometry.
Another view of narrow vein wireframe model and underground channel sample files as 3d holes.
With the rotated model functionality one can successfully build a block model within the narrow vein closed wireframe model no matter the vein thickness. On the picture below the vein is 30 cm thick.
View or download detailed instructions of creating Excel database for drill hole modelling. Though it is not mandatory to learn them for the moment.
Excel drill hole database file tm_drilloles.xls will be used for creating Datamine drill hole file. You can click on the file name to download it if you did not do it before. As you can see on the picture below, there are 4 sheels in the file: Collars, Surveys, Assays, Zones.
These 4 spreadsheets will be used for creating Datamine drillhole table files. For Collars file, Go to File | Add to Project | Create From Datasource
In the Data Import dialog box, select ODBC as the Driver Category and Tables in Data Type and press OK
In the Select Data Source dialog box go to Machine Data Source, and select Excel Files and press OK
If the Excel Machine Data Source does not work on you your machine, you will receive a Microsoft warning. With Studio 3, this happens on the minority of the machines and mainly is created by your MS Office configuration. Press New in the Select Data Source dialog and follow instruction of building a new Excel based data source. For more details, go to ODBC Driver Setup For Studio 3 / Studio RM section
In the Select Workbook dialog navigate to the project directory and Excel file location and click tm_drillholes.xls in the Database Name list. Press OK.
In the Table Selection dialog box make sure the System box is ticked on, then check 'Collars$' box and press OK
In the Tables dialog box leave all the boxes checked and press OK
In the Import Files dialog box Datamine creates default name (collars$) with a $ sign at the end as an indication of a supplementary table file to the drill hole creation process. You may change the name as you would need it if you have more than one collar file in the project, but always retain the dollar sign. At this stage leave everything intact, press OK
Repeat the same steps for creating surveys$, assays$, and zones$ files, but checking corresponding boxes in the Table Selection dialog. In the end you will have 4 supplementary files for creating drill hole file using HOLES3D command.
Wnen working on Assays data, make sure the meaningfull fields are checked on the Tables Dialog, and tick off the check boxes which might accasionally be highlihted by your system.
You will have four *$.dm files in you Project folder.
The process is called Desurveying of drillhole data tables (Collars, Surveys, Assays, Zones) to create 3d static drillholes. Use HOLES3D in the Command Line at the bottom of the User Interface: an entry box with white field preceeded with !>>> indicator . The letter case does not matter, you can enter hoLes3D or HoleS3d with the same result, but if you come across with the command in capital letters in this manual or in the Datamine Product Help, it is a convention to type it into the Command Line. (Commands outside the Command Line in the Design Window are described in the lowercase). Type HOLES3D (remember not to pay attention to the letter case, upper case is just in the tutor to indicate you must type in the Command Line) and press Enter.
Use selection buttons to the right of the HOLES3D dialog to select corresponting drillhole tables in the Input Files section and type a drillhole file name in the Output Files section. You can type in a table file name in HOLESMRY and ERRORS fields and the program will save the info about the data summary and errors if present. The latter is especially useful for locating either data entry errors, or downhole survey errors and other mistakes in field logging. Press OK.
Congratulations! You have only just created a 3D static drillhole file!
The Project Files list is updated with the drillhole file.
Studio RM is a revolutionary step forward in the Studio series. Thought the developers did not include Design window into the start up configuration, but could not get rid of it because even the Product Help informs you that for some of the operations Design Window is mandatory. It is also easier and faster to work in Design window.
I prefer working in Design Window. Luckily, the developers still allow you to return the Design view back on the UI. But you will have to do it on every new session.
Right-click (R-click) at any spot on the side bar, select Windows > Design.
I hope next generations of Studio RM will have Design window by default
The procedure for creating Datamine table files (*$.dm) in Studio RM differs from Studio 3. Here I will show how to make Collar$.dm file. Also, standard Excel data driver may not be configured for Studio RM, so you will also have to configure the new Excel data source driver.
Go to Main Toolbar, Data | External | Other.
in Data Import dialog box select ODBC in Driver Category and Tables in Data Type as you did for Studio 3.
In the Select Data Source dialog box go to Machine Data Source, and select Excel Files and press OK
If you get error message:
Press OK and close the next dialog. Repeat Data | External | Other, then in the Data Import dialog box select ODBC in Driver Category and Tables in Data Type. Instead of selecting Excel, press New.
Press Next in the Create New Data Source dialog.
Select Microsoft Excel Driver and click Next.
Click Finish in the following dialog.
Enter any name in the Data Source Name field (for example Studio RM) and press OK.
You will be returned back to the Select Data Source dialog with the updated list of ODBC drivers. Select StudioRM database driver you've just created, and click here on Select Workbook. to follow correspoinding instructions.
The rest of the procedures for creating drillhole table files (collars$, surveys$, assays$, zones$) are the same in Studio 3 and Studio RM with one important exception:
Unlike Studio3, Studio RM does not automatically save drillhole table files (*$.dm). These files are kept in the memory untill you turn off the session. Therefore, make sure you save them in your project folder before closing the program.
To save collars$.dm, go to Main Toolbar, Data | Export | External
Select Collars$, press OK.
Browse to your project directory and save it as collarsrm$.dm to distinguish the file from the one you created in Studio 3 session (if you use both programs). Press OK.
Go back to Main Toolbar and create surveys$, assays$, and zones$ files and save them to the project. Refer to Desurveying Drill Holes section of this manual to create 3d drillholes in Studio RM with HOLES3D command.
Drillholes made with desurveying process are called Static. Another type of Datamine drillholes is Dynamic. You do static holes first, then dynamic holes out of static ones (if needed). But before I show you the procedure, you should understand the difference. To my opinion, the necessity of dynamic holes depends on the accuracy of downhole survey in the field.
Many experienced Datamine users, even those self-decorated with notorious AusIMM note at the bottom of every e-mail, may not know what is static hole and what is dynamic. I’ve met with the one in 2008. 10 years later he still did not know what I was talking about.
Dynamic drillholes inhabit only the Design Window current session. You can not find them in the Project File or in the Files Window. But you can rebuild static drillholes which inherit properties of dynamic drillholes.
Drillhole trace is not a straight line. Rather, it is a compound curve because drill bit penetrates layers with different physical characteristics, which coupled with drill rod rotation efforts make the drill bit diverge from the straight line. When a field surveyor makes a downhole survey of the drill bit penetration into the ground, he writes down sample intervals dip angle and dip direction. Studio 3/RM algorithm of HOLES3D command calculates location of midpoints and builds 3d drillholes and locates them on the imaginary drillhole curve. Since the sample interval is a straight line, placing the centre point on the curve of the trace automatically means end points are out. But how much should they be out? If the downhole survey is both accurate and precize, you do not need to worry about it as much as the gap between sample ends is not noticeable. But downhole survey equipment and human errors in the field can do a significant impact on the issue making the drilhole samples look like the ones I draw or even worse! Probably this is the point of Datamine dynamic holes process when static holes are re-surveyed to make sample end points meet to the detriment of the sample centre points having been distanced from the hole trace. Both types of drillholes can be used for ore body modelling and estimation. Probably, dynamic holes have some reserved functions for development in future.
Opposite to dynamic, static drillhole centre points lay on the drillhole trace. Correspondingly, sample interval end points are out of the trace line.
You will need table files you created for HOLE3D process downloaded into the session. Go to Project Files, select files by pressing and holding CTRL button and clicking on the *.$ table files. Then release CTRL, R-click and choose Load.
You will note collar points on the screen. Next, go to Main Toolbar, Tools | Define Holes
In the Define Hole Tables dialog select table files as on the picture below, press OK.
Dynamic holes dwell in the Design Window only, not even in the session memory. They are not saved on the hard disk and will dissapear after the session restarting. The only way to save them is Rebuilding Static Holes From Dynamic Holes. Go to Tools | Rebuild Holes...
Build Holes dialog appears. Makes sure the Use existing traces and only desurvey new holes radio button is ticked on. Check the Create static drillholes box. Press OK
A new Static drillhole hole file is created and Datamine gives it a machine name. To save the file on the hard disk, go to Data | Save | Static Drillholes. Select the new static file an rename it if you want.
Navigate to the project folder and press Save.
I've come across with a lot of examples, when dynamic hole process is the only remedy. This happens if you import drillholes made in Micromine. Micromine is 2.5D software while Datamine is true 3D! As usual, you do not have access to the raw database to make drillholes from scratch because those who gave you a crumpled Micromine file will make sure you do not have the database available. Another issue might have been the downlole survey performed not accurately enough. In both cases use dynamic drillhole modelling.
Below is the picture of the same drillhole cured by the dynamic process. The effect is obvious, though not perfect. This is maximum you can do with fabricated Micromine drillhole file. If you have access to the drillhole database, you can be more specific: it might happened to be the downhole survey or/and records issue. If so, you have explanation to your HOLES3D drillhole geometry on the picture above, and the dynamic process effect on the static drillhole on the picture below. You are the only manager of your project and must be able to answer questions.
Studio RM users can load *rm$.dm table files into Design Window, then go to Sample Analysis | Prepare Samples | Define Holes
Pick corresponding table files for each entry box, click Rebuild.
Follow check box pick-ups on the picture below, press OK.
A new dynamically treated static drillhole is created in the Datamine session. To save it on you machine, go to Data | Export | External
Pick the sth*.tmp(drillholes) machine generated file and press OK.
In Data Export dialog select Datamine Driver Category and Tables in Data Type fileds. Press OK.
In Dynamic Data Table dialog navigate to the project folder, change the file name and press OK.