sql_export
This module enables users to export data from Odoo databases to CSV files using custom SQL queries with support for parameters and validation.
Key Features
- sql.export: Allows defining and validating SQL queries for data export
- sql.export: Supports parameterized queries using properties (date, integer, many2many, etc.)
- sql.export: Automatically substitutes company and user IDs in queries
- sql.export: Configures CSV export options including delimiter and encoding
- sql.export: Prevents destructive SQL operations like UPDATE, DELETE, INSERT
- sql.file.wizard: Provides a wizard interface for inputting property values
- sql.export: Tracks last execution date and user for audit purposes
- reporting: Integrates SQL Export functionality into the Dashboard menu
- sql.export: Generates and downloads CSV files from query results