QIF Import Fails

Derek Atkins warlord at MIT.EDU
Thu May 29 13:50:45 EDT 2014


"Maf. King" <maf at chilwell.net> writes:

>> >> With this file I get the error "Transaction amount: Unrecognized or
>> >> inconsistent format.
[snip]
>> I did a visual check against a different qif file which was happily
>> accepted, but I can't see any obvious difference.
>
> Hi Keith,
>
> Sorry, I don't know QIF enough to be able to make an other suggestions.  Can 
> you post one of the failing transactions (and your GC/OS versions) - maybe one 
> of the Gurus will pick the thread up.

Generally this means there is some problem with your numeric entries.
Check all your 'T', '$', etc columns.  Most likely the issue is a
malformed number, or a blank number, or even one with a currency
symbol.  This error can also happen if there are inconsistencies in
formats, e.g. if you have 1,000.00 and 1.000,00 in the same data file.

> Cheers,
> Maf.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

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