Qif Import show Date format unercognized

[Derek Atkins]

David,

On Tue, December 28, 2010 5:59 pm, David T. 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).

The QIF importer doesn't care about the locale; it will test all four date
formats.  HOWEVER, if it finds:

D12/22/2010
and then later
D22/01/2010

it will report an error because no single date format fits all your data.

> David

-derek

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