Extra caution is recommended when installing recently uploaded/updated scripts (read more)
Be sure you trust any scripts you install
Co-op/Smile to OFX
UNOFFICIAL script to convert Co-operative Bank and Smile.co.uk bank statements and Co-operative Bank credit card statements into CSV and OFX files
Unofficial greasemonkey (http://greasemonkey.mozdev.org/) script to convert online statements to CSV and OFX formats from www.co-operativebank.co.uk and smile.co.uk.
Many thanks to Michael Vandercamp on who's script (http://userscripts.org/scripts/show/3420) this one is heavily based.
Currently the only way to save the output is by copying and pasting the text from the popup window.
You will probably need to add more URL's to the scripts as their are multiple servers hosting the online banking.
To do this go to Tools -> Greasemonkey -> Manage User Scripts and add the URL to the Included Scripts section.
You could comment on this script if you were logged in.
login to vote
Hi again,
I created another script of this kind. This time it's for UK Marks&Spencer Credit Card so I thought it might be more relevant to people in this thread.
login to vote
Hi Chris,
thanks for the script, since I don't have an account at co-operative but I'd suffered similar pain with my Aussie Wizard ClearAdvantage credit card statements, I decided to steal the idea and some parts of the implementation. Here's my script.
login to vote
Hi there,
I've just installed it on Firefox 3.0.1 and can't seem to see any buttons on my co-operativebank.co.uk statement pages.
Any Clues?
Cheers
David
login to vote
Chris, thanks very much, this will be very useful to use with my smile account. I think I must be naive, but could you spell out how to 'save as' .ofx format once you've got the ofx output in a text window? Sorry! Sam.
login to vote
Chris B - many thanks for finishing this off! I wrote this out of frustrations with the bank. I'm pleased you found it useful. The next step would be to make it into an extension then you could write files.
Cheers Mike
- an ex Pyramid worker ;)
login to vote
Guy - The Co-op bussiness banking pages probably have a different layout so that may be why it doesn't work for them. Does it work for your Smile account?
Adam/Paul - I'm not sure why it wouldn't be working for you. I have it working on Firefox 1.5.0.12 on Ubuntu 6.06 and Firefox 2.0.0.4 on Ubuntu 7.04. If you look at the script (Tools -> Greasemonkey -> Manage User Scripts -> Edit), on line 139 is the text
//alert(transCount+", "+date+", "+transaction+", "+deposit+", "+withdrawal);. If you change it toalert(transCount+", "+date+", "+transaction+", "+deposit+", "+withdrawal);- i.e. removing the leading '//'s, and try wiewing a statement you should get a message for each line in the statement. If so, this shows that the script is being run but must be having problems later on.I've updated the script to include the https://welcome23.smile.co.uk domain too.
login to vote
Hi Chris,
This is a brilliant script (and will probably stop me leaving Smile as a customer:-)
I'm also a Co-Op business bank customer, they deliver statements from a different domain:
https://welcome10.co-operativebankonline.co.uk/...*
I've tried adding that url, but I suspect it's the different domain that prevents it from working? I've tried manually hacking a local copy of the script to replace one of the existing domains in your conditional statements (and replacing an @include ) but I'm way out of my depth...
Any ideas?
cheers,
guy.
login to vote
Hello Chris, this doesn't work for me either - I've just installed it on Firefox 2. I've added the relevant statement page URLs to the list of URLs to apply the script to, but no joy. I'm just not getting the icons.
Would be v.grateful if you can suggest a fix.
login to vote
Just installed this script on Firefox 2.0.03 (Ubuntu 7.04). Doesn't seem to work for me. No CSV/OFX icons are appearing.
I'm using it to look at smile statements (not recent items) and pop-up protection is turned off.
The address used in the address bar is
https://welcome22.smile.co.uk/SmileWeb/getDomes...*
which is in the list of included pages.
I'll have a look at the code and see what I think. I'm a Python guy myself though...
Thanks for the script. It'll be very good if I can get it to work! :-)
login to vote
Updated the script to correct the output missing the first 2 lines of the first page of a visa statement.
login to vote
You need to look at your statements pages. It won't work on the 'recent items' pages.
On the statement pages you should get some icons above the statement. One for CSV and one for OFX. click on the one you want and a pop-up window should appear. You'll need to copy and paste the contents of this page into a file and save the file (either as .csv or .ofx)
Sometimes the script can be a bit belligerent on the statement pages by not always appearing but go back to the previous statement page and then forward again and it should appear.
Hope this helps.
I use the OFX output for importing transactions into GnuCash (http://www.gnucash.org/).
login to vote
Hi Chris, I've installed your script but I'm not quite sure how to use it (I'm new to using scripts). When I log into Smile and open my account window, what do I do next?