Re: [GNC] Identify error transaction in QIF import

From: hh8...@gmail.com Sent: Sunday, April 28, 2024 8:42 PM To: 'Christopher Lam' Cc: gnucash-user@gnucash.org Subject: RE: [GNC] Identify error transaction in QIF import Good news. The last stable build Apr 28 could import the full QIF file. It took 9 hours but finished with some

Re: [GNC] Identify error transaction in QIF import

to go back and redo it. From: Christopher Lam Sent: Sunday, April 28, 2024 10:44 AM To: Hao Huang Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Identify error transaction in QIF import Please pick a recent build from https://code.gnucash.org/builds/win32/stable/ On Sun, 28 Apr 2024

Re: [GNC] Identify error transaction in QIF import

fic topic. There is wealth of that info. Hope this helps. -Original Message- From: hh8...@gmail.com Sent: Sunday, April 28, 2024 7:43 AM To: 'Joseph Keithley' Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Identify error transaction in QIF import Hi, Thanks for the advice. I ru

Re: [GNC] Identify error transaction in QIF import

Please pick a recent build from https://code.gnucash.org/builds/win32/stable/ On Sun, 28 Apr 2024 at 21:54, Hao Huang wrote: > Hi, > > The original problem was "The erroneous transaction seems to be the last > of those imported". If that's the case, it won't apply. What is shown in my > case is

Re: [GNC] Identify error transaction in QIF import

Hi, The original problem was "The erroneous transaction seems to be the last of those imported". If that's the case, it won't apply. What is shown in my case is there is no investment transaction on that day and it's somewhere in the middle of all the dates. Also, in Quicken I can't find any

Re: [GNC] Identify error transaction in QIF import

Hello HH Please read this: https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html Regards Geoff = On 28/04/2024 9:43 pm, 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.

Re: [GNC] Identify error transaction in QIF import

ng to > exact transaction? > > > > Thanks > > > > *From:* Joseph Keithley > *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 > > >

Re: [GNC] Identify error transaction in QIF import

act transaction? Thanks From: Joseph Keithley 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 Valid

Re: [GNC] Identify error transaction in QIF import

Ah yes, hex editing. Alas, gone are the days when one could utilize skills in assembly language programming and the like, at least with modern code. Do then even attempt to teach anyone assembly language anymore? The other thing that makes editing binary data difficult is that it is also

Re: [GNC] Identify error transaction in QIF import

For future reference, Quicken Interchange Format - Wikipedia On Sun, Apr 21, 2024 at 8:38 AM wrote: > 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

Re: [GNC] Identify error transaction in QIF import

To address your specific inquiry, just looking at the line you posted, the date format looks kind of wonky. I would expect something like " 5/ 4/21" or better would be something like 2021-05-04. I don't recall if Quicken will let you specify the date format when you export to QIF (the

Re: [GNC] Identify error transaction in QIF import

One more thing, if you are not aware, the qif is a simple text file. Since the error gave you a line number you might be able to import the qif file into Excel or a word processor that identifies line or row numbers and see what the error line is. If not simply do a search for some part of the

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

Re: [GNC] Identify error transaction in QIF import

Sorry, I was  being an idiot and opened the QDF file, not the QIF file. My QIF files definitely have the date format you are seeing, something like  "11/21/97" for pre-2000 years, and " 4/ 5' 3" It looks like the price lines you are being told about a lacking a numeric price. All the price

Re: [GNC] Identify error transaction in QIF import

Converting from Quicken seems to come up a lot here. Here's a long post I made after I'd converted over a lot of data: https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103226.html There is a lot of advice in the form of wiki pages and the like, too. To address your specific

Re: [GNC] Identify error transaction in QIF import

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

[GNC] 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