Dealing with a large QIF file

[David Carlson]

To your last question I would suggest doing those two in small chunks
covering limited date intervals, perhaps a month at a time.

The reason I suggest that is because it is best to examine each transaction
individually when matching to existing, as it is too easy to lose track of
where you are at  in a large file.

David C

On Mon, Dec 25, 2017 at 5:53 AM, Cliff McDiarmid <cliffhanger at gardener.com>
wrote:

>
>
>    Sent: Monday, December 25, 2017 at 3:23 AM
>    From: D <sunfish62 at yahoo.com>
>    To: "cliffhanger at gardener.com" <cliffhanger at gardener.com>, "Colin Law"
>    <clanlaw at gmail.com>
>    Cc: "Gnucash Users" <gnucash-user at gnucash.org>
>    Subject: Re: Dealing with a large QIF file
>    >Gnucash creates the accounts because you and the transactions used
>    those accounts. Personally, I prefer having all that "clutter," since
>    it represents what happened. Accounting is supposed to >track what
>    happened, after all.
>    >Two points: first, you can hide accounts in the Chart of Accounts,
>    which would allow these accounts to exist without disturbing your daily
>    accounting work. Second, you can delete accounts, if >that really is
>    your goal; when you delete an account with transactions in it, you get
>    a chance to move them all to an account of your choosing. (I propose
>    that this would be easier than editing >the QIF, as another suggests).
>    >Personally, I'd keep the transactions and hide the accounts.
>    >David
>    >On December 25, 2017, at 5:47 AM, 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
>    > _______________________________________________
>    > gnucash-user mailing list
>    > gnucash-user at gnucash.org
>    > [1]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.
>    _______________________________________________
>     Thanks to all for all the advice.  I'm seeing clearer now.  I will
>    probably keep the accounts and hide them.
>
>     One other thing, does anyone know, is it best to import all the
>    accounts in one go?  I have about 32 of them, but only two have over
>    6000 entries.
>
>    Cliff
>
> References
>
>    1. https://lists.gnucash.org/mailman/listinfo/gnucash-user
> _______________________________________________
> 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.
>