After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 134473 - Failure importing QIF files into new account
Failure importing QIF files into new account
Status: VERIFIED DUPLICATE of bug 106242
Product: GnuCash
Classification: Other
Component: Import - Other
1.8.x
Other Linux
: Normal critical
: ---
Assigned To: Benoit Grégoire
Benoit Grégoire
Depends on:
Blocks:
 
 
Reported: 2004-02-15 22:42 UTC by Dave Hammond
Modified: 2018-06-29 20:41 UTC
See Also:
GNOME target: ---
GNOME version: 2.3/2.4



Description Dave Hammond 2004-02-15 22:42:04 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
Comment 1 Derek Atkins 2004-02-16 04:16:29 UTC
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 ***
Comment 2 John Ralls 2018-06-29 20:41:19 UTC
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.