importing QIF

[Paul Kinzelman]

Thanks for the tips.

1. Sigh.

2. I'm merely using and extending what Quicken generated, it used an N 
marker.

3. You're right, a small test case would be better. I've been using my 
20-yr data
which is "yuge" and that's not efficient. I was hoping this would be easy.
I pulled a snippet out of my big QIF file in the area that looked like I 
could tweak
it by hand pretty easily. Tweaking it was easy. Getting it right is not. :-(

On 5/27/2016 9:50 PM, David wrote:
>
> A couple of points:
>
> 1. qif is an old format that quicken created, and which they don't 
> even use any more. It is, by definition, out of date.
>
> 2. N appears to be the wrong tag for a transaction. L is the right one 
> for transaction categories.
>
> 3. Finally, your examples are not complete ; it is impossible to tell 
> whether the problem is in this snippet, or something else. Try again 
> with a complete, 1 transaction file.
>
>
>
> ------------------------------------------------------------------------
> *From:* Paul Kinzelman <paul at kinzelman.com>
> *Sent:* Fri May 27 22:52:30 EDT 2016
> *To:* Gnucash Elist <gnucash-user at gnucash.org>
> *Subject:* Re: importing QIF
>
> 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.
> >
>
> ------------------------------------------------------------------------
>
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.