actualbudget / actualbudget/actual
[Bug]: error on importing from csv when only a single decmal digit in transaction
- Langage dominant
- TypeScript
- Étoiles
- 28.7k
- Forks
- 3k
- Merge moyen
- 2 j 11 h
- PR mergées (30 j)
- 65
Description
### Verified issue does not already exist?
- [x] I have searched and found no existing issue
### What happened?
The following CSV gives an error. The first record "SHOPPING STORE" tries to import a value of "-1,107.00" rather than "-110,70". The reason is that the people who create the CSV do not put two digits after the dot if the last decimal digit is a zero. This causes Actual to move the dot and add a couple of zeros as decimals.
```
Date;Affilié;Montant
17-05-2025;"Dépense SHOPPING STORE (Transaction 7fadbaae-631a-469d-a1c8-7a2c613ccb88)";" -110.7 €"
17-05-2025;"Dépense ANOTHER STORE (Transaction f432ba17-f272-4bd3-b89f-bdb67c6fbe1a)";" -116.62 €"
06-05-2025;"Dépense YET ANOTHER STORE (Transaction 0743b082-854c-4128-addd-d8fa80f0f793)";" -109.78 €"
```
### How can we reproduce the issue?
Simply import the above CSV into an account with [these import settings](https://paste.pics/890e3b2fc742b7c42e74d972fc6e5b21).
### Where are you hosting Actual?
Docker
### What browsers are you seeing the problem on?
Firefox
### Operating System
Linux
Guide de contribution
Ouvrir le guide de contribution
Évaluation
Cette issue n'a pas encore été évaluée.