CSV: Can't import DD.MM.YY dates

[iffy]

Sample CSV:

$ cat /tmp/sample.csv 
13.03.21,76.00,something

[iffy]

It's not just those dates... I can't get any of these dates to import:

13.03.21,76.00,something
13/03/21,76.00,something
13-03-21,76.00,something
13.03.2021,76.00,something
03.13.2021,76.00,something
03/13/2021,76.00,something
03/13/21,76.00,something
03-13-21,76.00,something
03.13.21,76.00,something

[maphew]

Also fails: DD MMM YYYY

Date,Description,Transfer,Balance
01 NOV 2021,Interest received,$9.99,$999.99
10 OCT 2021,Interac e-Transfer sent,-$99,$999.9
01 OCT 2021,Interest received,$9.99,$999.9

[ishanjain28]

Fails with almost every single format I tried. I can't import any transactions at all. Tested on Linux with versions 0.63.2 and 0.60.1

[iffy]

@ishanjain28 If you choose the right format and proceed with "Set mapping" (ignoring the red "Invalid") see if it actually succeeds. I've found that the displaying of "Invalid" is often invalid.

Related #581

[ishanjain28]

Hey @iffy Thank you for that!

I was a bit confused initially because the set mapping button was also greyed out and I couldn't figure out why.

Later I learned that you can't have 2 columns tagged as the date. (doesn't make much sense anyway I guess and I am not sure why my bank does this either).

I was able to import all my tx and it works well! thank you

[iffy]

Included in v0.65.0 release (AUTOMATED COMMENT)