Error importing qif files from Capitalone

[Charles Day]

On Tue, Feb 3, 2009 at 4:43 PM, Rob Hymns <hymnsie at gmail.com> wrote:

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

No problem. Copy yourself on bug 141003 in bugzilla if you want to be
informed of any progress on handling the pound symbol.

http://bugzilla.gnome.org/show_bug.cgi?id=141003


> Rob
>

-Charles


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