Difference between revisions of "FusionXL DataAuthor"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Data Set)
(Load a Data Set)
Line 32: Line 32:
  
 
==Load a Data Set==
 
==Load a Data Set==
 +
 +
To load an existing dataset, locate the file using Windows Explorer.
 +
 +
If the system can find details of the Provision Agreement, a pop up window will appear enabling you to select the Data Provider and the Dataflow.
 +
 +
===Supported Formats===
 +
Supported formats are:
 +
 +
SDMX-ML
 +
SDMX-CSV
 +
SDMX-JSON
 +
FUSION-JSON
  
 
==Create Data Set==
 
==Create Data Set==

Revision as of 07:57, 12 July 2021

Prerequisites

To use the Data Author, you need to have installed the FXL add-in and connected to a Registry from the FusionXL tab in an Excel workbook. Click here to learn how to do that. Additionally, you will also need to Login with your Registry username and password.

The image below shows the Connected Registry along with the name of the logged in user.


Data Author Toolbar.PNG

Features Overview

Button Function Usage
Load Data Set button.PNG Load Data Set Allows the user to load an existing dataset using Windows Explorer to locate the saved file which needs to be in one of the supported formats.
Create Data Set button.PNG Create Data Set Allows users to create a for an existing Provision Agreement within the Connected Registry.
Author Helper button.PNG Author Helper Allows users to view the Dimensions and Attributes used in a Data Structure and if enumerated, pick from a list the individual item.
Validate Data button.PNG Validate Data Allows users to validate data, both loaded and created using FusionXL.
Convert Data Button.PNG Convert Data Allows users to convert the data into one of the supported formats.
Publish Data button.PNG Publish Data Allows Administrators and Data Providers (subject to the usual permissions)to Publish data to the Registry.

These functions are grouped into two areas:

Data Set

Data sets can be created using FXL and also existing datasets (in one of the supported formats) can be loaded. The Load and Create options allow the user to use the Author Helper tool which enable a user to look up the format of the data expected including individual codes if a component has been enumerated.

Load a Data Set

To load an existing dataset, locate the file using Windows Explorer.

If the system can find details of the Provision Agreement, a pop up window will appear enabling you to select the Data Provider and the Dataflow.

Supported Formats

Supported formats are:

SDMX-ML SDMX-CSV SDMX-JSON FUSION-JSON

Create Data Set

Author Helper

Data Set Action

Validate Data

Convert Data

Publish Data

Back to Main Page