Export hole properties

You can export properties for all holes selected or displayed in the Viewport. The data is exported as a CSV file (see File formats).

Export templates are saved in the mine site database rather than as external files.

Access hole property exporting:

  1. Select the Design, Drill, Measure, Charge or Initiation module.
  2. Select patterns in the DataBlast Items Tree as required to display the holes for which to export the properties.

    Note: If you only want to export properties for a subset of the holes in a the displayed drill patterns, see Select objects in the viewport or Filter displayed holes.

  3. On the Utilities/View ribbon menu, select Export Data.

    The Export Hole Pattern Data screen displays.

To create and save an export template:

  1. Click New Template.

    The Hole Properties Export Template screen displays.

  2. Enter the Name. Template names cannot be reused.
  3. Click OK.

    Note: As you update the following settings, the bottom table displays a preview of the data to be exported.

  4. Select whether to Include Headers.
  5. Select the Field Delimiter from Comma, Tab, Space and Semicolon; or enter a character for Other.
  6. Select the Decimal Separator from Period and Comma; or enter a character for Other.

    Note: The Thousands Separator is read-only.

  7. To find a property in the Available Columns list, enter text in the search field if required.
  8. For each required property:
    1. Drag the property from the Available Columns list to the Columns to Export table; or double-click the property in the Available Columns list.
    2. Update the Heading if required.
    3. Enter or select the Format if required.

      Note: The format is only applicable for numerical, date/time and boolean properties. The drop-down list has example formats, but you can enter other formats if required. For example, you can enter T:F as an alternative to true:false or y:n for a boolean property.

  9. To remove an export property, either drag the property back to the Available Columns list; or:
    1. Select the property in the Columns to Export table.
    2. Click Remove Selected Column.
  10. To set a sort order for the data, drag a property from the Available Columns list to the Sort By table. You can also select the Sort By table and double-click the property in the Available Columns list.

    Note: You can sort by multiple properties. The properties by which data is sorted do not need to be included in the export. The default sort order is ascending (ASC). Click ASC to change to descending (DESC) if required. If the Sort By table is empty and Hole Identifier is added to the Columns to Export table, Hole Identifier is also added to the Sort By table automatically. Sorting by Hole Identifier uses numeric sorting when all exported hole identifiers are numeric. If any exported hole identifier is not numeric, alphanumeric sorting is used.

  11. To remove a sorting property:
    1. Select the property in the Columns to Export table.
    2. Click Remove Selected Sort Column.
  12. To reorder export properties or sorting properties, click and drag the column by the Columns to Export or Sort By cell for the property in the table. You can also reorder export properties by dragging columns in the Export Data Preview table.
  13. To save the template, click Save Template.
  14. To save the template with a new name:
    1. Click Save Template As.
    2. Enter the Name.
    3. Click OK.

To load an export template:

  1. Click Load Template.

    The Hole Properties Export Template Selection screen displays.

  2. Select the template.
  3. Click OK.

    The bottom table displays a preview of the data to be exported.

To export hole properties:

  1. Create or load an export template.
  2. On the Export ribbon menu, click Export Data.
  3. Browse for a file location and enter a file name for the CSV file as required.
  4. Click Save.