mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-15 22:54:03 -05:00
[Bug]: Issue importing CSV with semicolon deliminter #663
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#663
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @RandomByte on GitHub (Oct 7, 2023).
Verified issue does not already exist?
What happened?
I'm not sure with which release this started to fail, but the CSV files my (German) bank generates can't be imported to Actual v23.10.0. These CSV files generally use semicolons as delimiters and comma as decimal separators.
I created two test files for your convenience, one using comma as delimiter (and period as decimal separator) and one using semicolons. The first can be imported as expected, the second seems to fail some kind of parsing as you can see in the screenshot below.
Files: Comma.csv | Semicolon.csv
What error did you receive?
See screenshot above. Import is not possible. After rewriting the CSV to use comma as delimiter (and period as decimal separator), the import was successful.
While I am facing this issue on my personal instance, I was able to reproduce the behavior on the current test server at: https://actualbudget.netlify.app
Where are you hosting Actual?
Docker
What browsers are you seeing the problem on?
Firefox, Safari
Operating System
Mac OSX
@thagorastos commented on GitHub (Oct 8, 2023):
I have the exact same issue. No matter whether I use Safari or Firefox. I also self host the server, which apparently makes not difference.