1 files changed, 12 insertions, 0 deletions
diff --git a/schools-cc-importer.py b/schools-cc-importer.py
new file mode 100644
index 0000000..0741d3b
--- /dev/null
+++ b/schools-cc-importer.py
@@ -0,0 +1,12 @@
+import csv
+from datetime import datetime
+with open('transactions.CSV', newline='') as csvfile:
+    with open("temp-trans-out.txt", "w") as output:
+        trans = csv.reader(csvfile, delimiter=',', quotechar='|')
+        for t in trans:
+            dt = datetime.strptime(t[0], '%m/%d/%Y')
+            dt = dt.strftime("%Y-%m-%d")
+            line = '%s * "%s"\n  Liabilities:SchoolsFirst:Card         -%s USD\n  Expenses:Misc:Amazon                  %s USD\n\n' % (dt, t[1], t[5], t[5])
+            output.write(line)
+        output.close()
+    csvfile.close()