#!/usr/bin/python # # See google QIF interchange format # # It is hoped that the kludges in this program only echo the kludges in the # QIF specification. :-) # # Open source. W3C licence. # import sys import string import os def convertName(what, value): """ Convert a random name to a ID as part of a URI.""" pref=string.lower(what[:3]) ln = zapOut(value, "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789_") return pref + ":" + ln def stripOut(str, characters): str2 = "" for i in range(len(str)): if str[i] not in characters: str2 = str2 + str[i] return str2 def zapOut(str, allowed): """Only allow the characters give. Strings of consecutive unallowed characters are replaced with a single underscore character""" str2 = "" for i in range(len(str)): if str[i] in allowed: str2 = str2 + str[i] else: if str2[-1:] != "_": str2 = str2 + "_" return str2 def dealWithNumber(str): """The number field can be used for other things, which map to class membership.""" if str == "ATM": return "a qu:ATMTrans;" if str == "DEP": return "a qu:depositTrans;" return "qu:number " + '"' + str + '";' def convertAmount(str): return stripOut(str, ",") def convertDate(qdate): """ convert from QIF time format to ISO date string QIF is like "7/ 9/98" "9/ 7/99" or "10/10/99" or "10/10'01" for y2k or, it seems (citibankdownload 20002) like "01/22/2002" or, (Paypal 2011) like "3/2/2011". ISO is like YYYY-MM-DD I think @@check """ if qdate[1] == "/": qdate = "0" + qdate # Extend month to 2 digits if qdate[4] == "/": qdate = qdate[:3]+"0" + qdate[3:] # Extend month to 2 digits for i in range(len(qdate)): if qdate[i] == " ": qdate = qdate[:i] + "0" + qdate[i+1:] if len(qdate) == 10: # new form with YYYY date return qdate[6:10] + "-" + qdate[0:2] + "-" + qdate[3:5] if qdate[5] == "'": C="20" else: C="19" return C + qdate[6:8] + "-" + qdate[0:2] + "-" + qdate[3:5] def extract(path): global verbose global defaultAccount defaultUsed = 0 crs = 0 total = 0 nextId = 1 ignorables = [ "Clear:AutoSwitch", "Option:AutoSwitch" ] # Without leading "!" # The properties for any non-investment account: nonInvestmentProperties = { "C": None, "D": "date", "E": "splitMemo", "L": "category", "P": "payee", "M": "memo", "N": "number", "S": "splitCategory", "T": "amount", "U": None, "$": "splitAmount"} payPalCashProperties = { "D": "date", "P": "payee", "T": "amount", "M": "memo","C": None, "L": None, "S": None, "$":None} # Split stuff # For each type of account, a conversion from QIF poerty letter to rdf property name: properties = { # The line below was "Oth L" for a mortguage type which looks corrupted -- No, its "Other lender" "Mort": nonInvestmentProperties, "Account": {"D": "description", "L": "limit", "N": "name", "T": "type"}, "Bank": nonInvestmentProperties, "Bill": nonInvestmentProperties, "Cat": {"B": None, "D": "description", "I": None, "N": "name", "T": None}, # Category "CCard": nonInvestmentProperties, "Class": {"D": "description", "N": "name"}, "Invst": { "D": "date", "L": "link", "P": "payee", "M": "memo", "N": "number", "T": "amount", "U": "amount2", "$": "splitAmount" }, "Oth_A": nonInvestmentProperties, "Oth_L": nonInvestmentProperties, "Cash" : payPalCashProperties, } print "# n3 Personal and confidential. Not for distrbution." print "# From Quicken data in ", path print "# Extracted by $Id: qif2n3.py,v 1.8 2012/12/05 18:29:21 timbl Exp $ " print print """ @prefix : <#>. @prefix d: <#>. @prefix s: . @prefix log: . @prefix qu: . # @prefix acc: <../../../Financial/Data/accounts.n3#>. # @prefix cat: . # @prefix cla: . """ input = open(path, "r") inRecord = 0 # inAccount = 0 split = 0 what = "" toAccount = None # The destination of current transactions. inSentence = 0 # Flag: The record has been closed, delay though. while 1: line = input.readline() if line [-1:] == "\n": line = line[:-1] # Strip triling LF while line [-1:] == "\r": line = line[:-1] # Strip triling CRs if line=="": break # EOF attr = line[0] value = line[1:] if attr == "!": while value[-1:]==" ":value=value[:-1] # strip trailing blanks(!) for i in range(len(value)): if value[i]==" ": value=value[:i]+"_"+value[i+1:] if what == "Account" and value[0:5]=="Type:": # @@@ sic # print " is qu:toAccount of\n [", # inAccount = 1 # inRecord = 1 what = value[5:] continue if inSentence: print "." inSentence = 0 # if inAccount: # print "]. ", # inAccount = 0 print if value in ignorables: print "# Ignoring ", line elif value[0:5] == "Type:": was = what what = value[5:] print "\n# List of %s\n" % what # inAccount = 1 inRecord = 1 elif value == "Account": what = "Account" print "\n# Account information:\n", # inAccount = 0 inRecord = 1 else: print "#@@@@@@ Unknown ", line elif attr == "^": # The end of the record if split: print "]", split = 0 print "qu:accordingTo <>;", if (what == "Bank" or what == "CCard" or what == "Cash"): if toAccount!= None: #@@ mising from citibank download print "qu:toAccount ",toAccount, else: print "qu:toAccount %s;" % defaultAccount, defaultUsed = 1 print "." inSentence = 0 else: dictionary = properties.get(what, None) if dictionary == None: print dictionary raise RuntimeError("@@ No propertylist for <%s>" % what) property = dictionary.get(attr, "quicken_"+what+"_"+attr) # if not inAccount : raise oops if property == "name": if inSentence: raise oops qname = convertName(what, value) print '%s a qu:%s; s:label "%s";' %(qname, what, value), inSentence = 1 if what == "Account": toAccount = string.lower(qname) continue if not inSentence: print "<#id%i>" % nextId, nextId += 1 # print "[]", # Start the sentence unnamed about thing inSentence = 1 val = "" for c in value: if c == '"': val = val+'\\"' else: val = val + c if property != None: if not inRecord: print ",\n [", qq inRecord = 1 if split and property=="splitCategory": # @ special! Starts new part of split print "],\n [", if not split and property[0:5]=="split": # @ convention! print "qu:split\n [" split =1 if property.find("date") >= 0: val = convertDate(val) elif property.find("amount") >=0: val = convertAmount(val) elif property=="category": i = val.find("/") if i >=0: print "a %s;" % convertName("class",val[i+1:]), val = val[:i] if val[0] == "[": print "qu:from %s;" %convertName("account",val[1:-1]), else: print "a %s;" % convertName("category",val), continue elif property == "number": print dealWithNumber(val), # includess the property name continue print 'qu:%s "%s";'%(property, val), if inSentence: print ".", # if inAccount: print "]\n." if defaultUsed and defaultAccount == "": print """ acc:Default s:label "DEFAULT". """ print "\n\n#ends\n" input.close() def do(path): if verbose: sys.stderr.write("Doing " + path + "\n") if path[-4:] == ".QIF" or path[-4:] == ".qif": extract(path) ######################################## Main program recursive = 0 verbose = 0 files = [] defaultAccount = ""; for arg in sys.argv[1:]: if arg[0:1] == "-": # if arg == "-r": recursive = 1 # Recursive if arg == "-v": verbose = 1 # Tell me even about files which were ok elif arg[:3] == "-A=": defaultAccount = "<%s>" % arg[3:] elif arg[:3] == "-a=": defaultAccount = "" % arg[3:] else: print """Bad option argument. -a=paypal set the default account in case none in file """ sys.exit(-1) else: files.append(arg) if files == []: files = [ "." ] # Default to this directory for path in files: do(path)