locked
Problems with MS Money 2005 UK RRS feed

  • Question

  • I have an oldish version of MS Money UK - "help about" describes it as version 12. It reisntalled fine when I got  my last laptop 2 years ago, running Vista. I have regularly downloaded bank statements from NatWest (OFX straight into Money import) and Nationwide (originally OFX then when they stopped providing OFX, used CSV and a converter). All worked fine until now.

    Problems are these:

    NatWest still appears to download and import but when Money is closed and reopened, the downloaded transactions have disappeared.

    Nationwide now offers OFX again - but whether I download that or download CSV and convert, Money says "The file appears to be invalid or contain corrupt data"

    I should be very grateful for advice on what to do next

    Many thanks

    Michael

    Monday, April 9, 2012 10:35 AM

All replies

  • I would check the OFX file with OFXAnalyzer.exe. That is part of this download: http://www.microsoft.com/download/en/details.aspx?id=21883

    The indications are not generally simple. It would be mainly to see if the problem was within the OFX file. It could be something simple.

    It is possible that if you identify the problem, somebody could put together a scrubber routine to make the file right.

    Just to make sure, be sure Help->About shows version  14.0.120.1105

    I presume this is web download.

    Monday, April 9, 2012 2:17 PM
    Moderator
  • Thank you

    I downloaded and ran ofxanalyzer.exe on the Nationwide OFX and got the error message pasted below. But presumably if Money is losing the NatWest download after apparently successfully importing it, something must be wrong with my version of Money ? How would I check for that and what can I do if so (without losing years of data) ?

    Here is ofxanalyzer error message:

    *** All line number references do not include header lines ***
    ***OFX 1.02 Add ~10
    ***OFX 2.0 Add ~2
    Running Data Through Parser
    ERROR -- File not found, File empty, Out of Memory, or Unknown Parse Failure


    Michael

    Monday, April 9, 2012 2:43 PM
  • How large is the file (at least make sure it is not less than 1000 bytes)?

    I suggest you look a the file with Notepad. The file should start with either of these lines:

    "OFXHEADER:100" or "<?xml version="1.0" encoding="US-ASCII"?>". There should not be a blank line or anything else before those. I think those should be on that first line by themselves.

    The first corresponds to what can be termed OFX 1, and the second would be OFX 2. (Each of those have sub-versions... 1.x or 2.x).  The encoding value could be something else.

    You could copy and paste everything up to <USERID> (but not including the value after that) without giving up anything personal. Maybe there will be a flaw before that point. That seems like it might be where the problem lays, due to the nature of your error message.



    Monday, April 9, 2012 3:03 PM
    Moderator
  • It starts like this:

    OFXHEADER:100
    DATA:OFXSGML
    VERSION:102
    SECURITY:NONE
    ENCODING:USASCII
    CHARSET:1252
    COMPRESSION:NONE
    OLDFILEUID:NONE
    NEWFILEUID:NONE

    <OFX>
        <SIGNONMSGSRSV1>
            <SONRS>
                <STATUS>
                    <CODE>0
                    <SEVERITY>INFO
                </STATUS>
                <DTSERVER>20120499991143[-5:EST]
                <LANGUAGE>ENG
            </SONRS>
        </SIGNONMSGSRSV1>
        <BANKMSGSRSV1>

            <STMTTRNRS>
                <TRNUID>1
                <STATUS>
                    <CODE>0
                    <SEVERITY>INFO
                </STATUS>
            <STMTRS>
                <CURDEF>GBP
                <BANKACCTFROM>
                    <BANKID>12345
                    <ACCTID>
                    <ACCTTYPE>CREDITLINE
                </BANKACCTFROM>
                <BANKTRANLIST>
                    <DTSTART>012""0000000[-5:EST]
                    <DTEND>me:""A000000[-5:EST]

                    <STMTTRN>
                        <TRNTYPE>OTHER
                        <DTPOSTED>me:""A000000[-5:EST]
                        <TRNAMT>-FlexAccount ****49991
                        <FITID>+me:""A000000
                        <NAME>"FlexAccount ****49991"
                        <MEMO>"Account Name:"
                    </STMTTRN>

                    <STMTTRN>
                        <TRNTYPE>OTHER
                        <DTPOSTED>ce:""A000000[-5:EST]
                        <TRNAMT>-£rr.66
                        <FITID>+ce:""A000000
                        <NAME>"£xx.66"
                        <MEMO>"Account Balance:"
                    </STMTTRN>

                    <STMTTRN>
                        <TRNTYPE>OTHER
                        <DTPOSTED>e: ""A000000[-5:EST]
                        <TRNAMT>-£yy.05
                        <FITID>+e: ""A000000
                        <NAME>"£zz.05"
                        <MEMO>"Available Balance: "
                    </STMTTRN>

                    <STMTTRN>
                        <TRNTYPE>OTHER
                        <DTPOSTED>ate""D000000[-5:EST]
                        <TRNAMT>-Paid out""Paid in""Balance
                        <FITID>+ate""D000000
                        <NAME>"Transaction type"
                        <MEMO>"Description"
                    </STMTTRN>

                    <STMTTRN>
                        <TRNTYPE>OTHER
                        <DTPOSTED>012""0000000[-5:EST]
                        <TRNAMT>-£100.00""""£pp.qq
                        <FITID>+012""0000000
                        <NAME>"Cheque"
                        <MEMO>"901859"
                    </STMTTRN>

    Then there are some more transaction entries similar to that last one

    Then it ends

                    </BANKTRANLIST>
                    <LEDGERBAL>
                        <BALAMT>0.00
                        <DTASOF>20120499991143[-5:EST]
                    </LEDGERBAL>
                </STMTRS>
            </STMTTRNRS>
        </BANKMSGSRSV1>
    </OFX>


    Michael

    Monday, April 9, 2012 3:36 PM
  • Note that the items that start with <DT are dates, and did not need to be munged.

    After working with your file, I suspect that you may not have browsed completely to your *.ofx file within OFXAnalyzer.exe. Check that by doing a copy (Ctrl+C) of the Filename, and see if you can paste that into a command window to see if you could do a DIR of that location, or paste it into Windows Explorer to see if it finds the file.

    Here is a test file I made from yours that shows no parse errors:

    ===============begin===================
    OFXHEADER:100
    DATA:OFXSGML
    VERSION:102
    SECURITY:NONE
    ENCODING:USASCII
    CHARSET:1252
    COMPRESSION:NONE
    OLDFILEUID:NONE
    NEWFILEUID:NONE
     
    <OFX>
         <SIGNONMSGSRSV1>
             <SONRS>
                 <STATUS>
                     <CODE>0
                     <SEVERITY>INFO
                 </STATUS>
                 <DTSERVER>20120499991143[-5:EST]
                 <LANGUAGE>ENG
             </SONRS>
         </SIGNONMSGSRSV1>
         <BANKMSGSRSV1>
     
            <STMTTRNRS>
                 <TRNUID>1
                 <STATUS>
                     <CODE>0
                     <SEVERITY>INFO
                 </STATUS>
             <STMTRS>
                 <CURDEF>GBP
                 <BANKACCTFROM>
                     <BANKID>12345
                     <ACCTID>987544321
                     <ACCTTYPE>CREDITLINE
                 </BANKACCTFROM>
                 <BANKTRANLIST>
                     <DTSTART>20120299991143[-5:EST]
                     <DTEND>20120499991143[-5:EST]
     
                    <STMTTRN>
                         <TRNTYPE>OTHER
                         <DTPOSTED>20120499991143[-5:EST]
                         <TRNAMT>-12.34
                         <FITID>A000000
                         <NAME>FlexAccount ****49991
                         <MEMO>Account Name:
                     </STMTTRN>
     
                    <STMTTRN>
                         <TRNTYPE>OTHER
                         <DTPOSTED>20120499991143[-5:EST]
                         <TRNAMT>-11.66
                         <FITID>A000001
                         <NAME>xx.66
                         <MEMO>Account Balance:
                     </STMTTRN>
     
                    <STMTTRN>
                         <TRNTYPE>OTHER
                         <DTPOSTED>20120499991143[-5:EST]
                         <TRNAMT>-22.05
                         <FITID>A000002
                         <NAME>zz.05
                         <MEMO>Available Balance:
                     </STMTTRN>
     
                    <STMTTRN>
                         <TRNTYPE>OTHER
                         <DTPOSTED>20120499991143[-5:EST]
                         <TRNAMT>-33.44
                         <FITID>B0033hello
                         <NAME>Transaction type
                         <MEMO>Description
                     </STMTTRN>
     
                    <STMTTRN>
                         <TRNTYPE>OTHER
                         <DTPOSTED>20120499991143[-5:EST]
                         <TRNAMT>-100.00
                         <FITID>A000003
                         <NAME>Cheque
                         <MEMO>901859
                     </STMTTRN>
     
                    </BANKTRANLIST>
                     <LEDGERBAL>
                         <BALAMT>0.00
                         <DTASOF>20120499991143[-5:EST]
                     </LEDGERBAL>
                 </STMTRS>
             </STMTTRNRS>
         </BANKMSGSRSV1>
     </OFX>
    ==============end========================

    Monday, April 9, 2012 4:47 PM
    Moderator