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

Sun Sep 8 01:05:52 EDT 2019

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 <jralls at ceridwen.us> 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 <ron at morsehouse.com> 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 <ron at morsehouse.com
> <mailto:ron at morsehouse.com>> 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><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 <mailto: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.
> >>
> >>    _______________________________________________
> >>    gnucash-user mailing list
> >>    gnucash-user at gnucash.org <mailto: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.
> >>
> > _______________________________________________
> > 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.
>
>