GNOME Bugzilla – Bug 550176
QIF Fuile Import Failure
Last modified: 2018-06-29 22:09:28 UTC
Please describe the problem: Error Parsing Lines Extra Characters Discarded The Qif File Has sone £ (UK Currency Values) in it and there are some blank enterys Steps to reproduce: 1. HERE IS THE FILE 2. (The File was opened in notepad & Cut Pasted Into Here) !Type:CCard D08/07/2008 PBALANCE FROM PREVIOUS STATEMENT T45.19- ^ D25/07/2008 P PAYMENT RECEIVED - THANK YOU T45.19 ^ D08/08/2008 PBALANCE BROUGHT FORWARD T0.00- ^ D08/07/2008 PBT PLUSNET PLC SHEFFIELD GB T21.99- ^ D08/07/2008 PMULTITHREAD CONSUTANTS LSUFFOLK GB T38.46- ^ D09/07/2008 PWATERSTONES MANCHESTER GB T6.99- ^ D09/07/2008 PBOOTS THE CHEMIST MANCHESTER GB T5.97- ^ D11/07/2008 PUC SOLUTIONS LTD INTERNET GB T1502.00- ^ D13/07/2008 PTHE ROYAL OAK HOTE LANCASHIRE GB T77.95- ^ D15/07/2008 PWATERSTONES MANCHESTER GB T6.99- ^ D20/07/2008 PJOLLY CROFTERS BOLTON GB T49.25- ^ D22/07/2008 PN W TRAINS COMP LTD (BOLBOLTON GB T85.00- ^ D25/07/2008 PWM MORRISONS STORES BOLTON GB T22.44- ^ D26/07/2008 PROYAL OAK INN OLDHAM GB T79.76- ^ D26/07/2008 PWATERSTONES MANCHESTER GB T16.99- ^ D31/07/2008 PWAGAMAMA MANCHESTER GB T20.05- ^ D04/08/2008 PMARKS AND SPENCER BOLTONBOLTON GB T7.53- ^ D04/08/2008 PWHITAKERS BOLTON GB T12.50- ^ D07/08/2008 PTOP UP TV EUROPE SA A 0035242142857 GB T9.99- ^ D08/06/2008 PBALANCE FROM PREVIOUS STATEMENT T5781.76- ^ D27/06/2008 P PAYMENT RECEIVED - THANK YOU T181.76 ^ D02/07/2008 P PAYMENT RECEIVED - THANK YOU T5736.18 ^ D08/07/2008 PBALANCE BROUGHT FORWARD T136.18 ^ D09/06/2008 PTOP UP TV EUROPE SA A 0035242142857 GB T9.99- ^ D08/06/2008 PBT PLUSNET PLC SHEFFIELD GB T21.99- ^ D10/06/2008 PMARKS AND SPENCER BOLTONBOLTON GB T11.31- ^ D15/06/2008 PWATERSTONES MANCHESTER GB T3.99- ^ D21/06/2008 PNORTH WESTERN TRAINS CO SALFORD GB T88.90- ^ D02/07/2008 PWATERSTONE'S BOLTON GB T6.99- ^ D03/07/2008 PSELFRIDGES, MANCHESTER EMANCHESTER GB T21.13- ^ D03/07/2008 PBOOTS THE CHEMIST MANCHESTER GB T7.08- ^ D07/07/2008 PTOP UP TV EUROPE SA A 0035242142857 GB T9.99- ^ D08/07/2008 P T ^ D08/07/2008 PNATWEST VISA 03/03/08 T ^ D08/07/2008 POUTSTANDING BALANCE £0.00 T ^ D07/05/2008 PBALANCE FROM PREVIOUS STATEMENT T5580.29- ^ D27/05/2008 P PAYMENT RECEIVED - THANK YOU T120.29 ^ D08/06/2008 PINTEREST T46.26- ^ D08/06/2008 PBALANCE BROUGHT FORWARD T5506.26- ^ D07/05/2008 PTOP UP TV EUROPE SA A 0035242142857 GB T9.99- ^ D06/05/2008 PWATERSTONES MANCHESTER GB T5.50- ^ D08/05/2008 PBT PLUSNET PLC SHEFFIELD GB T21.99- ^ D13/05/2008 PTAMPOPO MANCHESTER GB T7.95- ^ D13/05/2008 PCOTSWOLD-MANCHESTER MANCHESTER GB T40.00- ^ D13/05/2008 PMAPLIN ELECTRONICS PLC MANCHESTER GB T11.98- ^ D15/05/2008 PWATERSTONES MANCHESTER GB T6.99- ^ D15/05/2008 PBOOTS THE CHEMIST MANCHESTER GB T28.25- ^ D18/05/2008 PPACK HORSE INN HIGH PEAK GB T57.85- ^ D21/05/2008 PN W TRAINS COMP LTD (BOLBOLTON GB T85.00- ^ D08/06/2008 P T ^ D08/06/2008 PNATWEST VISA 03/03/08 T ^ D08/06/2008 POUTSTANDING BALANCE £2336.63 T ^ D26/08/2008 P PAYMENT RECEIVED - THANK YOU T63.86 ^ D08/08/2008 PBT PLUSNET PLC SHEFFIELD GB T21.99- ^ D10/08/2008 PTHE FISHERMANS RETREAT LBURY GB T61.00- ^ D10/08/2008 PWATERSTONES MANCHESTER GB T8.50- ^ D13/08/2008 PCRAVENS SHOE REPAIR BOLTON GB T45.00- ^ D21/08/2008 PMARKS AND SPENCER BOLTONBOLTON GB T9.39- ^ D22/08/2008 PNORTH WESTERN TRAINS CO SALFORD GB T85.00- ^ D24/08/2008 PTHE ROYAL OAK HOTE PRESTON GB T71.95- ^ Actual results: GNUCASH FAILURE MESSAGE Line 139: Some characters have been converted according to your locale. Converted to: OUTSTANDING BALANCE £0.00 Line 207: Some characters have been converted according to your locale. Converted to: OUTSTANDING BALANCE £2336.63 Transaction amount: Unrecognized or inconsistent format. Expected results: Does this happen every time? Other information:
There are several problems with this QIF file. Where did you get it? For example, some transactions don't have amounts. Some have neither an amount nor a description! In any case, the QIF importer doesn't currently support: 1. the pound symbol in amounts: £2336.63 2. use of the negative sign at the end of the number: 85.00- This is really a duplicate of bug 141002 and bug 141003. I'll take a look at see how hard these would be to fix. *** This bug has been marked as a duplicate of 141002 ***
its from the TSB (UK) bank, its a "quicken98" file fronm there online credit card Statement ...
Thanks, I have added that to the notes for bug 141002 and bug 141003. The good news is that you CAN import the QIF file if you are willing to do a little editing by hand or by script. You just need to get rid of the pound symbols and move the minus signs to the front of the number. Also, I just fixed bug 141003. When 2.2.7 is released, at least you won't have to worry about the pound signs any more. You would still need to move the minus signs until someone fixes bug 141002. (I might attempt that, but not before 2.2.7 is released.)
Actually, I lie... I have now fixed bug 141002 as well. So when 2.2.7 is released, your QIF file should import just fine. However, you credit card company shouldn't give you transactions like "BALANCE FROM PREVIOUS STATEMENT" because these are not genuine transactions, i.e. they do not change your account balance. You might consider complaining to them about that. May be like talking to a brick wall, though.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=550176. Please update any external references or bookmarks.