OFX import problem

Liz edodd at billiau.net
Sat Nov 5 21:05:27 EDT 2016


I have several accounts with the same financial institution. Some OFX
downloads import and others don't.
This is a failing account import. 
I see that there are a lot of items which the OFX importer is not
handling, and present them for comment (and assistance)

Liz

Running Gnucash from the command line, so I get some error messages....
I open the program and try to import a failing OFX file. 
I select a file to process and choose "Import"

A big blank window appears 
"Generic Import Transaction Matcher"
"List of downloaded transactions (source split shown):

This window should contain the transactions for checking.


$ gnucash
Found Finance::Quote version 1.38
LibOFX INFO: libofx_proc_file(): File format not specified, autodetecting...
(Above message occured on Line 18446744073709551615, Column 18446744073709551615)
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open Financial eXchange (OFX or QFX))
(Above message occured on Line 18446744073709551615, Column 18446744073709551615)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SIGNONMSGSRSV1
(Above message occured on Line 2, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate SONRS
(Above message occured on Line 3, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate BANKMSGSRSV1
(Above message occured on Line 12, Column 1)
LibOFX INFO: Created OfxDummyContainer to hold unsupported aggregate STMTTRNRS
(Above message occured on Line 13, Column 1)


This is the start of the OFX file, with square brackets replacing
identifying info

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20161106111819
<LANGUAGE>ENG
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>[numeric member ID]
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<STMTRS>
<CURDEF>AUD
<BANKACCTFROM>
<BANKID>[numeric bank ID]
<ACCTID>[numeric account ID]
<ACCTTYPE>SAVINGS
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20160908
<DTEND>20161106235959
<STMTTRN>
<TRNTYPE>DEBIT


I remove the xml opening and closing tags for 
SIGNONMSGSRSV1
SONRS
BANKMSGSRSV1
STMTTRNRS

and try again.

Now I have
LibOFX INFO: libofx_proc_file(): Detected file format: OFX (Open Financial eXchange (OFX or QFX))
(Above message occured on Line 268, Column 1)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpXSOBhD:2:7:E: document type does not allow element "STATUS" here

(Above message occured on Line 2, Column 8)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpXSOBhD:6:9:E: document type does not allow element "DTSERVER" here

(Above message occured on Line 6, Column 10)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpXSOBhD:7:9:E: document type does not allow element "LANGUAGE" here

(Above message occured on Line 7, Column 10)
LibOFX ERROR: startElement: incoming_data should be empty! You are probably using OpenSP <= 1.3.4.  The folowing data was lost: 20161106111819
(Above message occured on Line 7, Column 1)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpXSOBhD:8:7:E: document type does not allow element "TRNUID" here

(Above message occured on Line 8, Column 8)
LibOFX ERROR: startElement: incoming_data should be empty! You are probably using OpenSP <= 1.3.4.  The folowing data was lost: ENG
(Above message occured on Line 8, Column 1)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpXSOBhD:9:7:E: document type does not allow element "STATUS" here

(Above message occured on Line 9, Column 8)
LibOFX ERROR: startElement: incoming_data should be empty! You are probably using OpenSP <= 1.3.4.  The folowing data was lost: 63670776
(Above message occured on Line 10, Column 1)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpXSOBhD:13:7:E: document type does not allow element "STMTRS" here

(Above message occured on Line 13, Column 8)
LibOFX ERROR: startElement: incoming_data should be empty! You are probably using OpenSP <= 1.3.4.  The folowing data was lost: 
(Above message occured on Line 14, Column 1)
LibOFX ERROR: Tried to close a TRNUID but a  is currently open.
(Above message occured on Line 260, Column 1)
LibOFX ERROR: Tried to close a LANGUAGE but a  is currently open.
(Above message occured on Line 260, Column 1)
LibOFX ERROR: Tried to close a DTSERVER but a  is currently open.
(Above message occured on Line 260, Column 1)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/tmp/libofxtmpXSOBhD:260:5:E: end tag for "OFX" which is not finished

(Above message occured on Line 260, Column 6)




More information about the gnucash-user mailing list