Qif Import show Date format unercognized

[David T.]

BabaO & Jessica--

The reason that it dropped all the transactions is that the "D" in the QIF file designates the date field in the QIF file. Stripping the "D" effectively told the imported that none of the transactions had any dates, and it ignored all the invalid transactions. 

Is it possible that your system locale is set to use a dd/mm/yyyy format? You indicated that the QIF file had all the dates as mm/dd/yyyy. If Gnucash is interpreting these dates as dd/mm/yyyy, then the first transaction for the 13th of the month would cause the importer to give you a date error (since the QIF would have 01/13/2010, and Gnucash would interpret this as an illegal date).

David

--- On Tue, 12/28/10, BabaO <lbao.web at gmail.com> wrote:

> From: BabaO <lbao.web at gmail.com>
> Subject: Re: Qif Import show Date format unercognized
> To: gnucash-user at gnucash.org
> Date: Tuesday, December 28, 2010, 1:48 PM
> 
> *No no nooo lololol  you misunderstood :
> 
> I did tried all the regular format first but the import did
> not work not
> once.
> So after looking for an answer on the net, I read about de
> Dmm or Ddd
> formats, and I tried them just because I was out of "date
> formats to try"
> since I had tried all the regular ones (and theirs a lot of
> those).
> 
> The funny things is, someone suggested I look at the Qif
> files themselves
> and try to see what date formats showed on them directly.
> So I opened
> several of them with TxtEdit (im on a MAC) and those files
> were suppose to
> have many different date formats, but OH TO MY SURPRISE all
> of them showed
> with Dmm/dd/yyyy format !
> 
> Then Jessica suggested I tried taking the "D" out... now
> that was tedious
> but I just did it, and when I tried importing that qif file
> into GnuCash it
> did go through BUT dicarded EVERY transaction lolol. So
> that's not working
> either :)
> 
> BabaO
> 
> *
> 
> On Tue, Dec 28, 2010 at 16:36, VeryThorough [via GnuCash]
> <
> ml-node+3166502-1985024024-206850 at n4.nabble.com<ml-node%2B3166502-1985024024-206850 at n4.nabble.com>
> > wrote:
> 
> Well, you've come to the right place for help!  One
> way or another, we
> > should be able to figure out a way to make it work.
> >
> > I have a quick question about your most recent
> response.  You said, "Yes I
> > did try both: Dmm/dd/yyy and Ddd/mm/yyy"  Is that
> what you actually entered
> >
> > into the custom date field?  If so, I could see
> why you're getting all
> > those
> > D's!
> >
> > Maybe I'm misreading your response, but if not, could
> you try entering
> > "mm/dd/yyyy" (without quotes, of course) into the
> custom date field?
> >
> > Otherwise, it seems the search and replace method,
> though cludgy, should
> > work.
> >
> > VT
> >
> >
> 
> -- 
> View this message in context: http://gnucash.1415818.n4.nabble.com/Qif-Import-show-Date-format-unercognized-tp3166413p3166515.html
> Sent from the GnuCash - User mailing list archive at
> Nabble.com.
> _______________________________________________
> 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.
>