Bug 461890

Summary:	Error when importing OFX file that was correctly imported on version 2.27.0
Product:	[Applications] skrooge	Reporter:	Marco Sanchotene <marco.sanchotene>
Component:	general	Assignee:	Stephane MANKOWSKI <stephane>
Status:	RESOLVED DOWNSTREAM
Severity:	major	CC:	machtyn, stephane
Priority:	NOR
Version First Reported In:	Trunk from git
Target Milestone:	25.1.0
Platform:	Neon
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:
Attachments:	Sample OFX file that is not imported.

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.