Libofx problem with GnuCash

Rik Harris <[email protected]>
Newsgroups gmane.comp.finance.libofx.devel,gmane.comp.gnome.apps.gnucash.devel
Message-ID <[email protected]> 
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:

| LibOFX STATUS: find_dtd():DTD found: /usr/local/share/libofx/dtd/ofx160.dtd
| 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
| ofx_proc_status():
|     Ofx entity this status is relevent to: SONRS 
|     Severity: INFO
|     Code: 0, name: Success
|     Description: The server successfully processed the request.
| 
| ofx_proc_status():
|     Ofx entity this status is relevent to: CCSTMTTRNRS 
|     Severity: INFO
|     Code: 0, name: Success
|     Description: The server successfully processed the request.
| 
| ofx_proc_account():
|     Account ID: NNNNNNNNNNNNNNNN 
|     Account name: Credit card NNNNNNNNNNNNNNNN
|     Account type: CREDITCARD
|     Currency: AUD
| 
| ofx_proc_statement():
|     Currency: AUD
|     Account ID: NNNNNNNNNNNNNNNN 
|     Start date of this statement: Sun Dec  1 11:00:00 2002 EST
|     End date of this statement: Fri Jan 31 11:00:00 2003 EST
|     Ledger balance: 0.00
| 
| ofx_proc_transaction():
|     Account ID : NNNNNNNNNNNNNNNN 
|     Transaction type: PAYMENT: Electronic payment
|     Date posted: Mon Dec  9 11:00:00 2002 EST
|     Total money amount: 338.94
|     # of units: -338.94
|     Unit price: 1.00
|     Financial institution's ID for this transaction: 200212090001
|     Extra transaction information (memo): PAYMENT-BPAY-THANK YOU 00
| 
| ofx_proc_transaction():
|     Account ID : NNNNNNNNNNNNNNNN 
|     Transaction type: OTHER: Other
|     Date posted: Mon Jan  6 11:00:00 2003 EST
|     Total money amount: -108.00
|     # of units: 108.00
|     Unit price: 1.00
|     Financial institution's ID for this transaction: 200301060001
|     Extra transaction information (memo): XXXXXXXXXXXXXXXXXXXX
| 
| ofx_proc_transaction():
|     Account ID : NNNNNNNNNNNNNNNN 
|     Transaction type: OTHER: Other
|     Date posted: Tue Jan  7 11:00:00 2003 EST
|     Total money amount: -13.00
|     # of units: 13.00
|     Unit price: 1.00
|     Financial institution's ID for this transaction: 200301070001
|     Extra transaction information (memo): YYYYYYYYYYYYYYYYYYYY
| 
| ofx_proc_transaction():
|     Account ID : NNNNNNNNNNNNNNNN 
|     Transaction type: OTHER: Other
|     Date posted: Fri Jan 24 11:00:00 2003 EST
|     Total money amount: -333.09
|     # of units: 333.09
|     Unit price: 1.00
|     Financial institution's ID for this transaction: 200301240001
|     Extra transaction information (memo): ZZZZZZZZZZZZZZZZZZZZZ

Any suggestions?

thanks,
rik.


-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.