[GNC] QIF import ignore account

[Kalpesh Patel]

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 <tydeman.fred at gmail.com> 
Sent: Saturday, January 20, 2024 6:36 PM
To: Geoff <cleanoutmyshed at gmail.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] QIF import ignore account

On Sat, Jan 20, 2024 at 3:02 PM Geoff <cleanoutmyshed at gmail.com> 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