SDMX-CSV Data - Revision history

Vmurrell: /* Overview */

2023-08-14T10:18:17Z

‎Overview

Vmurrell: /* Formatting Using Query Parameters */

2023-07-17T12:25:02Z

‎Formatting Using Query Parameters

Plazarou: /* Formatting Using Query Parameters */

2023-06-09T11:34:38Z

‎Formatting Using Query Parameters

Plazarou: /* Example of SDMX CSV version 1.0.0 */

2022-10-27T15:36:51Z

‎Example of SDMX CSV version 1.0.0

Plazarou: /* Example */

2022-10-27T15:36:28Z

‎Example

Plazarou: /* Example */

2022-10-27T15:23:45Z

‎Example

Plazarou: /* Example */

2022-10-27T15:22:56Z

‎Example

Plazarou: /* Example */

2022-10-27T15:22:42Z

‎Example

Plazarou: /* Example of SDMX CSV version 1.0.0 */

2022-10-27T15:21:12Z

‎Example of SDMX CSV version 1.0.0

Plazarou: /* Example of SDMX CSV version 1.0.0 */

2022-10-27T15:15:57Z

‎Example of SDMX CSV version 1.0.0

@@ Line 1: / Line 1: @@
 [[Category:FMR Formats Reference]]
 =Overview=
-The SDMX-CSV Data format is an official SDMX format described on the [https://github.com/sdmx-twg/sdmx-csv/tree/master/data-message SDMX GitHub Repository]. It comes in 2 flavours, the older [https://github.com/sdmx-twg/sdmx-csv/blob/v1.0/data-message/docs/sdmx-csv-field-guide.md version 1.0.0 format] or the newer [https://github.com/sdmx-twg/sdmx-csv/blob/master/data-message/docs/sdmx-csv-field-guide.md version 2.0.0 format]. Metadata Technology recommend using the newer version 2.0.0 format.
+The SDMX-CSV Data format is an official SDMX format described on the [https://github.com/sdmx-twg/sdmx-csv/tree/master/data-message SDMX GitHub Repository]. It comes in 2 flavours, the older [https://github.com/sdmx-twg/sdmx-csv/blob/v1.0/data-message/docs/sdmx-csv-field-guide.md version 1.0.0 format] or the newer [https://github.com/sdmx-twg/sdmx-csv/blob/master/data-message/docs/sdmx-csv-field-guide.md version 2.0.0 format]. Using the newer version 2.0.0 format is recommended.
 It can be used as both an import and export format for the Fusion Metadata Registry, and an export format for the Fusion Edge Server and Fusion Data Browser.

@@ Line 27: / Line 27: @@
 | timeFormat || normalized || outputs the time in the highest-frequency.  E.g if annual data is supplied, but the highest frequency is daily, then 2001 would become either 2001-01-01 or 2001-12-31 depending on whether startPeriod or endPeriod is used.
 |-
-| serieskey  || '''include ''' or '''exclude'''  <br/> default exclude   || If true, a series key column will be included in the output
+| serieskey  || '''include ''' or '''exclude'''  <br/> default exclude   || If true, a series key column will be included in the output. Example -:-,-true-y.
 |-
 | bom || '''include ''' or '''exclude'''  || (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)

@@ Line 30: / Line 30: @@
 |-
 | bom || '''include ''' or '''exclude'''  || (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)
 |}

@@ Line 79: / Line 79: @@
 =Example of SDMX CSV version 1.0.0=
 An example query using the format request parameters, [[Data_Formats|HTTP Accept Headers]] can also be used to define the same format.<br/>
-<i>https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/WB/GCI/1.0/?c%5BREF_AREA%5D=GHA&c%5BINDICATOR%5D=GCI&format=sdmx-csv-1.0.0</i>
+https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/WB/GCI/1.0/?c%5BREF_AREA%5D=GHA&c%5BINDICATOR%5D=GCI&c%5BSUB_INDICATOR%5D=RANK&format=sdmx-csv-1.0.0</i>
 An example dataset with IDs only, spaces have been added to this example to assist readability.

@@ Line 49: / Line 49: @@
 An example dataset with IDs only, spaces have been added to this example to assist readability.
 <pre>
-DATAFLOW,    REF_AREA, INDICATOR, SUB_INDICATOR, FREQ, TIME_PERIOD, OBS_VALUE
+STRUCTURE, STRUCTURE_ID, ACTION, REF_AREA, INDICATOR, SUB_INDICATOR, FREQ, TIME_PERIOD, OBS_VALUE
-WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2008,        102
+dataflow,  WB:GCI(1.0),  I,      GHA,      GCI,       RANK,          A,    2008,        102
-WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2009,        114
+dataflow,  WB:GCI(1.0),  I,      GHA,      GCI,       RANK,          A,    2009,        114
-WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2010,        114
+dataflow,  WB:GCI(1.0),  I,      GHA,      GCI,       RANK,          A,    2010,        114
-WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2011,        114
+dataflow,  WB:GCI(1.0),  I,      GHA,      GCI,       RANK,          A,    2011,        114
-WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2012,        103
+dataflow,  WB:GCI(1.0),  I,      GHA,      GCI,       RANK,          A,    2012,        103
-WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2013,        114
+dataflow,  WB:GCI(1.0),  I,      GHA,      GCI,       RANK,          A,    2013,        114
-WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2014,        111
+dataflow,  WB:GCI(1.0),  I,      GHA,      GCI,       RANK,          A,    2014,        111
 </pre>
 The same dataset in SDMX-CSV with labels included.
 <pre>
-DATAFLOW,                                  REF_AREA:Reference Area, INDICATOR:Indicator,               SUB_INDICATOR:Sub Indicator, FREQ:Frequency, TIME_PERIOD:Time period, OBS_VALUE:Observation
+STRUCTURE, STRUCTURE_ID,                              ACTION, REF_AREA:Reference Area, INDICATOR:Indicator,               SUB_INDICATOR:Sub Indicator, FREQ:Frequency, TIME_PERIOD:Time period, OBS_VALUE:Observation
-WB:GCI(1.0): Global Competitiveness Index, GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2008,                    102
+dataflow,  WB:GCI(1.0): Global Competitiveness Index, I,      GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2008,                    102
-WB:GCI(1.0): Global Competitiveness Index, GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2009,                    114
+dataflow,  WB:GCI(1.0): Global Competitiveness Index, I,      GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2009,                    114
-WB:GCI(1.0): Global Competitiveness Index, GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2010,                    114
+dataflow,  WB:GCI(1.0): Global Competitiveness Index, I,      GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2010,                    114
-WB:GCI(1.0): Global Competitiveness Index, GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2011,                    114
+dataflow,  WB:GCI(1.0): Global Competitiveness Index, I,      GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2011,                    114
-WB:GCI(1.0): Global Competitiveness Index, GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2012,                    103
+dataflow,  WB:GCI(1.0): Global Competitiveness Index, I,      GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2012,                    103
-WB:GCI(1.0): Global Competitiveness Index, GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2013,                    114
+dataflow,  WB:GCI(1.0): Global Competitiveness Index, I,      GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2013,                    114
-WB:GCI(1.0): Global Competitiveness Index, GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2014,                    111
+dataflow,  WB:GCI(1.0): Global Competitiveness Index, I,      GHA: Ghana,              GCI: Global Competitiveness Index, RANK: Rank,                  A: Annual,      2014,                    111
 </pre>

@@ Line 45: / Line 45: @@
 =Example=
 An example query using the format request parameters, [[Data_Formats|HTTP Accept Headers]] can also be used to define the same format.<br/>
-<i>https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/WB/GCI/1.0/?c%5BREF_AREA%5D=GHA&c%5BINDICATOR%5D=GCI&c%5BSUB_INDICATOR%5D=RANK&format=sdmx-csv-1.0.0
+<i>https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/data/dataflow/WB/GCI/1.0/?c%5BREF_AREA%5D=GHA&c%5BINDICATOR%5D=GCI&c%5BSUB_INDICATOR%5D=RANK&format=sdmx-csv</i>
 An example dataset with IDs only, spaces have been added to this example to assist readability.