Upload issue of uncoded dataset attributes using the EDD mechanism
I have an issue uploading dataset level's non-coded attributes using the EDD mechanism.
My dataset level attributes CONTACT, LAST_UPDATE, SURVEY, LINK, MATRIX, DATABASE are stored in "metadata" sheet. And in EDD file I defined them as:
<Dataset-Attribute-Mapping Worksheet="metadata">
<Attribute Code='CONTACT' Value='Cell("C2").Value' />
<Attribute Code='LAST_UPDATE' Value='Cell("C3").Value' />
<Attribute Code='SURVEY' Value='Cell("C4").Value' />
<Attribute Code='LINK' Value='Cell("C5").Value' />
<Attribute Code='MATRIX' Value='Cell("C6").Value' />
<Attribute Code='DATABASE' Value='Cell("C7").Value' />
</Dataset-Attribute-Mapping>
But when uploading the data file, observations get uploaded, but dataset attributes - not.
DSD_POP_DF_ACTIVITY_Q.xml
Activity_rate_edd_trimestriel.xml
je-f-03.02.00.01.02_upload.xlsx
I used the EDD examples that Aleksei previously provided, but when uploading these files to qa:reset, the data upload is successful and says:
10/01/2020 08:31:01 NOTICE
The structure information of dataflow IT1:264D_264_SALDI2_2(1.0) was successfully loaded from dataspace staging:SIS-CC-reset.
10/01/2020 08:31:05 NOTICE
100 observations are being processed.
10/01/2020 08:31:06 NOTICE
The request was successfully processed.
But no observations are returned for this DF at all. http://nsi-reset-qa-oecd.redpelicans.com/rest/data/IT1,264D_264_SALDI2_2,2.0