[GNC] Identify error transaction in QIF import

[hh8923 at gmail.com]

Hi,

 

Thanks for the advice.  I run Quicken -> Validate and Repair File and it reported a few errors that I fixed.

 

However, I still get the same error message

 

Missing QIF investment action for transaction dated 9/19/2019



I opened the QIF in text editor and searched for 9/19’19.  There are about 10 instances in a few banking accounts.  Then all others are !Type:Prices

 

I have more than 20 years of records and more than 100 accounts.  It will be very difficult to do this one by one.

 

Is it possible for the error message to be more specific and pointing to exact transaction?

 

Thanks

 

From: Joseph Keithley <joeyiii57 at gmail.com> 
Sent: Sunday, April 21, 2024 11:47 AM
To: hh8923 at gmail.com
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Identify error transaction in QIF import

 

The first thing I did before I exported my 150mb Quicken file to a qif was to run the Validate and Repair in the File menu under File Operations.  Sometimes the Quicken data file gets corrupted and you have to repair transactions.  That may help you track down if the issue is with your Quicken file or GnuCash.

 

I tried to export my Quicken file as a single qif and then import it into GnuCash.  That approach was a complete disaster.  I assume that since my Quicken file was so large, GnuCash couldn't really handle the conversion directly.  

 

In order for me to finally get my Quicken file imported into GnuCash, after ten different attempts, I exported one account at a time, one year at a time, until I had all the data exported. Then I imported each into GnuCash.  I then had to make a number of manual edits and corrections to the GnuCash file but that was largely due to my unfamiliarity with GnuCash.

 

The bottom line is, one way to make the import easier is to stick to exporting/importing one account at a time.  When you then import the next account, matching up transactions will be much easier.  I also found that having the account structure already setup in GnuCash, mimicing the same account names and categories in Quicken, made the import task much easier.  Otherwise each time you import a file that wants to add a new account or category to GnuCash for any undefined transaction account/category gets extremely confusing.

 

 

 

On Sun, Apr 21, 2024 at 8:49 AM <hh8923 at gmail.com <mailto:hh8923 at gmail.com> > wrote:

One more thing.  In Quicken, I can't find any investment transaction on that
date.  They are credit card or banking transactions.



From: hh8923 at gmail.com <mailto:hh8923 at gmail.com>  <hh8923 at gmail.com <mailto:hh8923 at gmail.com> > 
Sent: Sunday, April 21, 2024 8:37 AM
To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
Subject: Identify error transaction in QIF import



Hi,



I'm a long time Quicken user and trying to migrate to GnuCash.  I've
exported my entire Quicken file to QIF and then try to import into GnuCash.
Here is what I noted during the attempt.



Load QIF files

Line 627318: Could not parse price line: "#C093280",," 5/ 4'21"



Match payees/memos to GnuCash accounts

It listed about 10 that maps to Unspecified and I kept them as New selected



Tradable commodities

There are many and I did not review them.  Exchange or abbreviation type
appear to be NONCURRENCY for all of them



New Book Options

I did not change any settings



QIF Import - Failed

Missing QIF investment action for transaction dated 9/19/2019



I have many accounts and many transactions.  Searching the QIF file find
many with this date.  How can I get the details on what to fix?  Is there a
log file of import?



Thanks



_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
To update your subscription preferences or to unsubscribe:
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.




 

-- 

iii