QIF importer bug in GC 2.2.2: stocks -> commodities
William D. Hamblen
William.D.Hamblen at Dartmouth.EDU
Fri Jan 4 08:08:00 EST 2008
Hi everyone,
This seems to only affect importing commodities and only if you have
records in the "map from QIF stock name to GNC commodity" section of the
qif-accounts-map file. If it's empty, no problem.
When you do have data in the commodity section of qif-accounts-map, the
importer GUI no longer asks you to confirm the name, type, and symbol
for commodities and no commodities/securities are created in GnuCash.
This leaves the corresponding accounts in GC a bit incomplete. There
are no "units" for the account so the balance is 0 until you create a
security for it.
I've attached a simple QIF file that demonstrates this. Delete or
rename your .gnucash/qif-accounts-map file and start GnuCash with an
empty file. Import the QIF file. Optionally change from NYSE to NASDAQ
(where INTC is traded). Apply the import. The importer will dutifully
record INTC in qif-accounts-map. The security editor will show Intel as
a stock. The stock account has a balance of 1 share on INTC. Life is
good.
Now you have a qif-accounts-map. Exit and do the import again (into a
new empty file). This time you will not be asked about securities and
none will be created. The stock account will have a zero balance (until
you create a security for it).
I think on my real data the importer was ok if everything was set to
NYSE (that's why in the example I included the step to change to NASDAQ)
but that doesn't seem to be true for this test file. I'm a little
confused by that.
On a related note, if you select commodity type FUND the account type
gets set to Stock but probably should be Mutual Fund.
Unless somebody tells me not to, :-), I'll try to put together a bug
report and file it this weekend.
- Bill
-------------- next part --------------
!Type:Security
NIntel Corporation
SINTC
TStock
^
!Option:AutoSwitch
!Account
NIRA
TInvst
^
!Type:Invst
D1/ 2' 8
NBuy
YIntel Corporation
I25
Q1
U25.00
T25.00
^
More information about the gnucash-devel
mailing list