SQL Export

sql_export · OCA/reporting-engine

    Repository
    OCA/reporting-engine · module folder · Try on Runboat
    Module version
    1.1.1
    Category
    Generic Modules/Others
    Folder size
    0.89 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    https://github.com/OCA/reporting-engine
    Last tracking update
    2026-08-07 08:43:02
    Authors
    Akretion, Odoo Community Association (OCA), GRAP
    Maintainers
    Akretion, Odoo Community Association (OCA), GRAP
    Committers
    Miquel Raïch, Florian da Costa, David Beal, Weblate, OCA-git-bot, oca-ci
    Odoo dependencies
    OCA/reporting-engine:
    - sql_request_abstract
    odoo/odoo:
    - spreadsheet_dashboard
    - spreadsheet
    - bus
    - base
    - web
    - portal
    - web_editor
    - html_editor
    - http_routing
    - mail
    - base_setup
    - web_tour
    - auth_signup
    Python dependencies
    None
    System dependencies
    None
    Required by
    sql_export_delta, sql_export_excel, sql_export_mail
    Description
    Allow to export data in csv files FROM sql requests. There are some
restrictions in the sql query, you can only read datas. No update,
deletion or creation are possible. A new sub menu named Sql Export is
available in the Dashboard main menu.

    Code Analysis ⓘ

    Views touched (3)
    XML IDNameModelTypeStatus
    sql_export_view_form sql.export form Inherits sql_request_abstract.view_sql_request_mixin_form
    sql_export_view_tree sql.export tree Inherits sql_request_abstract.view_sql_request_mixin_tree
    sql_file_wizard_view_form sql.file.wizard.view.form sql.file.wizard form New
    HTTP endpoints (0)

    No HTTP endpoints found for this module.

    Models touched (2)

    New fields (7)
    • copy_options Char
      default="CSV HEADER DELIMITER ';'" required=False
    • encoding Selection
      default='utf-8' required=True args: [('utf-8', 'utf-8'), ('utf-16', 'utf-16'), ('windows-1252', 'windows-1252'), ('latin1', 'latin1'), ('latin2', 'latin2'), ('big5', 'big5'), ('gb18030', 'gb18030'), ('shift_jis', 'shift_jis'), ('windows-1251', 'windows-1251'), ('koir8_r', 'koir8_r')]
    • file_format Selection
      default='csv' required=True args: [('csv', 'CSV')]
    • last_execution_date Datetime
      readonly=True
    • last_execution_uid Many2one → res.users
      readonly=True string='Last execution User' args: 'res.users'
    • query_properties_definition PropertiesDefinition
      args: 'Query Properties'
    • use_properties Boolean
      compute='_compute_use_properties'
    Public methods (3)
    • configure_properties(self)
    • csv_get_data_from_query(self, variable_dict)
    • export_sql_query(self)

    New fields (4)
    • binary_file Binary
      readonly=True args: 'File'
    • file_name Char
      readonly=True
    • query_properties Properties
      copy=False definition='sql_export_id.query_properties_definition' string='Properties'
    • sql_export_id Many2one → sql.export
      comodel_name='sql.export' required=True
    Public methods (1)
    • export_sql(self)

    Loading…

    Loading…

    Loading…

    Loading…

    Loading…

    Loading…

    Loading…

    Loading…

    Loading…

    Status
    Open migration PR — not merged yet for this version
    CI status
    green — ready to merge
    Open since
    30 days ago
    Last activity
    30 days ago
    Repository
    OCA/reporting-engine
    Pull request
    [19.0][MIG] sql_export: Migration to 19.0 (#1180)
    Status
    Open migration PR — not merged yet for this version
    CI status
    green — ready to merge
    Open since
    194 days ago
    Last activity
    58 days ago
    Repository
    OCA/reporting-engine
    Pull request
    [19.0][MIG] sql export: Migration to 19.0 (#1128)