Account Bank Statement Import TXT/CSV/XLSX

• sheet_mapping_id Many2one → account.bank.statement.import.sheet.mapping
  comodel_name='account.bank.statement.import.sheet.mapping' default=_get_default_mapping_id string='Sheet mapping'

No public methods.

• amount_column Char
  help="Amount of transaction in journal's currency" required=True string='Amount column'
• balance_column Char
  help="Balance after transaction in journal's currency" string='Balance column'
• bank_account_column Char
  help="Partner's bank account" string='Bank Account column'
• bank_name_column Char
  help="Partner's bank" string='Bank Name column'
• credit_value Char
  default='C' help="Value of debit/credit column that indicates if it's a credit" string='Credit value'
• currency_column Char
  help='In case statement is multi-currency, column to get currency of transaction from' string='Currency column'
• debit_credit_column Char
  help='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_value Char
  default='D' help="Value of debit/credit column that indicates if it's a debit" string='Debit value'
• delimiter Selection
  default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')] string='Delimiter'
• description_column Char
  string='Description column'
• file_encoding Selection
  default='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_sep Selection
  default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')] string='Decimals Separator'
• float_thousands_sep Selection
  default='dot' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')] string='Thousands Separator'
• name Char
  required=True
• no_header Boolean
  help='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_column Char
  string='Notes column'
• original_amount_column Char
  help='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_column Char
  help='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_column Char
  string='Partner Name column'
• quotechar Char
  default='"' size=1 string='Text qualifier'
• reference_column Char
  string='Reference column'
• timestamp_column Char
  required=True string='Timestamp column'
• timestamp_format Char
  required=True string='Timestamp Format'
• transaction_id_column Char
  string='Unique transaction ID column'

• onchange_decimal_separator(self)
  @api.onchange('float_decimal_sep')
• onchange_thousands_separator(self)
  @api.onchange('float_thousands_sep')

• amount_column Char
  help="Amount of transaction in journal's currency" string='Amount column'
• attachment_ids Many2many → ir.attachment
  comodel_name='ir.attachment' relation='account_bank_statement_import_sheet_mapping_wiz_attachment_rel' required=True string='Files'
• balance_column Char
  help="Balance after transaction in journal's currency" string='Balance column'
• bank_account_column Char
  help="Partner's bank account" string='Bank Account column'
• bank_name_column Char
  help="Partner's bank" string='Bank Name column'
• credit_value Char
  default='C' help="Value of debit/credit column that indicates if it's a credit" string='Credit value'
• currency_column Char
  help='In case statement is multi-currency, column to get currency of transaction from' string='Currency column'
• debit_credit_column Char
  help='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_value Char
  default='D' help="Value of debit/credit column that indicates if it's a debit" string='Debit value'
• delimiter Selection
  selection=<expr> string='Delimiter'
• description_column Char
  string='Description column'
• file_encoding Selection
  selection=<expr> string='Encoding'
• header Char
• notes_column Char
  string='Notes column'
• original_amount_column Char
  help='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_column Char
  help='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_column Char
  string='Partner Name column'
• quotechar Char
  size=1 string='Text qualifier'
• reference_column Char
  string='Reference column'
• timestamp_column Char
  string='Timestamp column'
• transaction_id_column Char
  string='Unique transaction ID column'

• import_mapping(self)
• statement_columns(self)
  @api.model

No new fields.

• parse(self, data_file, mapping, filename)
  @api.model
• parse_header(self, data_file, encoding, csv_options)
  @api.model

• default_sheet_mapping_id Many2one → account.bank.statement.import.sheet.mapping
  comodel_name='account.bank.statement.import.sheet.mapping'

No public methods.