QFX import problem and work around, possible bug or new feature?
gnucash_user
gnucash at toups.info
Fri Sep 2 11:06:25 EDT 2016
All,
Today tried to import data from a credit card account and found that the
description fields were showing as null rather than with the payee value.
Studied the QFX file and noticed that the format of a transaction record as
received from the provider has changed from:
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>xxxxxxxxxxxxxxxxx[0:GMT]
<TRNAMT>xxxxx
<FITID>xxxxxxxxxxxxxxxxxxxxxx
<NAME>xxxxxxxxxxxxxxxxxxxxx
</STMTTRN>
to
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>xxxxxxxxxxxx[0:GMT]
<TRNAMT>xxxxxxxxxxxxxx
<FITID>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
<NAME>xxxxxxxxxxxxx
<CATEGORY>
<MEMO>null
</STMTTRN>
Note xxxxxxx represents the valid entries hidden for privacy reasons.
Work around is it to delete the lines:
<CATEGORY>
<MEMO>null
from the .QFX file from each transaction via your favorite text editor or
awk or sed script. After removal, the file imports as expected.
Is this a bug or new feature that needs to be reported or is it already
known? Or is there another way to address this problem?
Thanks
Michael
More information about the gnucash-user
mailing list