QIF Import created spurious accounts

Derek Atkins warlord at MIT.EDU
Thu Dec 13 12:56:04 EST 2007


"Ian Lewis" <ianmlewis at gmail.com> writes:

>     > I agree but since the QIF currency might not match the locale currency,
>     you
>     > should be able to select the QIF currency during import. There seems to
>     be a
>     > part of the QIF import druid for this but it never seems to come up for
>     me.
>     > The QIF import druid just uses the locale currency.
>    
>     Right, and THAT is the bug that needs to be fixed.
>
> Ok, This is a different bug than the one I submitted. This specifically refers
> to the locale rather than just the flow of the QIF import druid. I could
> imagine that the solution is perhaps the same for both bugs however.

It should default to the locale currency unless you change it in
the QIF druid.  The fact that you CAN'T set it in the QIF druid
is a bug that should get fixed.  If you then tell the importer
that you're importing USD but you assign to an account of CAD,
yes, the importer should create a secondary set of accounts.

>     > BTW: By locale currency were are talking about the currency that is set
>     in the
>     > preferences dialog (defaults to locale currency) right?
>    
>     Nope.  The locale currency is the currency you see in your
>     computer locale.   See locale(1)
>
> Hmm, Changing the default currency in the gnucash preferences seems to allow
> me to import the QIF with that currency, i.e. It doesn't create the extra
> accounts, which is what I would expect. Why would it use the system locale
> currency when it could use the gnucash default currency?

Hmm.. That's pretty weird.  Admittedly, GnuCash doesn't have a good
concept (currently) of "default currency".  There are many of them.
There's the default new-account currency (set in the prefs), there's
the default report currency (also set in the prefs), and there's the
locale currency (set in the computer locale, outside of gnucash).

Which currency applies where is... confusing at best.  Eventually
that should get cleaned up, in our copious amounts of free time.

> Ian Lewis
> ianlewis at member.fsf.org
> http://www.ianlewis.org/

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list