Kmymoney parsing error on Ubuntu 24.04

Help
1

Version 5.1.3 Kmymoney on 24.04 1 LTS
When trying to open .qfx file, get the Unable to import using OFX plugin. The plugin returned the following error: Unable to parse file

This is a fresh install of Ubuntu. And of course, this all worked flawlessly on the old system so I don’t feel the bank has changed its file format.
Does anyone have an idea of the cause?
Thank you.

1 Like
2

It seems, that QFX files exist in two different formats: one is based on XML which is what the plugin understands, and the other one is a binary (maybe proprietary) format. We just recently got the screenshot of such a binary file opened in an editor attached to one of our bug entries. That is the version the plugin does not know of and will respond with the said error message.

Since you’re on Kubuntu, can you open a terminal/konsole window and run the file utility on your qfx file? What does it report?

Here’s how this looks like when I do this on some qfx test files I have:

thb@nb /home/thb $ file Downloads/testml.qfx 
Downloads/testml.qfx: ASCII text, with CRLF line terminators
thb@nb /home/thb $ file Downloads/vanguard-anonymous.qfx 
Downloads/vanguard-anonymous.qfx: ASCII text
3

file transactions_xxxx.qfx results in ASCII text

4

That’s cool, because in this case it should be possible to be processed. Can you monitor which messages are printed to the console when importing the file and post them here?

5

Unable to import /home/sjwilke/Downloads/transactions_1234.qfx using OFX plugin. The plugin returned the following error: Unable to parse file.

6

I thought that got printed to an error dialog popping up. My instructions probably were not detailed enough.

  • Start KMyMoney from a terminal (the same way you previously started the file utility)
  • Start importing the QFX file.

I am interested in the messages printed to the terminal window after you started the process until the error dialog pops up. I hope that makes it a bit clearer and hopefully we see some more details there.

7

OfxImporterPlugin::slotImportFile
setup callback routines
process data
LibOFX INFO: libofx_proc_file(): File format not specified, autodetecting…
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open Financial eXchange (OFX or QFX))
LibOFX INFO: sanitize_proprietary_tags() removed: <INTU.BID>6157</INTU.BID>
LibOFX ERROR: find_dtd():Unable to find the DTD named opensp.dcl
LibOFX ERROR: find_dtd():Unable to find the DTD named ofx160.dtd
LibOFX ERROR: ofx_proc_file(): FATAL: Missing DTD, aborting
process data done
kf.notifications: Audio notification requested, but sound file from notifyrc file was not found, aborting audio notification

8

That is the root cause. It’s not finding a few required files. What is the output (again in a terminal window) of the following two commands:

find /usr -name opensp.dcl
find /usr -name ofx160.dtd

I have those installed as part of libofx which I build myself so the paths might be different for you. Maybe we deal with a packaging issue on Kubuntu which would explain why it worked previously.

9

Coming up with nothing on those commands. Even searched other directories. I am not finding those two files.

10

Ok, then it looks like a packaging issue of the libofx package for Ubuntu. You probably need to contact someone over there.

11

Thank you for your assistance.