Run the Wenco drill log import setup script

Important: This activity is only required if you plan to import data from Wenco/APS drill machines using the WencoLite integration. It is not applicable to the WencoMine integration. See Drill machine interfaces. This activity should be performed by the DataBlast System Installer and Database Installer. The person who runs the script must connect to the DataBlast SQL Server using Windows authentication and have permission to create a linked server and database synonyms, and make other changes to the DataBlast database.

Activity steps:

  1. In the DataBlast installation folder, double-click DataBlast Server\Database Scripts\Setup Wenco.bat.

    The DATABLAST Wenco Drill Log Import Setup Script batch application displays.

  2. Review the displayed settings. To change a setting, enter its number, press Enter, and then enter the new value when prompted.
  3. Configure the following settings as required.
    • DATABLAST SQL Server Name (and instance if required): The instance name of the SQL Server that contains the DataBlast database.
    • DATABLAST Database Name: The name of the DataBlast database.
    • Wenco SQL Server Name (and instance if required): The instance name of the SQL Server that contains the WencoLite database.
    • Wenco Database Name: The name of the WencoLite database.
    • Add Hole segment support: If set to TRUE, the importer uses the DrillReading table to generate hole segment data.
    • Use customised Wenco Drill Hole view: If set to TRUE, the drill holes view imports the additional Tag and TouchCoalDepth fields. These site-specific fields might not be available in a standard WencoLite database.
    • Wenco Database Drill Holes view name: The name of the view used to query drill hole data. The provided APS SQL scripts create the default view. Default: mineApsViewDrillHoles.
    • DATABLAST Uses Windows Authentication to connect to Wenco Server: The DataBlast Service must have read permission for the WencoLite database. If set to TRUE, access to the Wenco database uses the Windows authentication mode. If set to FALSE, the Wenco SQL Login and Wenco SQL Login Password settings display.
    • Wenco SQL Login: The SQL Server user name used to connect to the WencoLite database.
    • Wenco SQL Login Password: The password for the specified SQL Server user name.
  4. Select the next action:
    • To proceed with setup using the displayed settings, press Enter and wait for the script to complete.
    • If the WencoLite database is no longer available, enter A and press Enter to remove the WencoLite database synonyms and disable the importer.
    • To exit, enter X and press Enter.
  5. If you proceeded with setup, confirm that the mineApsViewDrillHoles and mineApsViewDrillHolesOperator views exist in the WencoLite database. No further action is required if both views exist. Older WencoLite databases might not contain these views. If either view is missing:
    1. In the DataBlast installation folder, access the DataBlast Server > Database Scripts > APS Scripts folder.
    2. Run the following scripts in a SQL Server scripting environment against the WencoLite database:
      • dbo.mineApsViewDrillHoles.View.sql
      • dbo.mineApsViewDrillHolesOperator.View.sql