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 141002 - QIF: Number format with '-' sign at end
QIF: Number format with '-' sign at end
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Import - QIF
unspecified
Other Linux
: Normal enhancement
: ---
Assigned To: Charles Day
Benoit Grégoire
: 550176 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2004-04-24 11:49 UTC by Andrew McDonald
Modified: 2018-06-29 20:43 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Andrew McDonald 2004-04-24 11:49:53 UTC 
The qif format produced by one of my on-line credit card accounts places the '-'
sign at the end of the number, which gnucash fails to import. It would be nice
if it worked, rather having to modify the qif files by hand first.

A sample qif looks like:

!Type:CCard
D25/03/2004
PTHE SHOPPING CENTRE     SOMEPLACE     GB
T10.50-
^
Comment 1 Derek Atkins 2004-04-24 14:46:16 UTC 
Does this imply a negative amount?
Comment 2 Andrew McDonald 2004-04-24 15:48:07 UTC 
Yes (translates into a 'charge' on a gnucash credit card account). My current
by-hand fix is to turn the "T10.50-" into "T-10.50" in the qif file before
importing.
Comment 3 Derek Atkins 2004-04-24 16:18:11 UTC 
Just making sure it means what I think it means.  I'll keep this in mind. 
unfortunately you're going to have to continue to hand-modify your QIF for the
forseeable future; there's not going to be another gnucash release for at least
4-6 months.
Comment 4 Allan Chandler 2008-07-15 08:32:06 UTC 
Does anyone still want this fixed?  It's had no comments since early 2004 and I think it should probably be closed if not needed.

The original reporter stated in another bug report that he no longer uses the service that produced these 'suspect' QIF files.

If it's needed, I'm looking for some simple bugs to get me oriented. Otherwise maybe it should re-enter triage for possible WONTFIX.
Comment 5 Charles Day 2008-09-01 15:47:10 UTC 
*** Bug 550176 has been marked as a duplicate of this bug. ***
Comment 6 Charles Day 2008-09-02 20:27:05 UTC 
This has been reported as a problem again (bug 550176). Apparently TSB (UK)
bank does this in their credit card statement downloads.
Comment 7 Charles Day 2008-09-03 00:12:25 UTC 
Fix committed as r17490. Requesting backport for 2.2.
Comment 8 Andreas Köhler 2008-09-19 02:52:55 UTC 
Improved by r17509 to use an escaped string.
As long as this break MacOSX (http://lists.gnucash.org/pipermail/gnucash-devel/2008-September/023919.html) I am going to remove this as blocker for the backport bug.
Comment 9 Charles Day 2009-03-25 15:17:10 UTC 
The fix to bug 141003 contained the problem with escaped strings, but it was removed completely in r17598. The fix for this bug remains in trunk and works fine. However, now it is unlikely to be backported for 2.2.x, so I'm going to mark this as closed with a target of 2.3.x.
Comment 10 John Ralls 2018-06-29 20:43:01 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=141002. Please update any external references or bookmarks.