Bank Statement TXT/CSV/XLSX Import
account_statement_import_txt_xlsx · OCA/bank-statement-import
Renamed to account_statement_import_sheet_file in 16.0
Replaces
account_bank_statement_import_txt_xlsx (14.0) Health
54/100
fair
-
Security25/25No findings
-
Activity12/25Last human commit 19 months ago
-
Required by5/250 modules depend on it
-
Maturity12/25In 2 Odoo series since 14.0
Heuristic over the facts below, not an audit · How it's computed
Required by
0
Modules depending on it
External deps
2 pip · 0 bin
Python packages / system binaries
License
AGPL-3
No conflicts with its dependencies
Folder size
0.4 MB
Module directory on disk
Code analysis
5 migration notes
5 models
5 views
0 HTTP endpoints
Migration considerations
AccountStatementImportSheetMapping— Migrating to 19.0: `_sql_constraints` is ignored and its constraints are silently not created: declare `models.Constraint` attributes instead. migration-sql-constraints · sourceaccount_statement_import_sheet_mapping_form— Migrating to 18.0: the `tree` view type was renamed to `list` (`<list>` roots, `view_mode`). migration-view-tree-tag · sourceaccount_statement_import_sheet_mapping_tree— Migrating to 17.0: `attrs=`/`states=` are rejected in views: convert them to Python expressions in `invisible`/`readonly`/`required`, keeping the original AND/OR logic. migration-view-attrs-states · sourceaccount_statement_import_sheet_mapping_wizard_form— Migrating to 17.0: `attrs=`/`states=` are rejected in views: convert them to Python expressions in `invisible`/`readonly`/`required`, keeping the original AND/OR logic. migration-view-attrs-states · sourceview_account_journal_form_n43— Migrating to 17.0: `attrs=`/`states=` are rejected in views: convert them to Python expressions in `invisible`/`readonly`/`required`, keeping the original AND/OR logic. migration-view-attrs-states · source
Migration review checklist, not a compatibility verdict. "Migrating to X.0" applies once you upgrade to that version; "Since X.0" means this version already ignores or rejects that code. Methodology
Description
Dependencies
Code analysis
Extracted from the source by best-effort static analysis (no code is executed); details may be incomplete.
Views touched 5
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
account_statement_import_form |
account.statement.import | account.statement.import | form | Inherits account_statement_import.account_statement_import_form |
account_statement_import_sheet_mapping_form |
account.statement.import.sheet.mapping.form | account.statement.import.sheet.mapping | tree | New |
account_statement_import_sheet_mapping_tree |
account.statement.import.sheet.mapping.tree | account.statement.import.sheet.mapping | form | New |
account_statement_import_sheet_mapping_wizard_form |
account.statement.import.sheet.mapping.wizard.form | account.statement.import.sheet.mapping.wizard | form | Inherits multi_step_wizard.multi_step_wizard_form |
view_account_journal_form_n43 |
account.journal | form | Inherits account.view_account_journal_form |
HTTP endpoints 0
No HTTP endpoints found for this module.
Models touched 5
New fields (1)
-
default_sheet_mapping_idMany2one → account.statement.import.sheet.mappingcomodel_name='account.statement.import.sheet.mapping'
No public methods.
New fields (1)
-
sheet_mapping_idMany2one → account.statement.import.sheet.mappingcomodel_name='account.statement.import.sheet.mapping'default=_get_default_mapping_idstring='Sheet mapping'
No public methods.
New fields (29)
-
amount_columnCharhelp="Amount of transaction in journal's currency" -
amount_credit_columnCharhelp="Credit amount of transaction in journal's currency"string='Credit amount column' -
amount_debit_columnCharhelp="Debit amount of transaction in journal's currency"string='Debit amount column' -
balance_columnCharhelp="Balance after transaction in journal's currency" -
bank_account_columnCharhelp="Partner's bank account" -
bank_name_columnCharhelp="Partner's bank" -
credit_valueChardefault='C'help="Value of debit/credit column that indicates if it's a credit" -
currency_columnCharhelp='In case statement is multi-currency, column to get currency of transaction from' -
debit_credit_columnCharhelp='Some statement formats use absolute amount value and indicate signof the transaction by specifying if it was a debit or a credit one'string='Debit/credit column' -
debit_valueChardefault='D'help="Value of debit/credit column that indicates if it's a debit" -
delimiterSelectiondefault='comma'selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')] -
description_columnChar -
file_encodingSelectiondefault='utf-8'selection=[('utf-8', 'UTF-8'), ('utf-8-sig', 'UTF-8 (with BOM)'), ('utf-16', 'UTF-16'), ('utf-16-sig', 'UTF-16 (with BOM)'), ('windows-1252', 'Western (Windows-1252)'), ('iso-8859-1', 'Western (Latin-1 / ISO 8859-1)'), ('iso-8859-2', 'Central European (Latin-2 / ISO 8859-2)'), ('iso-8859-4', 'Baltic (Latin-4 / ISO 8859-4)'), ('big5', 'Traditional Chinese (big5)'), ('gb18030', 'Unified Chinese (gb18030)'), ('shift_jis', 'Japanese (Shift JIS)'), ('windows-1251', 'Cyrillic (Windows-1251)'), ('koi8_r', 'Cyrillic (KOI8-R)'), ('koi8_u', 'Cyrillic (KOI8-U)')]string='Encoding' -
float_decimal_sepSelectiondefault='comma'selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')]string='Decimals Separator' -
float_thousands_sepSelectiondefault='dot'selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')]string='Thousands Separator' -
nameCharrequired=True -
no_headerBooleanhelp='When this occurs please indicate the column number in the Columns section instead of the column name, considering that the first column is 0'string='File does not contain header line' -
notes_columnChar -
offset_columnIntegerdefault=0help='Horizontal spaces to ignore before starting to parse' -
offset_rowIntegerdefault=0help='Vertical spaces to ignore before starting to parse' -
original_amount_columnCharhelp='In case statement provides original currency for transactions with automatic currency conversion, column to get original transaction amount in original transaction currency from' -
original_currency_columnCharhelp='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from' -
partner_name_columnChar -
quotecharChardefault='"'size=1string='Text qualifier' -
reference_columnChar -
skip_empty_linesBooleandefault=Falsehelp='Allows to skip empty lines' -
timestamp_columnCharrequired=True -
timestamp_formatCharrequired=True -
transaction_id_columnCharstring='Unique transaction ID column'
-
onchange_decimal_separator(self)@api.onchange('float_decimal_sep') -
onchange_thousands_separator(self)@api.onchange('float_thousands_sep')
New fields (23)
-
amount_columnCharhelp="Amount of transaction in journal's currency" -
amount_credit_columnBooleanhelp="Credit amount of transaction in journal's currency"string='Credit amount column' -
amount_debit_columnCharhelp="Debit amount of transaction in journal's currency"string='Debit amount column' -
attachment_idsMany2many → ir.attachmentcomodel_name='ir.attachment'relation='account_statement_import_sheet_mapping_wiz_attachment_rel'required=Truestring='Files' -
balance_columnCharhelp="Balance after transaction in journal's currency" -
bank_account_columnCharhelp="Partner's bank account" -
bank_name_columnCharhelp="Partner's bank" -
credit_valueChardefault='C'help="Value of debit/credit column that indicates if it's a credit" -
currency_columnCharhelp='In case statement is multi-currency, column to get currency of transaction from' -
debit_credit_columnCharhelp='Some statement formats use absolute amount value and indicate signof the transaction by specifying if it was a debit or a credit one'string='Debit/credit column' -
debit_valueChardefault='D'help="Value of debit/credit column that indicates if it's a debit" -
delimiterSelectionselection=<expr> -
description_columnChar -
file_encodingSelectionselection=<expr>string='Encoding' -
headerChar -
notes_columnChar -
original_amount_columnCharhelp='In case statement provides original currency for transactions with automatic currency conversion, column to get original transaction amount in original transaction currency from' -
original_currency_columnCharhelp='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from' -
partner_name_columnChar -
quotecharCharsize=1string='Text qualifier' -
reference_columnChar -
timestamp_columnChar -
transaction_id_columnCharstring='Unique transaction ID column'
-
import_mapping(self) -
statement_columns(self)@api.model
New fields (0)
No new fields.
Public methods (2)-
parse(self, data_file, mapping, filename)@api.model -
parse_header(self, data_file, encoding, csv_options)@api.model
Loading…