Me too on "Match payees/memos to Gnucash accounts ignored during QIF import"?

Kent Dahl kentda at pvv.org
Sun Apr 27 03:56:02 EDT 2008


Likely this is a duplicate of the issue mentioned in "Match payees/memos
to Gnucash accounts ignored during QIF import" thread, but I didn't see
any resolution nor bug number in the email thread and I noticed some
things while playing with it.

I've recently upgraded from Kubuntu 7.10 to 8.04 and am starting my
GnuCash accounting file from scratch (i.e. 2008 onwards) as the old one
is getting a bit crufty (with 5 years of data). I'm thus reimporting the
last three months of QIF files, which all imported OK on the old GnuCash
file, before the upgrade. 

There should be nothing scary in my QIFs. They're simple things created
by my dnbnor2qif Ruby script, so no L category lines etc. I'm also not
using scheduled transations or anything else scary. Most complicated
thing I have so far is a stock.

Reason for the email is that I noticed the QIF Import Druid has two
dialogs; one for mapping QIF Categories and a second one for mapping QIF
Memos. My files do not use any QIF categories ("L" entries), just Memos
("M"), for description. (Sample below.) But there still shows up one
blank line under the QIF category mapping dialog, which then points to
Unspecified. It seems this line overrides the memo/payee mapping done in
the next dialog. If I change it to a generic expense in stead, they all
end up there.

Interestingly, the one mapping that does survive and go into correct
place is income, but that entry has an explicit payee ("P") entry in the
QIF.

I'm using: GnuCash 2.2.4 (r16997 on 2008-03-27) (2.2.4-1ubuntu1)

The dnbnor2qif script:
http://www.pvv.org/~kentda/ruby/filer/dnbnor2qif.tar.gz

P.S.: Thanks for all the great work on GnuCash. 

=====<SAMPLE>=====
!Account
NMy bank account
^
!Type:Bank
MPay the rent
D03-01-2008
T-15000.0
^
!Type:Bank
MSometing to eat
D03-03-2008
T-345.5
N12345678
^
=====</SAMPLE>=====

-- 
Kent Dahl <kentda at pvv.org>
http://www.pvv.org/~kentda/



More information about the gnucash-user mailing list