Allow managing higher-level ref. metadata referencing DSD with the Excel Add-in
As Yavuz,
I want to be able to retrieve, edit and submit higher-level ref. metadata referencing both DF and DSD,
So that I can fully manage the content of all referential metadata.
Detailed specifications
Once dotstatsuite-core-sdmxri-nsi-ws#422 is implemented, the SDMX-CSV response from the NSI for ref. metadata for a DF will also include those at higher-levels related to the DSD (in different datasets).
All ref. metadata continue to be presented in one table, but there will be a new column titled SCOPE
before the SID
column with the relationship DF
or DSD
:
When the user saves this information, then, depending on the selection, the Excel Add-in generates two separate uploads, one for the higher-level ref. metadata related to the DSD and one for all the ref. metadata related to the DF (all obs.-level and some higher-level).
Ideally, the DLM should take into account the user's permissions for inserting/updating/deleting data for the dataflow and for the DSD. Upload files are only generated for those structures with appropriate permissions. Warn the user if a permission is missing.
Example
Reusing test data from Postman test ('referential-metadata-DF-DSD-levels'):
- structures: OECD.SDD.SDPS_DF_TEST_REF_METADATA_1_1.0_-_structures.xml
- data: OECD.SDD.SDPS-DF_TEST_REF_METADATA_1-1.0-data.csv
- ref. metadata at DSD level: OECD.SDD.SDPS-DSD_TEST_REF_METADATA-1.0-DSD%20Level%20Metadata.csv
- ref. metadata at DF level: OECD.SDD.SDPS-DF_TEST_REF_METADATA_1-1.0-metadata.csv