Design Data Import Setup

Although the columns are fixed when you are importing Drill and Blast design data, the names of those columns are defined as part of your Drill and Blast configuration.  For that reason, the column names that appear when you run the Import utility may not match those shown in the table below:

Import Key:
Location Mandatory - Location Code
Fire Mandatory - The fire/shot/blast id for each location. For underground systems this ID must be unique. For open pit, multiple locations can be fired in the same ‘shot’.
  Example - Surface:
 
  Example - Underground:
 
Design Data:
Weight Mandatory - Design weight for the location/fire combination. On the surface this would be the block design whereas for underground this would be the fire design (which may include one or more rings)
Volume  
GCM Weight  
  Example - Surface:
 
  Example - Underground:
 
  Notes - Underground:
  Volumes and Tonnes are ignored.
Dilution Data:
The dilution types selected in configuration will appear here.
Dilution Weight This column will be repeated depending on the number of dilution types selected in the configuration.
Dilution % This column will be repeated depending on the number of dilution types selected in the configuration.
  Example - Surface:
 
  Notes - Surface:
  Internal and External Dilution Weights and Percents.
  Example - Underground:
 
  Notes - Underground:
  Internal and External Dilution Weights. Percents are ignored.
Grade Data:
Multiple grades can be imported as a repeating group of columns.
Element Mandatory.
Design Grade Mandatory.
GCM Grade GCM Grade data is ignored.
Dilution Grade This column will be repeated depending on the number of dilution types selected in the configuration.
Repeat Default is 1. In other words, there must always be at least one element present.
  Set the repeat value to the number of elements (repeating groups) to be imported.
  Example - Surface:
 
  Notes - Surface:
  Design Grade, GCM Grade and Internal and External Dilution Grades.
  Although not part of the import file Repeat is set to 2 as there are two elements: Gold and Silver.
  Example - Underground:
 
  Notes - Underground:
  Design Grade and Internal and External Dilution Grades. GCM Grade is ignored.
  Although not part of the import file Repeat is set to 1 as there is only one element: Gold.

Ring Design Data Import Setup