Re: [Kmymoney-devel] OFX and UTF-8 problem

Cristian Oneț Mon, 16 Jan 2012 11:32:49 -0800

On Monday 16 January 2012 15:51:24 Cristian Oneț wrote:
> 2012/1/16 Martin Javorek <mar...@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

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>

signature.asc
Description: This is a digitally signed message part.

_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel

Re: [Kmymoney-devel] OFX and UTF-8 problem

Reply via email to