actualbudget / actualbudget/actual

[Bug]: No transactions detected in bank CSV export

Ouverte
#6,327 9 commentaires 0 réactions 0 personnes assignées Voir sur GitHub
help wanted transaction import
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?

When I tried to import the CSV exported from my bank's site, AB says there are no transactions in it:

Image

But if I look into the file, I see that there are 5 transactions in it, and a header row, fields separated by commas.
If I set the "skip start lines" to 1, AB says I cant skip more lines than there is, so maybe it cannot handle the line endings used?

Image

According to the linux "file" command, the is a "Little-endian UTF-16 Unicode text, with very long lines".
I dont know how to tell what line endings it has though, because suprisingly its much harder than on windows.. no text editor I know can tell that to me.

Another problem could be that AB does not allow me to select the standard date format used in my country (YYYY.MM.DD), but that would be on top of the line detection issue. If it turns out to be an issue I'll open a separate issue for that.

### How can we reproduce the issue?

0. You would need a sample export file from my bank
1. Open AB's webapp in Firefox
2. Select an account on the left
3. Click Import at the top
4. Select the sample CSV file

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

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.