Libofx problem with GnuCash

Sun Feb 2 17:27:58 CST 2003

I'm not sure whether this is a libofx problem, a GnuCash problem or my
OFX file.

I'm using GnuCash CVS from today (2/2/2003) and OpenSP 1.5 (installed in
/usr).

This was the first time I've compiled GnuCash with OFX, so I haven't yet
had much experience with it.  I've imported three other (non-credit card)
OFX files successfully into GnuCash with a total of about 40 transactions.

When I try to import a credit card file, I get a zero-dollar amount in
the matcher for all transactions that are TRNTYPE OTHER (i.e. purchases).
I have two credit card files from my bank and they both behave in the
same way.  There is one transaction that is also negative (payment),
in a different file, which has a TRNTYPE of FEE - this one comes up with
the proper value in the matcher.

I have tried the 0.6.2 RPM for libofx from libofx.sourceforge.net and
compiled my own 0.6.1 version from CVS (tag libofx-0-6-1).

0.6.2 gave a variety of errors in the debug output from Gnucash, like this:

| LibOFX WARNING: startElement: The OpenSP <= 1.3.4 endElement bug workaround was used: Encountered MEMO, generating endElement for FITID
| ).  Upgrade your OpenSP, your data is NOT garanteed to be correct.
| LibOFX ERROR: OpenSP parser: otherError (misc parse error)
| Error msg: /tmp/libofxtmpAziFgU:54:9:E: end tag for "MEMO" omitted, but OMITTAG NO was specified
| /tmp/libofxtmpAziFgU:53:0: start tag was here
| 
| LibOFX ERROR: OpenSP parser: otherError (misc parse error)
| Error msg: /tmp/libofxtmpAziFgU:54:9:E: end tag for "FITID" omitted, but OMITTAG NO was specified
| /tmp/libofxtmpAziFgU:52:0: start tag was here
| 
| LibOFX ERROR: Tried to close a FITID but a TRANSACTION is currently open.
| LibOFX ERROR: OpenSP parser: otherError (misc parse error)
| Error msg: /tmp/libofxtmpAziFgU:54:9:E: end tag for "TRNAMT" omitted, but OMITTAG NO was specified
| /tmp/libofxtmpAziFgU:51:0: start tag was here
| 
| LibOFX ERROR: Tried to close a TRNAMT but a TRANSACTION is currently open.
| LibOFX ERROR: OpenSP parser: otherError (misc parse error)
| Error msg: /tmp/libofxtmpAziFgU:54:9:E: end tag for "DTPOSTED" omitted, but OMITTAG NO was specified
| /tmp/libofxtmpAziFgU:50:0: start tag was here

but the same result in GnuCash (zero dollars, no Memo, no Account).

Here is the debug output from GnuCash while using libofx 0.6.1:

| Debug: gnc_file_ofx_import: Filename found: /home/rik/money/bank-20030201/InternetVisa.OFX
| Debug: gnc_file_ofx_import: Opening selected file
| LibOFX ERROR: OpenSP parser: otherError (misc parse error)
| Error msg: /usr/local/share/libofx/dtd/ofx160.dtd:3058:5:E: content model is ambiguous: when no tokens have been matched, both the 1st and 3rd occurrences of "SIGNONMSGSET" are possible
| 
| LibOFX ERROR: OpenSP parser: otherError (misc parse error)
| Error msg: /usr/local/share/libofx/dtd/ofx160.dtd:3058:5:E: content model is ambiguous: when no tokens have been matched, both the 2nd and 4th occurrences of "PROFMSGSET" are possible
| LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate OFX
| LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SIGNONMSGSRSV1
| LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SONRS
| LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate CREDITCARDMSGSRSV1
| LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate CCSTMTTRNRS
| WRITEME:  ofx_proc_account() Fill in the account type, default name, currency, etc.  
| Debug: ofx_proc_account_cb: Currency from libofx: AUD
| Debug: gnc_import_select_account: Default commodity received: Australian Dollar
| Debug: gnc_import_select_account: Default account type received: Credit Card
| Debug: gnc_import_select_account: Default commodity received: (null)
| Debug: gnc_import_select_account: Default account type received: 
| Error: ofx_proc_transaction_cb: WRITEME: Gnucash ofx_proc_transaction():Add PAYEE and ADRESS here once supported by libofx!
| 
| Debug: ofx_proc_transaction_cb: Currency from libofx: AUD
| Debug: ofx_proc_transaction_cb: Adding split; Ordinary banking transaction, money flows from or into the source account
| Debug: ofx_proc_transaction_cb: 1 splits sent to the importer gui
| Debug: gnc_import_select_account: Default commodity received: (null)
| Debug: gnc_import_select_account: Default account type received: 
| Error: ofx_proc_transaction_cb: WRITEME: Gnucash ofx_proc_transaction():Add PAYEE and ADRESS here once supported by libofx!
| 
| Debug: ofx_proc_transaction_cb: Currency from libofx: AUD
| Debug: ofx_proc_transaction_cb: 0 splits sent to the importer gui
| Debug: gnc_import_select_account: Default commodity received: (null)
| Debug: gnc_import_select_account: Default account type received: 
| Error: ofx_proc_transaction_cb: WRITEME: Gnucash ofx_proc_transaction():Add PAYEE and ADRESS here once supported by libofx!
| 
| Debug: ofx_proc_transaction_cb: Currency from libofx: AUD
| Debug: ofx_proc_transaction_cb: 0 splits sent to the importer gui
| Debug: gnc_import_select_account: Default commodity received: (null)
| Debug: gnc_import_select_account: Default account type received: 
| Error: ofx_proc_transaction_cb: WRITEME: Gnucash ofx_proc_transaction():Add PAYEE and ADRESS here once supported by libofx!
| 
| Debug: ofx_proc_transaction_cb: Currency from libofx: AUD
| Debug: ofx_proc_transaction_cb: 0 splits sent to the importer gui

ofxdump on the same file gives me:

Any suggestions?

thanks,
rik.