SUMMARY Can not import ofx or qfx files. I get the following error dialog. Unable to import '/home/seseeley/Documents/finances/2025/JointChecking/Checking2 Jan 2025.qfx' using the OFX importer plugin. The plugin returned the following error: Unable to parse file STEPS TO REPRODUCE 1. Use existing or create new empty .kmy file 2. Import any ofx or qfx file 3. OBSERVED RESULT Unable to parse file error comes back with the error so fast I don't think its even trying to parse the file. EXPECTED RESULT ofx or qfx file parsed and imported into my .kmy file. SOFTWARE/OS VERSIONS I'm trying to migrate from Windows 10 to Ubuntu 24.04.01. Everything works fine in Windows. But I get the above error in Ubuntu. There are version differences: Ubuntu 24.04.1 LTS Gnome 46 KMyMoney 5.1.3 KDE 5.108.0 Qt 5.15.10 Windows 10 KMyMoney 5.1.1-a93931030 KDE 5.79.0 Qt 5.15.2 ADDITIONAL INFORMATION I've tried setting the log file location in Settings, Configure KMyMoney..., General, Support, Log path But I get no log file. I've tried importing into an new empty .kmy file with no success.
The first thing here is to be sure it really is a valid ofx/qfx file. Please post the first few lines of the file. Where did you get that file? If you are saying the same file imports OK on Windows but not on Ubuntu, then how did you transfer the file?
(In reply to Jack from comment #1) > The first thing here is to be sure it really is a valid ofx/qfx file. > Please post the first few lines of the file. Where did you get that file? > If you are saying the same file imports OK on Windows but not on Ubuntu, > then how did you transfer the file? It's all on a single line: OFXHEADER:100DATA:OFXSGMLVERSION:102SECURITY:NONEENCODING:USASCIICHARSET:1252COMPRESSION:NONEOLDFILEUID:NONENEWFILEUID:NONE<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20250204125507.092[-8:PST]<LANGUAGE>ENG<FI><ORG>WF<FID>3000</FI><SESSCOOKIE>d6562d1e-f985-4d2e-b3eb-318056f6859a-02042025145506991<INTU.BID>3000<INTU.USERID>ses7nak3</SONRS></SIGNONMSGSRSV1><BANKMSGSRSV1><STMTTRNRS><TRNUID>0<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><STMTRS><CURDEF>USD<BANKACCTFROM><BANKID>121042882<ACCTID>0483246609<ACCTTYPE>CHECKING</BANKACCTFROM><BANKTRANLIST><DTSTART>20250101120000.000[-8:PST]<DTEND>20250131120000.000[-8:PST]<STMTTRN><TRNTYPE>DIRECTDEP<DTPOSTED>20250102120000.000[-8:PST]<TRNAMT>1156.46<FITID>202501021<NAME>PUB EMP RET SYS RET BENFT<MEMO>010225 V1584063 PERS KELLER-SEELEY N A</STMTTRN><STMTTRN><TRNTYPE>PAYMENT<DTPOSTED>20250102120000.000[-8:PST]<TRNAMT>-147.25<FITID>202501022<NAME>BILL PAY DISH NETWORK ON-LINE<MEMO>xxxxxxxxxxxx2596 ON 01-02</STMTTRN><STMTTRN><TRNTYPE>PAYMENT<DTPOSTED>20250102120000.000[-8:PST]<TRNAMT>-4267.00<FITID>202501023<NAME>BILL PAY Cap One CC ON-LINE<MEMO>xxxxxxxxxxxx6547 ON 01-02</STMTTRN><STMTTRN><TRNTYPE>PAYMENT<DTPOSTED>20250103120000.000[-8:PST]<TRNAMT>-986.93<FITID>202501031<NAME>BILL PAY Quicken Loans RECURRING<MEMO>xxxxxx3571 ON 01-03</STMTTRN><STMTTRN><TRNTYPE>DIRECTDEP<DTPOSTED>20250108120000.000[-8:PST]<TRNAMT>3127.00<FITID>202501081<NAME>SSA TREAS 310 XXSOC SEC<MEMO>010825 XXXXX3425A SSA STEVEN E SEELEY</STMTTRN><STMTTRN><TRNTYPE>DIRECTDEBIT<DTPOSTED>20250108120000.000[-8:PST]<TRNAMT>-113.00<FITID>202501082<NAME>IOF - FORESTERS FORESTERS<MEMO>39119283410974 STEVEN/NORA SEELEY</STMTTRN><STMTTRN><TRNTYPE>CHECK<DTPOSTED>20250117120000.000[-8:PST]<TRNAMT>-222.72<FITID>202501171<CHECKNUM>4937<NAME>CHECK</STMTTRN><STMTTRN><TRNTYPE>DIRECTDEP<DTPOSTED>20250122120000.000[-8:PST]<TRNAMT>2289.00<FITID>202501221<NAME>SSA TREAS 310 XXSOC SEC<MEMO>012225 XXXXX8688A SSA NORA A KELLER-SEELEY</STMTTRN><STMTTRN><TRNTYPE>XFER<DTPOSTED>20250128120000.000[-8:PST]<TRNAMT>-200.00<FITID>202501281<NAME>TO SEELEY S REF #OP0R42QL6T EVER<MEMO>RECURRING TRANSFER YDAY CHECKING STEVE ALLOWANCE</STMTTRN><STMTTRN><TRNTYPE>XFER<DTPOSTED>20250128120000.000[-8:PST]<TRNAMT>-200.00<FITID>202501282<NAME>RECURRING TRANSFER TO<MEMO>SAFE CREDIT UNION CHK XXXXXX3912 S. SEELEY REF #FP0R42RF3B NORA ALLOWANCE</STMTTRN><STMTTRN><TRNTYPE>DIRECTDEP<DTPOSTED>20250131120000.000[-8:PST]<TRNAMT>1156.46<FITID>202501311<NAME>PUB EMP RET SYS RET BENFT<MEMO>013125 V2443508 PERS KELLER-SEELEY N A</STMTTRN><STMTTRN><TRNTYPE>PAYMENT<DTPOSTED>20250131120000.000[-8:PST]<TRNAMT>-3795.98<FITID>202501312<NAME>BILL PAY Cap One CC ON-LINE<MEMO>xxxxxxxxxxxx6547 ON 01-31</STMTTRN></BANKTRANLIST><LEDGERBAL><BALAMT>3585.96<DTASOF>20250203120000.000[-8:PST]</LEDGERBAL><AVAILBAL><BALAMT>2599.03<DTASOF>20250203120000.000[-8:PST]</AVAILBAL></STMTRS></STMTTRNRS></BANKMSGSRSV1></OFX>
The file is from a credit card company. I downloaded the file while on Ubuntu using Firefox. I copy file to USB drive to transfer to Windows.
I'm getting the same exact error as posted here: https://discuss.kde.org/t/kmymoney-parsing-error-on-ubuntu-24-04/24468/11 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>4351 LibOFX INFO: sanitize_proprietary_tags() removed: <INTU.USERID>06PandaBear 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 kf.notifications: Audio notification requested, but sound file from notifyrc file was not found, aborting audio notification
I was going to start by saying that is not an ofx file, although a subset of it (starting with <OFX> and ending with </OFX>) is. You might try extracting that part to a new file and try importing it. However, if you are getting the same issue as in the post you link to on Discuss, and you are missing those DTD files, then that is likely your problem, and as was suggested in that thread, you need to take this up on an Ubuntu specific mailing list or forum. (I'm going to try spinning up an Ubuntu instance in VirtualBox to see if I can confirm, but I'm not sure how quickly I'll be able to do so.)
I installed https://linux-packages.com/ubuntu-24-04/package/libofx-dev and created link sudo ln -s libofx7/libofx libofx still no joy
I thought I had replicated the error, but it seems not. I tried importing a file similar to yours, and it failed, but in my case, it DID find the dtd files. I'm not going to post the errors I got, as once I removed everything before the <OFX> it actually imported just fine, so that was a red herring. So, one test you can do is to trim that file by removing everything before <OFX> and after </OFX>. However, even that wont work if you are missing the dtd files. This points back to a problem with your installation of libofx7t64. (You shouldn't need the -dev package as that has header files needed for compiling against that lib, but shouldn't be necessary for plain use.) The version of libofx7t64 I have is 1:0.10.9-1build2. The files are in /usr/share/libofx7/libofx/dtd. If you don't have that folder or there are no files in it, there is a problem with the version of libofx you have installed. The first thing I would try in that case is to reinstall it, and possible for force a clean download of the package.
I ran sudo apt-get install libofx7t64 and got "libofx7t64 is already the newest version (1:0.10.9-1.1build2)." I verified opensp.dcl and ofx160.dtd are located in /usr/share/libofx/libofx/dtd and are read only. I installed KMyMoney as a snap package. Would an appimage be any different? I'll try removing pre <OFX> tags next.
Removing pre <OFX> tags didn't not help. However uninstalling the snap package version from the App Center and installing the Debian version from the App Center fixed the importing problem with libofx. Also, KMM overall seems to be working smoother. We can close this tag/ticket.
Thanks for confirming. Closing as DOWNSTREAM, and changing the Platform to Snap to point to an issue with the Snap Package. (Clearing the "version fixed in" as that field is only for the version of KMyMoney if the problem requires a code fix within the program.)