QIF import shows wrong dates

[scott anderson]

Import QIF shows wrong dates in import window, sometimes off by three to four months. When I open the QIF file the dates are correct from the downloaded bank statement. Basically 04/01/2011 from the bank shows up as 01/04/2011 in Homebank...

[scott anderson (lwarranty)]

Also does not recognize OFX or CVS statements downloaded from my bank whereas earlier releases did / worked fine! Compiled on Debian "Wheezy" using Homebank 4.4 source downloaded from Homebank site...

[scott anderson (lwarranty)]

Recompiled with latest squeeze and wheezy environments, ofx import works now (libofx-dev?) HOWEVER regardless of date tolerance in the import window, it will try to import existing entries. No rhyme nor reason, hitting refresh, etc if you import, it will add some redundant entries with the same information, date, amounts, payee name as. QIF import is inverting month/day - still no solution yet...

[Maxime DOYEN (mdoyen)]

Can you enable DEBUG into imp_qif.c file , recompile and launch into a terminal, then import your qif file, an post here as attachment the log of the console ?

[Maxime DOYEN (mdoyen)]

This is probably a bad date format recognition DD/MM/YY instead of MM/DD/YY

[Raphael Camus (raphael-camus)]

I used to have the same issue in the past and so had to start from an old .xhb backup (which was OK) and reimport a big qif file (and redo my categories,.. which hopefully were not really up-to-date).
I faced the issue again today (hopefully now I am making a backup after each import).

What I have noticed is that :
- Dates in my qif files are in MM/DD/YYYY format (ex: D11/04/2011), which I think is a qif standard, is it ?
- If none of days are superior to 12, HomeBank imports with DD/MM/YYYY format, which in my case is wrong
- If at least one day is >12, HomeBanks imports with MM/DD/YYYY format

Can the import date format be set in settings (per account) and not guessed ? (as date guessing cannot be performed in case where both date and months are < to 12 )
Does the date format specified in the Preferences have an impact on the import date ? In my case, I have French environement with %x format.

Thanks

[Raphael Camus (raphael-camus)]

I have tested changing the date format in preferences from %x (local settings - french in my case so DD/MM/YYYY) to %D (MM/DD/YY). The problem remains but the other way round...

[Maxime DOYEN (mdoyen)]

For v4.5, I have added a new preference parameter that let you choose between d-m-y or m-d-y, and no more rely on the guess of date format for qif files.
Adding to this is a date is invalid during import, it is showed with ??? into the transaction import list and the forward button is disabled to avois importing incorrect datas.