AQBanking OFX File Parsing

Robin Chattopadhyay robinraymn at gmail.com
Tue Feb 14 21:53:20 EST 2012


Hi-

I have been using Gnc for several years on Windows, but just this weekend
switched to Linux (Ubuntu 11.10) (YAY ME!). I have AQBanking set up on both
systems and I noticed that AQBanking parses OFX files differently under
Linux than under Windows.

Given the following transaction:
<TRNTYPE>POS
<DTPOSTED>20111117120000.000
<TRNAMT>-4.86
<NAME>CARIBOU COFFEE CO # 16
<MEMO>CHECK CRD PURCHASE 11/15 MINNEAPOLIS MN 4323XXXXXXXX0221
321140004581187 ?MCC=5814 90

Under Windows, the value that goes in the Description field is <NAME>
<MEMO>.

As in CARIBOU COFFEE CO # 16 CHECK CRD PURCHASE 11/15 MINNEAPOLIS MN
4323XXXXXXXX0221 321140004581187 ?MCC=5814 90

Under Linux, the Description field is <MEMO> <NAME>

As in CHECK CRD PURCHASE 11/15 MINNEAPOLIS MN 4323XXXXXXXX0221
321140004581187 ?MCC=5814 90 CARIBOU COFFEE CO # 16

It's not really a bug per-se, I'm sure different banks have different
implementations of their OFX files, but it was more convenient under the
Windows implementation because the merchant name was at the beginning of
the string and not the end.

Just thought I'd share!

Thanks,
Robin


More information about the gnucash-user mailing list