OFX import problem

[Chris Good]

> Message: 7
> Date: Sun, 6 Nov 2016 12:05:27 +1100
> From: Liz <edodd at billiau.net>
> To: gnucash users mailing list <gnucash-user at gnucash.org>
> Subject: OFX import problem
> Message-ID: <20161106120527.62ecd5e2 at billiau.net>
> Content-Type: text/plain; charset=US-ASCII
> 
> 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)
> 

Hi Liz,

I don't think there is any problem with SIGNONMSGSRSV1,  SONRS,
BANKMSGSRSV1, or STMTTRNRS
as these are exactly like my files which import OK.
The only difference I can see between your file and mine is that after
BANKTRANLIST,
you have:
 <DTSTART>20160908
<DTEND>20161106235959
which are missing on mine.
You might like to try removing those (and putting back those you mentioned
above removing), but I suspect that will not help.
Maybe it is something in the actual transactions themselves which you have
not supplied an example of.
Please supply an example transaction (everything between <STMTTRN> and
</STMTTRN> and also
the end of the file after the last </STMTTRN>.

Do you know that the OFX importer will not try to import transactions for
which there are already transactions with the same
<FITID>? If you have already imported these transactions once, then you'll
need to delete them before re-trying.
I'm not sure if the FITID needs to be unique within the bank account or
within all GnuCash. I expect just within the bank account you are importing
to.

Also I don't have a blank line before <OFX>.

Here's an example of one of my transactions, and the end of the file:
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20161015000000
<TRNAMT>2300.00
<FITID>106232
<MEMO>[comment...] 
</STMTTRN>
</BANKTRANLIST>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>

Regards, Chris Good
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4817 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20161106/13e82c63/attachment.p7s>