[Bug]: Insufficient detection of number delimiter in CSV import #835

Closed
opened 2026-02-28 19:21:27 -06:00 by GiteaMirror · 2 comments
Owner

Originally created by @lkempf on GitHub (Dec 30, 2023).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

My bank uses csv files with ; as a delimiter and , as a comma in amounts. When importing the csv via the UI I can select the correct csv delimiter but the number delimiter seems to be selected automatically. This work in almost all cases. But for exact amounts, e.g. 1.000 the detected amount is 1.00, not the correct 1000. For inexact amounts, e.g. 1.111,11 the correct delimiter is selected.

What error did you receive?

No response

Where are you hosting Actual?

Locally via Yarn

What browsers are you seeing the problem on?

Firefox

Operating System

Linux

Originally created by @lkempf on GitHub (Dec 30, 2023). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### What happened? My bank uses csv files with `;` as a delimiter and `,` as a comma in amounts. When importing the csv via the UI I can select the correct csv delimiter but the number delimiter seems to be selected automatically. This work in almost all cases. But for exact amounts, e.g. `1.000` the detected amount is 1.00, not the correct 1000. For inexact amounts, e.g. `1.111,11` the correct delimiter is selected. ### What error did you receive? _No response_ ### Where are you hosting Actual? Locally via Yarn ### What browsers are you seeing the problem on? Firefox ### Operating System Linux
GiteaMirror added the needs infobug labels 2026-02-28 19:21:27 -06:00
Author
Owner

@MatissJanis commented on GitHub (Jan 11, 2024):

👋 Could you please provide an example CSV file so folks could reproduce it?

Thanks!

@MatissJanis commented on GitHub (Jan 11, 2024): 👋 Could you please provide an example CSV file so folks could reproduce it? Thanks!
Author
Owner

@MatissJanis commented on GitHub (Feb 1, 2024):

Closing due to lack of information.

@MatissJanis commented on GitHub (Feb 1, 2024): Closing due to lack of information.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#835