Add code selector for coded components in edited table
As David,
I want - when adding and editing data or ref. metadata - to be able to choose dimension, attribute and ref. metadata values from a list of the underlying allowed codes if those components are coded (have a codelist representation) and the SID/Coordinates cells and the dimension column cells (if present) are automatically prefilled/updated,
So that I do not have to remember all the possible code IDs and enter them manually.
Functional specifications
-
Combined into the existing DLM Excel add-in ribbon menu for editing of referential metadata (and into the related context-sensitive menu), allow a specific cell edit action also whenever the cursor is on a cell representing the values of a dimension, coded attribute or coded ref. metadata attribute.
Note: Please also update the icon to an "Edit" icon.
-
When clicking on this menu item on cells in already existing table rows, then the side panel opens, which contains a dimension item tree list selector similarly to the filter editor in the wizard. If the cell already contains a value, the related item in the tree is pre-selected. Only one single item can be selected in the tree (thus use radio buttons). Ideally, allow filtering the items (spotlight feature, see screenshot) and viewing only the selected item.
When the user clicks onAPPLY
then the current table cell as well as the SID/Coordinates cell is automatically updated with the selected dimension item. -
When clicking on this menu item on cells in a newly added row at the end of the table, then a wizard panel opens, which contains a dimension selector and a dimension item tree list selector similarly to the filter editor in the wizard. For all dimensions, several items per dimension can be selected in the trees. Ideally, allow filtering the items (spotlight feature, see screenshot) and viewing only the selected items. For data tables, the
APPLY
button becomes available only after having selected items in all dimensions. For ref metadata, it is allowed to not make any selection.
When the user clicks onAPPLY
then the table is automatically extended with all the rows corresponding to the combination of all selected dimensions items (incl. SID/Coordinates cells).
In addition:
- The tree only shows allowed items (retrieved through rest URL option
detail=referencepartial
). Even more accurate would be self-applying the allowed content constraint (especially when 2 dimensions use the same codelist). However, don't filter by actual content constraints (only values with data). - If possible easily (otherwise in another ticket) display the items according to the codelist tree structure.
- When clicking on the 'Edit data - Cell' menu when currently a ref. metadata cell is selected then the ref. metadata editor is shown.
- When moving from one cell to another while any editor (code/ref. metadata) is open, the related editor of the new cell is opened automatically. The current editor only closes completely when moving to a cell that has no editor linked. The
APPLY
button acts then on all cells being edited. - Allow the user to choose between "Merge", "Replace" and "Delete".