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

<?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">
    ...
</OFX>

And here's after:

<?xml version="1.0" standalone="no"?>
<?OFX OFXHEADER="200" VERSION="202" SECURITY="NONE" OLDFILEUID="NONE"
NEWFILEUID="NONE"?>
<OFX>
    ...
</OFX>


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





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html