actualbudget / actualbudget/actual

[Bug]: error on importing from csv when only a single decmal digit in transaction

Đang mở
#5,020 0 bình luận 1 reaction 0 người được giao Xem trên GitHub
transaction import
Ngôn ngữ chính
TypeScript
Star
28.7k
Fork
3k
Merge trung bình
2 ngày 11 giờ
Pull request đã merge (30 ngày)
65

Mô tả

### 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

Hướng dẫn đóng góp

Mở hướng dẫn đóng góp

Đánh giá

Issue này chưa được đánh giá.

Nhận issue mới trong hộp thư của bạn

Bản tóm tắt ngắn những issue GitHub phù hợp với người mới.