Re: [GNC] Gnucash doesn't load American Express QFX files
An update on this. The development branch, at least, on the libofx github https://github.com/libofx/libofx can parse the American Express OFX files. I'm not sure when that ability was added, I didn't try any releases, just the latest commit on the github. So I was able to get them working with GnuCash 3.6. I assume this version of libofx will make it into the repositories eventually, but for now users will have to build their own libofx I guess. Jim ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Gnucash doesn't load American Express QFX files
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 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 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 <mailto:r...@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: > >>> > >>> >>VERSION="202" > >>> SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?> >>xmlns:ns2=" > >>> > >>http://ofx.net/types/2003/04
Re: [GNC] Gnucash doesn't load American Express QFX files
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 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: > > > > > SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?>http://ofx.net/types/2003/04 > ">0INFOLogin > > > Successful!2019090700.000[-7:MST]ENGAMEX3101310100INFOUSD52019081900.000[-7:MST]2019091700.000[-7:MST]DEBIT2019090300.000[-7:MST]-5.963201924704200838863886GODEBIT2019082800.000[-7:MST]-5.713201924002972419971997ABEDEBIT2019082400.000[-7:MST]-18.753201923602295056635663 > > > E>SPDEBIT2019082200.000[-7:MST]-44.093201923401947735603560CARDEBIT2019082200.000[-7:MST]-72.303201923502195209780978KODEBIT2019082200.000[-7:MST]-34.683201923502162871327132SA-2715.882019090700.000[-7:MST] > > ___ > > gnucash-user mailing list > > gnucash-user@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@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@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.
[GNC] Gnucash doesn't load American Express QFX files
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: http://ofx.net/types/2003/04;>0INFOLogin Successful!2019090700.000[-7:MST]ENGAMEX3101310100INFOUSD52019081900.000[-7:MST]2019091700.000[-7:MST]DEBIT2019090300.000[-7:MST]-5.963201924704200838863886GODEBIT2019082800.000[-7:MST]-5.713201924002972419971997ABEDEBIT2019082400.000[-7:MST]-18.753201923602295056635663SPDEBIT2019082200.000[-7:MST]-44.093201923401947735603560CARDEBIT2019082200.000[-7:MST]-72.303201923502195209780978KODEBIT2019082200.000[-7:MST]-34.683201923502162871327132SA-2715.882019090700.000[-7:MST] ___ gnucash-user mailing list gnucash-user@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.