windows/libofx: import non utf-8 char bad for é è à ...

[francois]

Accent in ofx file from my banq is not imported correctly. Accents in memo field are replaced by symbols

See attached file.

[Maxime DOYEN (mdoyen)]

homebank version ?
os ?

[francois (fbeauchemin)]

HB version: 5.1.8
OS: Win10

[Maxime DOYEN (mdoyen)]

your file contains
ENCODING:USASCII
CHARSET:8859-1

but OFX library detect CP1152.
this file is a direct download, without any alteration ?
what if you convert it again to 8859-1 (can be done with a text editor ?
https://www.google.com/search?q=text+editor+change+encoding

[Maxime DOYEN (mdoyen)]

ofxdump the file produce SGML errors, I will post to libofx dev to get guidance on if your file is wrong or libofx problem

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:38:20:E: non SGML character number 9500

(Above message occured on Line 38, Column 21)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:38:21:E: non SGML character number 174

(Above message occured on Line 38, Column 22)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:38:23:E: non SGML character number 9500

(Above message occured on Line 38, Column 24)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:38:24:E: non SGML character number 225

(Above message occured on Line 38, Column 25)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:46:7:E: non SGML character number 9500

(Above message occured on Line 46, Column 8)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:46:8:E: non SGML character number 174

(Above message occured on Line 46, Column 9)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:46:10:E: non SGML character number 9500

(Above message occured on Line 46, Column 11)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
C:\Users\Maxime\AppData\Local\Temp\libofxtmpXXXXXX:46:11:E: non SGML character number 9508

[Maxime DOYEN (mdoyen)]

libofx bug:
https://github.com/libofx/libofx/issues/20

[Eduardo (eduedp)]

I'm having trouble importing any ofx file with special characters like accents, no mather what the encoding is. Tried UTF-8, cp1252, 8859-1....

Is there a workaround for now?

[Maxime DOYEN (mdoyen)]

the problem is due to a bug with libofx compiled for windows, we wait for a patch
https://github.com/libofx/libofx/issues/20

[Eduardo (eduedp)]

Any news on that libofx patch?

[Maxime DOYEN (mdoyen)]

As you may see by yourself by reading the bug page @libofx,

the author is blocked in building a test env into his Windows machine.
I've just gave him a procedure to follow, hoping he will succeed and be able to debug, and at last hopefully propose a patch.

[Sergey Mitrichev (for-serg)]

Similar problems with importing UTF-8 OFX files with non-latin letters on HomeBank 5.2.6 / Windows 10 v1903. The same OFX file in Ubuntu imports well.

Waiting for the ofxlib patch...

[Maxime DOYEN (mdoyen)]

@All:
don't hesitate to encourage the libofx maintainers @https://github.com/libofx/libofx/issues/20

[bleutneut (bleutneut)]

Hello

Is it possible to fix it as well for month's name in french language when data are exported in csv file

[Maxime DOYEN (mdoyen)]

@bleutneut:
absolutely not related with this bug, csv import do not use libofx.

your csv file file is just not well encoded (UTF-8) see the doc