Help importing QIF file into existing account, "Data for number or date does not match a known format."

[Derek Atkins]

"Michael Chaffin" <chaffinmichael at gmail.com> writes:

> After I try to import the file I receive less then helpful message "QIF File
> parse failed: Data for number or date does not match a known format."
>
> Here is a small snippet of my QIF file,
> ** SNIP **
> ...
> D08/14/2006
> T11.06-
[snip]

T11.06- isn't a valid number format.
>
> After a quick look between the two, I notice that my accounts are missing
> the 'C' and 'L' fields, are they required? I also noticed that my dates are
> 4 characters long (2006), is that a problem? How about the fact that my
> Total ('T') fields end in a minus (-) and do not start with it? I am not
> even sure what the regular expression would look like to fix this problem.

C and L are optional.  The problem is the T line.

> My system is a Gentoo box running kernel 2.6.17, I am using GnuCash
> 2.0.1Built 2006-08-24 from r14585 (or Gentoo app-office/gnucash-
> 2.0.1 ). Any help is greatly appreciated.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available