Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
    • Switch to GitLab Next
  • Sign in / Register
  • dotstatsuite-excel-addin dotstatsuite-excel-addin
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Issues 17
    • Issues 17
    • List
    • Boards
    • Service Desk
    • Milestones
    • Iterations
    • Requirements
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
    • Test Cases
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages & Registries
    • Packages & Registries
    • Package Registry
    • Container Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Code review
    • Insights
    • Issue
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

GitLab 15.0 is launching on May 22! This version brings many exciting improvements, but also removes deprecated features and introduces breaking changes that may impact your workflow. To see what is being deprecated and removed, please visit Breaking changes in 15.0 and Deprecations.

  • SIS-CC
  • Stat Suite
  • dotstatsuite-excel-addindotstatsuite-excel-addin
  • Issues
  • #3
Closed
Open
Created Jul 27, 2019 by Jens Dossé@dosse💬Owner

Save back edited observation and attribute values in a flat or time-series oriented table view

As a data producer
In order to edit observation and attribute values (stored or to be stored in an .Stat Suite data space)
I want to be able to do this in a flat or time-series oriented (across or down) Excel table

Scenario 1: Save selected edited data back into same .Stat Suite data space as used for extraction
Given that I already have a flat or time-series oriented Excel table filled with data (linked to a .Stat Suite data space through a previous extraction)
And I have made a selection within the table
When I press on a button "Save selected data"
Then the currently selected data is uploaded to the .Stat Suite data space

Scenario 2: Save all edited data back into same .Stat Suite data space as used for extraction
Given that I already have a multi-dimensional Excel table filled with data (linked to a .Stat Suite data space through a previous extraction)
When I press on a button "Save all table data"
Then all the data of the table (in which the current Excel cell is located) is uploaded to the .Stat Suite data space

Note: the toolbar is split in 4 areas:

Area 1 2 3 4
Area Title Get Data Save to Database Refresh Help
* * * *
Icon 1 New Table Selected Data Current Sheet Help
Icon 2 Change Selection Entire Table All Sheets

image
These new icons and menu titles are to be applied.

Notes:

  • Arabic text is to be supported.
  • User's write access rights need to be respected. Using the authorisation web service, the application should check if the current user is allowed to submit data for the given dataflow and disable the two above buttons if the user has no access rights.
  • Currently the transfer server accepts imports only when observations values are submitted together with all attribute values (at all levels). This needs to be made more flexible, see ticket dotstatsuite-core-transfer#61 (closed) which should be done with priority.
  • Meanwhile, the get data feature should be extended to retrieve all attribute values, including those defined at higher levels, when the 'Flags' option is selected. Higher-level attribute values are replicated for each time-series in the 2 time-series formats and for each observation in the flat format.
  • The 'Flags' option is to be relabelled to "Attributes".
Edited Apr 16, 2020 by Jens Dossé
Assignee
Assign to
Time tracking