summaryrefslogtreecommitdiffstats
path: root/contrib/csvpricesqif.py
diff options
context:
space:
mode:
authortpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da>2011-07-04 22:38:03 +0000
committertpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da>2011-07-04 22:38:03 +0000
commitdadc34655c3ab961b0b0b94a10eaaba710f0b5e8 (patch)
tree99e72842fe687baea16376a147619b6048d7e441 /contrib/csvpricesqif.py
downloadkmymoney-dadc34655c3ab961b0b0b94a10eaaba710f0b5e8.tar.gz
kmymoney-dadc34655c3ab961b0b0b94a10eaaba710f0b5e8.zip
Added kmymoney
git-svn-id: svn://anonsvn.kde.org/home/kde/branches/trinity/applications/kmymoney@1239792 283d02a7-25f6-0310-bc7c-ecb5cbfe19da
Diffstat (limited to 'contrib/csvpricesqif.py')
-rwxr-xr-xcontrib/csvpricesqif.py59
1 files changed, 59 insertions, 0 deletions
diff --git a/contrib/csvpricesqif.py b/contrib/csvpricesqif.py
new file mode 100755
index 0000000..656ce20
--- /dev/null
+++ b/contrib/csvpricesqif.py
@@ -0,0 +1,59 @@
+#!/usr/bin/python
+# -*- coding: utf-8 -*-
+#
+#***************************************************************************
+# csvpricesqif.py - description
+# -------------------
+# begin : Sat 24 Oct. 2009
+# copyright : (C) 2009 by Allan Anderson
+# email : aganderson@ukonline.co.uk
+#
+#***************************************************************************/
+#
+#***************************************************************************
+#* *
+#* This program is free software; you can redistribute it and/or modify *
+#* it under the terms of the GNU General Public License as published by *
+#* the Free Software Foundation; either version 2 of the License, or *
+#* (at your option) any later version. *
+#* *
+#***************************************************************************/
+
+import csv
+
+# *** NOTE ***
+# It may be necessary to remove the second line, before running.
+
+# Simple script to convert a csv format Prices file, as from later
+# editions of Quicken, to qif format for KMyMoney2.
+# It and its data files are expected to be in the same directory.
+# First make the script executable:- chmod u+x csvpricesqif.py
+# Run by ''./csvpricesqif.py' .
+# You will be prompted to enter input and output filenames, followed
+# by the symbol for the stock.
+
+# Input format - "23.12.09","61.62",,,
+# Output format -
+# !Type:Prices
+# "HJU8.BE",61.62,"23.12.09"
+# ^
+
+fin = raw_input('Please enter the input Prices filename (.csv, .PRN, etc.) : ')
+fout = raw_input('Please enter the output filename (add .qif) : ')
+symbol = raw_input('Please enter the symbol for this stock: ')
+symbol ='"'+ symbol+'"'# Add " " around symbol
+
+inputfile = csv.reader(open(fin, 'rb'))
+outputfile = open(fout, 'w')
+inputfile.next() # Skip header line. Comment out if no header.
+inputfile_list = []
+inputfile_list.extend(inputfile)
+
+for data in inputfile_list:
+ line = '!Type:Prices\n'
+ line = line +symbol +',' + data[1] + ',"' + data[0] + '"\n' + '^\n'
+
+ #print line
+ outputfile.write(line)
+
+outputfile.close()