Documentation for Importation

[Jerry Criswell]

I did that.  I exported my share draft account a year at a time  and
cleaned up the unspecified file each time.  I am now converted and have
a usable gnucash at this time.  Still needs a little clean-up but my
share draft account is in balance.  I'll double post for a while but
we're good to go I think.
-- 

JC 

-----Original Message-----
From: David T. <sunfish62 at yahoo.com>
To: Jerry Criswell <jcriswell58 at gmail.com>
Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: Documentation for Importation
Date: Mon, 26 Nov 2012 12:49:30 -0800 (PST)

Jerry--


For what it's worth, I would recommend going back in to Quicken and
getting EVERYTHING categorized first, and then doing the Export/Import.
Since you are probably more comfortable with the Quicken interface to
begin with, it will be quicker that way. Then, when you go to import
into Gnucash, you won't end up with a boatload of transactions in
IMBALANCE-USD.


I seem to recall that I had to go through my transactions a number of
times, searching for particular payees, and then changing the Quicken
category to something appropriate. For example, I might search my
transactions for all McDonald's payees, and then change every found
transaction to "Dining" [if you could call it that!]


Frankly, I find that I end up doing this sort of exercise every once in
a while (annually, if I am lazy, quarterly if I am not) to make sure
that I am getting all my tax-deductible transactions into the
appropriate buckets. That being said, I will hold to my suggestion that
you do this before you do the export/import.


David



________________________________________________________________________
From: Jerry Criswell <jcriswell58 at gmail.com>
To: David T. <sunfish62 at yahoo.com> 
Cc: gnucash-user at gnucash.org 
Sent: Sunday, November 25, 2012 7:00 AM
Subject: Re: Documentation for Importation


I had not yet looked at the help file; I was working from the tutorial.
The chapter on migration in the tutorial is worthless.  You have helped
me a lot there.  I have also discovered that I was not as meticulous as
you when I first started using Quicken (12 years ago).  Therefore I have
a ton of entries in the unspecified account to reconcile.  Thanks to you
I have slowed down and studied the process.  What I will do is
export/import my checkbook one year at a time and then reconcile the
unspecified account with quicken.  When I get done, I should be able to
import the whole thing.

Now all I have to do is figure out how to mark this as solved.
-- 

JC 


-----Original Message-----
From: David T. <sunfish62 at yahoo.com>
To: Jerry Criswell <jcriswell58 at gmail.com>, gnucash-user at gnucash.org
<gnucash-user at gnucash.org>
Subject: Re: Documentation for Importation
Date: Sat, 24 Nov 2012 16:47:31 -0800 (PST)

Jerry--

I'm not entirely sure about your questions... Chapter 3.3 of the Help
file discusses importing QIF files. Have you looked there? Personally, I
find the Tutorial to be a very useful document. The FAQ does offer some
info about importing QIF, but see below.

>From my original experience way back when, I found that if I had Quicken
export Transactions, Accounts and Categories for all my accounts, I
could then import this QIF file into Gnucash, and (for me, at least)
everything went flawlessly. All the transactions came in, complete with
Categories mapping to Gucash accounts. The FAQ tells you to create your
account structure in Gnucash first, but I found that Gnucash pulled in
my structure from the Quicken categories pretty well without my setting
up the accounts first. This may be a consequence of my exacting use of
Quicken--I was scrupulous in using and assigning my transactions to
categories in Quicken.

As for your question about hidden accounts, if you tell Quicken to
export them, then Gnucash should be able to import them (although I do
not know whether they will retain their hidden status).

Finally, I use OFX from my bank all the time quite successfully to
import ongoing transactions into Gnucash, so I know that OFX files can
work. My understanding of that standard, however, is that it only
addresses one account at a time. This would render it painful at best
for a full import process, IMHO. 

HTH, David




________________________________________________________________________

From: Jerry Criswell <jcriswell58 at gmail.com>
To: gnucash-user at gnucash.org 
Sent: Saturday, November 24, 2012 1:10 PM
Subject: Documentation for Importation


Is there any documentation for importation of Quicken files?  I have
looked through the help files and I even bought a book.  I even tried
QFX files and that doesn't work at all.  When you export to a QIF file
are the quicken accts that are hidden included?  A step by step walk
through of exporting Quicken accounts would be nice.

Thank you for your time.