FusionLink is a Xll library for Excel and a FusionInvest Toolkit which provides the ability to subscribe to real-time and query data from a FusionInvest client.
- A Toolkit license for Finastra FusionInvest / FusionCapital (Sophis).
- Knowledge of Toolkit development
- Knowledge of C#, WCF and ExcelDNA development.
- Visual Studio 2019
- Excel 2003 or above
In order to build the solution without access to the SDK dll's, a Mocks library is provided which match the assembly, type and method signatures of the SDK. The FusionLink toolkit when built against this library will successfully run.
Various build configurations are supplied for versions 7.1.3.14, 7.1.3.19 & 7.2.6 of the SDK.
Steps
- Clone the Repo to your PC.
- Open the Client solution within the src folder in VS2019.
- Build the solution. (The first time will download all the required NuGet packages)
- Open the Server solution within the src folder in VS2019.
- Choose the build configuration which matches your SDK.
- Build the solution. (The first time will download all the required NuGet packages)
- All the files in the build directory of the "ExcelClient" project need to be distributed to your installation location of choice.
- Start Excel
- Open "FusionLink-AddIn.xll" from Excel.
- To verify the add-in has loaded successfully, you should see a new ribbon tab "FusionLink".
- In the FusionLink project under the SQL folder, run all the SQL in Install.sql. This will setup a new permission under "SDK Rights" for each user and group.
- Enable the "FusionLink" right for the users / groups that require access in the FusionInvest / FusionCapital UI.
- All the files in the build directory of the "FusionLink" project need to be placed in your Toolkit dll folder.
- In the AssemblyDll section of your config file add the location of the "FusionLink" dll.
- Load FusionInvest / FusionCapital. If your user has the necessary permission to "FusionLink" you should be able to see a MFC Caption Bar with the connection information.
- Philippe Bonneau for the inspiration on using the MFC Caption Bar within Sophis.