Account Bank Statement Import TXT/CSV/XLSX
account_bank_statement_import_txt_xlsx · OCA/bank-statement-import
Renamed to account_statement_import_txt_xlsx in 14.0, then renamed to account_statement_import_sheet_file in 16.0
Health
42/100
poor
-
Security25/25No findings
-
Activity0/25Last human commit 44 months ago
-
Required by5/250 modules depend on it
-
Maturity12/25In 2 Odoo series since 12.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.23 MB
Module directory on disk
Code analysis
4 migration notes
5 models
5 views
0 HTTP endpoints
Migration considerations
account_bank_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_bank_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_bank_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_bank_statement_import_sheet_mapping_form |
account.bank.statement.import.sheet.mapping.form | account.bank.statement.import.sheet.mapping | tree | New |
account_bank_statement_import_sheet_mapping_tree |
account.bank.statement.import.sheet.mapping.tree | account.bank.statement.import.sheet.mapping | form | New |
account_bank_statement_import_sheet_mapping_wizard_form |
account.bank.statement.import.sheet.mapping.wizard.form | account.bank.statement.import.sheet.mapping.wizard | form | Inherits multi_step_wizard.multi_step_wizard_form |
account_bank_statement_import_view |
account.bank.statement.import | account.bank.statement.import | Inherits account_bank_statement_import.account_bank_statement_import_view | |
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)
-
sheet_mapping_idMany2one → account.bank.statement.import.sheet.mappingcomodel_name='account.bank.statement.import.sheet.mapping'default=_get_default_mapping_idstring='Sheet mapping'
No public methods.
New fields (24)
-
amount_columnCharhelp="Amount of transaction in journal's currency"required=Truestring='Amount column' -
balance_columnCharhelp="Balance after transaction in journal's currency"string='Balance column' -
bank_account_columnCharhelp="Partner's bank account"string='Bank Account column' -
bank_name_columnCharhelp="Partner's bank"string='Bank Name column' -
credit_valueChardefault='C'help="Value of debit/credit column that indicates if it's a credit"string='Credit value' -
currency_columnCharhelp='In case statement is multi-currency, column to get currency of transaction from'string='Currency column' -
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"string='Debit value' -
delimiterSelectiondefault='comma'selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')]string='Delimiter' -
description_columnCharstring='Description column' -
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' args: 'File does not contain header line' -
notes_columnCharstring='Notes column' -
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'string='Original amount column' -
original_currency_columnCharhelp='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from'string='Original currency column' -
partner_name_columnCharstring='Partner Name column' -
quotecharChardefault='"'size=1string='Text qualifier' -
reference_columnCharstring='Reference column' -
timestamp_columnCharrequired=Truestring='Timestamp column' -
timestamp_formatCharrequired=Truestring='Timestamp Format' -
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 (21)
-
amount_columnCharhelp="Amount of transaction in journal's currency"string='Amount column' -
attachment_idsMany2many → ir.attachmentcomodel_name='ir.attachment'relation='account_bank_statement_import_sheet_mapping_wiz_attachment_rel'required=Truestring='Files' -
balance_columnCharhelp="Balance after transaction in journal's currency"string='Balance column' -
bank_account_columnCharhelp="Partner's bank account"string='Bank Account column' -
bank_name_columnCharhelp="Partner's bank"string='Bank Name column' -
credit_valueChardefault='C'help="Value of debit/credit column that indicates if it's a credit"string='Credit value' -
currency_columnCharhelp='In case statement is multi-currency, column to get currency of transaction from'string='Currency column' -
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"string='Debit value' -
delimiterSelectionselection=<expr>string='Delimiter' -
description_columnCharstring='Description column' -
file_encodingSelectionselection=<expr>string='Encoding' -
headerChar -
notes_columnCharstring='Notes column' -
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'string='Original amount column' -
original_currency_columnCharhelp='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from'string='Original currency column' -
partner_name_columnCharstring='Partner Name column' -
quotecharCharsize=1string='Text qualifier' -
reference_columnCharstring='Reference column' -
timestamp_columnCharstring='Timestamp column' -
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
New fields (1)
-
default_sheet_mapping_idMany2one → account.bank.statement.import.sheet.mappingcomodel_name='account.bank.statement.import.sheet.mapping'
No public methods.
Loading…