QIF import failure

[James A. de Haseth]

My experience is that such a large file is somewhat doomed.  I expect
that you are importing from another app that has at least several
different accounts, e.g. checking, credit cards, savings, plus budget
codes.  The QIF importer does a good job, but trying to unravel all the
threads between the accounts is very difficult.

I'd suggest breaking the file into separate accounts.  It can be edited
with a text editor.  Try importing one account/budget code at a time.
You can save yourself a lot of headaches if you preprocess your qif
files with sed, by replacing accounts with the gnucash names, or adding
accounts to qif entries where there is none.  

As far as the date is concerned, check the qif for lines such as
Dmm/dd/yy or Ddd/mm/yy, depending on location.  These are the
appropriate formats.  Somewhere the format is messed up.

Jim

On Sun, 2007-03-11 at 21:38 -0700, David Mitchell wrote:
> Good day all,
> 
> I am trying to import a large QIF file (1.4 MBytes). QIF Import appears
> to read in the file and
> then fails with the error message: QIF file parse failed: Data for
> number or date does not match a known format.
> 
> Can anyone suggest a way to identify the offending data line(s)?
> 
> I am using version 2.0.1 on Ubuntu Edgy.
> 
> Thanks,
> 
> David
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>