Odoo Mindscape. Understand Odoo faster. Explore modules, fields, dependencies and version differences in one place instead of digging through the source code.

Module: Excel Import/Export/Report

Entity: xlsx.template

Compute Method: _compute_output_instruction

View 18.0
Inputs Method Outputs
  • section_type
  • sheet
  • row_field
  • is_cont
  • is_extend
  • excel_cell
  • no_delete
  • field_name
  • field_cond
  • post_import_hook
+ """From database, compute back to dictionary"""
+ for rec in self:
+             inst_dict = {}
+             prev_sheet = False
+             prev_row = False
+             # Export Instruction
+             itype = "__EXPORT__"
+             inst_dict[itype] = {}
+             for line in rec.export_ids:
+                 if line.section_type == "sheet":
+                     sheet = co.isinteger(line.sheet) and int(line.sheet) or line.sheet
+                     sheet_dict = {sheet: {}}
+                     inst_dict[itype].update(sheet_dict)
+                     prev_sheet = sheet
+                     continue
+                 if line.section_type in ("head", "row"):
+                     row_field = line.row_field
+                     if line.section_type == "row" and line.is_cont:
+                         row_field = f"_CONT_{row_field}"
+                     if line.section_type == "row" and line.is_extend:
+                         row_field = f"_EXTEND_{row_field}"
+                     row_dict = {row_field: {}}
+                     inst_dict[itype][prev_sheet].update(row_dict)
+                     prev_row = row_field
+                     continue
+                 if line.section_type == "data":
+                     excel_cell = line.excel_cell
+                     field_name = self._compose_field_name(line)
+                     cell_dict = {excel_cell: field_name}
+                     inst_dict[itype][prev_sheet][prev_row].update(cell_dict)
+                     continue
+             # Import Instruction
+             itype = "__IMPORT__"
+             inst_dict[itype] = {}
+             for line in rec.import_ids:
+                 if line.section_type == "sheet":
+                     sheet = co.isinteger(line.sheet) and int(line.sheet) or line.sheet
+                     sheet_dict = {sheet: {}}
+                     inst_dict[itype].update(sheet_dict)
+                     prev_sheet = sheet
+                     continue
+                 if line.section_type in ("head", "row"):
+                     row_field = line.row_field
+                     if line.section_type == "row" and line.no_delete:
+                         row_field = f"_NODEL_{row_field}"
+                     row_dict = {row_field: {}}
+                     inst_dict[itype][prev_sheet].update(row_dict)
+                     prev_row = row_field
+                     continue
+                 if line.section_type == "data":
+                     excel_cell = line.excel_cell
+                     field_name = line.field_name or ""
+                     field_name += line.field_cond or ""
+                     cell_dict = {excel_cell: field_name}
+                     inst_dict[itype][prev_sheet][prev_row].update(cell_dict)
+                     continue
+             itype = "__POST_IMPORT__"
+             inst_dict[itype] = False
+             if rec.post_import_hook:
+                 inst_dict[itype] = rec.post_import_hook
+             rec.instruction = inst_dict
  • instruction

Back to entity