yet another QIF import problem

[Charles Day]

On Fri, Mar 14, 2008 at 12:29 PM, Carla Schroder <carla at bratgrrl.com> wrote:

> hello all,
>
> Just like so many other GnuCash users, I'm having trouble importing
> existing
> data. I have a QIF file exported from Moneydance, and GnuCash gives me the
> famous "QIF file parse failed: Data for number or date does not match a
> known
> format." I've read many messages here in the archives, and the GnuCash
> manual, and still I am not seeing the light. I'm running version 2.2.1 on
> Kubuntu. I tried building 2.2.4 from sources on a PCLinuxOS box, but after
> 300+ megabytes of ./configure, fail, install a new dependency,
> ./configure,
> fail, install a new dependency, ./configure, fail, install a new
> dependency,
> etc ad nauseum, I gave it up.
>

There have been so many fixes to the QIF importer since 2.2.1 that I've lost
count. Definitely upgrade to 2.2.4 before importing all your data! Others
here can probably help you with the compiling issues.

It's a 70k file, and here is a snippet. From what I've read everything looks
> correct, but obviously I'm missing something:
>

The small sample that you have shown here looks correct, and imports
perfectly into 2.2.4. So either 2.2.4 has fixed the problem, or the trouble
lies elsewhere within that 70k file.

You may have a better chance of spotting what exactly 2.2.1 is choking on if
you start GnuCash from a command line. The QIF importer sends some limited
diagnostic messages to standard output, which you should be able to see from
the command line. It may even tell you what actual content of the QIF file
is confusing the importer.

Cheers,
Charles

!Option:AutoSwitch
> !Account
> NFoo Money Market-Terry
> DFoo One
> TBank
> ^
> !Account
> NFoo Money Market-joint
> DFoo
> TBank
> ^
>
> [snipped]
>
> !Clear:AutoSwitch
> !Account
> NFoo Money Market-Terry
> DFoo
> TBank
> ^
> !Type:Bank
> D03/11/2008
> T1000.00
> C
> NTrn
> Ptransfer
> M
> L[Terry Checking]
> ^
> D01/31/2008
> T27.42
> C
> NDep
> Pinterest earned
> M
> LIncome-money market
> ^
> D08/07/2007
> T150.00
> C
> N
> PACH transfer
> M
> L[Joint Checking]
> ^
>
> All brilliant notions are welcome!
>
> Carla
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Carla Schroder
> check out the shiny new Linux Networking Cookbook!
> Chock full o' step-by-step howtos for network admins!
> http://www.oreilly.com/catalog/9780596102487/
>
> many more Linux howtos at
> http://tuxcomputing.com/
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> _______________________________________________
> 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.
>