OFX Import fails when running MSMoney 2003 Int on Linux

[David Kimber]

• Computing Environment is dual-boot Windows 10 and Ubuntu 24.04.03 LTS
• Money 2003 International version, runs OK on Windows apart from usual bugs e.g. Net Worth report.
• On Linux installed with PlayOnLinux via mounting MSMoney ISO (non-listed program). 
  • Everything seems normal and functions as per Windows version
  • apart from importing OFX files Corrupt message

1. All OFX files are on Google Drive and have tried downloading to local file.
2. They are the same OFX files that are imported correcty into Windows version
3. Converted OFX file to both Linux and Windows formats (CR/LF)

Any suggestions e.g. DLLs ?

[Cal Learner]

Not likely helpful, but easy to try:

When Money is not open and you "run" an OFX file, the file gets put into your %temp% folder as a *.tmp file by mnyimprt.exe. There is an entry put into the registry that Money checks when it gets opened.

You could try running OFX analyze on that *.tmp file or on original ofx file (I expect them to be identical, but not totally sure).  https://microsoftmoneyoffline.wordpress.com/ofx-file-analzer/

I am hoping there is something weird in the OFX.  I expect that is not going to be productive, but I am not going to be able to address Linux stuff.

[N G]

Hi David,

Nice work in getting Money 2003 running with PoL!

Below are some random thoughts, maybe one might help.

I haven't tried Money 2003 myself, I've only gone as far back as Money 2004 with Linux. The deal-breaker for me on Money 2004 was it didn't import my ofx files and I assumed it was an ofx version problem. (greater than 2.0?). Unfortunately I can't find where I had read which versions of Money support up to which versions of OFX. I thought it was in one of the docs list here:

http://moneymvps.org/faq/article/8.aspx

It's possible I had the same problem in Money 2004 that you're having with Money 2003.

Something I do with Sunset running on Linux is install vcrun2005 from winetricks. You might try that, or an older version of visual C runtime. I think PoL has debug and log file features, you might be able to see some errors when you try to import ofx files. I don't use PoL but google should be able to get you in the ballpark.

In any case, in addition to running OFX analyze suggested by Cal, can you tell us what version the ofx files are from the headers in the files? I understand that they work when Money 2003 is running in Windows, do you recall any patches you might have installed in the past? Any registry tweaks? 

[Cal Learner]

I haven't tried Money 2003 myself, I've only gone as far back as Money 2004 with Linux. The deal-breaker for me on Money 2004 was it didn't import my ofx files and I assumed it was an ofx version problem. (greater than 2.0?). Unfortunately I can't find where I had read which versions of Money support up to which versions of OFX.

It is my distant recollection that 2003 and above support 1.02 and 2.0 and maybe 1.03.

2004 has good compatibility with lots of stuff, and might be the best before the move to more dependence on online. I think Money 2003 may have some 16-bit code, and I think 2024 does not. I am not saying that the OFX handling of Money 2003 involves any 16-bit code. I do know that both 2004 and 2005 were able to convert some earlier versions, where Money 2006 required an intermediate stage of conversion.

Money 2004 was the last one with a good built-in help.

[Bob Smiley]

The OFX 2.0 and later specifications came out in 2006. Money 2004 (and earlier) would be unable to understand an OFX 2.0 file. If I remember correctly, the update to Money 2005 included support for OFX 2.0. This was unavailable when Money 2005 shipped.

Bob

[Cal Learner]

Thanks Bob! And for those who may not know, Bob KNOWS!

[David Kimber]

Thanks all for the clarification regarding versions of OFX, I will try changing the OFX headers by to V1.x, but may be long shot as the same MSMoney version on Windows works with the OFX files.

Just for info and being UK based, I have hacked together Python code to fix HSBC OFX credit card downloads (they don't adhere to NAME length of 32 chars), converting CSV statement downloads from Starling, Chase UK, and Capitec SAF and FT watchlist price to OFX files. I am not a developer but I have worked out a way to update stock and fund prices via a two step process in 2003 into version. I am sure there are better apps, but it was done as a bit of fun learning python, but happy to share.

Regards David

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/0b7fd47c-a44c-4617-9264-0c964a8cb29bn%40googlegroups.com.