Re: [GNC] QIF import fails without error messages
Hi Geoff, thanks a lot for confirming my problem. I thought about a date problem (which also explains why it worked sometimes) but as the import let's you select the right format I didn't dig deeper. Anyhow you are right. Using a unambiguous date it works just fine. Going back to an older version is not an option for me right now (to much work) and therefore I'll just wait for the fix. I created a bug if you'd like to follow it: https://bugs.gnucash.org/show_bug.cgi?id=799160 Best regards Thomas On 09.12.23 02:38, Geoff wrote: Hi Thomas I also use QIF files extensively and was surprised when you reported this error. Coincidentally, yesterday I upgraded to v5.4.1 and found that I can reproduce the same error. By a process of elimination I found that it is due to the ambiguity in the date format. Using your example, a date of "01/12/2023" could be interpreted as 1st of December *or* 12th of January. Despite telling GnuCash that the dates are to be interpreted as "d-m-y" this information seems to be lost and the process fails. I also tried "2023/12/01" with "y-m-d" and this failed too. Unambiguous dates like "29/11/2023" work fine. I have now downgraded to v4.8 and your file was imported without any errors - see attached screenshot. I recommend that you: (a) Downgrade to a version 4 release. (b) Submit a bug report about this problem https://bugs.gnucash.org/enter_bug.cgi Regards Geoff = GnuCash v4.8 on Windows 10 On 9/12/2023 7:59 am, Thomas via gnucash-user wrote: Hello, i'm using GnuCash for a very long time (thanks a lot for it). In order to handle some regular (monthly) payments I created a small script to create very simple QIF files that I can then import into GnuCash. That was working perfectly for some years now. Anyhow for the last 2 or 3 months (only using it once a month) the import failed without telling me why (there is just no message in the dialog). It happened for the first time (I think) two months ago. Then I did it manually and it worked the following month. Anyhow now (this month) it fails again. There it does not seem to be a "one time problem". The QIF file is very simple and I can't see why that should fail: !Account NAktiva:Umlaufvermögen:Girokonto (1234567) ^ !Type:Cash D01/12/2023 T-123 LAktiva:Anlagevermögen:Bausparer (1234567) ^ (the real file contains more payments but this simple also fails) During the import wizard GnuCash identifies both accounts to exist and accepts the date format as d-m-y. Anyhow it fails without message. Any idea on why that happens? Thanks a lot. ___ 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. ___ 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.
Re: [GNC] QIF import fails in GnuCash 3.5, win 7
Thank you David I did find the trace file. I was looking at the wrong place. The file is attached. Message: 3 Date: Wed, 5 Jun 2019 15:20:06 -0500 From: David Carlson To: Tom Hatzigeorgiou Cc: "gnucash-user@gnucash.org" Subject: Re: [GNC] QIF import fails in GnuCash 3.5, win 7 Message-ID: Content-Type: text/plain; charset="UTF-8" Tom, There is always at least a rudimentary trace file. Read < https://wiki.gnucash.org/wiki/Tracefile> On Wed, Jun 5, 2019 at 3:12 PM Tom Hatzigeorgiou wrote: > there is no trace file generated > The import fails on the second step (importing the QIF file). The first > being checking the transfers. > > By the way I'm able to use my data as I install GNU version 3.1 import the > data then install version 3.5 and use the data. > Is just that the importing fails otherwise I find version 3.5 better and > faster than the previous one. > > Hopefully they will fix the importing function with the next release. gnucash.trace.SZN62Z.log Description: gnucash.trace.SZN62Z.log ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF import fails in GnuCash 3.5, win 7
ll the default locations for > GnuCash 3.x Configuration files. > > See > https://github.com/goodvibes2/BackupGnuCashLinux > Or > https://github.com/goodvibes2/BackupGnuCashWin > > Regards, Chris Good Good to hear that. Thanks for the update! Geert -- Message: 3 Date: Mon, 3 Jun 2019 21:01:54 + From: Tom Hatzigeorgiou To: "gnucash-user@gnucash.org" Subject: Re: [GNC] QIF import fails in GnuCash 3.5, win 7 Message-ID: Content-Type: text/plain; charset="iso-8859-1" When I start the import it fails after it has processed about a third of my file (I attached a screen snap). The file is processed with no errors in GnuCash 3.1. From: gnucash-user on behalf of gnucash-user-requ...@gnucash.org Sent: Monday, June 3, 2019 12:00 PM To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 195, Issue 3 Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Re: Misc Newbie Questions (Derek Atkins) 2. Re: QIF import fails in GnuCash 3.5, win 7 (Derek Atkins) 3. Re: GNUCASH Android (Derek Atkins) 4. Re: Future transactions (Derek Atkins) 5. Re: GnuCash thru Flathub (Derek Atkins) 6. Re: GC CTD lost saved reports (Chris Good) -- Message: 1 Date: Mon, 03 Jun 2019 10:56:49 -0400 From: Derek Atkins To: AEG via gnucash-user Cc: AEG Subject: Re: [GNC] Misc Newbie Questions Message-ID: Content-Type: text/plain Hi, AEG via gnucash-user writes: [snip] > I've been managing my finances with AceMoney for many years and like the way > future scheduled transactions can be made visible in all accounts via a > global setting. This makes it very easy to turn that visibility on or off > from a simple menu setting and to set how far in advance they would be > shown. Also, the future transactions are greyed out so that, although > visible, they are not easily confused with present entries, but they can be > manually brought forward, edited and made current via a simple right-click > menu. Sure, I can see how this would be useful, and could be implemented for a subset of SXes where the values are pre-computed. But what should it display if there is a user-variable in the SX? Currently, when an SX with a variable fires, it pops up a dialog and asked the user to fill in the variable. But for your suggestion, you're asking to see the SX before it actually fires -- so the variables aren't being filled out. Alternatively, you can just tell the SXes to fire up to 300 days in advance, but then they become "real" transactions and get harder to hide. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com<http://www.ihtfp.com> Computer and Internet Security Consultant -- Message: 2 Date: Mon, 03 Jun 2019 10:58:14 -0400 From: Derek Atkins To: Tom Hatzigeorgiou Cc: "gnucash-user\@gnucash.org" Subject: Re: [GNC] QIF import fails in GnuCash 3.5, win 7 Message-ID: Content-Type: text/plain Tom Hatzigeorgiou writes: > When I run the QIF importer it fail in GnuCash 3.5, win 7 > Yet the same file completes with no issue in GnuCash 3.1, win 7 > Anyone knows of any issues with the new release? > Thank you. Fails how? > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com<http://www.ihtfp.com> Computer and Internet Security Consultant -- Message: 3 Date: Mon, 03 Jun 2019 11:02:33 -0400 From: Derek Atkins To: nor via gnucash-user Subject: Re: [GNC] GNUCASH Android Message-ID: Content-Type: text/plain Hi, nor via gnucash-user writes: > Some more feedback for Mr. Jon,when i try to open a file saved with gnucash > desktop v.3.5 (windows) the error reports, "unable to parse transaction > time 2019-04-30 20:00:00" However, same file could be opened when exported > as "Export Accounts" in xml format. i.e file without any transactions. nor Well, sure, because when you Export Accounts, there are no transactions, so the tran
Re: [GNC] QIF import fails in GnuCash 3.5, win 7
Hi, Tom Hatzigeorgiou writes: > When I start the import it fails after it has processed about a third of my > file (I attached a screen snap). > The file is processed with no errors in GnuCash 3.1. Is there anything printed to your Trace File when the input fails? ( see https://wiki.gnucash.org/wiki/Tracefile ) Anything on the console (assuming you run GnuCash from the command line) > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF import fails in GnuCash 3.5, win 7
When I start the import it fails after it has processed about a third of my file (I attached a screen snap). The file is processed with no errors in GnuCash 3.1. From: gnucash-user on behalf of gnucash-user-requ...@gnucash.org Sent: Monday, June 3, 2019 12:00 PM To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 195, Issue 3 Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Re: Misc Newbie Questions (Derek Atkins) 2. Re: QIF import fails in GnuCash 3.5, win 7 (Derek Atkins) 3. Re: GNUCASH Android (Derek Atkins) 4. Re: Future transactions (Derek Atkins) 5. Re: GnuCash thru Flathub (Derek Atkins) 6. Re: GC CTD lost saved reports (Chris Good) -- Message: 1 Date: Mon, 03 Jun 2019 10:56:49 -0400 From: Derek Atkins To: AEG via gnucash-user Cc: AEG Subject: Re: [GNC] Misc Newbie Questions Message-ID: Content-Type: text/plain Hi, AEG via gnucash-user writes: [snip] > I've been managing my finances with AceMoney for many years and like the way > future scheduled transactions can be made visible in all accounts via a > global setting. This makes it very easy to turn that visibility on or off > from a simple menu setting and to set how far in advance they would be > shown. Also, the future transactions are greyed out so that, although > visible, they are not easily confused with present entries, but they can be > manually brought forward, edited and made current via a simple right-click > menu. Sure, I can see how this would be useful, and could be implemented for a subset of SXes where the values are pre-computed. But what should it display if there is a user-variable in the SX? Currently, when an SX with a variable fires, it pops up a dialog and asked the user to fill in the variable. But for your suggestion, you're asking to see the SX before it actually fires -- so the variables aren't being filled out. Alternatively, you can just tell the SXes to fire up to 300 days in advance, but then they become "real" transactions and get harder to hide. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com<http://www.ihtfp.com> Computer and Internet Security Consultant -- Message: 2 Date: Mon, 03 Jun 2019 10:58:14 -0400 From: Derek Atkins To: Tom Hatzigeorgiou Cc: "gnucash-user\@gnucash.org" Subject: Re: [GNC] QIF import fails in GnuCash 3.5, win 7 Message-ID: Content-Type: text/plain Tom Hatzigeorgiou writes: > When I run the QIF importer it fail in GnuCash 3.5, win 7 > Yet the same file completes with no issue in GnuCash 3.1, win 7 > Anyone knows of any issues with the new release? > Thank you. Fails how? > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com<http://www.ihtfp.com> Computer and Internet Security Consultant -- Message: 3 Date: Mon, 03 Jun 2019 11:02:33 -0400 From: Derek Atkins To: nor via gnucash-user Subject: Re: [GNC] GNUCASH Android Message-ID: Content-Type: text/plain Hi, nor via gnucash-user writes: > Some more feedback for Mr. Jon,when i try to open a file saved with gnucash > desktop v.3.5 (windows) the error reports, "unable to parse transaction > time 2019-04-30 20:00:00" However, same file could be opened when exported > as "Export Accounts" in xml format. i.e file without any transactions. nor Well, sure, because when you Export Accounts, there are no transactions, so the transaction parser is never used on read. A better question is, what's wrong with that transaction time and why is the parser barfing on it? > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com<http://www.ihtfp.com> Computer and Internet Security Consultant -- Message: 4 Date: Mon, 03 Jun 2019 11:06:38 -0400 From: Derek Atkins To: AEG via gnucash
Re: [GNC] QIF import fails in GnuCash 3.5, win 7
Tom Hatzigeorgiou writes: > When I run the QIF importer it fail in GnuCash 3.5, win 7 > Yet the same file completes with no issue in GnuCash 3.1, win 7 > Anyone knows of any issues with the new release? > Thank you. Fails how? > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF Import Fails
Is it using Retained Earnings for uncategorized transactions? Quicken used to have a report for uncategorized transactions. Years ago when I tried to convert (then life got busy), uncategorized transactions caused many problems. <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Fri, 5 Apr 2019 at 03:58, Art Chimes wrote: > Thanks for the troubleshooting suggestions. Adrien pointed out the > ability to filter register displays, for which I am thankful. As a new > user, I hadn't discovered that tool yet. > > He also suggested searching to see if the transaction ended up > imported into some other account. Which is exactly what happened. > Instead of going into the checking account where it was supposed to > go, this transaction -- and many others I thought I had failed to > import -- ended up in "Equity:Retained Earnings." I suspect "retained > earnings" has some specific accounting definition, but I don't know > what it is or what transactions actually belong in that account. I do > know that it was not my intention to put those transactions in that > account, and I am pretty sure I did not assign any transactions to > that account in the import process. > > In 2009, a user filed a bug report in Bugzilla on just this behavior. > (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user > replied to the bug report, "The importer is assuming these are opening > balance transactions. Could you explain why this type of transaction > is legitimate for some other purpose?" My transaction involved a bank > account interest payment. (In Quicken there is no separate income > account so the bank account has an interest payment that appears as if > by magic; it can be credited to the account or transferred to another > account.) > > I can manually move these transactions, one-by-one, to where they > should be. But going forward, do I just have to resign myself to a lot > of QIF editing? Since I imagine that a lot of QIF importer users are > migrating from Quicken, perhaps some Quicken-specific warnings or > something could be considered? > > Thanks again, > Art > > > ------------------ > > > > Message: 1 > > Date: Thu, 4 Apr 2019 11:25:00 -0500 > > From: Adrien Monteleone > > To: Gnucash Users > > Subject: Re: [GNC] QIF Import Fails > > Message-ID: > > Content-Type: text/plain; charset=utf-8 > > > > Any time I?m in a pickle and can?t see a transaction that should be > there, I check that the register is not set to a filtered view. The > transaction might be hidden for some reason. I also check one of the > registers for the other accounts involved in the transaction. > > > > There is also a very powerful Find feature that you can even use regex > with to find it. > > > > Regards, > > Adrien > > > > > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: > > > > > > !Type:Bank > > > D7/ 1/97 > > > U5.32 > > > T5.32 > > > CX > > > PInterest Earned > > > L_IntInc > > > ^ > > > > > > Above is an example of a transaction that is failing to import. The > > > QIF export is from Quicken 2000 via Windows. > > > > > > I've had problems with imports before, but eventually figured out the > > > problem. This one has me stymied. I successfully imported > > > transactions from 1998-present, but the older ones aren't cooperating. > > > > > > The importer process seems to work ok, concluding with the encouraging > > > notice, "QIF Import Completed" However, the transaction does not > > > appear in the account register. > > > > > > One possible clue: I get a screen that asks me to match this > > > transaction with one of two others that have the same > > > date/amount/payee, even though the transaction doesn't appear in the > > > account. > > > > > > This is actually one of numerous exports from the same Quicken file. > > > Some work; others don't, and my troubleshooting hasn't gotten me > > > anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ > > > (2018-12-30) > > > > > > Thanks to the community for your help! > > > > > > Art > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To upda
Re: [GNC] QIF Import Fails
Art, I offered a simple definition of retained earnings in a previous reply. Did you not see that message? Anyhow, A simple test would verify a bug or (inadvertent) user-error. Delete the imported transactions. (all copies) Then try the import again and this time, paying extra careful attention to the assigned accounts (changing 99.5% to 100%) proceed with the import. Screenshot everything if you are so inclined... If you STILL end up with those transactions assigned to an account OTHER than the one you very clearly specified, then yes, you have found a bug and then the task is to source the cause of the bug. (I never did see a reply on the apparent space character from the QIF file in the date field possibly being an issue) While there are many known issues and bugs with any software, this one included, no one wants to start chasing a non-bug. (I’m guilty many times of thinking something is a bug that wasn’t) So please, indulge us a careful and methodical re-import, at least with one test transaction, for completeness sake and report back, if you don’t mind, and have the time. It will aide in narrowing down the issue (if any) and hopefully identify the cause, which will lead to quicker resolution. It is very possible that importing *only* one or more offending transactions will more than likely narrow down the exact issue. (one at a time is the best approach) Regards, Adrien > On Apr 5, 2019, at 9:39 AM, Art Chimes wrote: > > David, In the course of numerous import activities I reassigned many > transactions from the defaults suggested by the import tool. However, > I am 99.5 percent certain I never assigned a transaction to "Retained > Earnings," and I found dozens of transactions incorrectly assigned to > that account. I am also very (but somewhat less) confident that none > of the proposed matches was presented by default as "Retained > Earnings." I know very little about accounting -- what constitutes > "retained earnings" is still a mystery -- and even less about coding, > but it seems to me that, with all respect to those who contributed to > the code, the import function is at least quirky. > > Again, thanks to you and the rest of the GnuCash community for your help, > Art (a noobie making baby GnuSteps...) > > On Fri, Apr 5, 2019 at 10:04 AM David Carlson > wrote: >> >> Art, >> >> You have the opportunity during the import process to review the proposed >> "category" assignments and make corrections at the match transactions step. >> This is where you fix those incorrect imports. >> >> If you start with a select few small imports the Bayesian matching feature >> will get a chance to make most of those corrections for you. It is not >> perfect, so you need to monitor it carefully. >> >> Good luck >> >> David Carlson >> >> >> On Fri, Apr 5, 2019, 2:57 AM Art Chimes wrote: >>> >>> Thanks for the troubleshooting suggestions. Adrien pointed out the >>> ability to filter register displays, for which I am thankful. As a new >>> user, I hadn't discovered that tool yet. >>> >>> He also suggested searching to see if the transaction ended up >>> imported into some other account. Which is exactly what happened. >>> Instead of going into the checking account where it was supposed to >>> go, this transaction -- and many others I thought I had failed to >>> import -- ended up in "Equity:Retained Earnings." I suspect "retained >>> earnings" has some specific accounting definition, but I don't know >>> what it is or what transactions actually belong in that account. I do >>> know that it was not my intention to put those transactions in that >>> account, and I am pretty sure I did not assign any transactions to >>> that account in the import process. >>> >>> In 2009, a user filed a bug report in Bugzilla on just this behavior. >>> (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user >>> replied to the bug report, "The importer is assuming these are opening >>> balance transactions. Could you explain why this type of transaction >>> is legitimate for some other purpose?" My transaction involved a bank >>> account interest payment. (In Quicken there is no separate income >>> account so the bank account has an interest payment that appears as if >>> by magic; it can be credited to the account or transferred to another >>> account.) >>> >>> I can manually move these transactions, one-by-one, to where they >>> should be. But going forward, do I just have to resign myself to a lot >>>
Re: [GNC] QIF Import Fails
David, In the course of numerous import activities I reassigned many transactions from the defaults suggested by the import tool. However, I am 99.5 percent certain I never assigned a transaction to "Retained Earnings," and I found dozens of transactions incorrectly assigned to that account. I am also very (but somewhat less) confident that none of the proposed matches was presented by default as "Retained Earnings." I know very little about accounting -- what constitutes "retained earnings" is still a mystery -- and even less about coding, but it seems to me that, with all respect to those who contributed to the code, the import function is at least quirky. Again, thanks to you and the rest of the GnuCash community for your help, Art (a noobie making baby GnuSteps...) On Fri, Apr 5, 2019 at 10:04 AM David Carlson wrote: > > Art, > > You have the opportunity during the import process to review the proposed > "category" assignments and make corrections at the match transactions step. > This is where you fix those incorrect imports. > > If you start with a select few small imports the Bayesian matching feature > will get a chance to make most of those corrections for you. It is not > perfect, so you need to monitor it carefully. > > Good luck > > David Carlson > > > On Fri, Apr 5, 2019, 2:57 AM Art Chimes wrote: >> >> Thanks for the troubleshooting suggestions. Adrien pointed out the >> ability to filter register displays, for which I am thankful. As a new >> user, I hadn't discovered that tool yet. >> >> He also suggested searching to see if the transaction ended up >> imported into some other account. Which is exactly what happened. >> Instead of going into the checking account where it was supposed to >> go, this transaction -- and many others I thought I had failed to >> import -- ended up in "Equity:Retained Earnings." I suspect "retained >> earnings" has some specific accounting definition, but I don't know >> what it is or what transactions actually belong in that account. I do >> know that it was not my intention to put those transactions in that >> account, and I am pretty sure I did not assign any transactions to >> that account in the import process. >> >> In 2009, a user filed a bug report in Bugzilla on just this behavior. >> (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user >> replied to the bug report, "The importer is assuming these are opening >> balance transactions. Could you explain why this type of transaction >> is legitimate for some other purpose?" My transaction involved a bank >> account interest payment. (In Quicken there is no separate income >> account so the bank account has an interest payment that appears as if >> by magic; it can be credited to the account or transferred to another >> account.) >> >> I can manually move these transactions, one-by-one, to where they >> should be. But going forward, do I just have to resign myself to a lot >> of QIF editing? Since I imagine that a lot of QIF importer users are >> migrating from Quicken, perhaps some Quicken-specific warnings or >> something could be considered? >> >> Thanks again, >> Art >> >> > -- >> > >> > Message: 1 >> > Date: Thu, 4 Apr 2019 11:25:00 -0500 >> > From: Adrien Monteleone >> > To: Gnucash Users >> > Subject: Re: [GNC] QIF Import Fails >> > Message-ID: >> > Content-Type: text/plain; charset=utf-8 >> > >> > Any time I?m in a pickle and can?t see a transaction that should be there, >> > I check that the register is not set to a filtered view. The transaction >> > might be hidden for some reason. I also check one of the registers for the >> > other accounts involved in the transaction. >> > >> > There is also a very powerful Find feature that you can even use regex >> > with to find it. >> > >> > Regards, >> > Adrien >> > >> > > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: >> > > >> > > !Type:Bank >> > > D7/ 1/97 >> > > U5.32 >> > > T5.32 >> > > CX >> > > PInterest Earned >> > > L_IntInc >> > > ^ >> > > >> > > Above is an example of a transaction that is failing to import. The >> > > QIF export is from Quicken 2000 via Windows. >> > > >> > > I've had problems with imports before, but eventually figured out the >> >
Re: [GNC] QIF Import Fails
Art, Glad you found your transactions! Tracking down why it happened in the first place would certainly be of benefit to you and other users. From the info you provided from the QIF, I can’t see why GnuCash would have assigned that account. I would have thought it try to use Imbalance-CUR if it fails to find or create a valid account. If they were supposed to go to Assets:Checking, is that where the assignment error occured? I don’t use the importer, but my understanding is that you set one account (like Checking) and then the Quicken category info becomes the ‘other’ account assigned. If you didn’t notice that the first assigned account was Equity:Retained Earnings, (for whatever reason) then that would be the cause. If you had correctly set it to Assets:Checking then that is a bug worth investigating further. If all of the transactions sent there go to Checking, then just delete the Retained Earnings account and GnuCash will ask you where you want to move them to. (to save you some time) Of course, if you have real transactions in Retained Earnings that you want to keep, you can’t use this workflow. That account is used to hold the annual net of Income-Expenses if you close the books each year. It is a holdover from the pen and paper days. It is not generally needed with GnuCash. (but will be used if you perform a ‘close books’ function) Regards, Adrien > On Apr 4, 2019, at 5:59 PM, Art Chimes wrote: > > Thanks for the troubleshooting suggestions. Adrien pointed out the > ability to filter register displays, for which I am thankful. As a new > user, I hadn't discovered that tool yet. > > He also suggested searching to see if the transaction ended up > imported into some other account. Which is exactly what happened. > Instead of going into the checking account where it was supposed to > go, this transaction -- and many others I thought I had failed to > import -- ended up in "Equity:Retained Earnings." I suspect "retained > earnings" has some specific accounting definition, but I don't know > what it is or what transactions actually belong in that account. I do > know that it was not my intention to put those transactions in that > account, and I am pretty sure I did not assign any transactions to > that account in the import process. > > In 2009, a user filed a bug report in Bugzilla on just this behavior. > (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user > replied to the bug report, "The importer is assuming these are opening > balance transactions. Could you explain why this type of transaction > is legitimate for some other purpose?" My transaction involved a bank > account interest payment. (In Quicken there is no separate income > account so the bank account has an interest payment that appears as if > by magic; it can be credited to the account or transferred to another > account.) > > I can manually move these transactions, one-by-one, to where they > should be. But going forward, do I just have to resign myself to a lot > of QIF editing? Since I imagine that a lot of QIF importer users are > migrating from Quicken, perhaps some Quicken-specific warnings or > something could be considered? > > Thanks again, > Art > >> ---------------------- >> >> Message: 1 >> Date: Thu, 4 Apr 2019 11:25:00 -0500 >> From: Adrien Monteleone >> To: Gnucash Users >> Subject: Re: [GNC] QIF Import Fails >> Message-ID: >> Content-Type: text/plain; charset=utf-8 >> >> Any time I?m in a pickle and can?t see a transaction that should be there, I >> check that the register is not set to a filtered view. The transaction might >> be hidden for some reason. I also check one of the registers for the other >> accounts involved in the transaction. >> >> There is also a very powerful Find feature that you can even use regex with >> to find it. >> >> Regards, >> Adrien >> >>> On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: >>> >>> !Type:Bank >>> D7/ 1/97 >>> U5.32 >>> T5.32 >>> CX >>> PInterest Earned >>> L_IntInc >>> ^ >>> >>> Above is an example of a transaction that is failing to import. The >>> QIF export is from Quicken 2000 via Windows. >>> >>> I've had problems with imports before, but eventually figured out the >>> problem. This one has me stymied. I successfully imported >>> transactions from 1998-present, but the older ones aren't cooperating. >>> >>> The importer process seems to work ok, concluding with the encouraging >>> notice, "QIF Import Completed&q
Re: [GNC] QIF Import Fails
Regarding. The interest deposits, I think that Quicken could have assigned an "Interest" category to allow you to differentiate from other deposits, but the fact that it didn't require such is why it sometimes is a challenge to import data from Quicken. David Carlson On Fri, Apr 5, 2019, 2:57 AM Art Chimes wrote: > Thanks for the troubleshooting suggestions. Adrien pointed out the > ability to filter register displays, for which I am thankful. As a new > user, I hadn't discovered that tool yet. > > He also suggested searching to see if the transaction ended up > imported into some other account. Which is exactly what happened. > Instead of going into the checking account where it was supposed to > go, this transaction -- and many others I thought I had failed to > import -- ended up in "Equity:Retained Earnings." I suspect "retained > earnings" has some specific accounting definition, but I don't know > what it is or what transactions actually belong in that account. I do > know that it was not my intention to put those transactions in that > account, and I am pretty sure I did not assign any transactions to > that account in the import process. > > In 2009, a user filed a bug report in Bugzilla on just this behavior. > (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user > replied to the bug report, "The importer is assuming these are opening > balance transactions. Could you explain why this type of transaction > is legitimate for some other purpose?" My transaction involved a bank > account interest payment. (In Quicken there is no separate income > account so the bank account has an interest payment that appears as if > by magic; it can be credited to the account or transferred to another > account.) > > I can manually move these transactions, one-by-one, to where they > should be. But going forward, do I just have to resign myself to a lot > of QIF editing? Since I imagine that a lot of QIF importer users are > migrating from Quicken, perhaps some Quicken-specific warnings or > something could be considered? > > Thanks again, > Art > > > ------------------ > > > > Message: 1 > > Date: Thu, 4 Apr 2019 11:25:00 -0500 > > From: Adrien Monteleone > > To: Gnucash Users > > Subject: Re: [GNC] QIF Import Fails > > Message-ID: > > Content-Type: text/plain; charset=utf-8 > > > > Any time I?m in a pickle and can?t see a transaction that should be > there, I check that the register is not set to a filtered view. The > transaction might be hidden for some reason. I also check one of the > registers for the other accounts involved in the transaction. > > > > There is also a very powerful Find feature that you can even use regex > with to find it. > > > > Regards, > > Adrien > > > > > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: > > > > > > !Type:Bank > > > D7/ 1/97 > > > U5.32 > > > T5.32 > > > CX > > > PInterest Earned > > > L_IntInc > > > ^ > > > > > > Above is an example of a transaction that is failing to import. The > > > QIF export is from Quicken 2000 via Windows. > > > > > > I've had problems with imports before, but eventually figured out the > > > problem. This one has me stymied. I successfully imported > > > transactions from 1998-present, but the older ones aren't cooperating. > > > > > > The importer process seems to work ok, concluding with the encouraging > > > notice, "QIF Import Completed" However, the transaction does not > > > appear in the account register. > > > > > > One possible clue: I get a screen that asks me to match this > > > transaction with one of two others that have the same > > > date/amount/payee, even though the transaction doesn't appear in the > > > account. > > > > > > This is actually one of numerous exports from the same Quicken file. > > > Some work; others don't, and my troubleshooting hasn't gotten me > > > anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ > > > (2018-12-30) > > > > > > Thanks to the community for your help! > > > > > > Art > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF Import Fails
Art, You have the opportunity during the import process to review the proposed "category" assignments and make corrections at the match transactions step. This is where you fix those incorrect imports. If you start with a select few small imports the Bayesian matching feature will get a chance to make most of those corrections for you. It is not perfect, so you need to monitor it carefully. Good luck David Carlson On Fri, Apr 5, 2019, 2:57 AM Art Chimes wrote: > Thanks for the troubleshooting suggestions. Adrien pointed out the > ability to filter register displays, for which I am thankful. As a new > user, I hadn't discovered that tool yet. > > He also suggested searching to see if the transaction ended up > imported into some other account. Which is exactly what happened. > Instead of going into the checking account where it was supposed to > go, this transaction -- and many others I thought I had failed to > import -- ended up in "Equity:Retained Earnings." I suspect "retained > earnings" has some specific accounting definition, but I don't know > what it is or what transactions actually belong in that account. I do > know that it was not my intention to put those transactions in that > account, and I am pretty sure I did not assign any transactions to > that account in the import process. > > In 2009, a user filed a bug report in Bugzilla on just this behavior. > (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user > replied to the bug report, "The importer is assuming these are opening > balance transactions. Could you explain why this type of transaction > is legitimate for some other purpose?" My transaction involved a bank > account interest payment. (In Quicken there is no separate income > account so the bank account has an interest payment that appears as if > by magic; it can be credited to the account or transferred to another > account.) > > I can manually move these transactions, one-by-one, to where they > should be. But going forward, do I just have to resign myself to a lot > of QIF editing? Since I imagine that a lot of QIF importer users are > migrating from Quicken, perhaps some Quicken-specific warnings or > something could be considered? > > Thanks again, > Art > > > ------------------ > > > > Message: 1 > > Date: Thu, 4 Apr 2019 11:25:00 -0500 > > From: Adrien Monteleone > > To: Gnucash Users > > Subject: Re: [GNC] QIF Import Fails > > Message-ID: > > Content-Type: text/plain; charset=utf-8 > > > > Any time I?m in a pickle and can?t see a transaction that should be > there, I check that the register is not set to a filtered view. The > transaction might be hidden for some reason. I also check one of the > registers for the other accounts involved in the transaction. > > > > There is also a very powerful Find feature that you can even use regex > with to find it. > > > > Regards, > > Adrien > > > > > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: > > > > > > !Type:Bank > > > D7/ 1/97 > > > U5.32 > > > T5.32 > > > CX > > > PInterest Earned > > > L_IntInc > > > ^ > > > > > > Above is an example of a transaction that is failing to import. The > > > QIF export is from Quicken 2000 via Windows. > > > > > > I've had problems with imports before, but eventually figured out the > > > problem. This one has me stymied. I successfully imported > > > transactions from 1998-present, but the older ones aren't cooperating. > > > > > > The importer process seems to work ok, concluding with the encouraging > > > notice, "QIF Import Completed" However, the transaction does not > > > appear in the account register. > > > > > > One possible clue: I get a screen that asks me to match this > > > transaction with one of two others that have the same > > > date/amount/payee, even though the transaction doesn't appear in the > > > account. > > > > > > This is actually one of numerous exports from the same Quicken file. > > > Some work; others don't, and my troubleshooting hasn't gotten me > > > anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ > > > (2018-12-30) > > > > > > Thanks to the community for your help! > > > > > > Art > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.o
Re: [GNC] QIF Import Fails
Thanks for the troubleshooting suggestions. Adrien pointed out the ability to filter register displays, for which I am thankful. As a new user, I hadn't discovered that tool yet. He also suggested searching to see if the transaction ended up imported into some other account. Which is exactly what happened. Instead of going into the checking account where it was supposed to go, this transaction -- and many others I thought I had failed to import -- ended up in "Equity:Retained Earnings." I suspect "retained earnings" has some specific accounting definition, but I don't know what it is or what transactions actually belong in that account. I do know that it was not my intention to put those transactions in that account, and I am pretty sure I did not assign any transactions to that account in the import process. In 2009, a user filed a bug report in Bugzilla on just this behavior. (https://bugs.gnucash.org/show_bug.cgi?id=603761). Another user replied to the bug report, "The importer is assuming these are opening balance transactions. Could you explain why this type of transaction is legitimate for some other purpose?" My transaction involved a bank account interest payment. (In Quicken there is no separate income account so the bank account has an interest payment that appears as if by magic; it can be credited to the account or transferred to another account.) I can manually move these transactions, one-by-one, to where they should be. But going forward, do I just have to resign myself to a lot of QIF editing? Since I imagine that a lot of QIF importer users are migrating from Quicken, perhaps some Quicken-specific warnings or something could be considered? Thanks again, Art > -- > > Message: 1 > Date: Thu, 4 Apr 2019 11:25:00 -0500 > From: Adrien Monteleone > To: Gnucash Users > Subject: Re: [GNC] QIF Import Fails > Message-ID: > Content-Type: text/plain; charset=utf-8 > > Any time I?m in a pickle and can?t see a transaction that should be there, I > check that the register is not set to a filtered view. The transaction might > be hidden for some reason. I also check one of the registers for the other > accounts involved in the transaction. > > There is also a very powerful Find feature that you can even use regex with > to find it. > > Regards, > Adrien > > > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: > > > > !Type:Bank > > D7/ 1/97 > > U5.32 > > T5.32 > > CX > > PInterest Earned > > L_IntInc > > ^ > > > > Above is an example of a transaction that is failing to import. The > > QIF export is from Quicken 2000 via Windows. > > > > I've had problems with imports before, but eventually figured out the > > problem. This one has me stymied. I successfully imported > > transactions from 1998-present, but the older ones aren't cooperating. > > > > The importer process seems to work ok, concluding with the encouraging > > notice, "QIF Import Completed" However, the transaction does not > > appear in the account register. > > > > One possible clue: I get a screen that asks me to match this > > transaction with one of two others that have the same > > date/amount/payee, even though the transaction doesn't appear in the > > account. > > > > This is actually one of numerous exports from the same Quicken file. > > Some work; others don't, and my troubleshooting hasn't gotten me > > anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ > > (2018-12-30) > > > > Thanks to the community for your help! > > > > Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF Import Fails
Any time I’m in a pickle and can’t see a transaction that should be there, I check that the register is not set to a filtered view. The transaction might be hidden for some reason. I also check one of the registers for the other accounts involved in the transaction. There is also a very powerful Find feature that you can even use regex with to find it. Regards, Adrien > On Apr 3, 2019, at 9:16 PM, Art Chimes wrote: > > !Type:Bank > D7/ 1/97 > U5.32 > T5.32 > CX > PInterest Earned > L_IntInc > ^ > > Above is an example of a transaction that is failing to import. The > QIF export is from Quicken 2000 via Windows. > > I've had problems with imports before, but eventually figured out the > problem. This one has me stymied. I successfully imported > transactions from 1998-present, but the older ones aren't cooperating. > > The importer process seems to work ok, concluding with the encouraging > notice, "QIF Import Completed" However, the transaction does not > appear in the account register. > > One possible clue: I get a screen that asks me to match this > transaction with one of two others that have the same > date/amount/payee, even though the transaction doesn't appear in the > account. > > This is actually one of numerous exports from the same Quicken file. > Some work; others don't, and my troubleshooting hasn't gotten me > anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ > (2018-12-30) > > Thanks to the community for your help! > > Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF Import Fails
Hi, Don't know anything about importing to GC or QIF structure, but does the whitespace in the date field make a difference? sorry if that's way off track. Maf. On Thursday, 4 April 2019 03:16:41 BST Art Chimes wrote: > !Type:Bank > D7/ 1/97 > U5.32 > T5.32 > CX > PInterest Earned > L_IntInc > ^ > > Above is an example of a transaction that is failing to import. The > QIF export is from Quicken 2000 via Windows. > > I've had problems with imports before, but eventually figured out the > problem. This one has me stymied. I successfully imported > transactions from 1998-present, but the older ones aren't cooperating. > > The importer process seems to work ok, concluding with the encouraging > notice, "QIF Import Completed" However, the transaction does not > appear in the account register. > > One possible clue: I get a screen that asks me to match this > transaction with one of two others that have the same > date/amount/payee, even though the transaction doesn't appear in the > account. > > This is actually one of numerous exports from the same Quicken file. > Some work; others don't, and my troubleshooting hasn't gotten me > anywhere. From the "about" screen: Version: 3.4; Build ID: 3.4+ > (2018-12-30) > > Thanks to the community for your help! > > Art > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.