normalization of nrens including datamigration

normalization of nrens including datamigration The NREN list is hardcoded in the db migration and no new NRENs are made automatically (the db migration crashes if an unknown NREN is found, the excel importers emit a warning and skip the entry). Some NRENs have old or alternative names, which is taken into account in the db migration file and in the publishers helpers.py file.

compendium_v2/background_task/parse_excel_data.py

@@ -39,7 +39,7 @@ def fetch_budget_excel_data():
                 # process the data (e.g. save to database)
                 # print(f"NREN: {nren}, Budget: {budget}, Year: {year}")
 
-                yield nren, budget, year
+                yield nren.upper(), budget, year
 
 
 def fetch_funding_excel_data():
@@ -92,7 +92,7 @@ def fetch_funding_excel_data():
 
             # process the data (e.g. save to database)
             if nren is not None:
-                yield (nren, year, client_institution,
+                yield (nren.upper(), year, client_institution,
                        european_funding,
                        gov_public_bodies,
                        commercial, other)
@@ -148,7 +148,7 @@ def fetch_charging_structure_excel_data():
                     f'NREN: {nren}, Charging Structure: {charging_structure},'
                     f' Year: {year}')
 
-                yield nren, year, charging_structure
+                yield nren.upper(), year, charging_structure
 
     # For 2021
     yield from create_points_for_year(3, 45, 2021, 2)