Nationwide to remove support for Microsoft money

techno79

rpb424 wrote: »

I don't think it actually matters. You can put anything you like as long as it is not blank. The advantage of putting your number and then exactly the same within the account settings of Money itself is that Money should then import the data without asking you which account is applies too, which it would otherwise not necessarily know.

I have three accounts. Flexaccount and e-savings are both 8 digit numbers. ISA is 4 digits, then a slash, then 9 digits. The first 4 digits are the branch code of where the account was originally opened.

Thank you, that's absolutely magic. I set all the numbers in Money to just the 8 digit account number and same in the script as well. All sorted now.

I really appreciate your efforts in updating the script and the help in getting it working. Finally I can get back into a routine for my finances.

Big boo to Nationwide for causing so much hassle to their customers!

Marc_C

Marc_C wrote: »

Yes, definitely in the correct folder. However..........if I click cancel I return to scripts which is now greyed out!

I think I will uninstall MT2OFX and try again.

Started again. The modified script is definitely in the correct folder. I have not changed the name of the file - I just replaced the 8 xs with my account number.

The old file is noted as a .vbs file and the new file is noted as a text document file.

When I open MT2OFX and select options, script then new, the file type which MT2OFX is looking to add is a .vbs file type and only this type. It does not see the new (text document) file. I suspect that this is the reason why I cannot locate the file.

I acknowledge that no-one else is having this problem - perhaps it is a W7 issue?

rpb424

Rename your modified script and remove the .txt extension and make sure it ends .vbs, and all should work.

Marc_C

rpb424 wrote: »

Rename your modified script and remove the .txt extension and make sure it ends .vbs, and all should work.

The file which I downloaded ended in .vbs but W7 said it was a text document. I renamed the file, added a new .vbs ending but W7 still said it was a text document. Consequently, MT2OFX could not find it.

Thanks for trying to sort out my problem.

It would be interesting to hear from any other W7 users to see if they were also encountering the problem.

Marc_C

You have to laugh!

I (and many others no doubt) complained to Nationwide about the csv and ofx files not working properly.

On checking my Flex account this morning, the ofx option had been removed and MT2OFX would still not open the csv file.

My Credit Card account still had both options - MT2OFX would not open the csv file but I used it to convert the ofx file to ofx. This converted filed was imported by MS Money!

The only problem was that the debits were on the credit side and vv but MS Money does allow you to change a credit to a charge and vv. At least my cc data in now correct in MS Money.

rpb424

Marc_C wrote: »

You have to laugh!

I (and many others no doubt) complained to Nationwide about the csv and ofx files not working properly.

On checking my Flex account this morning, the ofx option had been removed and MT2OFX would still not open the csv file.

My Credit Card account still had both options - MT2OFX would not open the csv file but I used it to convert the ofx file to ofx. This converted filed was imported by MS Money!

The only problem was that the debits were on the credit side and vv but MS Money does allow you to change a credit to a charge and vv. At least my cc data in now correct in MS Money.

There are two types of Flexaccount statement that the website can show you - a mini one and a full one. The irony is that the mini one actually shows you more transactions including very recent ones that haven't necessarily cleared, however the descriptions are not as helpful. There is a link near the bottom of the statement page to switch between them. OFX download only seems to be available on the full statement, but csv is available on both. I was puzzled where OFX had gone for a while until I discovered this. Unfortunately when you click on Flexaccount is always defaults to showing you a mini statement first, and there appears to be no option to change this.

Regarding your credit credit reversal problem. Having downloaded and swapped the entries over I would try downloading them again. I think you'll find that the same entries get downloaded (wrongly) again because Money thinks it hasn't seen them before. If so then you'll need instead to get to the cause of why mt2ofx isn't accepting the csv. The advantage of csv is that you have almost complete control of what mt2ofx can do to it once you figure out how the scripts work.

joeatiyah

Thanks for the new scripts, I now have them working fine.

Flex account initially asked for the account number, but I found that I had used the longer version in Money, edited that to the 8 digit version, and no longer asks for a/c.

Credit card still asks for account on import, but it always did for me (I think Colin gave advice as to how to avoid that, but I never bothered - its no big deal).

Marc_C

Hi rpb,

Yes you are quite correct. Importing my cc data again results in the same transactions appearing on the "wrong" side which means that I have to this time delete the duplicates.

I don't know why I cannot get mt20fx to recognise the modified file. If I had access to my laptop with WXP on it perhaps I would have some success (away from home at the moment).

Nationwide has until the end of the year to sort out this problem or else I move all my dealings from Nationwide to Barclays where the data downloaded always imports.

PhilG

Thanks for the updated script suggestion. I couldn't get it to run in Money 2005 UK and as we have multiple Nationwide Accounts, I've gone for a slight variation which uses VBScript's Case-Select function.

If you want to use this piece of code you can cut and past into the script at line 253.

'**********SCRIPT BEGINS************
LoadTextFile = False

sLine = ReadLine()
sName = Trim(Mid(sLine, 18))
sName = Left(sName,Len(sName)-1)
'this removes the trailing quote mark

Select Case sName
Case "AAAA"
sAcct = "aaaaaa-bbbbbbbb"
Case "BBBB"
sAcct = "nnnn/mmmmmmmmm"
Case Else
sAcct = "Account name or number error"
End Select
'**********SCRIPT ENDS**************

For each account you want to download, convert and import you need a Case & sAcct pair.
The Case must be exactly the same as the name you have given your account at Nationwide on-line e.g. "SoleFlex ****3562"
The sAcct must be exactly the same as the account number you enter in account details in Money (I use sort code-account number e.g. "070116-67143562")
You must enter the text AND the quotemarks
Example:
Case "SoleFlex ****3562"
sAcct = "070116-67143562"
Case "JointSavings ****7312"
sAcct = "0572/524523562"
Case Else
sAcct = "not found here"
End Select

When you've finished editing the file, the next line after the end Select should be: sLine = ReadLine()

Hope this helps!

spurtime

rpb424 wrote: »

Hi Spurtime,

I've made a slight change to that script, so could you re-download it and try it again? Strangely the error you quoted looks like it relates to an area that I didn't change, but try it anyway.

Thank you, thank you, thank you. You are a genius my friend.