Hi all,

I am trying to get KMyMoney import working. If I download data from my bank in OFX format and import the data, it imports fine. The problem is my bank puts the POS transaction ID in the NAME field of the OFX data. KMyMoney is unable to automatically catgorize transactions because the names are never the same.

I wrote a simple PHP script to parse the <NAME> and <MEMO> fields and reformat them into usable data. The other fields remain unchanged. When I import my changed OFX file most of the transaction come through with a blank Pay To field in KMyMoney. The NAME tag is filled in the OFX file.

Here is a <STMTMTRN> before change:

Code: Select all

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20100630120000
<TRNAMT>-52.97
<FITID>20100630SWDC0000000052970000000
<NAME>POS      #049002*POS* TAYLORS SC
<MEMO> 3301 WADE HAMPTON HICKORY POI
</STMTTRN>

and after change:

Code: Select all

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20100630120000
<TRNAMT>-52.97
<FITID>20100630SWDC0000000052970000000
<NAME>WADE HAMPTON HICKORY POI       
<MEMO>TAYLORS SC3301
</STMTTRN>

Can someone help me figure out what I am doing wrong with the conversion? Some of the transactions that are converted come through just fine.

Thanks,
James

Over the weekend I upgraded to Ubuntu 10.10 with KMyMoney 4.5.0 (KDE 4.5.1). I tried the import again and everything worked. My modified transactions imported without a problem.