QIF import broken

[ascpial]

I tried to import data from an other app, HomeBank, as well as the example file given in #265 and the toaster says "0 transactions imported".

The format of the date in both files is correct (US date: MM/DD/YYYY).

I'm using the latest version at the time of writing, which is 2023.2.2.

A QIF file that is broken: test.zip

[nlogozzo]

Recording.2023-03-14.123115.mp4

I can't reproduce it...works fine for me.

[nlogozzo]

^ That's running V2023.3.0-beta1, but that release did not change QIF from the latest stable.

[ascpial]

Sorry but everything is in french:

Capture.video.du.2023-03-14.17-46-34.webm

There is nothing in the list after restarting.

[nlogozzo]

It worked fine for me using GNOME version too.
Maybe it's because the application is in French.
If you run the app using en-US does it work?

[ascpial]

I tried in english, and it works fine, so the issue might come from language translation.

[nlogozzo]

I have to see what localization occurs for QIF...and i'll fix it.

[nlogozzo]

I believe this line is the problem: https://github.com/nlogozzo/NickvisionMoney/blob/main/NickvisionMoney.Shared/Models/Account.cs#L1354

I believe the en_US culture needs to be passed to that DateTime function other wise it will try to parse the date with the current locale instead of en_US.

I'm not home right now so I can't make the change and test. Maybe @fsobolev can.

[fsobolev]

I'm not home right now so I can't make the change and test. Maybe @fsobolev can.

I will work on it.

[ascpial]

I quickly tested the fix with the CI build and it's working great, thanks for the support!

[nlogozzo]

Once #355 is merged, I'll release beta 2 with all the file fixes :)

[nlogozzo]

https://github.com/nlogozzo/NickvisionMoney/releases/tag/2023.3.0-beta2

[kivutar]

Using 2023.4.1 from flathub I'm also having issues importing a QIF with date format DD/MM/YYYY.

If I change the dates in the QIF, Denaro is able to import the file properly.

[nlogozzo]

@kivutar As per docs: https://htmlpreview.github.io/?https://raw.githubusercontent.com/NickvisionApps/Denaro/2023.4.1/NickvisionMoney.Shared/Docs/html/C/import-export.html

Quicken Interchange Format (.qif)
Dates should be in English (US) format (MM/DD/YYYY).