none
Suddenly have problems opening .qfx downloaded file from American Express in MS Money RRS feed

  • Question

  • Suddenly this month I am unable to open downloaded .qfx files from American Express in Money. I have as recently as November 2019, downloaded the file to my computer then imported the file into money. This month I get the error message: "file attempting to import appears to be invalid or contain corrupt data". The American Express site had a message stating that "because of a recent change you may have update your connection between Amex and Quicken." I don't have quicken so there's no one for me to contact. I contacted American Express and they were not of much help, and told me to contact Microsoft. I have a feeling they did something on their end that in someway altered something in the way file downloads. Does anyone else have this problem and know how to solve it? (I'm using MS MoneyPlus Deluxe Version 17.0.120.3817 on a Windows 10 computer.)

    Thanks for your help.

    Monday, December 30, 2019 7:14 AM

All replies

  • You could try this Python script:

    ############begin AMEX_FX3.PY########
    #modifies AMEX OFX file with extra crud in the <OFX>
    #invoke with filename of the source as the parameter.

    #Example: AMEX_FX3.PY ax_abc.qfx
    #2019-7-30 Cal Learner...
    #2019-12-8 modified to run on Python 2 or 3.

    import sys, re

    ofxfile1= open(sys.argv[1],'r') # open for read in current directory
        # Input file read in as parameter. Output file fixed in this case.
    ofxfile2= open("ModOut.ofx",'w') # open for write in current directory

    #do stuff


    ofx=ofxfile1.read()

    ofx_parts=re.split(r"\s*<OFX[^>]*>",ofx) #splits the file into 2 pieces in list
    ofx_body= re.sub(r"(?<!\s)<", r"\n<",ofx_parts[1]) #add the newlines to body

    ofx_mod=ofx_parts[0]+"\n<OFX>" + ofx_body #assembling the new header and the body


    ofxfile2.write(ofx_mod)

    ofxfile1.close()
    ofxfile2.close()
    print("Modified version of ", sys.argv[1],' written to "ModOut.ofx" file.')

    ############end AMEX_FX3.PY########

    I forget the flaw this fixes, but it might be that instead of <ofx>, the file contains <ofx somethingOrAnother>.  So if that is the case, you could just modify the QFX file with a text editor, such as Notepad.

    Monday, December 30, 2019 6:50 PM
    Moderator
  • This issue with Amex qif files was reported back on December 11th.  Here is a link:

    https://social.microsoft.com/Forums/en-US/d978e734-bfaa-4b93-9abd-7122b593c901/unable-to-import-qfx-files-from-amex?forum=money

    However, for some reason, copied links from this forum aren't working for me right now, soif you have the same problem with links, here is my response from that thread:

    I had this issue with AMEX downloads for several months and Cal's Python program fixed those files.  Since November 20th, the downloads have imported correctly for me, but, from your experience, there are still issues.  If you are willing to manually edit the downloaded file using Notepad, I found that this single replacement worked:

    Find <OFX xmlns:ns2="http://ofx.net/types/2003/04"> and replace it with <OFX>

    Cal's responses in that thread have more detail if you want to automate the fix using the above Python script.


    Bill Becker




    • Edited by Bill Becker Tuesday, December 31, 2019 4:36 PM
    Monday, December 30, 2019 9:19 PM
  • Just downloaded transactions for my Amex Blue Cash Preferred credit card and I find that Amex is once again downloading activity.qfx files that won't import into Money.  The fix that still works is:

      - open the activity.qfx file with Notepad

      - search for <OFX xmlns:ns2="http://ofx.net/types/2003/04"> It's pretty early in the file.

      - replace it with <OFX>, i.e. delete  xmlns:ns2="http://ofx.net/types/2003/04"

    Save the file and then double-click it to open it in Money.


    Bill Becker

    Wednesday, January 1, 2020 3:28 AM
  • I don't know how you do it, but I use the manual download of the .qfx file and change the extension to .ofx.

    American Express changed the URL for the download, and along with that a file format that doesn't work (I see that others have found the line to edit).  I have the old one that still sends a .qfx that requires no editing.

    Instructions:

    1. Paste this into the address field https://online.americanexpress.com/myca/ofxdl/us/domesticOptions.do?request_type=authreg_ofxdownload&Face=en_US&intlink=des_downloadcardact

    2.  Login.

    3.  It takes you right there to the old download screen.

    4.  Make it a favorite for easier access.

    If you're someone that logins and checks for new activity before initiating the download, you can do this (after making the above URL a favorite):

    1.  Login to americanexpress.com

    2.  See that you have new activity.

    3.  Go to favorites, and launch the URL

    4.  It keeps you logged in, and takes you to the old familiar download screen that gives a .qfx file that doesn't require editing.

    Sunday, January 26, 2020 4:55 PM
  • Wow, Thanks!  I just tried this and it works.  Money reads the download with no problems. 

    Let's hope that Amex doesn't find out and mess it up!


    Bill Becker

    Sunday, January 26, 2020 10:53 PM
  • Hi, I wonder if any of you can help me? American Express have just updated their web site here for me in the UK and the option to download transaction data to Money has disapeared. I knew it would at some point, so was expecting this some day. I use this functionality every month, like a lot of you I guess, to download my transactions into Money. (I'm using 2001 Financial Suite on a Window 10 PC and have done so happily since, well, 2001 :-)).

    I tried some of the things listed above to see if I could download in Quicken format but I couldn't get it to work.

    First I tried the simple approach of just changing the files extension to .ofx and double clicking the downloaded file, but that didn't work.

    I then downloaded the file again, opened it in Notepad, did the edit decribed above, saved the file and then changed the extension to .ofx and again it did not work. The error message said the file was invalid or contained corrupt data.

    I really don't know what a Python Script is and that all sounds a bit complicated to me, so don't really want to start doing anything like that. I'd be quite happy with a manual process to download a file, make some changes and manually import it.

    Do any of you have any suggestions as to what I could do here?

    Thanks

    Paul

    Wednesday, September 16, 2020 6:00 PM
  • Hi, I wonder if any of you can help me? American Express have just updated their web site here for me in the UK and the option to download transaction data to Money has disapeared. I knew it would at some point, so was expecting this some day. I use this functionality every month, like a lot of you I guess, to download my transactions into Money. (I'm using 2001 Financial Suite on a Window 10 PC and have done so happily since, well, 2001 :-)).

    I tried some of the things listed above to see if I could download in Quicken format but I couldn't get it to work.

    First I tried the simple approach of just changing the files extension to .ofx and double clicking the downloaded file, but that didn't work.

    I then downloaded the file again, opened it in Notepad, did the edit decribed above, saved the file and then changed the extension to .ofx and again it did not work. The error message said the file was invalid or contained corrupt data.

    I really don't know what a Python Script is and that all sounds a bit complicated to me, so don't really want to start doing anything like that. I'd be quite happy with a manual process to download a file, make some changes and manually import it.

    Do any of you have any suggestions as to what I could do here?

    Thanks

    Paul

    1. You could download and use the OFX Analyzer.  https://microsoftmoneyoffline.wordpress.com/ofx-file-analzer/

    The error messages are a bit arcane, but might make sense to you, or you could post the results.

    2. You could modify the file in Notepad to replace your <ACCTID> (which will be your card number) with 1234567890123456 or whatever. Inspect the file to see that nothing personal remains. Then copy the content, and paste into a post here. We can inspect or run the OFX Analyzer on it.


    Wednesday, September 16, 2020 9:48 PM
    Moderator
  • Hi Cal, I very much appreciate your offer to help. I thought going down the OFX Analyzer route would be a bit complex for me, so I've edited the file in Notepad and think (...and hope!) I've edited any personal information. This is the content of the file now:

    <?xml version="1.0" standalone="no"?><?OFX OFXHEADER="200" VERSION="202" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?><OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY><MESSAGE>Login Successful!</MESSAGE></STATUS><DTSERVER>20200916000000.000[-7:MST]</DTSERVER><LANGUAGE>ENG</LANGUAGE><FI><ORG>AMEX</ORG><FID>7477</FID></FI><INTU.BID>7477</INTU.BID></SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>0</TRNUID><STATUS><CODE>0</CODE><SEVERITY>INFO</SEVERITY></STATUS><CCSTMTRS><CURDEF>GBP</CURDEF><CCACCTFROM><ACCTID>U6QTNINNZEDPHXN|12345</ACCTID></CCACCTFROM><BANKTRANLIST><DTSTART>20200820000000.000[-7:MST]</DTSTART><DTEND>20200919000000.000[-7:MST]</DTEND><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200913000000.000[-7:MST]</DTPOSTED><TRNAMT>-4.11</TRNAMT><FITID>AT202580068000010029972</FITID><REFNUM>AT202580068000010029972</REFNUM><NAME>AMZNMKTPLACE AMAZONCOUK</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200913000000.000[-7:MST]</DTPOSTED><TRNAMT>-1.15</TRNAMT><FITID>AT202580029000010120914</FITID><REFNUM>AT202580029000010120914</REFNUM><NAME>COOP PETROL BROMPTON R NORTHALLE</NAME><MEMO>MR C P ABCD-12345-THE COOPERATIVE</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200913000000.000[-7:MST]</DTPOSTED><TRNAMT>-81.07</TRNAMT><FITID>AT202580029000010139321</FITID><REFNUM>AT202580029000010139321</REFNUM><NAME>MAJESTIC WINE WAREHOUSE NORTHALL</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200913000000.000[-7:MST]</DTPOSTED><TRNAMT>-5.98</TRNAMT><FITID>AT202570064000010022049</FITID><REFNUM>AT202570064000010022049</REFNUM><NAME>PAYPAL GLENFIELDIN EBA 402935773</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200912000000.000[-7:MST]</DTPOSTED><TRNAMT>-46.75</TRNAMT><FITID>AT202570025000010133762</FITID><REFNUM>AT202570025000010133762</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200910000000.000[-7:MST]</DTPOSTED><TRNAMT>-4.50</TRNAMT><FITID>AT202550028000010134693</FITID><REFNUM>AT202550028000010134693</REFNUM><NAME>TT CAF MILTON KEYNES</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200910000000.000[-7:MST]</DTPOSTED><TRNAMT>-4.00</TRNAMT><FITID>AT202550028000010134694</FITID><REFNUM>AT202550028000010134694</REFNUM><NAME>TT CAF MILTON KEYNES</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200910000000.000[-7:MST]</DTPOSTED><TRNAMT>-1.00</TRNAMT><FITID>AT202550028000010134695</FITID><REFNUM>AT202550028000010134695</REFNUM><NAME>TT CAF MILTON KEYNES</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200910000000.000[-7:MST]</DTPOSTED><TRNAMT>-14.70</TRNAMT><FITID>AT202540028000010114729</FITID><REFNUM>AT202540028000010114729</REFNUM><NAME>TRAINLINECOM LONDON</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200910000000.000[-7:MST]</DTPOSTED><TRNAMT>-22.88</TRNAMT><FITID>AT202550028000010137258</FITID><REFNUM>AT202550028000010137258</REFNUM><NAME>ZIZZI 794 MK HUB MILTON KEYNES</NAME><MEMO>MR C P ABCD-12345-Zizzi - 794 - Milton Keynes -</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200909000000.000[-7:MST]</DTPOSTED><TRNAMT>-1.85</TRNAMT><FITID>AT202540028000010110568</FITID><REFNUM>AT202540028000010110568</REFNUM><NAME>MARKS SPENCER PLC LONDON</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200909000000.000[-7:MST]</DTPOSTED><TRNAMT>-4.95</TRNAMT><FITID>AT202540028000010109131</FITID><REFNUM>AT202540028000010109131</REFNUM><NAME>OLD BARN MILTON KEYNES</NAME><MEMO>MR C P ABCD-12345-HOSPITALITY-GOODS-SERVICES</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200909000000.000[-7:MST]</DTPOSTED><TRNAMT>-8.40</TRNAMT><FITID>AT202540028000010135714</FITID><REFNUM>AT202540028000010135714</REFNUM><NAME>TT CAF MILTON KEYNES</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200909000000.000[-7:MST]</DTPOSTED><TRNAMT>-14.70</TRNAMT><FITID>AT202530028000010101899</FITID><REFNUM>AT202530028000010101899</REFNUM><NAME>TRAINLINECOM LONDON</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200909000000.000[-7:MST]</DTPOSTED><TRNAMT>-6.00</TRNAMT><FITID>AT202540028000010122390</FITID><REFNUM>AT202540028000010122390</REFNUM><NAME>UBER TRIP SAN FRANCISCO</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200909000000.000[-7:MST]</DTPOSTED><TRNAMT>-5.00</TRNAMT><FITID>AT202540028000010122397</FITID><REFNUM>AT202540028000010122397</REFNUM><NAME>UBER TRIP SAN FRANCISCO</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200908000000.000[-7:MST]</DTPOSTED><TRNAMT>-3.49</TRNAMT><FITID>AT202530028000010118664</FITID><REFNUM>AT202530028000010118664</REFNUM><NAME>HPI INSTANT INK UK HPI BERKSHIRE</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200907000000.000[-7:MST]</DTPOSTED><TRNAMT>-28.99</TRNAMT><FITID>AT202520038000010120780</FITID><REFNUM>AT202520038000010120780</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200905000000.000[-7:MST]</DTPOSTED><TRNAMT>-1.70</TRNAMT><FITID>AT202500020000010165318</FITID><REFNUM>AT202500020000010165318</REFNUM><NAME>COOP PETROL BROMPTON R NORTHALLE</NAME><MEMO>MR C P ABCD-12345-THE COOPERATIVE</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200905000000.000[-7:MST]</DTPOSTED><TRNAMT>-6.85</TRNAMT><FITID>AT202500020000010167070</FITID><REFNUM>AT202500020000010167070</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200905000000.000[-7:MST]</DTPOSTED><TRNAMT>-31.99</TRNAMT><FITID>AT202500020000010160530</FITID><REFNUM>AT202500020000010160530</REFNUM><NAME>SUMUPPETEXTRA NORTHALLERTON</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200904000000.000[-7:MST]</DTPOSTED><TRNAMT>-84.08</TRNAMT><FITID>AT202490038000010107480</FITID><REFNUM>AT202490038000010107480</REFNUM><NAME>MAJESTIC WINE WAREHOUSE NORTHALL</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200904000000.000[-7:MST]</DTPOSTED><TRNAMT>-11.30</TRNAMT><FITID>AT202490038000010104853</FITID><REFNUM>AT202490038000010104853</REFNUM><NAME>MARKS SPENCER NORTH NORTH YORKSH</NAME><MEMO>MR C P ABCD-12345-RETAIL GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200903000000.000[-7:MST]</DTPOSTED><TRNAMT>-2.20</TRNAMT><FITID>AT202480028000010115696</FITID><REFNUM>AT202480028000010115696</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200902000000.000[-7:MST]</DTPOSTED><TRNAMT>-4.50</TRNAMT><FITID>AT202470029000010136285</FITID><REFNUM>AT202470029000010136285</REFNUM><NAME>COOP PETROL BROMPTON R NORTHALLE</NAME><MEMO>MR C P ABCD-12345-THE COOPERATIVE</MEMO></STMTTRN><STMTTRN><TRNTYPE>CREDIT</TRNTYPE><DTPOSTED>20200902000000.000[-7:MST]</DTPOSTED><TRNAMT>1500.28</TRNAMT><FITID>10000000010829999916610</FITID><REFNUM>10000000010829999916610</REFNUM><NAME>PAYMENT RECEIVED THANK YOU</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200902000000.000[-7:MST]</DTPOSTED><TRNAMT>-125.00</TRNAMT><FITID>AT202470029000010142282</FITID><REFNUM>AT202470029000010142282</REFNUM><NAME>SUMUPEMILY BERGAMINO ROMANBY</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200901000000.000[-7:MST]</DTPOSTED><TRNAMT>-12.34</TRNAMT><FITID>AT202460028000010130700</FITID><REFNUM>AT202460028000010130700</REFNUM><NAME>MARKS SPENCER NORTH NORTH YORKSH</NAME><MEMO>MR C P ABCD-12345-RETAIL GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200901000000.000[-7:MST]</DTPOSTED><TRNAMT>-8.99</TRNAMT><FITID>AT202450064000010035091</FITID><REFNUM>AT202450064000010035091</REFNUM><NAME>PAYPAL HANNSAVERS EBAY 402935773</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200901000000.000[-7:MST]</DTPOSTED><TRNAMT>-36.20</TRNAMT><FITID>AT202460028000010135805</FITID><REFNUM>AT202460028000010135805</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200831000000.000[-7:MST]</DTPOSTED><TRNAMT>-6.89</TRNAMT><FITID>AT202440066000010026598</FITID><REFNUM>AT202440066000010026598</REFNUM><NAME>PAYPAL PHONETICTAC EBA 402935773</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200831000000.000[-7:MST]</DTPOSTED><TRNAMT>-80.00</TRNAMT><FITID>AT202450024000010138585</FITID><REFNUM>AT202450024000010138585</REFNUM><NAME>VIRGIN WINES VIRGIN WIN UNITED K</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200830000000.000[-7:MST]</DTPOSTED><TRNAMT>-89.95</TRNAMT><FITID>AT202450024000010136620</FITID><REFNUM>AT202450024000010136620</REFNUM><NAME>BOSE LIMITED CHATHAM</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200830000000.000[-7:MST]</DTPOSTED><TRNAMT>-49.00</TRNAMT><FITID>AT202440025000010103867</FITID><REFNUM>AT202440025000010103867</REFNUM><NAME>COOP PETROL BROMPTON R NORTHALLE</NAME><MEMO>MR C P ABCD-12345-THE COOPERATIVE</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200829000000.000[-7:MST]</DTPOSTED><TRNAMT>-1.70</TRNAMT><FITID>AT202430025000010130839</FITID><REFNUM>AT202430025000010130839</REFNUM><NAME>COOP PETROL BROMPTON R NORTHALLE</NAME><MEMO>MR C P ABCD-12345-THE COOPERATIVE</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200829000000.000[-7:MST]</DTPOSTED><TRNAMT>-7.69</TRNAMT><FITID>AT202430025000010117615</FITID><REFNUM>AT202430025000010117615</REFNUM><NAME>LEEDS MSA SKELTON LAKE LEEDS</NAME><MEMO>MR C P ABCD-12345-LMSA Burger King 14931071</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200828000000.000[-7:MST]</DTPOSTED><TRNAMT>-36.13</TRNAMT><FITID>AT202430025000010144239</FITID><REFNUM>AT202430025000010144239</REFNUM><NAME>THE ALCHEMIST LIVERPOOL</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200828000000.000[-7:MST]</DTPOSTED><TRNAMT>-8.30</TRNAMT><FITID>AT202420024000010115017</FITID><REFNUM>AT202420024000010115017</REFNUM><NAME>WAITROSE 0761 314S BRIDGHOUSE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200827000000.000[-7:MST]</DTPOSTED><TRNAMT>-5.50</TRNAMT><FITID>AT202410027000010148393</FITID><REFNUM>AT202410027000010148393</REFNUM><NAME>OYATSU LTD NORTH YORKSHIRE</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200827000000.000[-7:MST]</DTPOSTED><TRNAMT>-104.00</TRNAMT><FITID>AT202400029000010130962</FITID><REFNUM>AT202400029000010130962</REFNUM><NAME>TRAINLINECOM LONDON</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200826000000.000[-7:MST]</DTPOSTED><TRNAMT>-32.50</TRNAMT><FITID>AT202410027000010140722</FITID><REFNUM>AT202410027000010140722</REFNUM><NAME>WWWPREMIERINNCOM MKE MILTON KEYN</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200824000000.000[-7:MST]</DTPOSTED><TRNAMT>-26.01</TRNAMT><FITID>AT202380031000010132145</FITID><REFNUM>AT202380031000010132145</REFNUM><NAME>EASYJETEASYJET 987654321 LUTON</NAME><MEMO>MR C P ABCD-12345-ROUTING:    FROM:     MANCHESTER             TO:       COPENHAGEN APT    CARRIER:        U2  CLASS:          Y TICKET NUMBER:  987654321                 PASSENGER NAME: ABCDEFGHI ABCD</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200824000000.000[-7:MST]</DTPOSTED><TRNAMT>-17.18</TRNAMT><FITID>AT202380031000010132148</FITID><REFNUM>AT202380031000010132148</REFNUM><NAME>EASYJETEASYJET 987654322 LUTON</NAME><MEMO>MR C P ABCD-12345-ROUTING:    FROM:     COPENHAGEN APT             TO:       MANCHESTER        CARRIER:        U2  CLASS:          Y TICKET NUMBER:  987654322                 PASSENGER NAME: ABCDEFGHI ABCD</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200824000000.000[-7:MST]</DTPOSTED><TRNAMT>-9.15</TRNAMT><FITID>AT202380031000010126732</FITID><REFNUM>AT202380031000010126732</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200824000000.000[-7:MST]</DTPOSTED><TRNAMT>-40.50</TRNAMT><FITID>AT202390029000010117909</FITID><REFNUM>AT202390029000010117909</REFNUM><NAME>WWWPREMIERINNCOM ST ST HELENS</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200823000000.000[-7:MST]</DTPOSTED><TRNAMT>-6.85</TRNAMT><FITID>AT202370027000010109577</FITID><REFNUM>AT202370027000010109577</REFNUM><NAME>COOP PETROL DARLINGTON NORTHALLE</NAME><MEMO>MR C P ABCD-12345-THE COOPERATIVE</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200822000000.000[-7:MST]</DTPOSTED><TRNAMT>-10.50</TRNAMT><FITID>AT202350023000010103745</FITID><REFNUM>AT202350023000010103745</REFNUM><NAME>LISAS CAFE AND TAKEAWAY NORTHALL</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200822000000.000[-7:MST]</DTPOSTED><TRNAMT>-91.53</TRNAMT><FITID>AT202360022000010167343</FITID><REFNUM>AT202360022000010167343</REFNUM><NAME>MAJESTIC WINE WAREHOUSE NORTHALL</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200822000000.000[-7:MST]</DTPOSTED><TRNAMT>-10.00</TRNAMT><FITID>AT202360022000010151091</FITID><REFNUM>AT202360022000010151091</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200822000000.000[-7:MST]</DTPOSTED><TRNAMT>-11.60</TRNAMT><FITID>AT202360022000010151092</FITID><REFNUM>AT202360022000010151092</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200821000000.000[-7:MST]</DTPOSTED><TRNAMT>-43.96</TRNAMT><FITID>AT202360022000010143207</FITID><REFNUM>AT202360022000010143207</REFNUM><NAME>DOMINOS PIZZA GROUP MILTON KEYNE</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200821000000.000[-7:MST]</DTPOSTED><TRNAMT>-7.20</TRNAMT><FITID>AT202350023000010112172</FITID><REFNUM>AT202350023000010112172</REFNUM><NAME>SAINSBURYS SUPERMARKET NORTHALLE</NAME><MEMO>MR C P ABCD-12345-GOODS</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200819000000.000[-7:MST]</DTPOSTED><TRNAMT>-7.52</TRNAMT><FITID>AT202330030000010130842</FITID><REFNUM>AT202330030000010130842</REFNUM><NAME>EXELBY SERVICES A19 SOU NORTHALL</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN><STMTTRN><TRNTYPE>DEBIT</TRNTYPE><DTPOSTED>20200819000000.000[-7:MST]</DTPOSTED><TRNAMT>-344.24</TRNAMT><FITID>AT202330030000010136884</FITID><REFNUM>AT202330030000010136884</REFNUM><NAME>MB TEESSIDE STOCKTON ON TEE</NAME><MEMO>MR C P ABCD-12345</MEMO></STMTTRN></BANKTRANLIST><LEDGERBAL><BALAMT>-1632.57</BALAMT><DTASOF>20200916000000.000[-7:MST]</DTASOF></LEDGERBAL></CCSTMTRS></CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>

    I hope that all helps and you can give me your thoughts.

    Paul

    Friday, September 18, 2020 11:47 AM
  • I copied and pasted your text into a file called ModOut.ofx. I then ran that through AMEX_FX3.PY described above, and produced ModOut.ofx

    I was surprised that OFX Analyzer did not have a problem with it, nor did it have a problem with ModOut.ofx

    I then, in a test file, created a credit card account in Money Plus Sunset that used British Pounds as currency, and imported ModOut.ofx. It imported giving me 54 transactions to read.

    I think it unlikely that the difference was you using Money 2005. What I expect the difference is that the first character that I copied (to paste) was < and the last was >. I wondered if maybe you had a blank line in you file at the beginning? I tried that, but that imported too.  A blank line at the end would have been ignored.

    I uploaded a zip file for you: http://s000.tinyupload.com/?file_id=10084795986570092600

    That zip file  will disappear in about a month. test2020.zip contains

    test.ofx what I copied from your post

     test2.ofx same with a blank line first

    AMEX_FX3.PY the file discussed above

    ModOut.ofx the output of AMEX_FX3.PY

     

    Friday, September 18, 2020 1:24 PM
    Moderator
  • Hi Cal and thanks very much for the work you have put in to try and help me here. I really do appreciate it! However, when I click on all the files you kindly created for me I still get an error message saying "The file you attempted to import appears to be invalid or contains corrupt data. Please download the file again. etc."

    I notice you mentioned Money 2005, but the version of Money I'm using is "Microsoft Money 2001 Financial Suite Version 9.0".

    Might this be the reason the files won't import correctly?

    I'd be grateful for any other thoughts and help you could give me with this.

    Thanks

    Paul

    Sunday, September 20, 2020 5:19 PM
  • Sorry. The Amex OFX file is OFX version 2.x

    I think Money 2003 was the first to be able to handle OFX 2.

    Money 2005 UK will handle OFX2. The syntax and look will change from what you are used to, but it will convert your 2001 file.

    It is possible to install Money 2005 and leave Money 2001 installed, but it is tricky. It takes vigilance to not uninstall Money 2001. Also, file associations, such as OFX will go with the last installed.

    If processing these Amex OFX files is important, you should upgrade.

    Monday, September 21, 2020 7:51 PM
    Moderator
  • Also, if you have both installed, any file touched by 2005 will not be able to be opened in 2001. 

    Bob - MSN Mobile

    Monday, September 21, 2020 10:48 PM
  • Thanks Bob and Cal, that clarifies things for me, so thanks for your comments.

    I really don't want to be running two versions. I'm sure I can find this out by looking around, but to save me a bit of time doing so, where can I get hold of Money 2005 UK? I'm sure one of you will have a link that might save me time hunting.

    Cheers

    Paul

    Tuesday, September 22, 2020 10:10 AM
  • See the third ("sticky") post for the link.  In case these posts disappear tomorrow, the first post in my blog also contains the download links: https://microsoftmoneyoffline.wordpress.com/ 
    Tuesday, September 22, 2020 12:53 PM