Module: sql_export - Odoo Module Metadata

TIP: You can type at any time to perform a new search.

SQL Export

sql_export

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/18.0/sql_export
VERSION
VERSION	1.1.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Miquel Raïch, Florian da Costa, David Beal, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:30:07
ODOO DEPENDENCIES
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
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
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 ID	Name	Model	Type	Status
`sql_export_view_form`		sql.export	field	Inherits sql_request_abstract.view_sql_request_mixin_form
`sql_export_view_tree`		sql.export	field	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)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/17.0/sql_export
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Florian da Costa, Weblate, OCA-git-bot, oca-ci, Sander Lienaerts
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:20:00
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_request_abstract odoo/odoo: - spreadsheet_dashboard - spreadsheet - bus - base - web - portal - web_editor - http_routing - mail - base_setup - web_tour - auth_signup
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
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 ID	Name	Model	Type	Status
`sql_export_view_form`		sql.export	field	Inherits sql_request_abstract.view_sql_request_mixin_form
`sql_export_view_tree`		sql.export	field	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)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/16.0/sql_export
VERSION
VERSION	2.2.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Holger Brunn, Sylvain LE GAL, Florian da Costa, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:53:57
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_request_abstract odoo/odoo: - spreadsheet_dashboard - spreadsheet - bus - base - web - mail - base_setup - web_tour
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (3)

XML ID	Name	Model	Type	Status
`sql_export_view_form`		sql.export	field	Inherits sql_request_abstract.view_sql_request_mixin_form
`sql_export_view_tree`		sql.export	field	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 (8)

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')]
keep_generated_file Boolean
help='Check this to keep generated export files as attachments'
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 (2)

export_sql(self)
unlink(self)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/15.0/sql_export
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	OCA Transbot, Weblate, OCA-git-bot, oca-ci, mariadforgeflow
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:46:42
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (5)

XML ID	Name	Model	Type	Status
`sql_export_view_form`	Sql_export_form_view	sql.export	form	New
`sql_export_view_tree`	Sql_export_tree_view	sql.export	tree	New
`sql_file_wizard_view_form`	sql.file.wizard.view.form	sql.file.wizard	form	New
`sql_parameter_view_form`	Sql_parameter_form_view	ir.model.fields	form	New
`sql_parameter_view_tree`	Sql_parameter_tree_view	ir.model.fields	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (2)

New fields (4)

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')]
field_ids Many2many → ir.model.fields
domain=[('model', '=', 'sql.file.wizard'), ('state', '=', 'manual')] help="Before adding parameters, make sure you have created one that fill your need in the dedicated menu with the right type and label. \nThen, when you add a parameter here, you have to include it in the SQL query in order to have dynamic values depending on the user choice.\nThe format of the parameters in the SQL query must be like this : %(parameter_field_name)s. \nExample : from the variable menu, create an variable with type 'char', having field name 'x_name' and field label : 'Name' \nThen, you can create a SQL query like this : SELECT * FROM res_partner WHERE name = %(x_name)s the variable can be used in any number of different SQL queries. \nIn the SQL query, you can also include these 2 special parameters %(user_id)s and %(company_id)s which will be replaced respectively by the user executing the query and the company of the user executing the query." args: 'ir.model.fields', 'fields_sqlquery_rel', 'sql_id', 'field_id', 'Parameters'
file_format Selection
default='csv' required=True args: [('csv', 'CSV')]

Public methods (2)

csv_get_data_from_query(self, variable_dict)
export_sql_query(self)

New fields (3)

binary_file Binary
readonly=True args: 'File'
file_name Char
readonly=True
sql_export_id Many2one → sql.export
comodel_name='sql.export' required=True

Public methods (2)

export_sql(self)
fields_view_get(self, view_id=None, view_type='form', toolbar=False, submenu=False)
@api.model

Display dynamically parameter fields depending on the sql_export.

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/14.0/sql_export
VERSION
VERSION	1.2.2
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Sylvain LE GAL, Enric Tobella, OCA Transbot, Sébastien BEAU, Florian da Costa, oca-travis, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:41:06
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (5)

XML ID	Name	Model	Type	Status
`sql_export_view_form`	Sql_export_form_view	sql.export	form	New
`sql_export_view_tree`	Sql_export_tree_view	sql.export	tree	New
`sql_file_wizard_view_form`	sql.file.wizard.view.form	sql.file.wizard	form	New
`sql_parameter_view_form`	Sql_parameter_form_view	ir.model.fields	form	New
`sql_parameter_view_tree`	Sql_parameter_tree_view	ir.model.fields	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (2)

New fields (4)

copy_options Char
default="CSV HEADER DELIMITER ';'" required=False string='Copy Options'
encoding Selection
default='utf-8' required=True string='Encoding' 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')]
field_ids Many2many → ir.model.fields
domain=[('model', '=', 'sql.file.wizard'), ('state', '=', 'manual')] help="Before adding parameters, make sure you have created one that fill your need in the dedicated menu with the right type and label. \nThen, when you add a parameter here, you have to include it in the SQL query in order to have dynamic values depending on the user choice.\nThe format of the parameters in the SQL query must be like this : %(parameter_field_name)s. \nExample : from the variable menu, create an variable with type 'char', having field name 'x_name' and field label : 'Name' \nThen, you can create a SQL query like this : SELECT * FROM res_partner WHERE name = %(x_name)s the variable can be used in any number of different SQL queries. \nIn the SQL query, you can also include these 2 special parameters %(user_id)s and %(company_id)s which will be replaced respectively by the user executing the query and the company of the user executing the query." args: 'ir.model.fields', 'fields_sqlquery_rel', 'sql_id', 'field_id', 'Parameters'
file_format Selection
default='csv' required=True args: [('csv', 'CSV')]

Public methods (2)

csv_get_data_from_query(self, variable_dict)
export_sql_query(self)

New fields (3)

binary_file Binary
readonly=True args: 'File'
file_name Char
readonly=True args: 'File Name'
sql_export_id Many2one → sql.export
comodel_name='sql.export' required=True

Public methods (2)

export_sql(self)
fields_view_get(self, view_id=None, view_type='form', toolbar=False, submenu=False)
@api.model

Display dynamically parameter fields depending on the sql_export.

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/12.0/sql_export
VERSION
VERSION	1.2.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Sylvain LE GAL, GitHub, Stéphane Bidoul (ACSONE), OCA Transbot, Florian da Costa, David Beal, oca-travis, Weblate, OCA-git-bot, Tom Blauwendraat, Fernanda Hernandez
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:29:22
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (5)

XML ID	Name	Model	Type	Status
`sql_export_view_form`	Sql_export_form_view	sql.export	form	New
`sql_export_view_tree`	Sql_export_tree_view	sql.export	tree	New
`sql_file_wizard_view_form`	sql.file.wizard.view.form	sql.file.wizard	form	New
`sql_parameter_view_form`	Sql_parameter_form_view	ir.model.fields	form	New
`sql_parameter_view_tree`	Sql_parameter_tree_view	ir.model.fields	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (2)

New fields (4)

copy_options Char
default="CSV HEADER DELIMITER ';'" required=False string='Copy Options'
encoding Selection
default='utf-8' required=True string='Encoding' 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')]
field_ids Many2many → ir.model.fields
domain=[('model', '=', 'sql.file.wizard')] args: 'ir.model.fields', 'fields_sqlquery_rel', 'sql_id', 'field_id', 'Parameters'
file_format Selection
default='csv' required=True args: [('csv', 'CSV')]

Public methods (2)

csv_get_data_from_query(self, variable_dict)
export_sql_query(self)

New fields (3)

binary_file Binary
readonly=True args: 'File'
file_name Char
readonly=True args: 'File Name'
sql_export_id Many2one → sql.export
comodel_name='sql.export' required=True

Public methods (2)

export_sql(self)
fields_view_get(self, view_id=None, view_type='form', toolbar=False, submenu=False)
@api.model

Display dynamically parameter fields depending on the sql_export.

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/10.0/sql_export
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	mreficent, OCA Transbot, David Beal, oca-travis, Weblate, aheficent
WEBSITE
WEBSITE	http://www.akretion.com
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:19:59
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (5)

XML ID	Name	Model	Type	Status
`sql_export_view_form`	Sql_export_form_view	sql.export	form	New
`sql_export_view_tree`	Sql_export_tree_view	sql.export	tree	New
`sql_file_wizard_view_form`	sql.file.wizard.view.form	sql.file.wizard	form	New
`sql_parameter_view_form`	Sql_parameter_form_view	ir.model.fields	form	New
`sql_parameter_view_tree`	Sql_parameter_tree_view	ir.model.fields	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (2)

New fields (3)

copy_options Char
default="CSV HEADER DELIMITER ';'" required=True string='Copy Options'
encoding Selection
default='utf-8' required=True string='Encoding' 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')]
field_ids Many2many → ir.model.fields
domain=[('model', '=', 'sql.file.wizard')] args: 'ir.model.fields', 'fields_sqlquery_rel', 'sql_id', 'field_id', 'Parameters'

Public methods (1)

export_sql_query(self)
@api.multi

New fields (3)

binary_file Binary
readonly=True args: 'File'
file_name Char
readonly=True args: 'File Name'
sql_export_id Many2one → sql.export
comodel_name='sql.export' required=True

Public methods (2)

export_sql(self)
@api.multi
fields_view_get(self, view_id=None, view_type='form', toolbar=False, submenu=False)
@api.model

Display dinamicaly parameter fields depending on the sql_export.

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/9.0/sql_export
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Stéphane Bidoul (ACSONE), OCA Transbot, Florian da Costa, oca-travis, Weblate, aheficent, Mourad Elhadj Mimoune, oliverstore-ro
WEBSITE
WEBSITE	http://www.akretion.com
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:15:22
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (5)

XML ID	Name	Model	Type	Status
`sql_export_view_form`	Sql_export_form_view	sql.export	form	New
`sql_export_view_tree`	Sql_export_tree_view	sql.export	tree	New
`sql_file_wizard_view_form`	sql.file.wizard.view.form	sql.file.wizard	form	New
`sql_parameter_view_form`	Sql_parameter_form_view	ir.model.fields	form	New
`sql_parameter_view_tree`	Sql_parameter_tree_view	ir.model.fields	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (2)

New fields (3)

copy_options Char
default="CSV HEADER DELIMITER ';'" required=True string='Copy Options'
encoding Selection
default='utf-8' required=True string='Encoding' 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')]
field_ids Many2many → ir.model.fields
domain=[('model', '=', 'sql.file.wizard')] args: 'ir.model.fields', 'fields_sqlquery_rel', 'sql_id', 'field_id', 'Parameters'

Public methods (1)

export_sql_query(self)
@api.multi

New fields (3)

binary_file Binary
readonly=True args: 'File'
file_name Char
readonly=True args: 'File Name'
sql_export_id Many2one → sql.export
comodel_name='sql.export' required=True

Public methods (2)

export_sql(self)
@api.multi
fields_view_get(self, view_id=None, view_type='form', toolbar=False, submenu=False)
@api.model

Display dinamicaly parameter fields depending on the sql_export.

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/8.0/sql_export
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Sylvain LE GAL, GitHub, Stéphane Bidoul (ACSONE), OCA Transbot, Florian da Costa, oca-travis, Weblate
WEBSITE
WEBSITE	http://www.akretion.com
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:11:25
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_request_abstract odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (5)

XML ID	Name	Model	Type	Status
`sql_export_view_form`	Sql_export_form_view	sql.export	form	New
`sql_export_view_tree`	Sql_export_tree_view	sql.export	tree	New
`sql_file_wizard_view_form`	sql.file.wizard.view.form	sql.file.wizard	form	New
`sql_parameter_view_form`	Sql_parameter_form_view	ir.model.fields	form	New
`sql_parameter_view_tree`	Sql_parameter_tree_view	ir.model.fields	tree	New

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (2)

New fields (2)

copy_options Char
default="CSV HEADER DELIMITER ';'" required=True string='Copy Options'
field_ids Many2many → ir.model.fields
domain=[('model', '=', 'sql.file.wizard')] args: 'ir.model.fields', 'fields_sqlquery_rel', 'sql_id', 'field_id', 'Parameters'

Public methods (1)

export_sql_query(self)
@api.multi

New fields (3)

binary_file Binary
readonly=True args: 'File'
file_name Char
readonly=True args: 'File Name'
sql_export_id Many2one → sql.export
comodel_name='sql.export' required=True

Public methods (2)

export_sql(self)
@api.multi
fields_view_get(self, view_id=None, view_type='form', toolbar=False, submenu=False)
@api.model

Display dinamicaly parameter fields depending on the sql_export.

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/7.0/sql_export
VERSION
VERSION	0.1
CATEGORY
CATEGORY	Generic Modules/Others
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	Florian da Costa
WEBSITE
WEBSITE	http://www.akretion.com
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:07:15
ODOO DEPENDENCIES
ODOO DEPENDENCIES	odoo/odoo: - base
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	Allow to export data in csv files FROM sql requests. There are some restrictions in the sql sql request, you can only read datas. No update, deletion or creation are possible.

Code Analysis ⓘ

Views touched (3)

XML ID	Name	Model	Type	Status
`sql_export_view_form`	Sql_export_form_view	sql.export	form	New
`sql_export_view_tree`	Sql_export_tree_view	sql.export	tree	New
`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 (0)

No new fields.

Public methods (4)

check_query_syntax(self, cr, uid, vals, context=None)
create(self, cr, uid, vals, context=None)
export_sql_query(self, cr, uid, ids, context=None)
write(self, cr, uid, ids, vals, context=None)

New fields (0)

No new fields.

Public methods (0)

No public methods.

STATUS
STATUS	Open migration PR - not merged yet for this version
REPOSITORY
REPOSITORY	OCA/reporting-engine
PULL REQUEST
PULL REQUEST	[19.0][MIG] sql export: Migration to 19.0 (#1128)

SQL Export

Code Analysis ⓘ

Views touched (3)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 7 fields 3 methods SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 4 fields 1 method SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (3)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 7 fields 3 methods SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 4 fields 1 method SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (3)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 8 fields 3 methods SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 4 fields 2 methods SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (5)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 4 fields 2 methods SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 3 fields 2 methods SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (5)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 4 fields 2 methods SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 3 fields 2 methods SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (5)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 4 fields 2 methods SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 3 fields 2 methods SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (5)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 3 fields 1 method SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 3 fields 2 methods SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (5)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 3 fields 1 method SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 3 fields 2 methods SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (5)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 2 fields 1 method SqlExport · inherits sql.request.mixin · SQL export

sql.file.wizard New model TransientModel 3 fields 2 methods SqlFileWizard · Allow the user to save the file with sql request's data

Code Analysis ⓘ

Views touched (3)

HTTP endpoints (0)

Models touched (2)

sql.export New model Model 0 fields 4 methods SqlExport · SQL export

sql.file.wizard New model TransientModel 0 fields 0 methods SqlFileWizard · Allow the user to save the file with sql request's data