importing QIF

[Paul Kinzelman]

I tried a few different modifications. Using the wikipedia QIF entry (which
seems to be somewhat out of date, still mentions classes instead of 
tags) and looking at
the file, it looks like it wants to have the subaccounts bracketed with 
the top account.

Here's a portion of what I tried in case you have any suggestions. My 
comments
are in [xxxxxx] that aren't in the QIF file. I also named it Expensesxx 
in case the
Expenses account was a reserved word.

My modification didn't seem to do anything, the House account still came out
top level when I imported the QIF file and Expensesxx didn't appear 
anywhere.
---------------------------
NExpensesxx    [I added this record because the top level seemed to be 
needed to be defined]
E
^
NExpensesxx:House   [This was in the file already, I just added 
"Expensesxx:" to the account name]
DCA house expenses
E
^
NExpensesxx:House:Appliances
B-21.00
B-21.00   [I have no idea of what this repeated line is for. The wiki 
entry doesn't help]
B-21.00
B-21.00
B-21.00
B-21.00
B-21.00
B-21.00
B-21.00
B-21.00
B-21.00
B-21.00
E
^
NExpensesxx:House:ZZZZZ [This appears to be a termination record once 
the subaccounts are defined]
DCA house expenses
E
^
NExpensesxx:ZZZZZ   [I added this terminating account to match the one I 
added up top]
DExpenses
E
^



Perhaps the account "Expenses" is predefined and so can't be defined again.

On 5/27/2016 7:21 PM, David T. wrote:
> What happens if you change the qif so that it reads 
> "Expenses:House:Garden"?
>
>
>     On Fri, May 27, 2016 at 20:11, Paul Kinzelman
>     <paul at kinzelman.com> wrote:
>
>     I'm trying to import a large QIF file from my Quicken, and one
>     inconvenient thing
>     is that GnuCash does not recognize many accounts as being expense
>     accounts
>     because it does not group them under the parent account 'Expenses'.
>
>     For instance, my Quicken categories 'House:Garden' and
>     'House:Household' are
>     both recognized as subaccounts under 'House' in Gnucash, but
>     neither are
>     put under the parent 'Expenses' as is suggested in the setup. I've
>     looked at the
>     QIF file, but it's not obvious to me how to put a Category under a
>     parent by
>     direct editing the QIF file.
>
>     Can anybody suggest a way to put the 'House' Category
>     in Quicken under a (new) parent account 'Expenses' in GnuCash? I
>     figured
>     that
>     editing the QIF file might be easier than all the mouse clicks
>     necessary to
>     do this to all my Quicken expense categories when imported into
>     GnuCash.
>     TIA!
>
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org <javascript:return>
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     -----
>     Please remember to CC this list on all your replies.
>     You can do this by using Reply-To-List or Reply-All.
>