Re: [GNC] QIF import ignore account
Michael, that is generally true and I'll hazard specifically true with respect to XML files. But MS does have some things they refuse to let you open with browsers other than Edge. It is a source of contention in the tech world and there are plenty of blogs and articles about it. As far as I am aware though, each of these cases is something the OS generates a link to and not a user file. Regards, Adrien On 1/21/24 9:49 AM, Michael or Penny Novack wrote: NOT really a gnucash matter. But the "defaults" for which app to use for objects of type X are something you as the user get to specify. Naturally, Microsoft wants you to use THEIR apps, so "out of the box" Windows has all of the defaults set to THEIR apps (if Microsoft makes an app to handle objects of type X) I consider this to simply be one of the tasks to take care of with a new install of a Windows OS is to change all the "out of the box" settings that aren't to my liking to the apps I want to be using. So in a case like this, you go to the place where you make the association settings and see what app is specified for .xml ___ 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 ignore account
On 1/20/2024 7:24 PM, Geoff wrote: Conjecture - Edge is also the default app for opening XML files on Windows? Repeating the import in debug mode, the trace file contains lots of information, no obvious (to me) error messages, and no mention of Edge: https://bugs.gnucash.org/attachment.cgi?id=374989 Geoff NOT really a gnucash matter. But the "defaults" for which app to use for objects of type X are something you as the user get to specify. Naturally, Microsoft wants you to use THEIR apps, so "out of the box" Windows has all of the defaults set to THEIR apps (if Microsoft makes an app to handle objects of type X) I consider this to simply be one of the tasks to take care of with a new install of a Windows OS is to change all the "out of the box" settings that aren't to my liking to the apps I want to be using. So in a case like this, you go to the place where you make the association settings and see what app is specified for .xml Michael D Novack ___ 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 ignore account
It is not "That is how this old version Quicken does dates of form 20xx" but more or so thank Intuit for proprietary touch to QIF file format where they left good deal of ambiguities. It has behaved like that up to 2017 version which the latest version I had used. You will have to normalize them in to a consist format. I had used *NIX's crude sed script on thousands of transactions in the past to fix them during migration (WSL is fine) ... I hope the code comes intact ... no error checking and there should be no special characters or white spaces in the file name #!/bin/bash set -x iam=$1 cat ${iam} > ${iam}.orig sed -i.tmp -e "s+' 0+/2000+g" ${iam} sed -i.tmp -e "s+' 1+/2001+g" ${iam} sed -i.tmp -e "s+' 2+/2002+g" ${iam} sed -i.tmp -e "s+' 3+/2003+g" ${iam} sed -i.tmp -e "s+' 4+/2004+g" ${iam} sed -i.tmp -e "s+' 5+/2005+g" ${iam} sed -i.tmp -e "s+' 6+/2006+g" ${iam} sed -i.tmp -e "s+' 7+/2007+g" ${iam} sed -i.tmp -e "s+' 8+/2008+g" ${iam} sed -i.tmp -e "s+' 9+/2009+g" ${iam} sed -i.tmp -e "s+'10+/2010+g" ${iam} sed -i.tmp -e "s+'11+/2011+g" ${iam} sed -i.tmp -e "s+'12+/2012+g" ${iam} sed -i.tmp -e "s+'13+/2013+g" ${iam} sed -i.tmp -e "s+'14+/2014+g" ${iam} sed -i.tmp -e "s+'15+/2015+g" ${iam} sed -i.tmp -e "s+'16+/2016+g" ${iam} sed -i.tmp -e "s+'17+/2017+g" ${iam} sed -i.tmp -e "s+'18+/2018+g" ${iam} sed -i.tmp -e "s+'19+/2019+g" ${iam} sed -i.tmp -e "s+'20+/2020+g" ${iam} sed -i.tmp -e "s+'21+/2021+g" ${iam} sed -i.tmp -e "s+'22+/2022+g" ${iam} sed -i.tmp -e "s+'23+/2023+g" ${iam} sed -i.tmp -e "s+'24+/2024+g" ${iam} sed -i.tmp -e "s+/81+/1981+g" ${iam} sed -i.tmp -e "s+/82+/1982+g" ${iam} sed -i.tmp -e "s+/83+/1983+g" ${iam} sed -i.tmp -e "s+/84+/1984+g" ${iam} sed -i.tmp -e "s+/85+/1985+g" ${iam} sed -i.tmp -e "s+/86+/1986+g" ${iam} sed -i.tmp -e "s+/87+/1987+g" ${iam} sed -i.tmp -e "s+/88+/1988+g" ${iam} sed -i.tmp -e "s+/89+/1989+g" ${iam} sed -i.tmp -e "s+/90+/1990+g" ${iam} sed -i.tmp -e "s+/91+/1991+g" ${iam} sed -i.tmp -e "s+/92+/1992+g" ${iam} sed -i.tmp -e "s+/93+/1993+g" ${iam} sed -i.tmp -e "s+/94+/1994+g" ${iam} sed -i.tmp -e "s+/95+/1995+g" ${iam} sed -i.tmp -e "s+/96+/1996+g" ${iam} sed -i.tmp -e "s+/97+/1997+g" ${iam} sed -i.tmp -e "s+/98+/1998+g" ${iam} sed -i.tmp -e "s+/99+/1999+g" ${iam} -Original Message- From: Fred Tydeman Sent: Saturday, January 20, 2024 6:36 PM To: Geoff Cc: Gnucash Users Subject: Re: [GNC] QIF import ignore account On Sat, Jan 20, 2024 at 3:02 PM Geoff wrote: > Hmmm... > > When I try importing that file into GnuCash 5.5 it crashes silently, > and the trace file contains just one line: > > * 09:56:13 WARN Failed to open application manifest > `C:\Program > Files\WindowsApps\Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe\AppxManifest.xml' > > for package #38 > (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'): > error code 0x2 > > As I said in my previous reply, when it comes to investment > transactions, cut your losses with the QIF Importer and use the CSV > Importer instead. It just works. > I am getting the QIF file from Quicken for DOS v8.7 of 1996. It can only export as QIF. > P.S. You have a quote instead of a slash between the day and the year: > > > D1/19'24 That is how this old version Quicken does dates of form 20xx ___ 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 ignore account
As was noted by a previous responder, the following works in Gnucash 5.5 and I didn't have to do any pre-import setup. !Account NAssets:us:Investments:TaxFree:f:Roth-F-Fid TInvst ^ !Type:Invst D1/19'24 NDiv Yroyal gold CX T45.60 Mroyal gold LIncome:us:NoTax:Roth-F-Fid:div:royal gold ^ On Sat, Jan 13, 2024 at 12:45 PM Fred Tydeman wrote: > GnuCash 4.14 on Linux > > As part of a QIF import, I have the following transaction: > ^ > D1/12'24 > NDiv > Yblue owl cap > CX > T122.50 > Mblue owl cap > LIncome:us:NoTax:Roth-F-Fid:div:blue owl cap > ^ > > However, when I do the Import in GnuCash, it shows up as: > Income:Dividends:Assets:us:Investments:TaxFree:f:Roth-F-Fid.:blue owl cap > > I do not understand why the QIF importer is ignoring the L... line > Now, the account on the L... line does not yet exist (so that might be the > reason). > > In case it matters, the first few lines in the QIF are: > !Account > NAssets:us:Investments:TaxFree:f:Roth-F-Fid > TInvst > ^ > !Type:Invst > ___ > 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 ___ 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 ignore account
Conjecture - Edge is also the default app for opening XML files on Windows? Repeating the import in debug mode, the trace file contains lots of information, no obvious (to me) error messages, and no mention of Edge: https://bugs.gnucash.org/attachment.cgi?id=374989 Geoff = On 21/01/2024 10:43 am, Adrien Monteleone wrote: Yes, but why would a browser be involved at all? Perhaps that line in the tracefile was not pertinent to the particular issue at hand, and/or something else is amiss. Regards, Adrien On 1/20/24 5:38 PM, Geoff wrote: Beats me - apart from being the default Windows browser??? ___ 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 ignore account
Yes, but why would a browser be involved at all? Perhaps that line in the tracefile was not pertinent to the particular issue at hand, and/or something else is amiss. Regards, Adrien On 1/20/24 5:38 PM, Geoff wrote: Beats me - apart from being the default Windows browser??? ___ 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 ignore account
There are various apps and services to convert QIF to CSV. Perhaps try one and see if that produces a better result. Regards, Adrien On 1/20/24 5:36 PM, Fred Tydeman wrote: I am getting the QIF file from Quicken for DOS v8.7 of 1996. It can only export as QIF. ___ 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 ignore account
Beats me - apart from being the default Windows browser??? I have run this again in debug mode and lodged a bug report with detailed trace file: https://bugs.gnucash.org/show_bug.cgi?id=799225 Geoff = On 21/01/2024 10:20 am, Adrien Monteleone wrote: Why is Edge involved at all? Regards, Adrien On 1/20/24 5:02 PM, Geoff wrote: When I try importing that file into GnuCash 5.5 it crashes silently, and the trace file contains just one line: * 09:56:13 WARN Failed to open application manifest `C:\Program Files\WindowsApps\Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe\AppxManifest.xml' for package #38 (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'): error code 0x2 ___ 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 ignore account
On Sat, Jan 20, 2024 at 3:02 PM Geoff wrote: > Hmmm... > > When I try importing that file into GnuCash 5.5 it crashes silently, and > the trace file contains just one line: > > * 09:56:13 WARN Failed to open application manifest > `C:\Program > Files\WindowsApps\Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe\AppxManifest.xml' > > for package #38 > (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'): > error code 0x2 > > As I said in my previous reply, when it comes to investment > transactions, cut your losses with the QIF Importer and use the CSV > Importer instead. It just works. > I am getting the QIF file from Quicken for DOS v8.7 of 1996. It can only export as QIF. > P.S. You have a quote instead of a slash between the day and the year: > > > D1/19'24 That is how this old version Quicken does dates of form 20xx ___ 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 ignore account
Why is Edge involved at all? Regards, Adrien On 1/20/24 5:02 PM, Geoff wrote: When I try importing that file into GnuCash 5.5 it crashes silently, and the trace file contains just one line: * 09:56:13 WARN Failed to open application manifest `C:\Program Files\WindowsApps\Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe\AppxManifest.xml' for package #38 (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'): error code 0x2 ___ 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 ignore account
OK. Bug 799224 opened with trace file. On Sat, Jan 20, 2024 at 2:50 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Wiki has information on tracefiles. (and crash dumps) Start with > the tracefile. Also, running from command line can offer some feedback. > > Regards, > Adrien > > On 1/20/24 4:33 PM, Fred Tydeman wrote: > > If there is some trace or dump file that I should be looking for, > > I do not know what/where it is. > > ___ > 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 ignore account
Hmmm... When I try importing that file into GnuCash 5.5 it crashes silently, and the trace file contains just one line: * 09:56:13 WARN Failed to open application manifest `C:\Program Files\WindowsApps\Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe\AppxManifest.xml' for package #38 (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'): error code 0x2 As I said in my previous reply, when it comes to investment transactions, cut your losses with the QIF Importer and use the CSV Importer instead. It just works. Regards Geoff = P.S. You have a quote instead of a slash between the day and the year: > D1/19'24 On 21/01/2024 9:33 am, Fred Tydeman wrote: !Account NAssets:us:Investments:TaxFree:f:Roth-F-Fid TInvst ^ !Type:Invst D1/19'24 Yroyal gold CX T45.60 Mroyal gold LIncome:us:NoTax:Roth-F-Fid:div:royal gold ^ ___ 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 ignore account
The Wiki has information on tracefiles. (and crash dumps) Start with the tracefile. Also, running from command line can offer some feedback. Regards, Adrien On 1/20/24 4:33 PM, Fred Tydeman wrote: If there is some trace or dump file that I should be looking for, I do not know what/where it is. ___ 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 ignore account
On Mon, Jan 15, 2024 at 5:57 PM Geoff wrote: > The reason for this problem you encountered with the QIF Importer: > > > However, when I do the Import in GnuCash, it shows up as: > > Income:Dividends:Assets:us:Investments:TaxFree:f:Roth-F-Fid.:blue owl > cap > > Is this record in your file: > > NDiv > > As far as I can tell, this causes the QIF Importer to prepend > "Income:Dividends:" to your account. > OK. I have removed that one line for this week's import. Here is the entire QIF file: !Account NAssets:us:Investments:TaxFree:f:Roth-F-Fid TInvst ^ !Type:Invst D1/19'24 Yroyal gold CX T45.60 Mroyal gold LIncome:us:NoTax:Roth-F-Fid:div:royal gold ^ When I try to import that one transaction, I get: A bug was detected while detecting duplicates. Since this is not a duplicate transaction, I am very confused. If there is some trace or dump file that I should be looking for, I do not know what/where it is. ___ 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.