GnuCash crashes when importing QIF file

[Doug Laidlaw]

Sent the QIF privately, but will still file a bug report to put it in the 
system.

I just tried deleting everything above the "Type: Bank" line.  It still 
crashed immediately.  It seems as though my problem arises from the QIF 
exported by KMymoney.  Perhaps I should be filing a bug report there.  Since 
the QIF file has no set form, Gnucash probably can't account for all the 
variations.  I looked on Quicken's site and Wikipedia, with no precedent 
available, and no description of the tags.  The Australian banks (or the two 
I have accounts with) have tailored their QIFs to suit the Australian version 
of Quicken, and I can import them into Gnucash without any problems.  Perhaps 
things are different on the Continent.

About the only thing that I miss from Gnucash is QIF export.  I am keeping my 
reference records under Quicken 2005, but am in Linux most of the time, so I 
sometimes need to synchronize the two.  KMymoney is closer to Quicken, but 
doesn't seem to be as well-developed as Gnucash.  I find its interface 
difficult as well, and at 60+, my mind isn't nimble enough to adapt.  I will 
be staying with Gnucash, so this bug won't worry me personally.

OT: The other thing that I find difficult is the "Deposit" and "Withdrawal" 
headings in the Ledger.  Whether they are a debit or a credit depends on the 
account, and I keep getting them back to front.  For this reason, I use the 
default single-line entry most of the time.  I suppose that since Bank is an 
Asset and a debit, that should control my thinking.

Doug.

On Sunday 21 January 2007 03:55, Derek Atkins wrote:
> Thanks,
>
> I think I'm going to need your QIF.  Can you file a bug report
> and attach the QIF there?  Your bug is a little more difficult
> to track down than Melinda's was.
>
> -derek
>
> Quoting Doug Laidlaw <laidlaws at hotkey.net.au>:
> > In my case:
> >
> > gnucash
> > gnucash: [M] "Found Finance::Quote version ""1.11"
> > Backtrace:
> > In unknown file:
> >   ?: 0* [qif-file:parse-fields #]
> > In /usr/share/gnucash/scm/qif-import/qif-file.scm:
> > 505: 1* (let* (# # # #) (and # # # ...) (cond # #))
> > 520: 2* (and # # # ...)
> > 561: 3* [check-and-parse-field #<procedure qif-xtn:date #> ...]
> > 651: 4  (let (# # #) (if # #) (cond # # #) ...)
> > 679: 5* (cond (# # # #) (# #) (#t #))
> > 684: 6* (and (not (null? (cdr formats))) do-parsing)
> > 684: 7* [not ...
> > 684: 8*  [null? ...
> > 684: 9*   [cdr #f]
> >
> > /usr/share/gnucash/scm/qif-import/qif-file.scm:684:24: In procedure cdr
> > in expression (cdr formats):
> > /usr/share/gnucash/scm/qif-import/qif-file.scm:684:24: Wrong type
> > argument in position 1: #f
> >
> > I have kept the .QIF file if you need to see it.
> >
> > Doug.
> >
> > On Sunday 21 January 2007 01:43, warlord at mit.edu wrote:
> >> What's printed on the terminal?
> >>
> >> -derek
> >>
> >> Quoting Melinda Savoy <savoymp at yahoo.com>:
> >> > Actually I am having the same problem when importing the QIF that is
> >> > exported from Quicken itself.  When I get to the last step in the
> >> > GnuCash import wizard the GnuCash application crashes (I am assuming)
> >> > and disappears.  No error msg it just disappears from my screen.
> >> >
> >> > The only difference is that I am working on the new release of GnuCash
> >> > 2.0.4
> >> >
> >> > Regards.
> >> >
> >> > Doug Laidlaw <laidlaws at hotkey.net.au> wrote: I just had the same
> >> > problem.  It is caused by the QIF exported by KMymoney.
> >> > The QIF starts with a list of all the available accounts, then lists
> >> > the transactions, but in a rather different format.  In view of this
> >> > last observation, I didn't bother with deleting the firast part and
> >> > trying again.
> >> >
> >> > I don't know when another format will become standard here in Oz.  It
> >> > still seems to be QIF everywhere.
> >> >
> >> > Doug.
> >> >
> >> > On Wednesday 04 October 2006 10:26, Arkadi Gelfond wrote:
> >> >> I'm using GnuCash ver.  2.0.1-3   built from r14585 on 2006-09-13,
> >> >> running on Debian Etch(testing)
> >> >>
> >> >> GnuCash crashes now on the last step after 'Enter the currency used
> >> >> for new accounts'. It did not happen before, in fact I was able to
> >> >> import most of my data using numerous QIF files, but now it crashes
> >> >> even if I try to import the same QIF files into empty file.
> >> >>
> >> >> here is the trace I found in the /tmp:
> >> >>
> >> >>
> >> >> gnucash: /usr/lib/gnucash/libgnc-backend-postgres.so: cannot open
> >> >> shared object file: No such file or directory
> >> >>
> >> >> failed to load gnc-backend-postgres from /usr/lib/gnucash
> >> >>
> >> >> loading system configuration
> >> >> looking for /etc/gnucash/config
> >> >> trying to load /etc/gnucash/config
> >> >> loading user configuration
> >> >> looking for /home/arkadi/.gnucash/config-2.0.user
> >> >> looking for /home/arkadi/.gnucash/config-1.8.user
> >> >> looking for /home/arkadi/.gnucash/config-1.6.user
> >> >> looking for /home/arkadi/.gnucash/config.user
> >> >> loading auto configuration
> >> >> looking for /home/arkadi/.gnucash/config-2.0.auto
> >> >> looking for /home/arkadi/.gnucash/config-1.8.auto
> >> >> looking for /home/arkadi/.gnucash/config-1.6.auto
> >> >> looking for /home/arkadi/.gnucash/config.auto
> >> >> loading saved reports
> >> >> looking for /home/arkadi/.gnucash/saved-reports-2.0
> >> >> looking for /home/arkadi/.gnucash/saved-reports-1.8
> >> >> loading stylesheets
> >> >> looking for /home/arkadi/.gnucash/stylesheets-2.0
> >> >> trying to load /home/arkadi/.gnucash/stylesheets-2.0
> >> >>
> >> >> Thx
> >> >> Arkadi
> >> >> _______________________________________________
> >> >> 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.
> >> >
> >> > --
> >> > The American Constitution guarantees the pursuit of happiness; it does
> >> > not guarantee happiness.
> >> >   - Unknown.
> >> > _______________________________________________
> >> > 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.
> >> >
> >> >
> >> >
> >> > ---------------------------------
> >> > Don't get soaked.  Take a quick peak at the forecast
> >> > with theYahoo! Search weather shortcut.
> >> > _______________________________________________
> >> > 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.
> >
> > --
> > It is a miracle that curiosity survives formal education.
> >   - Albert Einstein
> > _______________________________________________
> > 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.

-- 
I am a part of all that I have met.
   - Lord Tennyson, "Ulysses."