[GNC] QIF import fails without error messages

Werzi2001 at gmx.de Werzi2001 at gmx.de
Sat Dec 9 11:22:15 EST 2023


Hi Geoff,

thanks a lot for confirming my problem. I thought about a date problem
(which also explains why it worked sometimes) but as the import let's
you select the right format I didn't dig deeper.
Anyhow you are right. Using a unambiguous date it works just fine. Going
back to an older version is not an option for me right now (to much
work) and therefore I'll just wait for the fix.

I created a bug if you'd like to follow it:
https://bugs.gnucash.org/show_bug.cgi?id=799160

Best regards
Thomas

On 09.12.23 02:38, Geoff wrote:
> 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.




More information about the gnucash-user mailing list