qif file

David Carlson david.carlson.417 at gmail.com
Sat Oct 25 14:29:59 EDT 2014


On 10/25/2014 12:04 PM, Derek Atkins wrote:
> Hi,
>
> On Sat, October 25, 2014 12:55 pm, Simon Bond wrote:
>> Hi
>>
>> I'm trying to import a qif file I downloaded into gnucash. It says there's
>> an error with the date format, but when I look at it with a basic text
>> editor, no apparent problem. There does appear to be extra lines starting
>> with "M". Is this the real problem ? I've copied in  a few lines from the
>> head of the file.
> What is the exact error you get?
>
> You should look through the WHOLE file and check every line that begins
> with a "D".  Most likely you have one in there that is bogus.
>
> How was this QIF created?
>
> -derek
>
> PS: There is nothing wrong with the few transactions you copied here.
>
>> Thanks Simon
>>
>> !Type:CCard
>> D14/08/2014
>> T-3612.10
>> PINITIAL BALANCE
>> M
>> ^
>> D14/08/2014
>> T0.77
>> PBONUS CASHBACK
>> M
>> ^
>> D14/08/2014
>> T3.82
>> P1PC CASHBACK
>> M
>> ^
>> D14/08/2014
>> T0.16
>> P2PC CASHBACK
>> M
>> ^
>> D14/08/2014
>> T9.00
>> P3PC CASHBACK
>> M
>> ^
>> D13/08/2014
>> T-39.95
>> PPURCHASE - DOMESTIC, CAMBRIDGE, S150-BLACKWELLS
>> M** 8411
>> ^
>> D13/08/2014
>> T-4.40
>> PPURCHASE - DOMESTIC, 7600, GREATER ANGLIA
>> M** 8411
>> ^
>> _______________________________________________
>> 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.
>>
>


I seem to recall that dates in format dd/mm/yy sometimes cause issues if
the locale defaults to mm/dd/yy.  You might also check your country
settings.

David C


More information about the gnucash-user mailing list