For gls mapping, account data doesn't appear in ofx output

[student-CE]

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

[jaraco]

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)

When I copy the file as you've shared, I don't get this error, and it works fine for me:

 csv2ofx main 🐚 cat > issue92.csv
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

 csv2ofx main 🐚 .tox/py/bin/python -m csv2ofx issue92.csv issue92.ofx -m gls
<no output>

Probably whatever tool you're using to get that CSV file is generating ISO8859 encoding. What you're getting isn't an error but a warning, and csv2ofx has handled the situation, so you can ignore that warning (but do use UTF-8 if you can).

Then, looking at the output, I also see what you see:

 csv2ofx main 🐚 cat issue92.ofx
DATA:OFXSGML
ENCODING:UTF-8
<OFX>
        <SIGNONMSGSRSV1>
                <SONRS>
                        <STATUS>
                                <CODE>0</CODE>
                                <SEVERITY>INFO</SEVERITY>
                        </STATUS>
                        <DTSERVER>20250228221002</DTSERVER>
                        <LANGUAGE>ENG</LANGUAGE>
                </SONRS>
        </SIGNONMSGSRSV1>
        <BANKMSGSRSV1>
                <STMTTRNRS>
                        <TRNUID></TRNUID>
                        <STATUS>
                                <CODE>0</CODE>
                                <SEVERITY>INFO</SEVERITY>
                        </STATUS>
                        <STMTRS>
                                <CURDEF>EUR</CURDEF>
                                <BANKACCTFROM>
                                        <BANKID>d14cd6ef74114049327b8f2246eebceb</BANKID>
                                        <ACCTID>174e773ff392f433d4aec878b7767583</ACCTID>
                                        <ACCTTYPE>CHECKING</ACCTTYPE>
                                </BANKACCTFROM>
                                <BANKTRANLIST>
                                        <DTSTART>19700101</DTSTART>
                                        <DTEND>20250228</DTEND>
                                        <STMTTRN>
                                                <TRNTYPE>DEBIT</TRNTYPE>
                                                <DTPOSTED>20171010000000</DTPOSTED>
                                                <TRNAMT>-98.76</TRNAMT>
                                                <FITID>5d06f9f8b0417d02d496d0e4355686b5</FITID>
                                                <NAME>Drillisch Online AG</NAME>
                                                <MEMO>SEPA-Basislastschrift</MEMO>
                                        </STMTTRN>
                                </BANKTRANLIST>
                        </STMTRS>
                </STMTTRNRS>
        </BANKMSGSRSV1>
</OFX>

At least for me, the ACCTID matches, but not the BANKID, and neither matches the number in the file.

I'm afraid I don't know how OFX is meant to work, but presumably it's working as intended given that there are tests for gls and they're passing.

The mapping for gls is here. I don't see anything unusual going on there, so probably the generation of BANKID and ACCTID come from elsewhere. Someone is going to have to investigate deeper into the code. Can you do that?