[Bug]: Import CSV not splitting on selected Delimiter

[HBDK]

Verified issue does not already exist?

• I have searched and found no existing issue

What happened?

After updating to 23.10 the values shown in the Date, Payee, Notes and Amount drop downs are split on Comma and not the Delimiter selected in the Delimiter drop down.

when i downgrade to 23.9 it splits on the selected delimiter as expected.

changing the delimiter does not change it and i see no errors in the browser console.

i'm running Firefox 115.0

What error did you receive?

No response

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Linux

[hippalectryon-0]

Can confirm, same here

[hippalectryon-0]

Actually, I believe this is the same as #1774 , so it should be fixed

[Marcus-Schubert]

As of today and running the latest available version (v23.10.0) I can confirm that this bug still exists.

[MikesGlitch]

As of today and running the latest available version (v23.10.0) I can confirm that this bug still exists.

I think this is fixed in the next release which will be v23.11.0. That'll get released in the next week or so.

[jlsjonas]

I actually seem to have a very related but worse-presenting issue since 23.10.0 (23.11.0 isn't available yet on truecharts to validate the fix; posting for documentation purposes if the issue persists)

Using the following dummy csv:

"Uittreksel";"Datum";"Valuta datum";"Rekening";"Beschrijving";"Bedrag";"Valuta"
"2023/0010/0002";"31/10/2023";"31/10/2023";"";"Foo";"+ 123,12";"EUR"
"2023/0010/0001";"21/10/2023";"21/10/2023";"";"Bar";"- 1,23";"EUR"

it results in:

As my csv contains quotes, I suspect that the underlying issue will also be the delimiter selector (it is expecting a delimiter and seeing ; --the delimiter-- after all.

edit: confirmed suspicion by import working as expected when replacing ; with ,

[twk3]

@jlsjonas Your sample data seems to be working now. (I just tested with v23.12.0)

I believe this issue can be closed. Fixed by #1774 in v23.11.0

[jlsjonas]

👍 Confirmed working on my side too!
I suspect the underlying issue will also be resolved for the issue author.

[HBDK]

Sorry for the late reply, I finally got around to upgrading my instance and the error appears to be fixed now.