Convert data between SDMX formats - Revision history

Vmurrell: /* Load Data UI Page */

2023-10-11T12:14:29Z

‎Load Data UI Page

Vmurrell: /* Load Data UI Page */

2023-10-11T11:49:04Z

‎Load Data UI Page

Plazarou at 10:44, 10 October 2023

2023-10-10T10:44:26Z

Plazarou: /* Converting from the Dataset Details Page */

2023-10-10T10:43:39Z

‎Converting from the Dataset Details Page

Plazarou: /* Using Quick Convert */

2023-10-10T10:12:46Z

‎Using Quick Convert

Vmurrell at 08:47, 22 October 2020

2020-10-22T08:47:32Z

Vmurrell: Created page with "Category:How_To =Overview= In Fusion Metadata Registry there are two ways of converting data using the Graphical User Interface ==Using Quick Convert== This option can b..."

2020-10-22T08:47:02Z

Created page with "Category:How_To =Overview= In Fusion Metadata Registry there are two ways of converting data using the Graphical User Interface ==Using Quick Convert== This option can b..."

New page

[[Category:How_To]]
=Overview=
In Fusion Metadata Registry there are two ways of converting data using the Graphical User Interface

==Using Quick Convert==

This option can be found by selecting '''Convert''' from the Data Menu as shown in the example below.

[[File:convert1.PNG|1000px]] 

'''You can use this option to:'''

# Convert SDMX V2.1 datasets to Excel format
# Convert datasets to SDMX V2.1 Structure specific format

'''Formats which can be converted to SDMX 2.1 are:'''
* SDMX-V2.0-Compact
* SDMX-EDI
* SDMX-JSON
* SDMX-V2.0-Generic

The xml file will be validated and downloaded.

If the validation was successful you will be advised as shown below.

[[File:convert3.PNG|800px]] 

If unsuccessful you will be presented with an error message similar to that shown below.

[[File:convert2.PNG|800px]] 

In both scenarios, to see more detail you can click the link ''View Conversion Report'' which will take you to the Dataset Details page as shown below.

[[File:val6.PNG|1000px]] 

==Converting from the Dataset Details Page==

To use this option, select the file (or enter the url) and click '''Load Data''' to validate the data. You will be taken to the Dataset Details page as shown below.

[[File:convert4.PNG|1000px]] 

Select the format you require and then click '''Download'''.

@@ Line 4: / Line 4: @@
 ==Load Data UI Page==
-The convert data page in FMR allows the user to load a data file or data via a URL to be validated and transformed.  The page contains a number of controls to aid you in loading a Dataset, however FMR will do its best to determine anumber of the values for you. For example, the only format that requires the DSD to be specified is Fusion CSV (this is one of the reasons that Fusion CSV is not recommended)
+The convert data page in FMR allows the user to load a data file or data via a URL to be validated and transformed.  The page contains a number of controls to aid you in loading a Dataset, however FMR will do its best to determine some of the values for you. For example, the only format that requires the DSD to be specified is Fusion CSV (this is one of the reasons that Fusion CSV is not recommended)
 Use the control "Data Source" to specify whether you wish to load a data file or load data from via a URL. The "Data Format" can be left on "Auto Detect" for the majority of use-cases unless you have an unusual file suffix. For example if your CSV file ends with something other than ".csv".  The Data Format of "SDMX" covers the case of loading SDMX-CSV, although you can load SDMX-CSV when the Data Format is set to "CSV".

← Older revision		Revision as of 10:43, 10 October 2023
Line 48:		Line 48:

	Select the format you require and then click '''Download'''.		Select the format you require and then click '''Download'''.
		+
		+	==Convert Data UI Page==
		+	The convert data page in FMR allows the user to load a data file or data via a URL to be validated and transformed. The page contains a number of controls to aid you in loading a Dataset, however FMR will do its best to determine anumber of the values for you. For example, the only format that requires the DSD to be specified is Fusion CSV (this is one of the reasons that Fusion CSV is not recommended)
		+
		+	Use the control "Data Source" to specify whether you wish to load a data file or load data from via a URL. The "Data Format" can be left on "Auto Detect" for the majority of use-cases unless you have an unusual file suffix. For example if your CSV file ends with something other than ".csv". The Data Format of "SDMX" covers the case of loading SDMX-CSV, although you can load SDMX-CSV when the Data Format is set to "CSV".
		+
		+	When the Data Format is set to CSV a further control appears stating what the delimiter is. This is only applicable for Fusion CSV and SDMX-CSV will ignore this.
		+
		+	Since most of the formats state within the Dataset themselves what structure they are for, the control for "Data Structure" can be left on "Auto Detect" except in 2 scenarios:
		+	- You are loading a Fusion CSV file - then a Data Structure MUST be specified
		+	- You wish to override the structure in the file, from one in the drop-down

@@ Line 2: / Line 2: @@
 =Overview=
 In Fusion Registry there are two ways of converting data using the Graphical User Interface
 ==Using Quick Convert==

@@ Line 18: / Line 18: @@
 '''Formats which can be converted to SDMX 2.1 are:'''
 * SDMX-V2.0-Compact
 * SDMX-EDI
 * SDMX-JSON
 * SDMX-V2.0-Generic
-The xml file will be validated and downloaded.
+The XML file will be validated and downloaded.
 If the validation was successful you will be advised as shown below.
@@ Line 38: / Line 39: @@
 [[File:val6.PNG|1000px]]<br>
 ==Converting from the Dataset Details Page==