Dealing with a large QIF file

[Lincoln A Baxter]

On Mon, 2017-12-25 at 00:46 +0000, cliffhanger at gardener.com wrote:
>    Thanks. Yes one can import one at a time but this cheque ac from
>    Quicken is huge and has references to other card accounts as
> categories
>    within it. These accounts don't exist anymore and gnucash is
> trying to
>    create them as part of the import. This is something I'd like to
> avoid.
>    Hope this makes sense. Cliff
> 
>    -------- Original Message --------
>    Subject: Re: Dealing with a large QIF file
>    From: Colin Law
>    To: Cliff McDiarmid
>    CC: gnucash-user at gnucash.org
> 
>      You should be able to export one account at a time from Quicken,
> I
>      think. Then import them one at a time.
>      Colin
>      On 24 December 2017 at 19:02, Cliff McDiarmid wrote:
>      > Hi
>      >
>      > I'm importing a large QIF file(a current a/c)about 6000
> entries.
>      > There are about a dozen other a/c's from Quicken, now closed,
>      > associated with this large file. When importing, Gnucash seems
> to
>      > want to create these defunct a/c's to 'balance the books'. I
>      assume
>      > there isn't any way of avoiding this. The whole thing looks
> like
>      it
>      > will be horrendous. I've imported some small credit card a/c's
>      already
>      > with success, but they were not any of these other closed
>      accounts.
>      >
>      > Any advice please.
>      > thanks
>      >
>      > Cliff

You might want to try editing the QIF file, and change all the
different categories referring legacy card accounts to one name.  Call
it "Legacy Card" or something like that.

In Quicken there was not enforcement of consistency of category
names... Quicken just said "ok" to what ever you put it.  It is pretty
loosy goosy.  But after you get things into GC, you can clean it up. I
was start, as a said, with the pre cleanup.  It is likely to make your
conversion easier.

Lincoln


>