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