Importing investment accounts from MS Money problem
Tracy Di Marco White
gendalia@iastate.edu
Wed, 25 Jul 2001 08:45:02 CDT
I'm trying to import around 50 .qif files. 4 of them won't import, I get
the "Data format inconsistent in QIF file." error. Looking through the
mailing list, I see someone had this problem in May, and it was either a
date or money inconsistency, likely. I looked through the shortest file
I'm having problems with, and the dates and numbers look consistent:
% grep ^D problem.qif
D12/21/1999
D3/10/2000
D4/5/2000
D5/12/2000
D6/21/2000
D6/21/2000
D6/21/2000
D8/11/2000
D12/19/2000
D2/20/2001
The numbers for Q, T, I, etc all look consistent, also. Some only have
a '.' (I15.364583), some are empty, but I see no inconsistencies in the
ones that have both a '.' & an ','.
I have four of these files, all investment accounts, and all look ok as
far as I can tell.
This brought up another problem. Once I've told it I wish to load
another QIF file, if I don't have another valid QIF file to load,
I don't see how to get it to go ahead and just use the QIF files I've
already loaded. My choices are "Back" & "Next". Next has problems
either because it can't load my file, or if I select some other file,
because I've already loaded it or if I don't specify a file, because I
haven't specified a file. Back takes me to a screen where all I can
do is select "Next", which just puts me back where I was. The only
way out is to click cancel, which loses the 45 files I just loaded.
I think it'd be nice to just tell it to load all the QIF files in this
directory, as I'd exported them all to one directory to lend itself to
doing just that.
I'm using gnucash 1.6.0 on NetBSD/i386 1.5.1. I've attempted to use
gnucash before, this looked like a good time to try again.
Tracy J. Di Marco White
Project Vincent Systems Manager
gendalia@iastate.edu