GnuCash crashes when importing QIF file

Derek Atkins warlord at MIT.EDU
Sat Jan 20 15:56:27 EST 2007


Well, it applies to a scheme file, so you can apply it either to your
source or install-tree.  If you built from source then just cd into
the top-level of the source tree and run:

  patch -p0 < /path/to/patch

and then just install the changed file:

  make -C src/import-export/qif-import istall

If you installed from a binary (deb/rpm) then you can just patch the
install tree directly:

  cd /usr/share/gnucash/scm/qif-import
  patch -p3 < /path/to/patch

And then you should be able to re-run GnuCash.

-derek

Quoting Melinda Savoy <savoymp at yahoo.com>:

> Derek,
>
> Thanks so much for your reply.  Being new to GnuCash can you please 
> point me in the direction of some instructions as to how to apply 
> this .patch file.  Will it be applied to the source, the binary ?
>
> I will get to you as soon as I can get it applied.
>
> Regards.
>
>
>
> Derek Atkins <warlord at MIT.EDU> wrote: INTERESTING.  It looks like 
> string-match uses regexp, but the author
> of this code didn't expect that.  Maybe guile changed the implementation.
> Anyways, try out the attached patch and let me know if it fixes this
> for you?  It should..
>
> I've committed this to trunk, and if it works for you I'll backport it
> to the 2.0 branch for inclusion in 2.0.5.
>
> Thanks,
>
> -derek
>
> Quoting Melinda Savoy :
>
>> Sorry here I forgot to include the user group:
>>
>> (gnucash:3105): libgnomevfs-WARNING **: Failed to open session DBUS
>> connection: Unable to determine the address of the message bus (try
>> 'man dbus-launch' and 'man dbus-daemon' for help)
>> Volume monitoring will not work.
>> 3105: arguments to dbus_connection_send_with_reply_and_block() were
>> incorrect, assertion "connection != NULL" failed in file
>> dbus-connection.c line 2873.
>> This is normally a bug in some application using the D-Bus library.
>> 3105: arguments to dbus_connection_send_with_reply_and_block() were
>> incorrect, assertion "connection != NULL" failed in file
>> dbus-connection.c line 2873.
>> This is normally a bug in some application using the D-Bus library.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-file:read-file : unknown Security slot G .. continuing anyway.
>> qif-parse:parse-acct-type : unhandled account type 401(k)/403(b)...
>> substituting Bank.qif-parse:parse-acct-type : unhandled account type
>> 401(k)/403(b)... substituting Bank.Backtrace:
>> In unknown file:
>>   ?:  5* [#
> #]
>> In /usr/local/share/gnucash/scm/qif-import/qif-dialog-utils.scm:
>> 381:  6  [for-each #
> (# # # # ...)]
>> In unknown file:
>>    ...
>>   ?:  7  (begin (f (car l)) (lp (cdr l)))
>>   ?:  8* [#
> #]
>> In /usr/local/share/gnucash/scm/qif-import/qif-dialog-utils.scm:
>> 384:  9* (if (not entry) (set! entry (qif-import:guess-acct # #
>> gnc-acct-info)))
>> 385: 10  (set! entry (qif-import:guess-acct (qif-cat:name cat) (if #
>> # ...) ...))
>> 386: 11* [qif-import:guess-acct "TAXES:TAX FICA(MEL" (9 8) ...]
>> In /usr/local/share/gnucash/scm/qif-import/qif-guess-map.scm:
>> 223: 12  (let* (# #) (qif-map-entry:set-qif-name! retval acct-name) ...)
>> 224: 13* [qif-import:find-similar-acct "TAXES:TAX FICA(MEL" (9 8) ...]
>> 258: 14  (let* (# # #) (for-each # gnc-acct-info) (for-each #
>> same-type-accts) ...)
>> 275: 15* [for-each #
> (# # # # ...)]
>> In unknown file:
>>   ?: 16  (if (null? rest) (letrec ((lp #)) (lp list1)) ...)
>>    ...
>>   ?: 17  (begin (f (car l)) (lp (cdr l)))
>>   ?: 18* [#
> ("Bonus" "Income:Bonus" #)]
>> In /usr/local/share/gnucash/scm/qif-import/qif-guess-map.scm:
>> 277: 19  (if # #)
>> 277: 20* [qif-import:possibly-matching-name? "TAXES:TAX FICA(MEL" #]
>> 301: 21  (or (string=? # #) (string=? # #) (and # #))
>> In unknown file:
>>    ...
>>   ?: 22  [string-match "taxes:tax fica(mel" "income:bonus"]
>>   ?: 23  (let ((rx #) (start #)) (regexp-exec rx str start))
>>   ?: 24* [gsubr-apply #
> "taxes:tax
>> fica(mel"]
>>
>> : In procedure make-regexp in expression (make-regexp pattern):
>> : Unmatched ( or \(
>>
>>
>> warlord at MIT.EDU wrote: What's printed on the terminal?
>>
>> -derek
>>
>> Quoting Melinda Savoy :
>>
>>> 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  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.
>>>
>>
>>
>>
>>
>>
>> ---------------------------------
>> Sucker-punch spam with award-winning protection.
>> Try the free Yahoo! Mail Beta.
>> _______________________________________________
>> 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.
>>
>
>
>
> --
>       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
>
> === src/import-export/qif-import/qif-guess-map.scm
> ==================================================================
> --- src/import-export/qif-import/qif-guess-map.scm (revision 13928)
> +++ src/import-export/qif-import/qif-guess-map.scm (local)
> @@ -5,6 +5,8 @@
> ;;;  Bill Gribble  20 Feb 2000
> ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
>
> +(use-modules (srfi srfi-13))
> +
> (define GNC-BANK-TYPE 0)
> (define GNC-CASH-TYPE 1)
> (define GNC-ASSET-TYPE 2)
> @@ -315,10 +317,9 @@
>    ;; this happens if you have the same tree but a different
>    ;; top-level structure. (i.e. expenses:tax vs. QIF tax)
>    (and (> (string-length qif-acct-name) 0)
> -        (string-match (string-downcase qif-acct-name)
> -                      (string-downcase (cadr gnc-acct))))))
> +        (string-contains (string-downcase (cadr gnc-acct))
> +    (string-downcase qif-acct-name)))))
>
> -
> ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
> ;;  qif-import:find-new-acct
> ;;  Come up with a logical name for a new account based on
>
>
>
>
>
>
>
>
>
> ---------------------------------
> Check out the all-new Yahoo! Mail beta - Fire up a more powerful 
> email and get things done faster.



-- 
       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



More information about the gnucash-user mailing list