1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
from ofxstatement.parser import CsvStatementParser
from ofxstatement.plugin import Plugin
from ofxstatement import statement
import csv
class DKBCCCsvStatementParser(CsvStatementParser):
mappings = {"date": 1, "memo": 3, "amount": 4}
date_format = "%d.%m.%Y"
def split_records(self):
return csv.reader(self.fin, delimiter=';')
def parse_record(self, line):
if self.cur_record == 3:
self.statement.start_date=self.parse_datetime(line[1])
return None
if self.cur_record == 5:
self.statement.end_balance=self.parse_float(line[1].replace(' EUR',''))
return None
if self.cur_record == 6:
self.statement.end_date=self.parse_datetime(line[1])
return None
if self.cur_record == 8:
self.statement.currency=line[4].strip('Betrag (').strip(')')
return None
if self.cur_record <= 8:
return None
line[4]=line[4].replace('.','').replace(',','.')
# fill statement line according to mappings
sl = super(DKBCCCsvStatementParser, self).parse_record(line)
return sl
class DKBCCPlugin(Plugin):
"""
Deutsche Kreditbank AG, CSV of creditcard statements
"""
def get_parser(self, fin):
f = open(fin, "r",encoding='iso-8859-1')
parser=DKBCCCsvStatementParser(f)
parser.statement.account_id = self.settings['account']
parser.statement.bank_id = self.settings.get('bank', 'DKB_VISA')
return parser
|
