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