Difference between revisions of "Convert data between SDMX formats"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Using Quick Convert)
Line 18: Line 18:
 
'''Formats which can be converted to SDMX 2.1 are:'''
 
'''Formats which can be converted to SDMX 2.1 are:'''
 
* SDMX-V2.0-Compact
 
* SDMX-V2.0-Compact
 +
* SDMX-CSV
 
* SDMX-EDI
 
* SDMX-EDI
 
* SDMX-JSON
 
* SDMX-JSON
 
* SDMX-V2.0-Generic  
 
* 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.
 
If the validation was successful you will be advised as shown below.
Line 38: Line 39:
  
 
[[File:val6.PNG|1000px]]<br>
 
[[File:val6.PNG|1000px]]<br>
 
  
 
==Converting from the Dataset Details Page==
 
==Converting from the Dataset Details Page==

Revision as of 02:12, 10 October 2023

Overview

In Fusion 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.


Convert1.PNG


You can use this option to:

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

Formats which can be converted to SDMX 2.1 are:

  • SDMX-V2.0-Compact
  • SDMX-CSV
  • 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.


Convert3.PNG

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


Convert2.PNG

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.


Val6.PNG

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.


Convert4.PNG

Select the format you require and then click Download.