OK, with comments from John Ralls and RBM, I think I see what's going on. American Express is updating their website. As part of that, they've upgraded to OFX version 2.0.2, which libofx does not support. Currently I can still click a button "Return to Previous Version", from which I can download my activity in OFX 1.0.2. So, that works for now.
AMEX let me take a survey, so I complained about it. But I imagine we need to update libofx, or get a new one that handles XML, or something. Jim On Sat, Sep 7, 2019 at 5:01 PM John Ralls <[email protected]> wrote: > IIRC libofx doesn't support OFX2000+, which is XML instead of SGML. > > Regards, > John Ralls > > > > On Sep 7, 2019, at 4:39 PM, Ronal B Morse <[email protected]> wrote: > > > > Maybe what I do is a little different. > > > > After logging in to Amex and navigating to the Statements and Activity > Page, I click on the green download icon from the pages toolbar and select > card activity from that drop down. > > > > A new paged opens automatically and on that page I select "Quicken" from > the options in the left pane then scroll down the page to find the date > range selection section in the right pane. Today I clicked on the > "Individual statements available to download" radio button then selected > checked "Aug 15 to Present" since I downloaded about a week ago. > > > > Clicking on the blue "download" button results in a file named ofx.qfx > in my downloads folder and that is the file I inport into Gnucash. > > > > Hope this helps > > > > RBM > > > > On 9/7/19 4:43 PM, Jim Leek wrote: > >> I just tried to download from AmericanExpress again. I still have the > same problem. I'm just clicking the little download icon next to my > activity on the "Statements and Activity" page. Maybe there's another > method? > >> > >> With GnuCash 3.6 I was able to import from CSV. That's a hassle, but > the import page is much better than was on Gnucash 2.6, so kudos to whoever > made that. > >> > >> Jim > >> > >> On Sat, Sep 7, 2019 at 3:26 PM Ronal B Morse <[email protected] > <mailto:[email protected]>> wrote: > >> > >> 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><N AM > >> > > >> > > 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 > >> > [email protected] <mailto:[email protected]> > >> > 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. > >> > >> _______________________________________________ > >> gnucash-user mailing list > >> [email protected] <mailto:[email protected]> > >> 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. > >> > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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. > > _______________________________________________ gnucash-user mailing list [email protected] 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.
