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
|
from ofxstatement.parser import CsvStatementParser
from ofxstatement.plugin import Plugin
from ofxstatement import statement
import csv
class LbbAmazonCsvStatementParser(CsvStatementParser):
mappings = {"date": 1, "memo": 3, "amount": 6}
date_format = "%d.%m.%Y"
def split_records(self):
return csv.reader(self.fin, delimiter=';')
def parse_record(self, line):
#Free Headerline
if self.cur_record <= 1:
return None
# Empty transactions to include amazon points
if line[6] == '':
if self.ignore_amazon_points:
return None
line[6] = '0,00'
#Change decimalsign from , to .
line[6] = line[6].replace(',', '.')
# fill statement line according to mappings
sl = super(LbbAmazonCsvStatementParser, self).parse_record(line)
return sl
class LbbAmazonPlugin(Plugin):
"""
Landensbank Berlin AG, Amazon Creditcard CSV
"""
def get_parser(self, fin):
f = open(fin, "r", encoding='iso-8859-1')
parser = LbbAmazonCsvStatementParser(f)
parser.statement.account_id = self.settings['account']
parser.statement.currency = self.settings['currency']
parser.statement.bank_id = self.settings.get('bank', 'LBB_Amazon')
parser.ignore_amazon_points = self.settings.get('ignore_amazon_points', 'false').lower() in ('true', 'yes', 'on')
return parser
|
