actualbudget / actualbudget/actual

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

未關閉
#5,020 0 則留言 1 個 reaction 已指派 0 人 在 GitHub 檢視
transaction import
主要語言
TypeScript
星號
28.7k
分支
3k
平均合併
2 天 11 小時
30 天內合併 PR
65

描述

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

貢獻指南

開啟貢獻指南

評估

這個 Issue 還沒有評估資料。

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。