[GNC] Gnucash doesn't load American Express QFX files

[Jim Leek]

I got this error using both Gnucash 2.6.19 and 3.6 on Linux Mint 19 with
libofx7 from the Ubuntu repositories.

I have been using Gnucash for many years, and this is the first time I've
ever had trouble with American Express.

Actually aqbanking couldn't communicate with american express for the first
time, I got the error:
Status for transaction statement request: Account not found (Code 2003,
severity "ERROR")
But that's not what I'm writing about.

I logged into the website and downloaded the QFX file, but could not import
it.  I get the following error.

LibOFX INFO: libofx_proc_file(): File format not specified, autodetecting...
(Above message occurred on Line 2815, Column 1)
LibOFX ERROR: libofx_detect_file_type(): Failed to identify input file
format
(Above message occurred on Line 2815, Column 1)
LibOFX INFO: libofx_proc_file(): Detected file format: UNKNOWN (File format
couldn't be successfully identified)
(Above message occurred on Line 2815, Column 1)
LibOFX ERROR: libofx_proc_file(): Detected file format not yet supported ou
couldn't detect file format; aborting.
(Above message occurred on Line 2815, Column 1)


Here is a sanitized version of the troublesome QFX file:

<?xml version="1.0" standalone="no"?><?OFX OFXHEADER="200" VERSION="202"
SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?><OFX xmlns:ns2="
http://ofx.net/types/2003/04"><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY><MESSAGE>Login
Successful!</MESSAGE></STATUS><DTSERVER>20190907000000.000[-7:MST]</DTSERVER><LANGUAGE>ENG</LANGUAGE><FI><ORG>AMEX</ORG><FID>3101</FID></FI><INTU.BID>3101</INTU.BID></SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>0</TRNUID><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS><CCSTMTRS><CURDEF>USD</CURDEF><CCACCTFROM><ACCTID>55555</ACCTID></CCACCTFROM><BANKTRANLIST><DTSTART>20190819000000.000[-7:MST]</DTSTART><DTEND>20190917000000.000[-7:MST]</DTEND><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20190903000000.000[-7:MST]</DTPOSTED><TRNAMT>-5.96</TRNAMT><FITID>320192470420083886</FITID><REFNUM>3886</REFNUM><NAME>GO</NAME></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20190828000000.000[-7:MST]</DTPOSTED><TRNAMT>-5.71</TRNAMT><FITID>320192400297241997</FITID><REFNUM>1997</REFNUM><NAME>ABE</NAME></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20190824000000.000[-7:MST]</DTPOSTED><TRNAMT>-18.75</TRNAMT><FITID>320192360229505663</FITID><REFNUM>5663</REFNUM><NAME>SP</NAME></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20190822000000.000[-7:MST]</DTPOSTED><TRNAMT>-44.09</TRNAMT><FITID>320192340194773560</FITID><REFNUM>3560</REFNUM><NAME>CAR</NAME></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20190822000000.000[-7:MST]</DTPOSTED><TRNAMT>-72.30</TRNAMT><FITID>320192350219520978</FITID><REFNUM>0978</REFNUM><NAME>KO</NAME></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20190822000000.000[-7:MST]</DTPOSTED><TRNAMT>-34.68</TRNAMT><FITID>320192350216287132</FITID><REFNUM>7132</REFNUM><NAME>SA</NAME></STMTTRN></BANKTRANLIST><LEDGERBAL><BALAMT>-2715.88</BALAMT><DTASOF>20190907000000.000[-7:MST]</DTASOF></LEDGERBAL></CCSTMTRS></CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>