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

Ronal B Morse ron at morsehouse.com
Sat Sep 7 18:23:01 EDT 2019


FWIW, I just downloaded my AMEX card activity with no problems or 
unusual results, beyond that it always takes me awhile to find the 
correct download portal.  Maybe just a transient problem on the server end?

RBM

On 9/7/19 2:46 PM, Jim Leek wrote:
> 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><NAM
>   E>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>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list