Bug 461890 - Error when importing OFX file that was correctly imported on version 2.27.0
Summary: Error when importing OFX file that was correctly imported on version 2.27.0
Status: RESOLVED DOWNSTREAM
Alias: None
Product: skrooge
Classification: Applications
Component: general (other bugs)
Version First Reported In: Trunk from git
Platform: Neon Linux
: NOR major
Target Milestone: 25.1.0
Assignee: Stephane MANKOWSKI
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-11-15 22:09 UTC by Marco Sanchotene
Modified: 2025-05-18 18:40 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments
Sample OFX file that is not imported. (801 bytes, text/plain)
2022-11-15 22:09 UTC, Marco Sanchotene
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marco Sanchotene 2022-11-15 22:09:05 UTC
Created attachment 153782 [details]
Sample OFX file that is not imported.

SUMMARY
***
NOTE: If you are reporting a crash, please try to attach a backtrace with debug symbols.
See https://community.kde.org/Guidelines_and_HOWTOs/Debugging/How_to_create_useful_crash_reports
***


STEPS TO REPRODUCE
1. Try to import the OFX file attached.
2. Skrooge displays a message like below:
[ERR-5]: Import of file named 'file:///sample.ofx' failed
[ERR-5]: Import OFX file 'file:///sample..ofx' failed

OBSERVED RESULT
Skrooge displays an error message and the file is not imported.

EXPECTED RESULT
The file should be imported without errors.

SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 5.26.3
KDE Frameworks Version: 5.100.0
Qt Version: 5.15.7

ADDITIONAL INFORMATION
Comment 1 Stephane MANKOWSKI 2022-11-16 21:21:18 UTC
Hi,

Skrooge uses libofx (https://github.com/libofx/libofx) to parse an OFX file.
You can test libofx by using ofxdump in a terminal.
Then, you will see that "ofxdump sample.ofx" returns those error:

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpTilD2P:34:5:E: end tag for element "BAL" which is not open

(Above message occurred on Line 34, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpTilD2P:35:9:E: end tag for element "BALLIST" which is not open

(Above message occurred on Line 35, Column 10)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpTilD2P:36:8:E: end tag for "BANKTRANLIST" omitted, but its declaration does not permit this
/tmp/libofxtmpTilD2P:31:0: start tag was here

(Above message occurred on Line 36, Column 9)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpTilD2P:36:8:E: end tag for "STMTRS" which is not finished

Conclusion: 
This sample file is not a valid OFX file and you should contact the provider of this file.
OR
You are sure this file is correct and you should open a ticket on libofx.
Comment 2 Marco Sanchotene 2022-11-17 21:14:14 UTC
Hi,

It's very unlikely that the file is invalid. As I mentioned, it was correctly imported in a previous version of Skrooge.

I will open an issue on libofx's repository.

Many thanks,
Marco
Comment 3 machtyn 2025-05-18 18:40:56 UTC
Likewise, I am having this issue with a specific bank. As Marco's experience, the file was working prior. Thank you for the information about ofxdump. I have contact my financial institution and notified them of this situation and will see if they make an update.