importing QIF

Derek Atkins warlord at MIT.EDU
Wed Jun 15 13:22:40 EDT 2016


Hi,

Paul Kinzelman <paul at kinzelman.com> writes:

> I know I can do it that way, but remember, I have a "yuge" database, the biggest
> and best database in the world, nobody has databases like I do. :-)
>
> But seriously, it's pretty big (QIF > 2Mb) and yes, I could do that, but it's a
> lot of work given how many categories I have in my Quicken database,
> and being as how I'm an engineer, I'll spend weeks to elegantly solve a problem
> that I could brute force in an hour. :-)

Coming in a bit late due to being on vacation, so this may no longer be
relevant to you, but...

During the QIF import process there are several pages where you can map
the QIF Categories/Accounts to GnuCash Accounts.  This only lets you map
to *existing* accounts.  So if you *have* an account Expenses:House:Rent
then you can map the QIF Category House:Rent to the GnuCash account
Expenses:House:Rent.

Now, it MAY be possible (I honestly don't recall, because it's been over
a decade since I've really looked at or used the QIF importer) for you
to assign the account without it already existing.  But it may be the
case that if the GnuCash account does not already exist then you might
not be able to change its name during the import.

In that case, what you should do is complete all your importing using
the QIF names, and then re-organize your account tree.  Or you can start
by creating a full set of accounts and then map them during the import.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-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