[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/distribution_table_import_wizard.py

@@ -18,8 +18,8 @@ class DistributionTableImportWizard(models.TransientModel):
     fname = fields.Char(string="File Name")
     delimiter = fields.Char(default=',', required=True, string='File Delimiter', help='Delimiter in import CSV file.')
     quotechar = fields.Char(default='"', required=True, string='File Quotechar', help='Quotechar in import CSV file.')
-    encoding = fields.Char(default='utf-8', required=True, string='File Encoding', help='Enconding format in import CSV file.')
-
+    encoding = fields.Char(default='utf-8', required=True, string='File Encoding',
+                           help='Enconding format in import CSV file.')
 
     @api.constrains('import_file')
     def _constrains_import_file(self):
@@ -37,7 +37,8 @@ class DistributionTableImportWizard(models.TransientModel):
         return True
 
     def download_template_button(self):
-        distribution_table_example_attachment = self.env.ref('energy_selfconsumption.distribution_table_example_attachment')
+        distribution_table_example_attachment = self.env.ref(
+            'energy_selfconsumption.distribution_table_example_attachment')
         download_url = '/web/content/{}/?download=true'.format(str(distribution_table_example_attachment.id))
         return {
             "type": "ir.actions.act_url",
@@ -72,6 +73,7 @@ class DistributionTableImportWizard(models.TransientModel):
 
         for index, line in enumerate(data[1:]):
             value = self.get_supply_point_assignation_values(line)
+
             supply_point_assignation_values_list.append((0, 0, value))
 
         distribution_table.write(
@@ -87,10 +89,10 @@ class DistributionTableImportWizard(models.TransientModel):
         }
 
     def get_supply_point_id(self, code):
-        supply_point = self.env['energy_selfconsumption.supply_point'].search([('code', '=', code)])
-        if not supply_point:
+        supply_point_id = self.env['energy_selfconsumption.supply_point'].search_read([('code', '=', code)], ['id'])
+        if not supply_point_id:
             raise ValidationError(_('There isn\'t any supply point with this code: {code}').format(code=code))
-        return supply_point.id
+        return supply_point_id[0]['id']
 
     def get_coefficient(self, coefficient):
         try: