Error importing qif files from Capitalone

[Paul Schwartz]

Any text editor should work.

Paul


--- On Tue, 2/3/09, Rob Hymns <hymnsie at gmail.com> wrote:

> From: Rob Hymns <hymnsie at gmail.com>
> Subject: Re: Error importing qif files from Capitalone
> To: "Derek Atkins" <warlord at mit.edu>
> Cc: gnucash-user at gnucash.org
> Date: Tuesday, February 3, 2009, 2:26 PM
> 2009/2/3 Derek Atkins <warlord at mit.edu>
> 
> > Ahh..   The £ is illegal -- the importer cannot
> handle that character.
> > Remove that from all your data and the importer should
> be able to
> > pull it in.
> >
> > -derek
> 
> 
> Sorry to be dense but how do I open it (or with what) in
> order to remove the
> pound signs?
> Rob
> 
> 
> 
> 
> >
> >
> > Quoting Rob Hymns <hymnsie at gmail.com>:
> >
> >  Thanks Charles
> >> Here's what I get:
> >>
> >> Line 3: Some characters have been converted
> according to your locale.
> >> Converted to: -£35.00
> >> Line 11: Some characters have been converted
> according to your locale.
> >> Converted to: -£56.50
> >> Line 19: Some characters have been converted
> according to your locale.
> >> Converted to: -£65.00
> >> Line 27: Some characters have been converted
> according to your locale.
> >> Converted to: -£56.50
> >> Line 35: Some characters have been converted
> according to your locale.
> >> Converted to: £295.48
> >> Line 43: Some characters have been converted
> according to your locale.
> >> Converted to: -£30.00
> >> Line 51: Some characters have been converted
> according to your locale.
> >> Converted to: -£56.50
> >> Line 59: Some characters have been converted
> according to your locale.
> >> Converted to: -£105.00
> >> Line 67: Some characters have been converted
> according to your locale.
> >> Converted to: -£29.00
> >> Line 75: Some characters have been converted
> according to your locale.
> >> Converted to: -£44.00
> >> Line 83: Some characters have been converted
> according to your locale.
> >> Converted to: -£30.00
> >> Line 91: Some characters have been converted
> according to your locale.
> >> Converted to: -£42.01
> >> Line 99: Some characters have been converted
> according to your locale.
> >> Converted to: -£48.50
> >> Line 107: Some characters have been converted
> according to your locale.
> >> Converted to: -£48.50
> >> Transaction amount: Unrecognized or inconsistent
> format.
> >>
> >> Rob
> >>
> >>
> >>
> >> 2009/2/3 Charles Day <cedayiv at gmail.com>
> >>
> >>  On Tue, Feb 3, 2009 at 2:39 AM, Rob Hymns
> <hymnsie at gmail.com> wrote:
> >>>
> >>>  I'm just getting started on Gnucash and
> having entered some transactions
> >>>> manually, I thought I'd try to import
> from my Capitalone credit card's
> >>>> webpage.
> >>>> Downloaded the qif file ok but after
> following the import procedure, I
> >>>> got
> >>>> a
> >>>> few lines with characters converted but
> with the final the error
> >>>> message:
> >>>> "Transaction amount: Unrecognized or
> inconsistent format."
> >>>> Anyone familiar with this or got some
> suggestions?
> >>>>
> >>>>
> >>> Does the QIF importer state a line number? If
> so, could you find the
> >>> offending line and post it here?
> >>>
> >>> Cheers,
> >>> Charles
> >>>
> >>>
> >>>  Rob
> >>>>
> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> -----
> >>>> Please remember to CC this list on all
> your replies.
> >>>> You can do this by using Reply-To-List or
> Reply-All.
> >>>>
> >>>>
> >>>
> >>> 
> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -----
> >> Please remember to CC this list on all your
> replies.
> >> You can do this by using Reply-To-List or
> Reply-All.
> >>
> >>
> >
> >
> > --
> >      Derek Atkins, SB '93 MIT EE, SM '95 MIT
> Media Laboratory
> >      Member, MIT Student Information Processing Board 
> (SIPB)
> >      URL: http://web.mit.edu/warlord/    PP-ASEL-IA   
>  N1NWH
> >      warlord at MIT.EDU                        PGP key
> available
> >
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.