Bug 513589

Summary: QIF import errors
Product: [Applications] skrooge Reporter: Bob Nestor <rnestor>
Component: generalAssignee: Stephane MANKOWSKI <stephane>
Status: RESOLVED FIXED    
Severity: normal    
Priority: NOR    
Version First Reported In: 25.10.0   
Target Milestone: 25.1.0   
Platform: Mint (Ubuntu based)   
OS: Linux   
Latest Commit: https://invent.kde.org/office/skrooge/-/commit/1ba4d7e60a35331a236b0a35a21ba93c69ffe85b Version Fixed/Implemented In:
Sentry Crash Report:

Description Bob Nestor 2025-12-19 20:38:24 UTC 
Importing a QIF file that conforms to the format documented in http://xl2qif.chez-alice.fr/download/QIF99.pdf
can abort with "Date format errors" even though all the date fields are in ISO 8601 Skrooge/Linux format.  The error is due to the import process assuming all lines beginning with "D" are date fields, but there are sections of the QIF file where the "D" field is used for a Description.  At least the presence of a Description in an Account Definition, Category and Budget will raise this error.  It may also occur in the Security, Payee and Class sections of the QIF file, but that wasn't tested/observed.

The error message produced is somewhat ambiguous because it doesn't identify where in the QIF file the error was seen, and in this case the error itself is incorrect as it's not a QIF file format error, it's a Skrooge processing error.
Comment 1 Stephane MANKOWSKI 2025-12-19 21:21:00 UTC 
Could you provide me a QIF sample file to reproduce the issue ?
Comment 2 Bob Nestor 2025-12-20 00:01:34 UTC 
!Option:AutoSwitch
!Account
NAIM
D5009091932
X
ABrokerage
TPort
B0.00
^
NAmerican Express
D3700-000000-06009
L15,500.00
X
ACredit Card
TCCard
B0.00
^
!Clear:AutoSwitch
!Type:Cat
NAuto
DAutomobile Expenses
E
^
NAuto:Fuel
DAuto Fuel
E
^
NAuto:Insurance
DAuto Insurance
E
^
!Type:Payee
!Type:Cat
NAuto
DAutomobile Expenses
E
^
NAuto:Fuel
DAuto Fuel
E
^
NAuto:Insurance
DAuto Insurance
E
^
!Type:Budget
NAuto
DAutomobile Expenses
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
B-5.00
^
NAuto:Fuel
DAuto Fuel
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
B-84.00
^
NAuto:Insurance
DAuto Insurance
B0.00
B0.00
B0.00
B0.00
B0.00
B0.00
B0.00
B0.00
B0.00
B0.00
B0.00
B0.00
^
!Type:Class
NSample Class
DTesting purposes only
^
NSample Class:Sample subclass
DJust another test
^
!Account
NAIM
D5009091932
X
ABrokerage
TPort
B0.00
^
!Type:Invst
D1996-07-19
NShrsIn
YAIM Value Fund
I28.830
Q260.219
CX
T0.00
MFrom IDS Savings
^
Comment 3 Stephane MANKOWSKI 2025-12-20 12:25:30 UTC 
Git commit 1ba4d7e60a35331a236b0a35a21ba93c69ffe85b by Stéphane MANKOWSKI.
Committed on 20/12/2025 at 12:25.
Pushed by smankowski into branch 'master'.

QIF import errors

M  +1    -0    CHANGELOG
M  +4    -0    plugins/import/skrooge_import_qif/skgimportpluginqif.cpp
A  +116  -0    tests/input/skgtestimportqif2/513589.qif
M  +14   -0    tests/skgbankmodelertest/skgtestimportqif2.cpp

https://invent.kde.org/office/skrooge/-/commit/1ba4d7e60a35331a236b0a35a21ba93c69ffe85b