[Kmymoney-devel] OFX and UTF-8 problem

[Cristian Oneț]

On Monday 16 January 2012 15:51:24 Cristian Oneț wrote:
> 2012/1/16 Martin Javorek <martin at javorkovi.cz>:
> > Hi all,
> > regarding this forum post:
> > http://forum.kde.org/viewtopic.php?f=69&t=98633 I'm sending
> > one-transaction OFX file in UTF-8 encoding which I cannot import into
> > KMyMoney without character encoding issue.
> > 
> > But, please keep in mind - I'm a KmyMoney beginner, I'm not reporting a
> > bug. It is possible I'm doing something completely wrong and I will be
> > happy if you say "aaaah, do it this way" :-)
> I can confirm the problem you've reported. Since everything seems
> alright I don't have a quick solution but I will investigate the
> problem later and get back to you with a fix.

After the investigation this turned out to be a bug [1] in the OFX importer 
plugin. The bug was fixed and will be available in the upcoming bugfix version 
4.6.2 [2].

As a side-note the file you've provided needs an extra OFX header to be 
interpreted with the correct encoding by libofx (used by the plugin to import 
OFX files) as in the attached version. Without that header the import won't 
work correctly anyway.

To test that you have a correct OFX file you can use the ofxdump application.

For the attached file it yields (I add only the memo line):

    Extra transaction information (memo): Životní pojištění - Investor

While for your original file the output is:

    Extra transaction information (memo): Ăivotní pojištění - Investor

Thanks for spotting this bug :).

-- 
Regards,

Cristian Oneț

[1] https://bugs.kde.org/show_bug.cgi?id=291685
[2] http://techbase.kde.org/Projects/KMyMoney#Version_4.6.2
-------------- next part --------------
OFXHEADER:200
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:UTF-8
CHARSET:CSUNICODE
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<?xml version="1.0" encoding="utf-8" ?><?OFX OFXHEADER="200" VERSION="211" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?><OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS><DTSERVER>20120113232658.279</DTSERVER><LANGUAGE>Czech</LANGUAGE></SONRS></SIGNONMSGSRSV1><BANKMSGSRSV1><STMTTRNRS><TRNUID>92742fcf-659d-4a58-b4c0-aea12b4be65c</TRNUID><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS><STMTRS><CURDEF>CZK</CURDEF><BANKACCTFROM><BANKID>RZBCCZPP</BANKID><ACCTTYPE>CHECKING</ACCTTYPE></BANKACCTFROM><BANKTRANLIST><DTSTART>20110102230000.000</DTSTART><DTEND>20111230230000.000</DTEND><STMTTRN><TRNTYPE>REPEATPMT</TRNTYPE><DTPOSTED>20111222110000.000</DTPOSTED><DTUSER>20111222110000.000</DTUSER><DTAVAIL>20111222110000.000</DTAVAIL><TRNAMT>-377.00</TRNAMT><FITID>ba93976c35a69b705a2f4812dbc2507002f0869d</FITID><REFNUM>8833230723</REFNUM><PAYEEID>Životní pojištění - Investor</PAYEEID><NAME>Životní pojištění - Investor</NAME><PAYEE><NAME>Životní pojištění - Investor</NAME></PAYEE><BANKACCTTO><BANKID>3500</BANKID><ACCTID>1010101010/3500</ACCTID><ACCTTYPE>CHECKING</ACCTTYPE></BANKACCTTO><MEMO>Životní pojištění - Investor</MEMO></STMTTRN></BANKTRANLIST></STMTRS></STMTTRNRS></BANKMSGSRSV1></OFX>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20120116/ea9cf744/attachment.sig>