Bank Statement TXT/CSV/XLSX Import

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

No public methods.

• sheet_mapping_id Many2one → account.statement.import.sheet.mapping
  comodel_name='account.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"
• amount_credit_column Char
  help="Credit amount of transaction in journal's currency" string='Credit amount column'
• amount_debit_column Char
  help="Debit amount of transaction in journal's currency" string='Debit amount column'
• balance_column Char
  help="Balance after transaction in journal's currency"
• bank_account_column Char
  help="Partner's bank account"
• bank_name_column Char
  help="Partner's bank"
• credit_value Char
  default='C' help="Value of debit/credit column that indicates if it's a credit"
• currency_column Char
  help='In case statement is multi-currency, column to get currency of transaction from'
• 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"
• delimiter Selection
  default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')]
• description_column Char
• 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' string='File does not contain header line'
• notes_column Char
• offset_column Integer
  default=0 help='Horizontal spaces to ignore before starting to parse'
• offset_row Integer
  default=0 help='Vertical spaces to ignore before starting to parse'
• 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'
• 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'
• partner_name_column Char
• quotechar Char
  default='"' size=1 string='Text qualifier'
• reference_column Char
• skip_empty_lines Boolean
  default=False help='Allows to skip empty lines'
• timestamp_column Char
  required=True
• timestamp_format Char
  required=True
• 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"
• amount_credit_column Boolean
  help="Credit amount of transaction in journal's currency" string='Credit amount column'
• amount_debit_column Char
  help="Debit amount of transaction in journal's currency" string='Debit amount column'
• attachment_ids Many2many → ir.attachment
  comodel_name='ir.attachment' relation='account_statement_import_sheet_mapping_wiz_attachment_rel' required=True string='Files'
• balance_column Char
  help="Balance after transaction in journal's currency"
• bank_account_column Char
  help="Partner's bank account"
• bank_name_column Char
  help="Partner's bank"
• credit_value Char
  default='C' help="Value of debit/credit column that indicates if it's a credit"
• currency_column Char
  help='In case statement is multi-currency, column to get currency of transaction from'
• 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"
• delimiter Selection
  selection=<expr>
• description_column Char
• file_encoding Selection
  selection=<expr> string='Encoding'
• header Char
• notes_column Char
• 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'
• 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'
• partner_name_column Char
• quotechar Char
  size=1 string='Text qualifier'
• reference_column Char
• timestamp_column Char
• 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