[GNC] Changing account tree on large database

[Greg Feneis]

Alternatively, Cricket, instead of exporting from Quicken, then arranging
things as you like, then importing to GnuCash, or some variation of that,
you could make a copy of your Quicken working file and from within Quicken,
arrange things as you like with a mind toward exporting to GnuCash, then
export from Quicken and import to GnuCash.  At one point, I recall trying
to decipher OFX or QIF files.  I found that exporting the same data as CSV
and opening in Excel gave me good hints about what I was looking at in the
OFX or QIF




Kind regards,

Greg Feneis




On Fri, Apr 26, 2019 at 8:06 PM Cricket Onebit <cricketbeautiful at gmail.com>
wrote:

> >
> > You WILL almost certainly see some strangeness in the imported data
> > because Quicken doesn't strictly enforce balanced transactions as GnuCash
> > does. When you're just dealing with a few years, you may find it easy to
> go
> > back and fix the odd strange transactions in Quicken, and start the
> import
> > over from scratch.
> >
>
> That's my first choice. I already checked for uncategorized transactions,
> and will remove the few stock purchases. Any other risky types?
>
> It seems like I started with the default GnuCash accounts, and worked from
> > a printout of my Quicken accounts and categories, and created them in
> > GnuCash beforehand. That made the transfer happen much faster because I
> > wasn't creating new accounts as I went along.
> >
>
> I remember letting GnuCash get the accounts from the QIF worked 2 years
> ago. It was other things that didn't work. That method might affect its
> ability to catch transfers. (Another reason I prefer double-entry
> accounting. One transaction with many accounts, rather than two
> transactions.)
>
>
> > You might also try exporting just however many years of data from a
> single
> > bank account at a time until you have them all. Unless I'm
> mis-remembering,
> > I think the only places you'll have duplicate transactions will be those
> > places where you transferred money BETWEEN the bank accounts.
> >
>
> There are a lot of transfers, about 10 a month, with credit cards, mortgage
> and car loan, and cash withdrawals.
>
> I think I'm ready for the next set of tests, hopefully in a few days.
>
> Good luck!
> >
>
> Thanks! If the program is as good as the community, I'll be very happy.
>
> +++
>
> Not as a ladder from earth to Heaven, not as a witness to any creed,
> But simple service simply given to his own kind in their common need.
> -- Rudyard Kipling
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>