[GNC] QIF import fails without error messages

Geoff cleanoutmyshed at gmail.com
Fri Dec 8 20:38:52 EST 2023


Hi Thomas

I also use QIF files extensively and was surprised when you reported 
this error.

Coincidentally, yesterday I upgraded to v5.4.1 and found that I can 
reproduce the same error.  By a process of elimination I found that it 
is due to the ambiguity in the date format.  Using your example, a date 
of "01/12/2023" could be interpreted as 1st of December *or* 12th of 
January.  Despite telling GnuCash that the dates are to be interpreted 
as "d-m-y" this information seems to be lost and the process fails.  I 
also tried "2023/12/01" with "y-m-d" and this failed too.  Unambiguous 
dates like "29/11/2023" work fine.

I have now downgraded to v4.8 and your file was imported without any 
errors - see attached screenshot.

I recommend that you:
(a) Downgrade to a version 4 release.
(b) Submit a bug report about this problem
https://bugs.gnucash.org/enter_bug.cgi

Regards

Geoff
=====
GnuCash v4.8 on Windows 10

On 9/12/2023 7:59 am, Thomas via gnucash-user wrote:
> Hello,
> 
> i'm using GnuCash for a very long time (thanks a lot for it). In order
> to handle some regular (monthly) payments I created a small script to
> create very simple QIF files that I can then import into GnuCash. That
> was working perfectly for some years now. Anyhow for the last 2 or 3
> months (only using it once a month) the import failed without telling me
> why (there is just no message in the dialog). It happened for the first
> time (I think) two months ago. Then I did it manually and it worked the
> following month. Anyhow now (this month) it fails again. There it does
> not seem to be a "one time problem".
> 
> The QIF file is very simple and I can't see why that should fail:
> 
> !Account
> NAktiva:Umlaufvermögen:Girokonto (1234567)
> ^
> !Type:Cash
> D01/12/2023
> T-123
> LAktiva:Anlagevermögen:Bausparer (1234567)
> ^
> 
> (the real file contains more payments but this simple also fails)
> 
> During the import wizard GnuCash identifies both accounts to exist and
> accepts the date format as d-m-y. Anyhow it fails without message.
> 
> Any idea on why that happens?
> 
> Thanks a lot.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnc_qif_import_date_error.jpg
Type: image/jpeg
Size: 136886 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20231209/df469b42/attachment-0001.jpg>


More information about the gnucash-user mailing list