[GNC] Changing account tree on large database

[Cricket Onebit]

Yep, that's my plan. Quicken has a bulk-edit feature that I'll make good
use of. When I get around to it. Too many emergency late nights last week
to tackle something I need to be awake for.

For now, I've decided to do the urgent report in Quicken, then worry about
the conversion. I'd hoped to do the conversion before then, but then I'd
miss the deadline for the report.

Thanks!

On Sat, 27 Apr 2019 at 10:33, Greg Feneis <mfeneis at gmail.com> wrote:

> 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.
> >
> _______________________________________________
> 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.
>


-- 
+++

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