...
Note: Units has moved to directly after "Field" for ease of finding it.
Above the data section (See image below), each column header will be a "key". The key is aiming to uniquely identify each column but also retain some information of the column metadata to make it more user friendly. The key is made up of two parts, the "Field" metadata (unique within the res.csv file) and a descriptive part (not necessarily unique within the res.csv file). The metadata should be referenced via the field when distinguishing the differences between each column. The key will always start with the "Field" metadata to make it unique, but to descriptive part depends on where it is exported from:
...
From Data Sources or any place that DOESN'T have all the metadata it will be: Field > Name
...
When exporting
From Results Manager or any place in which has all the adequate metadata to qualify for a "Result" we intend to use it will populate the metadata fields such as scenario, run name, input sets, site, structure, etc but NOT the name "Name" field
From Data Sources or any place that DOESN'T have all the metadata we intend to use will populate the name field for generating a key, and only some of the other metadata fields will be used like units and input sets (Although input sets will have a different meaning) all unused fields will be empty. This is because these metadata fields will be stripped when reading them in to certain places like Data Sources.
Reading into Results Manager
When Data was exported from Results Manager a it should be able to use the metadata to recreate the key in such a way it will replicate a tree structure that it had before it was exported
When Data was exported from a place that didn't insert all the metadata (such as Data Sources) it will appear to flatten the data.
...
Reading into Data Sources
We think it will be best to strip most of this data - as the metadata doesn't necessarily represent what it did when it was exported and user can rename the data, and it would be difficult to keep to maintain that
...
Input set: input sets in Data Sources refers to which input sets this data source is assigned to rather than the input set that was used in the run when the data was created
...