Use "Coordinates" instead of "SID" when getting & saving flat data & ref. metadata tables, make DIM columns optional when saving
As Gyorgy,
I want that the DLM Excel add-in generates flat data and ref. metadata tables with a "Coordinates" column instead of the current "SID" column and that the "Save" feature supports this and doesn't require the presence of any dimension columns,
So that I can use the current output of the .Stat V7 get.metadata Direct-Access method to easily import data into V8 using the DLM Excel add-in.
Functional specifications
- The new format with column label "Coordinates" only applies to
flat
data and ref. metadata tables, but not totime-series across
ortime-series down
data table flavors where "SID" is still applied. - The
Save
method should remain backward compatible and still allow saving (meta-)data from legacy flat tables that use theSID
column. - Requested format when Retrieving flat metadata table:
- To be allowed format when Saving flat metadata table:
- To remain allowed alternative format when Saving flat metadata table (current format for legacy tables):
- Requested format when Retrieving flat data table:
- To be allowed format when Saving flat data table:
- To remain allowed alternative format when Saving flat data table (current format for legacy tables):
Example data
Edited by jean-baptiste nonin