GNOME Bugzilla – Bug 134473
Failure importing QIF files into new account
Last modified: 2018-06-29 20:41:19 UTC
I am getting a repeatable failure trying to import all of my Quicken data (a bit over 12 years) from Quicken 4 Release 7 on Win95 to gnucash 1.8.8-1 (installed from rpm) running on Fedora Core 1.0. (Kernel 2.4.22-1.2115.nptl) After getting this error early (about the 10% point) in the process of removing duplicate transactions, I reran gnucash with loglevel 6. Here is the last bit of the output to stderr, including the backtrace: OR and AND Terms: AND Terms: Param List: book->guid Pred Data: guid how: COMPARE_EQUAL Match type GUID_MATCH_ANY, guids: 684579e940a4104d14c3dfa4db136413 Param List: account->guid Pred Data: guid how: COMPARE_EQUAL Match type GUID_MATCH_ANY Param List: trans->date-posted Pred Data: date how: COMPARE_GTE Match type DATE_MATCH_NORMAL query_date: 02/15/1992 Param List: trans->date-posted Pred Data: date how: COMPARE_LTE Match type DATE_MATCH_NORMAL query_date: 02/29/1992 Param List: book->guid Pred Data: guid how: COMPARE_EQUAL Match type GUID_MATCH_ANY, guids: 684579e940a4104d14c3dfa4db136413 Param List: value Pred Data: numeric how: COMPARE_EQUAL Match type NUMERIC_MATCH_ANY gnc_numeric: -36435/100 Sort Parameters: Param: GnucashQueryDefaultSortObject DESC Maximum number of results: -1 Leave: gncQueryPrint: Backtrace: In unknown file: ?: 0* [gnc:group-find-duplicates # #] In /usr/share/gnucash/scm/qif-import/qif-merge-groups.scm: 38: 1* (let* (# # # # ...) (if # #) (for-each # new-xtns) ...) 55: 2* [for-each #<procedure #f (xtn)> (# # # # ...)] In unknown file: ?: 3 (if (null? rest) (letrec ((lp #)) (lp list1)) ...) ... ?: 4 (begin (f (car l)) (lp (cdr l))) ?: 5* [#<procedure #f (xtn)> #<gw:wcp <gnc:Transaction*> 0xa683b68>] In /usr/share/gnucash/scm/qif-import/qif-merge-groups.scm: 57: 6 (let ((query (gnc:malloc-query))) (set! work-done (+ 1 work-done)) ...) 73: 7* (let ((date #)) (gnc:query-add-date-match-timepair query #t ...)) 74: 8 [gnc:query-add-date-match-timepair #<gw:wcp <gnc:Query*> 0xa81f788> #t ... 75: 9* [decdate (-1 . 0) #(0 0 0 7 0 0 0 0 -1 ...)] In /usr/share/gnucash/scm/date-utilities.scm: 151: 10 [moddate #<procedure #f (d1 . ds)> (-1 . 0) #(0 0 0 7 0 0 0 0 -1 ...)] ... 36: 11 [gnc:secs->timepair ... 36: 12* [car ... 36: 13* [mktime #(59 59 18 24 11 69 3 364 -1 ...)] /usr/share/gnucash/scm/date-utilities.scm:36:28: In procedure mktime in expression (mktime date): /usr/share/gnucash/scm/date-utilities.scm:36:28: Success I found that last transaction in the qif file and there doesn't seem to be anything strange about it. Here is the last transaction in the translog: ===== START C 8dd6e7b6538cdbed56bae0933e01b363 3290bee5e437ae2f3d1ffbdeab9f6602 2004-02-15 12:11:08.000000 -0500 2004-02-15 12:11:08.000000 -0500 1991-10-19 00:00:00.000000 -0400 0c1d4e95ace7fa285ea32b7a0e06bcdf CSRS-USAF Opening Balance n 4023605/100 4023605/100 1969-12-31 19:00:00.000000 -0500 C 8dd6e7b6538cdbed56bae0933e01b363 10e84ac13397fce99142ed5235350666 2004-02-15 12:11:08.000000 -0500 2004-02-15 12:11:08.000000 -0500 1991-10-19 00:00:00.000000 -0400 f5edb93a8a52dd0c49bc4ca7908e91ae Retained Earnings Opening Balance n -4023605/100 -4023605/100 1969-12-31 19:00:00.000000 -0500 ===== END Again, I was able to find that last transaction in a (different) qif file and there doesn't seem to be anything strange about it. I have saved the qif files and all of the output to the translog and stderr. I will be out of town and away from the computer until Saturday Feb 21, but will be happy to rerun any tests or supply more log output when I get back. Thanks in advance for any help anyone can give. Dave Hammond
Gnucash does not support dates prior to 1970. Remove any transactions prior to 1970 and import again. *** This bug has been marked as a duplicate of 106242 ***
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=134473. Please update any external references or bookmarks.