Configure Carlson Drill Integration

Activity Steps

  1. On the DataBlast Application Menu, select Site Maintenance.

    The Site Maintenance screen displays.

  2. Select the Service Control node.
  3. Select the Drill Machine Import » Carlson tab.
  4. Click Create Carlson Control Record.
  5. Leave Carlson Drill Machine Import Active unchecked while configuring the interface.
  6. Complete the following fields that are specific to Carlson drill integration as required.
    • Last Event Date/Time Imported—The date/time of the last record that was imported from the source Carlson database. Read-only.
    • Carlson Database Connection String—Enter the connection string to the MySQL database. Format: server=<HostName>;userid=<UserName>;password=<Password>;database=<DatabaseName>
    • Carlson Database Timeout—The amount of wait time (in seconds) before terminating an attempt to query the Carlson database and generating an error.
    • Default Pattern Inactive Days—Number of days between the first drilled hole time and the current time after which the pattern will no long be checked for drill activity.
    • Touch Intercept Tag Name(s)—The string that is used to associate DataBlast Pro hole 'touch coal' features with drill data from Carlson, based on Carlson drill tags.
  7. To edit pattern expiry mapping:
    1. Click View/Edit Pattern Expiry.

      The Carlson Drill Pattern Mapper View screen displays the patterns (known as 'folders') in the Carlson database.

      Note: These settings enable DataBlast Pro to stop receiving information about expired patterns. The top row includes options to filter the displayed data. Select from Custom, Blanks and NonBlanks. If set to Custom, specify custom filters.

    2. Edit the following fields as required for each data row.
      • Expiry Days—Prevents DataBlast Pro from looking at holes in the pattern after the specified number of days after the first hole is processed.
      • Stop Processing—Whether to stop processing the pattern.
    3. Click Close.
  8. Complete the following fields that are common to all drill interfaces as required.
    • Create Fault on 0 or Null Diameter—If checked, when the diameter provided is 0 or if no diameter is provided, a drill fault record instead of a drill machine hole detail record.
    • Reimport Skip Mode—If checked, processing of the current drill record is skipped if the hole already contains an undeleted drill machine record.
    • Time Zone—Select the time zone of the source data.
    • X/Y Deviation Diameter Count—The maximum number of design diameters distance in the X/Y plane from the design collar to the drilled collar that allows a hole to be considered within range. If the distance exceeds the amount represented by this value, the drill record is created as a drill fault, which requires manual confirmation as a valid hole record.
    • Sleep after Processing—The number of minutes to suspend processing when there are no new records available for processing.
    • Length Percentage Deviation—The percentage difference from the design drill length allowed before a hole is considered to require manual confirmation as a valid hole record.
    • Thread Database Timeout—If cleared, resets to Server default.
    • Angle Tolerance—The number of degrees difference from the design angle before a hole is considered to require manual confirmation as a valid hole record.
    • Bearing Tolerance—The number of degrees difference from the design bearing before a hole is considered to require manual confirmation as a valid hole record.
    • Ignore Drill Diameter—If checked, any drill diameter information provided by the source record is ignored.
    • Coordinate Conversion to Unit Multiplier—A multiplier applied directly to any X, Y or RL coordinate values before use.
    • Diameter Tolerance—The maximum percentage difference between the design and drill diameter before a hole is considered to require manual confirmation as a valid hole record.
    • Apply Diameter Tolerance to Valid Diameters
    • Drill Diameter Multiplier—A multiplier applied directly to the drill diameter value provided by the source drill import record.
    • Drill Diameter Rounding—The number of decimal places to round the diameter values before use (applied after the Drill Diameter Multiplier).
  9. To enable the interface, check Carlson Drill Machine Import Active.
  10. Click Save Changes.