Moneydance import

Don Miles dmiles at austin.rr.com
Sat Feb 22 17:13:25 CST 2003


On Saturday 22 February 2003 02:15 pm, Derek Atkins wrote:
> Is there any chance you could narrow this down to one or two
> transactions that don't import properly?
>
> -derek
>
> Massis Sirapian <msirapian at free.fr> writes:
> > Hi,
> >
> > I want to give up moneydance 3.2 to use gnucash, and have tried to
> > import my accounts via a QIF file.
> >
> > But gnucash 1.8.1 gives a
> > "Data for number or date does not match a known format" and I can't
> > import my accounts.
> >
> > I've searched for information on www, but haven't found an answer
> > to this issue :
> > 1) Is moneydance export procedure broken ?
> > 2) If so, is there a script to transform the broken qif in an
> > importable format ?
> >
> > I'd really appreciate to use gnucash, specially because it's
> > free/GNU, and moneydance is not.
> >
> > Thanks,
> >
> > Massis
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at lists.gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user

This may not be relevant, but I have a similar problem downloading my 
Visa card statement in QIF format (same error message).  Turns out the 
statement uses 2 lines for some entries, with a "00/00/00" date for the 
second line.  Gnucash rejects the file because of these bad date 
entries.  I use a bash script to filter out the 2d lines, which contain 
no critical data, and Gnucash accepts the file.  This is the script I 
use:

#! /bin/bash
flag=0
while read a
do
case "$a" in
	D00/00/00*) flag=1
	;;
	^*) if [ $flag == 1 ]  #end of record, reset flag
	then
		flag=0
	else
		echo "$a"
	fi
	;;
	*)if [ $flag == 0 ]
	then
		echo "$a"
	fi
	;;
esac
done

It could probably be done in one line with perl, but I'm too old to 
learn perl.  I assume my bank is violating the rules for QIF files when 
it generates these lines in my downloaded statement.  

Hope this helps.

Don Miles





More information about the gnucash-user mailing list