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

[MichaelK]

This has still not been fixed as of Gnucash v. 3.7 and American Express
download of QFX on 11/30/2019.  However the workaround is still basically
the same as described here:
https://bugs.gnucash.org/show_bug.cgi?id=797125


>From American Express website, download your credit card Activity and choose
the Quicken option, which will generate a .qfx file.  Open that text file in
an editor (Notepad or Wordpad work fine on Windows) and remove the namespace
declaration (xmlns:ns2="http://ofx.net/types/2003/04;) as follows:

Here's the file prior to changes:



http://ofx.net/types/2003/04;>
...


And here's after:




...



Save the .qfx file and import into Gnucash as normal.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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

[aegross]

I'm not sure if I was having the same problem as you, but I documented how
 in the OFX file was an issue for me.  See my  post/thread

  

Regards, 
AEG




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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

[John Ralls]

> On Sep 14, 2019, at 9:50 PM, Jim Leek  wrote:
> 
> 
> 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.


I looked to see what was new and found 
https://github.com/libofx/libofx/commit/9c8acb69771dfe0f893bdb887027567e80e6f518
 which points to https://bugs.gnucash.org/show_bug.cgi?id=797125. Although the 
commit comment says that it won't fix the Amex imports, two users reported on 
the bug that it actually does.

Naturally it's right after the last release. We just need to get Benoit to do a 
new one.

Regards,
John Ralls
___
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

[Jim Leek]

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

[Jim Leek]

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  > 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
> ">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, 

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

[John Ralls]

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 > > 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;>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.
>>   

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

[Ronal B Morse]

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 > 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 

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

[Jim Leek]

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.

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

[Ronal B Morse]

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:

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.


___
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

[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:

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.