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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
from ofxstatement.plugin import Plugin
from ofxstatement.parser import CsvStatementParser
from ofxstatement.statement import StatementLine
from ofxstatement.exceptions import ParseError
import csv
LINELENGTH = 18
HEADER_START = "Rekeningnummer"
class KbcBePlugin(Plugin):
"""Belgian KBC Bank plugin for ofxstatement
"""
def get_parser(self, filename):
f = open(filename, 'r')
parser = KbcBeParser(f)
return parser
class KbcBeParser(CsvStatementParser):
date_format = "%d/%m/%Y"
mappings = {
'memo': 6,
'date': 5,
'amount': 8,
}
line_nr = 0
def parse_float(self, value):
"""Return a float from a string with ',' as decimal mark.
"""
return float(value.replace(',','.'))
def split_records(self):
"""Return iterable object consisting of a line per transaction
"""
return csv.reader(self.fin, delimiter=';')
def parse_record(self, line):
"""Parse given transaction line and return StatementLine object
"""
self.line_nr += 1
if line[0] == HEADER_START:
return None
elif len(line) != LINELENGTH:
raise ParseError(self.line_nr,
'Wrong number of fields in line! ' +
'Found ' + str(len(line)) + ' fields ' +
'but should be ' + str(LINELENGTH) + '!')
# Check the account id. Each line should be for the same account!
if self.statement.account_id:
if line[0] != self.statement.account_id:
raise ParseError(self.line_nr,
'AccountID does not match on all lines! ' +
'Line has ' + line[0] + ' but file ' +
'started with ' + self.statement.account_id)
else:
self.statement.account_id = line[0]
# Check the currency. Each line should be for the same currency!
if self.statement.currency:
if line[3] != self.statement.currency:
raise ParseError(self.line_nr,
'Currency does not match on all lines! ' +
'Line has ' + line[3] + ' but file ' +
'started with ' + self.statement.currency)
else:
self.statement.currency = line[3]
stmt_ln = super(KbcBeParser, self).parse_record(line)
return stmt_ln
|
