NTNU-IndEcol / BuildME

6 stars 1 forks source link

Do not overwrite replace.xlsx #38

Closed nheeren closed 2 years ago

nheeren commented 2 years ago

As discussed with @kamilitsa, I would prefer if the MMV script would not write directly into the ./data/replace.xlsx. I suggest to do the following instead:

  1. See if MMV template archetype is present in ./data/archetype (see #30)
  2. Run change_archetype_to_MMV() on missing templates
  3. Write required inputs to ./data/replace_mmv.xlsx, which has a first sheet info specifying the date of creation / update.

Then when running BuildME:

  1. Load replace.xlsx and replace_mmv.xlsx
  2. Merge them into one dataframe
  3. Continue script as usual.

Does this make sense? @kamilitsa Would you like to take this on or should I?

kamilakrych commented 2 years ago

I can do it. The approach makes sense I think :)