Key Error 'einheitenaenderungnetzbetreiberzuordnungen'

[AhmadShelbayeh]

Description of the issue

Hey guys, I am getting a key error when downloading the Bulk data.
Code:
from open_mastr import Mastr
db = Mastr()
today_date = datetime.now().strftime('today')
db.download(method='bulk', data=["wind", "market", "permit", "deleted_units"], date=today_date)

KeyError: 'einheitenaenderungnetzbetreiberzuordnungen'

Steps to Reproduce

Ideas of solution

Context and Environment

Version used: 0.14.3. and 0.14.4.
Environment setup and (python) version: 3.11. & 3.12.

[FlorianK13]

Hi @AhmadShelbayeh
Based on this code line I assume that we have fixed this already. However a usual problem is that new versions of the database scheme are not initialized if an old database still exists. One solution should be that you delete your sqlite database (or the whole~/.open-mastr folder) and rerun your code.

If this does not work, you can answer again in this issue.

[AhmadShelbayeh]

@FlorianK13
Unfortunately, I deleted the entire folder and reran the code, but I am still encountering the same error. It seems the issue was not resolved by deleting the folder. Could you please help me troubleshoot this problem?

[AhmadShelbayeh]

@FlorianK13

This is the error:

Download has started, this can take several minutes.The download bar is only a rough estimate.
C:\Users\ahmad.shelbayeh.open-MaStR\data\xml_download\Gesamtdatenexport_20240930.zip: 19149 [09:20, 34.19/s]
Download is finished. It took 560 seconds.
MaStR was successfully downloaded to C:\Users\ahmad.shelbayeh.open-MaStR\data\xml_download.
Table 'wind_eeg' is filled with data 'anlageneegwind' from the bulk download.
File 'AnlagenEegWind.xml' is parsed.
Data is cleansed.
Traceback (most recent call last):

Cell In[1], line 13
db.download(method='bulk', data=[

File D:\Prog.cpy\Data\Anaconda3\envs\Ahmad\lib\site-packages\open_mastr\mastr.py:231 in download
write_mastr_xml_to_database(

File D:\Prog.cpy\Data\Anaconda3\envs\Ahmad\lib\site-packages\open_mastr\xml_download\utils_write_to_database.py:34 in write_mastr_xml_to_database
if is_table_relevant(

File D:\Prog.cpy\Data\Anaconda3\envs\Ahmad\lib\site-packages\open_mastr\xml_download\utils_write_to_database.py:76 in is_table_relevant
tablename_mapping[xml_tablename]["class"] is not None

KeyError: 'einheitenaenderungnetzbetreiberzuordnungen'

[FlorianK13]

And your version right now is 0.14.4? Because 0.14.3 would initialize the old database schema.

[AhmadShelbayeh]

@FlorianK13
How can I know my version, is it by run pip install --upgrade open-mastr, if yes my version is:
open-mastr in d:\prog.cpy\data\anaconda3\envs\ahmad\lib\site-packages (0.14.1)
how can solve it?

[FlorianK13]

Then you need to run pip install --upgrade open-mastr

[AhmadShelbayeh]

@FlorianK13
it works, thanks