GnuCash crashes when importing QIF file
Melinda Savoy
savoymp at yahoo.com
Sat Jan 20 15:44:40 EST 2007
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.
More information about the gnucash-user
mailing list