GNOME Bugzilla – Bug 527886
QIF Import: Support QIF numeric formats of 12'345.67 as produced by Quicken 4
Last modified: 2018-06-29 22:03:30 UTC
Please describe the problem: I've been using Quicken 4 since 1996 but was never able to migrate off to a newer tool. I have finally taken the time to investigate why I could never load the QIF files into GnuCash and have discovered the following formatting problems: Dates: D10.25'04 Amounts: T-5'197.65 $-2'385.85 I fixed this with this trivial Perl script: #!/usr/bin/perl open(IN, "<FILE.QIF"); open(OUT, ">outfile.qif"); while ( my $line = <IN> ) { if ( $line =~ /^D/ ) { $line =~ s/'/.20/; } if ( $line =~ /^T/ ) { $line =~ s/'//; } if ( $line =~ /^\$/ ) { $line =~ s/'//; } print OUT $line; } close(OUT); close(IN); It would be nice for the next persons (if there are any with such an old Quicken) to have the import be more tolerant about the apostrophes. Steps to reproduce: Generate a QIF export file from Quicken 4 or hack any of the D, T or $ tags with a apostrophes. Actual results: You get an import error Expected results: The import should understand the apostrophes Does this happen every time? Only for Dates in > 1999, Amounts > 999.99 Other information:
Judging by the code and my testing, that date format is actually already supported. Supporting the numbers formatted with an apostrophe appears to be a pretty easy fix. I'll see what I can do.
Fix committed as r17086. Requesting backport for 2.2.
Applied to branches/2.2 as r17110 for GnuCash 2.2.5. Thanks a lot!
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=527886. Please update any external references or bookmarks.