I feel your pain, my quicken data went back almost thirty years. If there is a more definitive description in some GnuCash log file for qif import errors, I haven't found it. Hopefully someone with more knowledgeable on the inner workings of GnuCash can shed more light on that.
I gather the particular sticking point is with either an option or futures contract. I only have direct experience using Quicken with stocks and bonds. I assume the process is similar for options/futures. I can offer one more option for you to consider. Make a copy of your quicken data file (your ".QDF" file) and open it with Quicken. Delete all the transactions with the date in question. Then create your QIF file to import into GnuCash and see if your file will import. Assuming the number of transactions aren't too great you can then manually enter them in to GnuCash OR create a QIF file or CSV file, manually, to import into GnuCash. I found that if you recreate your account/category structure in GnuCash beforehand the import becomes somewhat less laborious. On Sun, Apr 28, 2024 at 7:43 AM <hh8...@gmail.com> wrote: > 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> 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 <hh8...@gmail.com> > Sent: Sunday, April 21, 2024 8:37 AM > To: 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 > 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 > -- 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.
