GNOME Bugzilla – Bug 457591
QIF import does not handle tabs at top of file
Last modified: 2018-06-29 21:43:08 UTC
ANZ Bank, one of the "Big 4" banks in Australia, exports QIF files with three TAB whitespace characters at the beginning. Sample File (between dashed lines): ---------------------- !Type:Bank D21/06/2007 T-100.00 PANZ ATM WITHDRAWAL ^ ---------------------- Gnucash 2.2.0 fails to import this file with the error "QIF file load failed: File does not appear to be a QIF file." After manually deleting the first (whitespace) line in an editor, the import works. Yes, the Official QIF Specification states that the first line must be a header, ie. "!Type:". However, it's a fair assumption that Quicken does handle this extraneous whitespace (can someone with Quicken confirm?). Regardless, the chance of getting a Bank to modify their export format is slim. So it would be nice if GnuCash's QIF import could be relaxed a little to handle the extraneous whitespace.
It looks like ANZ has fixed their format... my last download from them didn't have the leading tabs and imported OK.
Created attachment 102584 [details] [review] Proposed patch This proposed patch allows the QIF importer to ignore lines that only contain whitespace.
Applied to trunk as r16876. Awaiting backport
Applied to branches/2.2 as r16896 for GnuCash 2.2.4. 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=457591. Please update any external references or bookmarks.