The Mingle Add-In for Excel 2010 and 2013 extends Microsoft Excel with direct integration to Mingle. This add-in provides a convenient ribbon bar in the Excel user interface that you use to access features of the add-in. From there you can create, name, save and run MQL queries that extract data from Mingle and bring it into Excel for analysis using all the power of Excel.
- Connect to Mingle directly from Excel
- Optionally run more than one query per worksheet
- Save queries with Excel workbooks (optionally several queries per worksheet)
- Run the same queries again later (refersh)
- Install the add-in
- You may need to adjust the permissions in Excel to allow the add-in to be loaded.
- Click on the Mingle tab on the Excel ribbon.
- Click on the orange Login button, supply the requested information, and click Connect.
- After a few moments the Fetch Cards button on the Mingle ribbon should illuminate. Click it and you'll see a UI for entering MQL commands.
The Mingle Add-In for Excel 2010 and 2013 uses the One-Click installation technique available for Microsoft Office Add-Ins.
- Since the Add-in uses Mingle’s RESTful API to communicate with Mingle you must have basic authentication enabled on your Mingle server. To enable basic authentication, you need to set the basic_authentication_enabled configuration option to true in the Mingle data directory\config\auth_config.yml file, where Mingle data directory is the path to the Mingle data directory. Only a Mingle server administrator can do this.
- Since this add-in is “unsigned” you’ll need to tell Excel to not to require a signing certificate for this add-in. To do this use File -> Options -> Trust Center -> Add-Ins -> Trust Center Settings and uncheck Require Application Add-ins to be signed by Trusted Publisher.
- Unzip the ExcelAddIn.zip file into a folder anywhere on your hard drive.
- Open this directory and run Setup.exe. Setup may offer to install a couple of software packages used by the Add-in. You need to install these if prompted to do so. These are: Visual Studio Tools for Office 2010 and Microsoft .NET Framework 4 Client Profile.
- Start Excel 2010. You should see a Mingle tab that exposes the Mingle Ribbon.
Installing the add-in on Windows Server 2012 R2 works, but you may have trouble with the installer's automated capture and download of a couple of dependencies. The add-in requires .NET Framework 3.5 and Visual Studio Tools for Office 2010. My experience is that I had to manually install .NET Framework 3.5 from its off-line installer. The Windows Server 2012 R2 feature for .NET 3.5 was not enough. I went ahead and installed Visual Studio Tools for Office 2010 manually at this point as well.
Please sign in to leave a comment.