Add New Output To Export All EBD In One Excel File

Hochfrequenz / ebdamame

Python library to scrape .docx files with "Entscheidungsbaumdiagramm" tables into a truely machine readable structure

GNU General Public License v3.0

0 stars 0 forks source link

Open hf-krechan opened 2 months ago

hf-krechan commented 2 months ago

Claudia would like to have an Excel file which contains all EBD tables.

The goal is to have something similar like the following excel file EBD_GPKE_LFW.xlsx

We do not need to fill column Häufigkeit.

[ ] Add a new subcommand to the ebdamame cli interface to export one excel file with all EBDs. See kohlrahbi as an example.
[ ] Add flag to choose format version
[ ] Add flag to choose EBDs (if no EBD flag is given, export all EBDs)
[ ] Add flag to set path to edi energy mirror (there are all EBD documents)
[ ] Add flag to set path to machine readable anwendungshandbücher (this is needed to check in which prüfis is the EBD)

OLILHR commented 2 months ago

important columns: C D F G I J K (basically everything an EBD is made off) + M

hf-kklein commented 2 months ago

OK, let's split this into easy-to-handle isolated features:

[ ] (0) allow excel export
[ ] (1) instead of a docx file it should be possible to provide a path to a directory
[ ] (2) add a wrapper around (1) that, given a path to edi_energy_mirror, exports all the files from a specific format version (which translates to a sub-directory)
[ ] (3) add a feature that, given a list of machine-readable AHBs, returns the prüfis of those that refer to a given EBD (str)
[ ] (4) add a wrapper around (3) that accepts the machine-readable-ahb repo + format version as argument, and reads the AHB information from there

So basically it's 3 real features (0), (1) and (3) and two utiliy functions/wrappers (2) + (4) around those features.