Error importing qif files from Capitalone

Derek Atkins warlord at MIT.EDU
Tue Feb 3 15:43:28 EST 2009


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

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



More information about the gnucash-user mailing list