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 527886 - QIF Import: Support QIF numeric formats of 12'345.67 as produced by Quicken 4
QIF Import: Support QIF numeric formats of 12'345.67 as produced by Quicken 4
Status: VERIFIED FIXED
Product: GnuCash
Classification: Other
Component: Import - QIF
2.2.x
Other All
: Normal normal
: ---
Assigned To: Charles Day
Derek Atkins
Depends on:
Blocks: backport
 
 
Reported: 2008-04-13 15:46 UTC by Richard Eigenmann
Modified: 2018-06-29 22:03 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Richard Eigenmann 2008-04-13 15:46:05 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:
Comment 1 Charles Day 2008-04-13 22:11:42 UTC
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.
Comment 2 Charles Day 2008-04-14 17:11:37 UTC
Fix committed as r17086. Requesting backport for 2.2.
Comment 3 Andreas Köhler 2008-04-22 23:02:45 UTC
Applied to branches/2.2 as r17110 for GnuCash 2.2.5.
Thanks a lot!
Comment 4 John Ralls 2018-06-29 22:03:30 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=527886. Please update any external references or bookmarks.