The csv2actual from jorisnoo

jorisnoo / csv2actual Goto Github PK

View Code? Open in Web Editor NEW

A command line utility to import bank transactions as csv into Actual

License: Other

JavaScript 4.37% Batchfile 0.22% TypeScript 95.40%

csv2actual's People

Contributors

Stargazers

Watchers

csv2actual's Issues

Support checking for invalid CSV files for DKB (Germany)

👋

DKB in Germany exports invalid CSV files that need a bit of manipulation to work with this module. Specifically, the first 6 lines of the file need to be removed. This would have to happen before the current code would be able to identify the file as DKB data. Is this a use case you are interested in allowing for?

Here's an example export to show you the problem

"Kontonummer:";"DE11111111111111111111 / Konto";

"Von:";"23.10.2021";
"Bis:";"22.11.2021";
"Kontostand vom 22.11.2021:";"1.111,11 EUR";

"Buchungstag";"Wertstellung";"Buchungstext";"Auftraggeber / Beg�nstigter";"Verwendungszweck";"Kontonummer";"BLZ";"Betrag (EUR)";"Gl�ubiger-ID";"Mandatsreferenz";"Kundenreferenz";
"27.10.2021";"27.10.2021";"Lohn";"Acme";"Lohn";"DE11111111111111111111";"ABCDEFGH111";"1.111,11";"";"";"111111111/111111";

Recommend Projects