def transform(self, this_row, next_row): essence = dict() essence['Date'] = Essence.normalizeDateField(this_row['Settlement Date']) essence['Amount'] = Essence.normalizeAmountField(this_row['Amount ($)']) essence['TransferMech1'] = this_row['Type'] essence['TransferMech2'] = this_row['Description 1'] essence['AccountAlias'] = this_row['Description 2'] essence['Institution'] = 'Beyond Banking' return True, essence
def transform(self, this_row, next_row): essence = dict() essence['Date'] = Essence.normalizeDateField(this_row['Date']) if this_row['Transaction Type'] == 'debit': maybe_minus = "-"+this_row['Amount'] elif this_row['Transaction Type'] == 'credit': maybe_minus = this_row['Amount'] else: maybe_minus = '0.0' print "ERROR: Db_Raw_Finance_Mint: transaction type is not credit or debit" essence['Amount'] = Essence.normalizeAmountField(maybe_minus) essence['TransferMech1'] = this_row['Category'] essence['TransferMech2'] = this_row['Description'] essence['AccountAlias'] = this_row['Original Description'] if this_row['Account Name'] == 'VISA SIGNATURE': essence['Institution'] = 'Mint Capital One' elif this_row['Account Name'] == 'CREDIT CARD': essence['Institution'] = 'Mint Chase' else: essence['Institution'] = this_row['Account Name'] return True, essence