reubano / csv2ofx

A Python library and command line tool for converting csv to ofx and qif files
MIT License
199 stars 113 forks source link

I can not find the same "account" content data in csv file like in ofx #92

Open student-CE opened 2 years ago

student-CE commented 2 years ago

Hi after installing the library csv2ofx, when i type

csv2ofx file_data_2021.csv file_data_2025kk.ofx -m gls

it gives me this error:

'utf-8' codec can't decode byte 0xe4 in position 54: invalid continuation byte
<_io.TextIOWrapper name='file_data_2021.csv' mode='r' encoding='utf-8'> was opened with the wrong encoding (utf-8)
Incorrectly encoded file, reopening with bytes to detect encoding
detected encoding: ISO-8859-1
Reopening <_io.TextIOWrapper name='file_data_2021.csv' mode='r' encoding='utf-8'> with encoding: ISO-8859-1](url)

I have used the test file exist in the github:

the content of the csv file:

Kontonummer;Buchungstag;Wertstellung;Auftraggeber/Empfänger;Buchungstext;VWZ1;VWZ2;VWZ3;VWZ4;VWZ5;VWZ6;VWZ7;VWZ8;VWZ9;VWZ10;VWZ11;VWZ12;VWZ13;VWZ14;Betrag;Kontostand;Währung
DE 1234567890;10.10.2017;10.10.2017;Drillisch Online AG;"SEPA-Basislastschrift";B4658645 U123456789 B123456;987 SIMply Rechnung;;;;;;;;;;;;;-98,76;1.234,56;EUR

----> My Question here that when i have looked in the file "ofx" generated after this command, i didn"t find the same "account" in csv for example in my csv file(the example data is at the top) Kontonummer = DE 1234567890 , i have found it like that:

                <BANKID>174e773ff392f433d4aec878b7767583</BANKID>
                <ACCTID>174e773ff392f433d4aec878b7767583</ACCTID>

----> what i mean that the account number in my csv file not the same like on ofx file ??? any help please