Excel Uploader System Requirements

The Excel Uploader has the following system requirements:

  • A client installation of MineMarket 4.7 or later, fully configured to connect to the MineMarket Service
  • 64-bit Microsoft Office 2013 or Microsoft Office 365 (desktop version), with macros fully enabled
  • The following files in the MineMarket installation folder:
    • Excel2007Sample.dll
    • Excel2007Sample.dll.manifest
    • Excel2007Sample.vsto
    • Excel2007Sample.xlsm (or other provided XLSM file with MineMarket Excel Uploader data)
    • Excel2007Sample.dll.config—New in MineMarket 5.5.3.

Note: The Excel Uploader cannot be used with a 32-bit version of Microsoft Office.

If you are using MineMarket 5.5.4 or later, you can use the Secure Sockets Layer (SSL) protocol for encrypted communication between the MineMarket Service and all clients. See Certificate Management in the MineMarket Installation Guide for more information.

Excel2007Sample.dll.config includes the following default application settings. These settings can be updated with the Application Configuration Editor. See Edit the MineMarket Application Configuration in the MineMarket Installation Guide.

Copy 
<add key="UseRemoting" value="False" />
<add key="gRPCTracers" value="-all" />
<add key="UseSSL" value="True" />
<add key="SSLTargetNameOverride" value="" />
<add key="Keystore" value="%ProgramFiles%\Datamine\MineMarket 5.5\keystore" />

Except for gRPCTracers, these settings must match the settings for the MineMarket Client; that is, in BulkTrak.exe.config. However, for the Excel Uploader, you need to specify an absolute path to the folder where certificates are stored. (In the default .\Keystore value in other configuration files, the dot before the backslash indicates a path relative to the MineMarket installation.)