[Kmymoney] OFX vs QFX: was Issue while importing statement data from CSV file

[Ryan Novosielski]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 04/13/2014 07:48 PM, Jack wrote:
> On 2014.04.13 19:44, Ryan Novosielski wrote:
>> It may just be my bank. OFX imports very poorly from their online
>> site whereas QFX is OK. I don't understand it myself, as I expect
>> the formats to be roughly the same (and they use the same
>> importer).
>> 
> I am very intrigued that there is a bank that provides both QFX
> and OFX.  I can't imagine why, but they likely have their reasons.
> I'd be interested (pure curiousity) to see what the differences are
> in downloading the same set of transactions in both formats.

OK, I can see why I didn't like OFX. For the most part, it's indenting
and the fact that the spaces are stripped from all names and memos.
Here's a snipped of a diff:

< Export.OFX
> Export.QFX)

< <TRNTYPE>CREDIT
< <DTPOSTED>20140411120000
< <TRNAMT>120.00
< <FITID>#######
< <NAME>ATMDeposit0410NJRUTHERFORD2
< <MEMO>ATMDeposit0410NJRUTHERFORD252PARKAVENUESEQ003501
- ---
> <TRNTYPE>CREDIT <DTPOSTED>20140411 <TRNAMT>120.00 <FITID>####### 
> <NAME>ATM Deposit 0410 NJ RUTHERFORD 2 <MEMO>ATM Deposit 0410 NJ
> RUTHERFORD 252 PARK AVENUE SEQ# 003501

...which does actually make me wonder why I'm seeing "PURCHASE" in the
name field instead of the actual name listed here. I can't imagine
that not having spaces in any of those names is preferable to anyone,
Microsoft Money or not.

Also, the OFX version omits <AVAILBAL></AVAILBAL>, having <BALAMT> and
<DTASOF> just out in the open. The header sections are identical, but
the OFX version has no <FI></FI>, including the contents of that section.

- -- 
     _    _
 ___| | _(_) -------------------------------------------------
/ __| |/ / | ~ Ryan Novosielski - ryan at novosielski.com       ~
\__ \   <| | ~ AIM - SainteX ~ GTalk: rnovosielski at gmail.com ~
|___/_|\_\_| -------------------------------------------------

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlNL+q4ACgkQYmfKSjLmC/BuIQCeKZ90d00ZTd8X+vjcDv0hPuaP
nNoAn0KsOuYMU0t03utyqFWb4TSpS+zD
=1Div
-----END PGP SIGNATURE-----