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 160735 - QIF Importer should cope with !Option line
QIF Importer should cope with !Option line
Status: VERIFIED FIXED
Product: GnuCash
Classification: Other
Component: Import - QIF
git-master
Other All
: Normal enhancement
: ---
Assigned To: Derek Atkins
Derek Atkins
Depends on:
Blocks: 347575
 
 
Reported: 2004-12-07 22:05 UTC by Jeffrey Ratcliffe
Modified: 2018-06-29 20:48 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Jeffrey Ratcliffe 2004-12-07 22:05:33 UTC 
Please describe the problem:
Although all stages of the import process are carried out (nothing is listed
under "match qif accounts/categories/payees/memos with gnucash accounts")
nothing is actually imported.

Steps to reproduce:
Import this QIF:

!Type:Bank
!Option:AllXfr
D01/12/04
T-898.15
PSt. Veit Str. Miete
MSt. Veit Str. Miete
ND/D
L
^
D13/12/04
T-10.42
PJeff VIAG Interkom
MJeff VIAG Interkom
ND/D
L
^
D16/12/04
T-24.04
PJudy VIAG Interkom
MJudy VIAG Interkom
ND/D
L
^


Actual results:
Nothing is imported

Expected results:
The 3 transactions should be imported

Does this happen every time?
Yes

Other information:
Comment 1 Jeffrey Ratcliffe 2004-12-07 22:11:04 UTC 
After some more playing around, it seems that if the line:

!Option:AllXfr

is removed, then everything works as expected. Perhaps gnucash could be updated
to cope with this option.
Comment 2 Christian Stimming 2004-12-08 12:15:52 UTC 
Thank you for reporting this problem. However, QIF is a really bad format since
virtually every bank adds its own additions to these files. It is nearly
impossible to cope with all exceptions that are around. 

In your case, you can remove these lines with the command

  grep -v '!Option:AllXfr' original.qif > fixed.qif

and import the "fixed.qif" into gnucash. I'm afraid we will not be able to
implement any further support to these exceptions...
Comment 3 Tim Wunder 2006-03-03 00:22:44 UTC 
couldn't gnucash's QIF importer simply ignore any !Option: it doesn't understand?
Comment 4 Derek Atkins 2006-03-03 00:27:49 UTC 
I'll see if I can fix this soon.
Comment 5 Derek Atkins 2006-07-16 23:01:18 UTC 
Okay, I've added code to ignore any unknown !Option.  This should be fixed on trunk in r14522.  Awaiting audit to backport to 2.0.
Comment 6 Josh Sled 2006-07-25 23:56:06 UTC 
reviewed.  fine for backport.
Comment 7 Derek Atkins 2006-07-26 02:39:18 UTC 
Backported in r14560.  Should be fixed in 2.0.1.
Comment 8 John Ralls 2018-06-29 20:48:22 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=160735. Please update any external references or bookmarks.