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 <[email protected]>
Sent: Saturday, January 20, 2024 6:36 PM
To: Geoff <[email protected]>
Cc: Gnucash Users <[email protected]>
Subject: Re: [GNC] QIF import ignore account
On Sat, Jan 20, 2024 at 3:02 PM Geoff <[email protected]> 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 <GLib-GIO> 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
[email protected]
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.
