Upload new or updated variables in bulk

[densoutar]

As a(n) Inventory Manager & Sector Expert and System Administrator I want to (be/be able to) upload new or updated variables (e.g. emission factors or activity data or other variables including source references and other documentation) in bulk to the database So that the system will update the new inventory with the new variables

Acceptance Criteria

• Defined inventory data is successfully uploaded when it is submitted in the defined format and file type (preferrably .xls)
• System warns uploader if data points are going to be overwritten for variables for years already present in the database. Uploader can abort if needed or roll back to pre upload version.
• Where a datapoint is left blank or has the same value in the upload template, the corresponding system datapoint is not overwritten.
• System aborts upload and warns user when the data is submitted in the incorrect format and file type
• Warnings are provided if data does not meet defined automatic QC criteria (Criteria = extreme slopes or dips and jumps in timeseries; significant differences from replaced/over written variables.)
• Warnings are easily understood and recommend specific troubleshooting steps
• System displays confirmation of a successful upload

[paradoxxjm]

• [ ] SPIKE: Uploading, parsing and storing of Excel Files (#33)
• [ ] Define template to be used by sector experts to upload GHG activity data to the database
• [ ] Defining workflow for uploading process
• [ ] Creating UI based on agreed workflow