Troubleshooting Semantic and Code List Errors in SDMX Converter

Read SDMX Converter Error Message and Resolve Them August 30th, 2023

How to read and fix errors generated How to read and fix errors generated by ESCWA SDG SDMX Converter errors by ESCWA SDG SDMX Converter errors Semantic error Key Series Not Allowed Semantic error Key Series Not Allowed content constraint is not met content constraint is not met Invalid code list Representation Invalid code list Representation means that the code used is not in the code list means that the code used is not in the code list Expected Type double Expected Type double means that a non means that a non- -numeric value is entered in the primary measure. numeric value is entered in the primary measure. Error description: No enum constant org.estat.sdmxsource.util.excel.ExcelPositionType.COLUMN It means the converter did not recognize the Position Type Column

Error 1: Semantic Error: Key Series Not Allowed Error 1: Semantic Error: Key Series Not Allowed It means the content constraint is not fully met; either a dimension is missing or wrong data entry, example below, after reviewing the content constraint we realize that FEMALE is missing in cell F17, and <5Y is missing in cell G18.

Error 2: Semantic Error: Key Series Not Allowed Error 2: Semantic Error: Key Series Not Allowed - - continued continued It means the content constraint is not fully met; either a dimension is missing or wrong data entry, example below, after reviewing the content constraint we realize that the correct series is Proportion of children moderately or severely stunted [2.2.1] [2.2.1], , not Proportion of children moderately or severely stunted [2.2.2] 2.2.2]

Error 3: Invalid code list Representation Error 3: Invalid code list Representation It means the code used is not available in the code list and does not match the code representation in the code list, to correct the errors, refer to the sheet Trans1 , and look for the correct code, in the examples below, male should be MALE, and PT should be PERCENT.

Error 4: Expected Type double Error 4: Expected Type double It means the primary measure must be numeric, to correct the error, we write 4.9 instead of 4,9

Dos & Donts Map internal code lists to DSD code lists. Preferably store transcoded codes in external files. Familiarity with the SDG DSD code lists SDG DSD code lists. . Familiarity with SDG Content Constraint SDG Content Constraint. . Use a Standard Excel template. For attributes; avoid adding unnecessary columns, if they can be mapped using FIX as the type of the position. It is recommended to use MIXED as the position type for dimensions. Check if the attribute UNIT_MULT is specified correctly. Validate against dataflow DF_SDG_GLC DF_SDG_GLC REPORTING_TYPE= N. Adding the date of the last update when you updated your datasets. Review SDMX converter error messages and correct them, until you get no error. Practice, Practice, and Practice! 7

Link Link https://datacatalog.unescwa.org/ ESCWA SDMX Converter for SDGs Java Desktop SDMX Converter Eurostat SDMX Online Converter ESCWA - Series of SDMX Trainings ESCWA - SDMX Crash Course I ESCWA - SDMX Crash Course II SDMX Global Registry SDMX SDG Page SDG Metadata Template SDG Metadata SDMX Converter User Manual Desktop SDMX Converter List of Error Messages Useful Links https://java.com/en/download/ https://bit.ly/3CwdjiA https://bit.ly/3HA28cg https://bit.ly/3y51Kzg https://bit.ly/3MZQ5Gc https://bit.ly/3xXnhse https://registry.sdmx.org/overview.html https://bit.ly/3zSWUX9 8 https://bit.ly/3N9B1ps https://bit.ly/39Fvmdc https://bit.ly/3ozvbYw https://bit.ly/3qMQGGg