Configure IMS Drill Integration
Activity Steps
- On the DataBlast Application Menu, select Site Maintenance.
The Site Maintenance screen displays.
- Select the Service Control node.
- Select the Drill Machine Import » IMS tab.
- Click Create IMS Control Record.
- Leave IMS Drill Machine Import Active unchecked while configuring the interface.
- Complete the following fields that are specific to IMS drill integration as required.
- Last Event ID Imported—The numerical event ID in the source IMS database from which to start looking for further records.
- IMS Database Connection String—Click the ellipsis (...) to open the Select Database Server and Database screen to enter connection details. Click Advanced for further connection details if required.
- IMS Database Timeout—The amount of wait time (in seconds) before terminating an attempt to query the IMS database and generating an error.
- IMS Mine Site ID—The mine_id value of the record in the mine table of the IMS database which represents the specific mine to import.
- IMS All Mine Site ID—The mine_id value of the record in the mine table of the IMS database which represents All mines.
- No Retry on Completed Entries with No Machine Assigned—If checked, a record that has a finish date time stamp, but does not have any drill machine information will be ignored. If unchecked, the record will be added to a list of records to retry later.
- Machine Value 0 is Invalid—If checked, a machine value of 0 is considered invalid, and the drill record is interpreted as if it does not contain information about the drill machine. If unchecked, a drill resource with an IMS ID of 0 is located or created.
- 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.
- Sleep after Processing—The number of minutes to suspend processing when there are no new records available for processing.
- Thread Database Timeout—If cleared, resets to Server default.
- 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.
- 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.
- 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.
- Coordinate Conversion to Unit Multiplier—A multiplier applied directly to any X, Y or RL coordinate values before use.
- Ignore Drill Diameter—If checked, any drill diameter information provided by the source record is ignored.
- 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).
- To enable the interface, check IMS Drill Machine Import Active.
- Click Save Changes.