qif file

Derek Atkins warlord at MIT.EDU
Thu Oct 30 10:09:22 EDT 2014


(forwarding back to the list).

Glad you figured it out!

-derek

Simon Bond <shug0131 at gmail.com> writes:

> Thanks for your thoughts. I did check and found a dubious date of 0/0/0000 for
> a transaction saying that zero interest was charged. Deleting that transaction
> sorted out the problem
>
> Simon
>
> On Sat, Oct 25, 2014 at 6:04 PM, Derek Atkins <derek at ihtfp.com> 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.
>     >
>
>     --
>            Derek Atkins                 617-623-3745
>            derek at ihtfp.com             www.ihtfp.com
>            Computer and Internet Security Consultant
>

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