"""Implements the Importers for Virginia Community Bank."""
import bank_import.importers.base as base
[docs]class CSVImporter(base.CSVImporter):
"""Specify the Field Conversion & Type Conversion for VCB CSV Exports."""
CSV_TO_DATA_FIELDS = {
'Date': 'date',
'Amount': 'amount',
'Transaction Description': 'type',
'Check Number': 'check_number',
'Reference': 'memo',
}
CSV_TYPE_TO_DATA_TYPE = {
'ACH Deposit': 'deposit',
'ACH Payment': 'withdrawal',
'Check': 'withdrawal',
'Withdrawal': 'withdrawal',
'Overdraft Fee': 'withdrawal',
'Stop Pmt Charge': 'withdrawal',
'Deposit': 'deposit',
'IB Transfer Deposit': 'transfer_deposit',
'IB Transfer W/D': 'transfer_withdrawal',
}
CSV_FIELD_ORDER = [
'Account',
'Date',
'Amount',
'Check Number',
'Reference',
'Transaction Description',
]
[docs] def get_data(self):
"""Reverse the data, imported lines are in descending order by date."""
self.data.reverse()
return self.data