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