Qif Import show Date format unercognized

[Jessica Parsons]

OK, that makes sense.  Sorry to push things in the wrong direction!

My next suggestion was to enter a few transactions into GnuCash and export
the QIF, then compare the two files.  I suppose this might have illuminated
that the D actually belongs there.  It might still be useful to compare
which date formats are being attempted on the GnuCash side.



On Tue, Dec 28, 2010 at 2:59 PM, David T. <sunfish62 at yahoo.com> wrote:

> 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>
> <ml-node%2B3166502-1985024024-206850 at n4.nabble.com<ml-node%252B3166502-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.
> >
>
>
>
> _______________________________________________
> 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.
>