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 <joeyii...@gmail.com> Sent: Sunday, April 21, 2024 11:47 AM To: hh8...@gmail.com Cc: gnucash-user@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 <hh8...@gmail.com <mailto:hh8...@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: hh8...@gmail.com <mailto:hh8...@gmail.com> <hh8...@gmail.com <mailto:hh8...@gmail.com> > Sent: Sunday, April 21, 2024 8:37 AM To: gnucash-user@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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 _______________________________________________ gnucash-user mailing list gnucash-user@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.
