IE_data_commons icon indicating copy to clipboard operation
IE_data_commons copied to clipboard

Changes of IEDC Excel data template and export routines

Open stefanpauliuk opened this issue 7 years ago • 7 comments

Note necessary and optional changes here so that they can be reviewed and become part of next version.

stefanpauliuk avatar Sep 06 '18 06:09 stefanpauliuk

So this is something like a wishlist :christmas_tree:? Let me add one thing. Parsing the Cover sheet was a quite tedious. We should rethink that. I can make a proposal.

nheeren avatar Sep 06 '18 13:09 nheeren

Sure, we can design a version 2 format. Note that the left part of the cover sheet is just a 1:1 copy of the dataset table entry. Here we don't have much flexibility.

stefanpauliuk avatar Sep 06 '18 14:09 stefanpauliuk

Another thing: IMO there should be no distinction between TABLE and LIST type data. The LIST type is basically a simple from of the TABLE type. Therefore the definitions of aspects & classifications (currently in the Cover sheet) should be 100% harmonized between the two. Right now I have to use a lot of case distinctions in my code which could be simplified then.

nheeren avatar Nov 24 '18 18:11 nheeren

When creating a custom classification directly from the data template, we have now: classification_Name = aspect_datasetName, e.g. commodity__1_F_steel_SankeyFlows_2008_Global

Please change the parser to do the following:

  • for description: from "generated by IEDC_tools v0.2" to "Custom classification, generated by IEDC_tools v0.2"
  • for meaning_attribute1: from "None" to "[aspect] aspect of dataset"

stefanpauliuk avatar Jan 22 '19 10:01 stefanpauliuk

  • for meaning_attribute1: from "None" to "[aspect] aspect of dataset"

Do you mean that literally or should "[aspect]" be replaced with something? Please give an example.

nheeren avatar Feb 05 '19 11:02 nheeren

Please replace [aspect] by the actual aspect (aspect.aspect for aspect.id = datasets.aspectx). E.g. "origin_region aspect of dataset" "age-cohort aspect of dataset"

stefanpauliuk avatar Feb 05 '19 12:02 stefanpauliuk

  • for description: from "generated by IEDC_tools v0.2" to "Custom classification, generated by IEDC_tools v0.2"
  • for meaning_attribute1: from "None" to "[aspect] aspect of dataset"

Done.

nheeren avatar Feb 06 '19 08:02 nheeren