Difference between revisions of "FusionXL install"

From FMR Knowledge Base
Jump to navigation Jump to search
m (Glenn moved page Fusion Excel Set Up to FusionXL install)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[Category:Use_Fusion_XL]]
+
[[Category:Fusion_XL]]
 
=Overview=
 
=Overview=
−
FusionXL is an Excel add-in which is available to download from [https://metadatatechnology.com/community/ the Metadata Technology SDMX Community tools web site]. If you haven't already done so, you will need to register and then login in order to download the add-in. Scroll down until you see the FXL section and then download the Zip file.
+
FusionXL is an Excel add in for Fusion Metadata Registry providing three main functions:
 +
* Browse and view structures
 +
* Create and maintain structures - in particular useful for maintaining large codelists
 +
* Author, validate and convert datasets
  
 +
[[File:FXL1.PNG|1000px]]
  
−
[[File:FXL0.png|1000px]]
+
=Download=
 +
The FusionXL add in is a single Excel XLAM file which can be downloaded from here: [https://www.sdmx.io/resources/download here:]
  
−
The zip file contains a single XLAM file which should be saved to your computer in one of two specific places '''(not both)'''. It will work with Microsoft Excel 2010 and later.
+
To add FXL to Windows 10 or higher, follow '''one''' of the two steps below.
  
−
The XLAM file must be in an AppData folder in one of two possible locations and the next time Excel is started, you will see a tab as shown on the image below.
+
=Install=
  
 +
====Using XLSTART folder====
 +
Copy the XLAM file to the Excel sub directory folder '''XLSTART''' as shown in the example path below:
  
−
[[File:FXL1.PNG|1000px]]
+
C:\Users\[your user name]\AppData\Roaming\Microsoft\Excel\XLSTART
  
−
To add FXL to Windows 10 or higher, follow '''one''' of the two steps below.
+
Files in this folder are automatically loaded when Excel starts.
  
−
==Using XLSSTART folder==
+
====Using Excel's add-in maintenance facility====
−
Place the XLAM file in the Excel sub directory folder '''XLSTART''' as shown in the example path below:
+
Copy the XLAM file to the Microsoft '''AddIns''' folder:
−
 
 
−
C:\Users\[your user name]\AppData\Roaming\Microsoft\Excel\XLSTART
 
−
 
 
−
==Using the Addins sub directory folder==
 
−
Place the XLAM file in the Excel sub directory folder '''XLSTART''' as shown in the example path below:
 
  
 
  C:\Users\[your user name]\AppData\Roaming\Microsoft\AddIns
 
  C:\Users\[your user name]\AppData\Roaming\Microsoft\AddIns
  
−
Having done this, the next step is to enable the Add-in. In Excel select the Options menu and then Add-ins.
+
Register the add-in with Excel by selecting the Options menu, then choosing Add-Ins.
  
−
 
+
[[File:FXL2.png|600px]]
−
[[File:FXL2.png|800px]]
 
  
 
After clicking '''Go''' an Add-Ins window will be displayed which will show '''FusionXL''' as an available add-in.  Select this add-in and click '''OK'''.
 
After clicking '''Go''' an Add-Ins window will be displayed which will show '''FusionXL''' as an available add-in.  Select this add-in and click '''OK'''.
Line 38: Line 39:
  
 
You are now ready to [[Connect_FXL_to_a_Registry|connect FXL to a Registry]].
 
You are now ready to [[Connect_FXL_to_a_Registry|connect FXL to a Registry]].
 +
 +
=Troubleshooting=
 +
====The FXL addin disappears or fails to load====
 +
A possible cause is Windows file protection security settings blocking the FXL.xlam file as it has originated from another computer. The following YouTube video explains how to solve the problem by disabling Windows protection on the file: https://www.youtube.com/watch?v=AhnOU-ulqNg
 +
 +
====Macro Disabled====
 +
As above.

Latest revision as of 03:28, 13 September 2023

Overview

FusionXL is an Excel add in for Fusion Metadata Registry providing three main functions:

  • Browse and view structures
  • Create and maintain structures - in particular useful for maintaining large codelists
  • Author, validate and convert datasets

FXL1.PNG

Download

The FusionXL add in is a single Excel XLAM file which can be downloaded from here: here:

To add FXL to Windows 10 or higher, follow one of the two steps below.

Install

Using XLSTART folder

Copy the XLAM file to the Excel sub directory folder XLSTART as shown in the example path below: 

C:\Users\[your user name]\AppData\Roaming\Microsoft\Excel\XLSTART

Files in this folder are automatically loaded when Excel starts.

Using Excel's add-in maintenance facility

Copy the XLAM file to the Microsoft AddIns folder: 

C:\Users\[your user name]\AppData\Roaming\Microsoft\AddIns

Register the add-in with Excel by selecting the Options menu, then choosing Add-Ins.

FXL2.png

After clicking Go an Add-Ins window will be displayed which will show FusionXL as an available add-in. Select this add-in and click OK.


FXL3.png

After clicking OK, restart Excel to see the RXL tab as shown in the image above.

You are now ready to connect FXL to a Registry.

Troubleshooting

The FXL addin disappears or fails to load

A possible cause is Windows file protection security settings blocking the FXL.xlam file as it has originated from another computer. The following YouTube video explains how to solve the problem by disabling Windows protection on the file: https://www.youtube.com/watch?v=AhnOU-ulqNg

Macro Disabled

As above.

Retrieved from "https://fmrwiki.sdmxcloud.org/index.php?title=FusionXL_install&oldid=7166"