Please help: How do we Open Quicken or MS Money files with Catalina?

One of the only reasons I kept Numbers from iWork '09 was to open QFX files from my bank.

I wrote a python script located here to read a qfx file and emit a corresponding text file with tab delimited data.

You may download the file here:

https://www.dropbox.com/s/qzla7gx2z40nhrp/QFX_to_Tab_Separated.py?dl=0

copy the script to any folder (I keep it in a folder in my documents folder)

you can invoke the script on the command line by launching the app "Terminal"

make the terminal window and the window with the script file visible

Then type

"python "

that "python" followed by a space, then drag the script file onto the terminal window

then python will run and should present a dialog to open an input qfx file. Navigate to, and select, the file, then open the corresponding text file that appears in the same folder as the original file

As you can see from this thread there don't seem to be many clean and neat solutions, except ones that potentially expose your data. Is there a way for you to get a format other than QIF/QFX/OFX from the data source? If so, that is the safest and most efficient approach.

SG

DO NOT TRY TO copy this text and paste it in a file to run. Python, sadly, relies on tabification to indicate membership in conditional statements. pasting here messes that up and potentially loses intent.

=====<[some text]>=====

indicates a section comment and is NOT a python acceptable comment. I'm just using that to make it stand out here

Here's the text of the script:

=====<[This part reads in libraries]>=====

# Written by Wayne L. Contello

# No guarantee as to the fitness of the script to be used for the intended purpose or any other purpose

# copyright 2019

# All Rights reserved

from __future__ import print_function

import builtins

# import pylab

# import numpy as np

# import matplotlib.pyplot as plt

import ntpath

import tkinter as tk

# import tkMessageBox

import re

import time

import re

from decimal import *

from tkinter import *

from tkinter import filedialog

# from tkinter import *

# import tkFileDialog

# import FileDialog

root = tk.Tk();

root.withdraw();

=====<[This prompts to select the input QXF file. There is no checking the file type, so select the correct file and do not mess up]>=====

file = tk.filedialog.askopenfile(parent=root);

print ("Input file: " + file.name + "\n");

# print("There are %d data items" % (len(DataItem)))

=====<[This sets the output file name and path, then opens the file]>=====

oFileName = file.name.replace(" ", "_") + ".out.txt"

print("Opening file: " + oFileName)

oFile = open(oFileName, 'w');

oFile.write("")

# now read the data from the input file and write to the proper output file if the CAN ID matches

x = 0

linesOfFile = file.read().split("<STMTTRN>")

for line in linesOfFile:

# this parses the fields out of a single line in the file

if(x > 0):

row = {}

# TRNTYPE = ""

# DTPOSTED = ""

# TRNAMT = ""

# FITID = ""

# NAME = ""

# MEMO = ""

# CHECKNUM = ""

# NAME = ""

remainingline = line.replace("</STMTTRN>", "")

# print(remainingline)

result = re.split("<", remainingline)

for item in result:

if(item):

fields = item.split('>')

row[fields[0]] = fields[1]

# print(row)

# Amount Date Type Check Number Payee Name Memo

# TRNAMT DTPOSTED TRNTYPE CHECKNUM NAME MEMO

oStr = ""

val = row.get('TRNAMT') if row.get('TRNAMT') else ""

oStr += val

oStr += "\t"

val = row.get('DTPOSTED') if row.get('DTPOSTED') else ""

if(val):

DateTime = val.split('.')

# print(DateTime[0])

YYYY = DateTime[0][0:4]

Mon = DateTime[0][4:6]

DD = DateTime[0][6:8]

HH = DateTime[0][8:10]

MM = DateTime[0][10:12]

SS = DateTime[0][12:14]

DT = Mon+"/"+DD+"/"+YYYY+" "+HH+":"+MM+":"+SS

else:

DT = ""

oStr += DT

oStr += "\t"

val = row.get('TRNTYPE') if row.get('TRNTYPE') else ""

oStr += val

oStr += "\t"

val = row.get('CHECKNUM') if row.get('CHECKNUM') else ""

oStr += val

oStr += "\t"

val = row.get('NAME') if row.get('NAME') else ""

oStr += val

oStr += "\t"

val = row.get('MEMO') if row.get('MEMO') else ""

oStr += val

# this write the reformatted line to the output file

# print("%d:\t%s" %(x, oStr))

oFile.write("%s\n" % (oStr))

x += 1

print("%08d" % (x))

# close the open files

if(oFile) :

oFile.close()

print("closing output file")

if(file) :

file.close()

print("closing input file")

exit();

pole1108 wrote:

Numbers is the apple program that used to work to open these type of files. Now, it doesn't.

A version of Numbers now already over 10 years old used to open QIF files.

Does this mean, people like me are out of luck? or might it be a way around it?

There's usually a way. You might consider exporting the data from Quicken in a more widely recognized format than QIF.

SG

make sure you have the 64 bit version of 365

https://go.microsoft.com/fwlink/p/?linkid=830196

if you can't get it to work you could try to log in with your Microsoft ID on

office.com

once you log in you can use the web versions of MS Office.

Quicken 2019 is out but I have no idea what they are supporting or not, you'd have to ask them what their plans are

https://community.quicken.com/discussion/7862670/quicken-for-mac-v5-13-released

Those are excellent questions that you are smart to consider. Python is a relatively recent scripting language (similar to perl, ruby, tk/tcl) that can perform various operations including processing data.

In this case, the script reads in the QFX file and picks out the fields and writes them to another file file. The best way to determine the script is safe is to open the script in a text editor and read the file. Opening the file . I assume you will not be able to do that since you do not know about python.

So your other ways to establish trust are:

1) I have a long history in the Apple forums

2) some of the other participants in the forum can look at the script and provide feedback as to the "safety" or running the script