Data Formats - Revision history

Vmurrell at 16:01, 13 November 2025

2025-11-13T16:01:40Z

Vmurrell: /* CSV Formats */

2025-11-13T15:50:28Z

‎CSV Formats

Vmurrell at 11:28, 5 November 2025

2025-11-05T11:28:31Z

Plazarou: /* CSV Formats */

2023-10-10T09:59:51Z

‎CSV Formats

Vmurrell at 13:13, 6 September 2023

2023-09-06T13:13:51Z

Mnelson: /* CSV Formats */

2023-03-10T09:15:30Z

‎CSV Formats

Mnelson: /* Examples */

2023-03-10T09:14:35Z

‎Examples

Mnelson: /* SDMX Formats */

2020-06-30T20:08:50Z

‎SDMX Formats

Mnelson: /* SDMX Formats */

2020-06-30T20:07:21Z

‎SDMX Formats

Glenn: /* CSV Formats */

2020-06-24T14:55:21Z

‎CSV Formats

@@ Line 44: / Line 44: @@
 | version || the version of the format|| 1.0.0, 2.0.0 [[SDMX-CSV]] only || 1.0.0 || [[SDMX-CSV]], [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
-| timeFormat ||  values are converted to the most granular ISO 8601 representation <br/>taking into account the highest frequency of the data in the message|| original or normalized || original  || [[SDMX-CSV]]
+| timeFormat ||  values are converted to the most granular ISO 8601 representation <br>taking into account the highest frequency of the data in the message|| original or normalized || original  || [[SDMX-CSV]]
 |-
-| labels || output both code/concept ids and the respective labels <br/> in the specified language || both/id/name || id || [[SDMX-CSV]] (with the exception of labels=name),<br/> [[Fusion-CSV]], [[Fusion-CSV-TS]]
+| labels || output both code/concept ids and the respective labels <br> in the specified language || both/id/name || id || [[SDMX-CSV]] (with the exception of labels=name),<br> [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
 | delimiter || the delimiter to use || comma/tab/semicolon/space || comma || [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
-| serieskey || include the series key as a column<br/> A series key is the concatenation of the dimension values <br/>for example A:UK:EMPLOYMENT || include/exclude || exclude ||  [[Fusion-CSV]], [[Fusion-CSV-TS]]
+| serieskey || include the series key as a column<br> A series key is the concatenation of the dimension values <br>for example A:UK:EMPLOYMENT || include/exclude || exclude ||  [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
-| bom <br/> <small>(since 10.3.1)</small> || Include or Exclude the [https://en.wikipedia.org/wiki/Byte_order_mark '''B'''yte '''O'''rder '''M'''ark] (BOM).<br/> The BOM helps Excel interpret non Latin characters when opening a CSV file || include/exclude || exclude ||  [[SDMX-CSV]], [[Fusion-CSV]], [[Fusion-CSV-TS]]
+| bom <br> <small>(since 10.3.1)</small> || Include or Exclude the [https://en.wikipedia.org/wiki/Byte_order_mark '''B'''yte '''O'''rder '''M'''ark] (BOM).<br> The BOM helps Excel interpret non Latin characters when opening a CSV file || include/exclude || exclude ||  [[SDMX-CSV]], [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
 |}
@@ Line 60: / Line 60: @@
 ===Examples===
-application/vnd.sdmx.data+csv <br/>
+application/vnd.sdmx.data+csv <br/
-application/vnd.sdmx.data+csv;version=1.0.0;<br/>
+application/vnd.sdmx.data+csv;version=1.0.0;<br>
-application/vnd.sdmx.data+csv;version=2.0.0;<br/>
+application/vnd.sdmx.data+csv;version=2.0.0;<br>
-application/vnd.sdmx.data+csv;version=1.0.0;timeFormat=normalized<br/>
+application/vnd.sdmx.data+csv;version=1.0.0;timeFormat=normalized<br>
-application/vnd.sdmx.data+csv;version=1.0.0;timeFormat=normalized;labels=both<br/>
+application/vnd.sdmx.data+csv;version=1.0.0;timeFormat=normalized;labels=both<br>
-<p/>
+<p>
-application/vnd.csv<br/>
+application/vnd.csv<br>
-application/vnd.csv;delimiter=tab<br/>
+application/vnd.csv;delimiter=tab<br>
-application/vnd.csv;timeFormat=normalized;serieskey=include<br/>
+application/vnd.csv;timeFormat=normalized;serieskey=include<br>
-application/vnd.csv;version=1.0.0;labels=both<br/>
+application/vnd.csv;version=1.0.0;labels=both<br>
-<p/>
+<p>
-application/vnd.csv-ts<br/>
+application/vnd.csv-ts<br>
-application/vnd.csv-ts;version=1.0.0;<br/>
+application/vnd.csv-ts;version=1.0.0;<br>
-application/vnd.csv-ts;version=1.0.0;labels=name<br/>
+application/vnd.csv-ts;version=1.0.0;labels=name<br>
 ==[[Reporting Template|Data Reporting Template]]==
@@ Line 85: / Line 85: @@
 | application/vnd.reporttemplate
 || Excel Report Template pre-populated with the data from a dataset.
-<br/> The dataset should contain the Provision Agreement reference, to enable the Fusion Registry to determine the Data Provider
+<br> The dataset should contain the Provision Agreement reference, to enable the Fusion Registry to determine the Data Provider
-<br/> The excel file will be the same as a Report Template generated via the [[Data_Reporting_Template_Web_Services|Reporting Template Web Service]], but it will be pre-populated with observation and attribute values from the dataset.
+<br> The excel file will be the same as a Report Template generated via the [[Data_Reporting_Template_Web_Services|Reporting Template Web Service]], but it will be pre-populated with observation and attribute values from the dataset.
 |-

@@ Line 50: / Line 50: @@
 | delimiter || the delimiter to use || comma/tab/semicolon/space || comma || [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
-| serieskey || include the series key as a column<br/> A series key is the concatenation of the dimension values<br/>for example A:UK:EMPLOYMENT || include/exclude || exclude ||  [[Fusion-CSV]], [[Fusion-CSV-TS]]
+| serieskey || include the series key as a column<br/> A series key is the concatenation of the dimension values <br/>for example A:UK:EMPLOYMENT || include/exclude || exclude ||  [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
 | bom <br/> <small>(since 10.3.1)</small> || Include or Exclude the [https://en.wikipedia.org/wiki/Byte_order_mark '''B'''yte '''O'''rder '''M'''ark] (BOM).<br/> The BOM helps Excel interpret non Latin characters when opening a CSV file || include/exclude || exclude ||  [[SDMX-CSV]], [[Fusion-CSV]], [[Fusion-CSV-TS]]

@@ Line 1: / Line 1: @@
-[[Category:SdmxDataFormat|Data Formats]]
+[[Category:SdmxDataFormat]]
 = Overview =
 Fusion Registry accepts and outputs datasets in a number of formats.  When consuming data, the Fusion Registry will analyse the dataset to try to determine what data format it has received, so that it is able to direct it to the right reader.  All datasets are read by the Fusion Registry in excatly the same way, so any data processing performed on a Dataset is the same, regardless of the input Data Format.

@@ Line 30: / Line 30: @@
 ==CSV Formats==
-There are a number of CSV 'flavours' supported by Fusion Software, including the [[SDMX-CSV]] format which is an official SDMX data format.
+There are a number of CSV 'flavours' supported by Fusion Software, including the [[SDMX-CSV]] format which is an official SDMX data format. It is recommended to use the SDMX CSV format version 2 if you cannot decide which format to use.
 <p>The following Formats and correspoding VND Headers are supported: </p>

← Older revision		Revision as of 13:13, 6 September 2023
Line 1:		Line 1:
		+	[[Category:SdmxDataFormat\|Data Formats]]
	= Overview =		= Overview =
	Fusion Registry accepts and outputs datasets in a number of formats. When consuming data, the Fusion Registry will analyse the dataset to try to determine what data format it has received, so that it is able to direct it to the right reader. All datasets are read by the Fusion Registry in excatly the same way, so any data processing performed on a Dataset is the same, regardless of the input Data Format.		Fusion Registry accepts and outputs datasets in a number of formats. When consuming data, the Fusion Registry will analyse the dataset to try to determine what data format it has received, so that it is able to direct it to the right reader. All datasets are read by the Fusion Registry in excatly the same way, so any data processing performed on a Dataset is the same, regardless of the input Data Format.

@@ Line 41: / Line 41: @@
 ! Argument !! Description !! Supported Values !! Default !! Supported Formats
 |-
-| version || the version of the format|| 1.0.0 || 1.0.0 || [[SDMX-CSV]], [[Fusion-CSV]], [[Fusion-CSV-TS]]
+| version || the version of the format|| 1.0.0, 2.0.0 [[SDMX-CSV]] only || 1.0.0 || [[SDMX-CSV]], [[Fusion-CSV]], [[Fusion-CSV-TS]]
 |-
 | timeFormat ||  values are converted to the most granular ISO 8601 representation <br/>taking into account the highest frequency of the data in the message|| original or normalized || original  || [[SDMX-CSV]]

@@ Line 14: / Line 14: @@
 |-
 ! Accept Header !! Format
 |-
 | application/vnd.sdmx.data+edi|| [[SDMX-EDI Data|SDMX EDI]]
 |-
 | application/vnd.sdmx.structurespecificdata+xml;version=2.1|| [[SDMX-ML Structure Specific Data|Structure Specific]] (2.1)
@@ Line 24: / Line 26: @@
 |-
 | application/vnd.sdmx.genericdata+xml;version=2.1|| [[SDMX-ML Generic Data|Generic]] (2.1/2.0/1.0)
 |}

← Older revision		Revision as of 20:07, 30 June 2020
Line 10:		Line 10:
	SDMX Fomats are supported as described by the [https://github.com/sdmx-twg/sdmx-rest/blob/master/v2_1/ws/rest/docs/4_6_conneg.md web services specification]		SDMX Fomats are supported as described by the [https://github.com/sdmx-twg/sdmx-rest/blob/master/v2_1/ws/rest/docs/4_6_conneg.md web services specification]

		+	Accept Headers
		+	{\| class="wikitable"
		+	\|-
		+	! Accept Header !! Format
		+	\|-
		+	\| application/vnd.sdmx.data+edi\|\| [[SDMX-EDI Data\|SDMX EDI]]
		+	\|-
		+	\| application/vnd.sdmx.data+json;version=1.0.0\|\| [[SDMX-JSON Data\|SDMX JSON]]
		+	\|-
		+	\| application/vnd.sdmx.structurespecificdata+xml;version=2.1\|\| [[SDMX-ML Structure Specific Data\|Structure Specific]] (2.1)
		+	\|-
		+	\| application/vnd.sdmx.structurespecificdata+xml;version=2.0\|\| Compact (2.0/1.0)
		+	\|-
		+	\| application/vnd.sdmx.genericdata+xml;version=2.1\|\| [[SDMX-ML Generic Data\|Generic]] (2.1/2.0/1.0)
		+	\|-
		+	\| application/vnd.sdmx.data+csv;version=1.0.0\|\| [[SDMX-CSV\|SDMX CSV]]
		+	\|}

	==CSV Formats==		==CSV Formats==