GNOME Bugzilla – Bug 100845
OFX import cannot import UTF-8
Last modified: 2018-06-29 20:23:05 UTC
When I import an ofx file from my bank here in Japan which is encoded in UTF-8 the importer shows me all transactions but the characters are not readable when I open it in an EUC-JP locale. When I check all and click import, the dialogue closes without a warning, but nothing is imported. This was written to standard error: Debug: gnc_import_select_account: Default commodity received: (null) Debug: gnc_import_select_account: Default account type received: Debug: gnc_import_select_account: Looking for account with online_id: 0005 034 0881745 WRITEME: gnc_import_select_account() Here we should check if account type is compatible, currency matches, etc. Debug: gnc_import_select_account: Return value: 0x837ea88, account name:Savings Account Error: ofx_proc_transaction_cb: WRITEME: Gnucash ofx_proc_transaction():Add PAYEE and ADRESS here once supported by libofx! Debug: ofx_proc_transaction_cb: Currency from libofx: JPY Debug: ofx_proc_transaction_cb: 0 splits sent to the importer gui Debug: refresh_clist_row: Begin -------------- What else information can I provide.
I would need a sample file, I've never seen OFX files containing multibyte characters yet. This may or may not be fixable, because of a OpenSP interface design error.
Can the reporter attach a sample file ? Otherwise this bug should be closed.
I had sent a sample file to Benoit 2 years ago. I don't want my private bank data on the web, and I don't understand OFX well enough to create a file by hand. Unfortunately, I'm not in a position to test again, because I don't have the set up on my PC here. I suggest that Benoit closes the bug, if he has fixed it, or I will close it once I can test again.
Ok, thanks for following this ! I guess it's Benoit's call now.
UTF-8 support is a little problematic in LibOfx because of the lack of support for it in standard C++. However, as it IS supported by OpenSP (but not in the generic interface). It should at least import corrupt caracters and not crast. I think the bug should stay open.
Are these dups of this bug? Sinc ethey are all Unicode related... http://bugzilla.gnome.org/show_bug.cgi?id=105345 http://bugzilla.gnome.org/show_bug.cgi?id=305121 ---
To comment #6: No, these are not duplicates, because this bug is a libofx problem and not related to the user interface.
Importing utf8 files works correctly for me in the 1.9.x version of gnucash. As of r14361 (and 1.9.8) gnucash will strip all non-utf8 characters from imported files. See bug 344841 for automatic conversion of imported files to utf8.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=100845. Please update any external references or bookmarks.