PSA for those using Santander UK

[Weissnix4711]

Santander's QIF files use the DD/MM/YYYY date format, and start with the line !Type:Oth L, not one of Bank, Cash, or CCard which are read by Denaro. If you use Santander, and keep getting an error along the lines of 'Nothing to import', an extremely simple python script like this might fix everything:

#!/bin/python
import re
import sys
with open(sys.argv[1], "r") as f:
	lines = f.readlines()
	for i in range(len(lines)):
		l = lines[i]
		if l.startswith("!Type:Oth"):
			lines[i] = "!Type:Bank\n"
		if l[0] == "D":
			date = (l[1:3], l[4:6], l[7:11])
			lines[i] = "D" + date[1] + "/" + date[0] + "/" + date[2] + "\n"
print(''.join(lines))

Usage: ./fix_qif.py santander_statement.qif > fixed_statement.qif