Difference between revisions of "Convert data between SDMX formats"
(Created page with "Category:FMR_How_To_Guides To be written.") |
|||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | [[Category: | + | [[Category:How_To]] |
| + | =Overview= | ||
| + | In Fusion Metadata Registry there are two ways of converting data using the Graphical User Interface. | ||
| + | ==1. Using Quick Convert== | ||
| − | To be | + | This option can be found by selecting '''Convert''' from the Data Menu as shown in the example below. |
| + | |||
| + | |||
| + | [[File:convert1.PNG|Convert Data page|1000px]]<br> | ||
| + | |||
| + | |||
| + | '''You can use this option to:''' | ||
| + | |||
| + | # Convert Excel datasets to SDMX V2.1 format | ||
| + | # Convert XML 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|Successful Conversion|800px]]<br> | ||
| + | |||
| + | If unsuccessful you will be presented with an error message similar to that shown below. | ||
| + | |||
| + | |||
| + | [[File:convert2.PNG|Conversion with Errors|800px]]<br> | ||
| + | |||
| + | 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|Dataset Detials|1000px]]<br> | ||
| + | |||
| + | ==2. 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|Convert and Download Options|1000px]]<br> | ||
| + | |||
| + | Select the format you require and then click '''Download'''. | ||
Latest revision as of 01:12, 3 May 2021
Overview
In Fusion Metadata Registry there are two ways of converting data using the Graphical User Interface.
1. Using Quick Convert
This option can be found by selecting Convert from the Data Menu as shown in the example below.
You can use this option to:
- Convert Excel datasets to SDMX V2.1 format
- Convert XML 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.
If unsuccessful you will be presented with an error message similar to that shown below.
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.
2. 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.
Select the format you require and then click Download.
