[IMP] energy_selfconsumption: importation of selfconsumption inscriptions, supply points and distribution tables by CSV

Trello Card

Changelog

• [IMP] energy_selfconsumption: Added wizard to import self-consumption inscriptions and supply points
• [IMP] energy_selfconsumption: Added wizard to import distribution tables
• [IMP] energy_selfconsumption: Added two attachments to be downloaded from the wizard as templates. The attachments are public and can be downloaded by anyone without login.
• [IMP] energy_selfconsumption: Added attachments to be downloaded from the wizard of selfconsumption import with list of all Spanish state codes.
• [IMP] energy_selfconsumption: Added field partner_id in supply points to indicate partner that has to be subscribed to the project.
• [IMP] energy_selfconsumption: SQL constraint to assure that a supply point code is unique for every company (can be same code for different companies)
• [IMP] energy_selfconsumption: updated security rules for only admins to be able to import.
• [FIX] energy_project: removed required of inscriptions to be able to remove them.
• [FIX] energy_project: inscription set on delete to cascade to remove them when deleting project.
• [FIX] energy_selfconsumption_cooperator: removed field cooperator_id and inheritance in views as this field function is implemented in the main module for the new field partner_id

energy_selfconsumption/wizards/selfconsumption_import_wizard.py

@@ -79,9 +79,9 @@ class SelfconsumptionImportWizard(models.TransientModel):
             logger.warning("Parser error", exc_info=True)
             raise UserError(_("Error parsing the file"))
 
-    def import_line(self, line, project):
+    def import_line(self, line_dict, project):
         partner = self.env['res.partner'].search([
-            '|', ('vat', '=', line['partner_vat']), ('vat', '=ilike', line['partner_vat'])
+            '|', ('vat', '=', line_dict['partner_vat']), ('vat', '=ilike', line_dict['partner_vat'])
         ], limit=1)
 
         if not partner:
@@ -97,7 +97,7 @@ class SelfconsumptionImportWizard(models.TransientModel):
             except:
                 return False, _('Could not create inscription for {vat}.').format(vat=line_dict['partner_vat'])
 
-        supply_point = self.env['energy_selfconsumption.supply_point'].search([('code', '=', line['code'])])
+        supply_point = self.env['energy_selfconsumption.supply_point'].search([('code', '=', line_dict['code'])])
 
         if supply_point and supply_point.partner_id != partner:
             return False, _(