[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

@@ -16,6 +16,10 @@ class DistributionTableImportWizard(models.TransientModel):
 
     import_file = fields.Binary(string="Import File (*.csv)")
     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.')
+
 
     @api.constrains('import_file')
     def _constrains_import_file(self):
@@ -47,10 +51,10 @@ class DistributionTableImportWizard(models.TransientModel):
         try:
             csv_options = {}
 
-            csv_options["delimiter"] = ','
-            csv_options["quotechar"] = '"'
+            csv_options["delimiter"] = self.delimiter
+            csv_options["quotechar"] = self.quotechar
             try:
-                decoded_file = data_file.decode("utf-8")
+                decoded_file = data_file.decode(self.encoding)
             except UnicodeDecodeError:
                 detected_encoding = chardet.detect(data_file).get("encoding", False)
                 if not detected_encoding: