[Specification] Update how the OED specification is stored, move from excel to csv

sambles commented 2 weeks ago

Description

Its tricky to track changes to the specification via github because the main spec is stored as a single excel object. A better method would be to flip this around.

specification is stored in CSV format
on each commit the csv files are built into an excel file for review (by GitHub actions)
on each release an excel file is attached to that release as an asset.
automate release notes for OED spec changes

Move OpenExposureData/utils/gencsv.py and OpenExposureData/utils/genexcel.py --> OpenDataStandards/docker/ along with extract_spec.py

johcarter commented 2 weeks ago

can hidden columns be removed in this change? eg SecMod? BackEndTableName etc in OED Input Fields

johcarter commented 1 week ago

yes to remove hidden columns

OasisLMF / ODS_OpenExposureData

[Specification] Update how the OED specification is stored, move from excel to csv #192

Description