Error importing qif files from Capitalone

[Rob Hymns]

Paul, Derek,Charles. That's great, many thanks. A bit of messing about but
still a big time saver for me.

Rob


2009/2/3 Paul Schwartz <pmjs1115 at yahoo.com>

> 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.
>
>
>
>