Budget Cuts - you heard it first on the Caseworks Blog
29 August 2010 10:44 | Budget Cuts, Free Software, Open Office, The Guardian | Permalink
I am going to allow myself a little self-congratulation this week. Ardent readers of this Blog, will have seen my suggestion that a great deal of public money could be saved if Councils and Government Departments gave up the rat race to install and upgrade Microsoft Office, at great expense, and adopted Open Office as their standard instead.
Scroll down a little bit, and look at my entry of the 30th June, entitled "Budget Cuts - a painless idea".
Now click on this hyperlink from the Guardian Technology Blog
http://www.guardian.co.uk/technology/blog/2010/aug/26/local-government-spending-open-standards-saving enititled "Councils 'could save at least £51m' with shift to ODF and open source" and you will see that Charles Arthur has had the same idea (8 weeks later). Interestingly, he has been able to put some figures on the saving by comparing UK IT costs with those of Spain, and come up with a figure of £51m, or, if you want to work it out for your own Authority, £200 per desktop per year. Now if you are reading this in your air conditioned open plan office just count the PCs and laptops and see much money could be saved. Multiply that for every section in every department, and every Local Authority, Housing Association and Government Department and £51m looks quite conservative.
My only criticism of his blog, is that it gives the impression that Open Office is incompatible with Microsoft Office, and therefore every major application which interfaces with Office would have to be re-written. He argues, that the Government should tell software companies to do just that.
Actually it is far from incompatible, and in my Local Government experience, many major systems don't really inteface with MS Office anyway. Caseworks is an exception in having an interface with both Word and Excel.
I have tested both. Word would be no problem, our mailmerge correspondence will open just as well in Open Office. We manipulate Rich Text Files on the server directly, we dont use Office to do that.
Excel Lists are no problem, they can also be read perfectly well in Open Office.
Excel Pivot Tables are a small problem, though not insurmountable. Open Office has a function which is the equivalent of Pivot Tables called Data Pilot. When you first open your Pivot Table in Open Office it appears to only do Drill Down, but when you read their Help, and do what it says - Data - DataPilot - Refresh - there is some magic and you get a DataPilot table out of your Pivot Table with all the functionality you would expect. Here is the proof - an Excel Pivot Report, live in Open Office... (I created the chart in Open Office, by the way)
If I am honest, I havent yet gone over to Open Office and abandoned my MS Office, but if it was a choice between this and cutting staff or services, I would do it tomorrow.
I would also argue, don't stop at Open Office. There is an abundance of free software out there which you could be using. I am currently reading up on MySQL, which appears to be a perfectly sound database option as an alternative to SQL Server and the horrendously expensive Oracle.
Now, to be honest, the conversion to MySQL would be much more onerous.
Readers will know, I am also sold on free maps (see Blog before last), and now I am looking at free GIS software - infact I am going to a conference about that in a weeks time and I will report back in this blog - so keep reading...
Scroll down a little bit, and look at my entry of the 30th June, entitled "Budget Cuts - a painless idea".
Now click on this hyperlink from the Guardian Technology Blog
http://www.guardian.co.uk/technology/blog/2010/aug/26/local-government-spending-open-standards-saving enititled "Councils 'could save at least £51m' with shift to ODF and open source" and you will see that Charles Arthur has had the same idea (8 weeks later). Interestingly, he has been able to put some figures on the saving by comparing UK IT costs with those of Spain, and come up with a figure of £51m, or, if you want to work it out for your own Authority, £200 per desktop per year. Now if you are reading this in your air conditioned open plan office just count the PCs and laptops and see much money could be saved. Multiply that for every section in every department, and every Local Authority, Housing Association and Government Department and £51m looks quite conservative.
My only criticism of his blog, is that it gives the impression that Open Office is incompatible with Microsoft Office, and therefore every major application which interfaces with Office would have to be re-written. He argues, that the Government should tell software companies to do just that.
Actually it is far from incompatible, and in my Local Government experience, many major systems don't really inteface with MS Office anyway. Caseworks is an exception in having an interface with both Word and Excel.
I have tested both. Word would be no problem, our mailmerge correspondence will open just as well in Open Office. We manipulate Rich Text Files on the server directly, we dont use Office to do that.
Excel Lists are no problem, they can also be read perfectly well in Open Office.
Excel Pivot Tables are a small problem, though not insurmountable. Open Office has a function which is the equivalent of Pivot Tables called Data Pilot. When you first open your Pivot Table in Open Office it appears to only do Drill Down, but when you read their Help, and do what it says - Data - DataPilot - Refresh - there is some magic and you get a DataPilot table out of your Pivot Table with all the functionality you would expect. Here is the proof - an Excel Pivot Report, live in Open Office... (I created the chart in Open Office, by the way)
If I am honest, I havent yet gone over to Open Office and abandoned my MS Office, but if it was a choice between this and cutting staff or services, I would do it tomorrow.
I would also argue, don't stop at Open Office. There is an abundance of free software out there which you could be using. I am currently reading up on MySQL, which appears to be a perfectly sound database option as an alternative to SQL Server and the horrendously expensive Oracle.
Now, to be honest, the conversion to MySQL would be much more onerous.
Readers will know, I am also sold on free maps (see Blog before last), and now I am looking at free GIS software - infact I am going to a conference about that in a weeks time and I will report back in this blog - so keep reading...
Comments
Another landmark
09 August 2010 10:23 | Case Pages, Cases | Permalink
Today was a special day for Caseworks.
Our customers created the 1,500,000th case page today.
Just thought I would mention it!
If you are interested in statistics, people are adding a page every three minutes during working hours, and have so far entered 85,000 cases.
In addition, nearly 225,000 "Notification Records" have been added to Notify and Respond / Estate Mananagement.
Free maps are better maps
29 July 2010 13:44 | OpenStreetMap, mapping | Permalink
The last Blog entry looked at Open Office, as a means of saving public sector cash. Since then, scarcely a day has gone by when the Coalition Government has not threatened more cuts, or abolished another body or another raft of Labour legislation. Right now Anti Social Behaviour Legislation is looking very vulnerable, and doubtless that will raise questions over the need for ASB units in Local Authorities.
My next money-saving idea, is a very serious one, and one we will definitely be implementing. As a result of the media profile which Google and Microsoft enjoy, most people will imagine that these are the only two mapping systems on the web, and that they are both free and there for our entertainment. Actually, none of these statements are true. There are other options, and nothing multi-national corporates do will be free, or even cheap, and if they are fun to use - which they are - this is part of the marketing lure. Bing and Google are looking to create advertising revenue from their products, so we all pay in all the products and services we buy, if we or others use online maps to find them. Where there is no advertising opportunity, both companies want to make a hefty charge, and, surprise surprise, the same hefty charge.
By contrast "OpenStreetMap" is an internet mapping system entirely built by volunteers in the tradition of Wikipedia. They are adding more detail all the time. The Open Street Map Foundation is not-for-profit. It ploughed a lot of its very small resources into helping out in Gaza and Haiti, where lack of maps (due to lack of commercial potential) hampers the aid process. I had the opportunity to attend their annual conference "State of the Map" in Girona, Spain and caught some of the infectious enthusiasm of the people who have built a great product from nothing in just four years.
I came back full of enthusiasm to see if we could use it in Caseworks, and today, my developer, Krish produced a brilliant conversion of our former facilty.
Login to their website and look at your own home area: http://www.openstreetmap.org/
This is an example of the open street map generated from the Case Screen
And the popup...
But readers, will be wondering if being free means it is rubbish. Absolutely not. The dedication of volunteers has guaranteed an immense amount of valuable details. I thought I would compare an area I know well, Alexandra Park in North London.
You decide!
This is Open Street Map
This is Google ............................................................And this is Virtual Earth
Budget Cuts - a painless idea
30 June 2010 13:34 | Budget Cuts, Open Office | Permalink
Nothing to do with Caseworks this time - but addressing an issue which will be taxing Caseworks Managers for at least the next 5 years. How to make a painless budget cut.
How about this for an idea? Stop paying license fees to Microsoft every time you buy a new PC. Dont upgrade to Office 2007 or 2010. Scrap the lot and download "OpenOffice" instead. Its free, its compatible and at least in some respects it is better. None of the users will mind, if they realise that this "cut" is instead of cutting the service they provide.
I have downloaded the whole suite to my PC from http://www.openoffice.org/ and spent time playing about with it. My verdict
- It really is compatible with Office, you can open Word, Excel and Powerpoint files and edit them and save them as Office files very easily
- There is MUCH less of a learning curve going from Office 2003 to OpenOffice than there would be going to Office 2007. I am still scanning the numerous "ribbon menus" trying to work out where Microsoft has put things.
- It does pretty much everything Office does, and a few things Office 2003 didnt do, like exporting to PDF.
- I still havent come to terms with the new Access 2007. The Open Office Database was a pleasurable throwback to the old Access look and feel which I have lost.
- Open Office Drawing programme offers you a version of Visio.
That's my idea for now. Share your ideas with our community for painless cuts by commenting or by emailing caseworker@hubsolutions.co.uk
Caseworks on an IPad
12 June 2010 12:28 | Caseworks, Caseworks Mobile, IPad | Permalink
Like many others, especially those from the Microsoft tradition, I was more than sceptical about the value of the IPAD format. Too big for your pocket, and no keyboard, was my initial reaction to the media hype.However, 10 minutes in the Apple Store in Brent Cross shopping centre, logging onto our new ASB Mobile and I am converted. It is a real pleasure to use; bright, crystal clear, the two-finger zoom control a
dds so much, and unlike so many other mobile browsers everything works really well.Remember, all of these pictures were taken by my mobile phone, in less than perfect conditions, but the crispness and clarity of the images are striking. The picture on the right, shows the neat way that the browser handles pick lists.
The image on the left shows the visually 
pleasing curves on buttons and input fields, while the one on the right, shows the Calendar Control. This control doesn't display properly on Windows Mobile or Blackberry, and will as a result have to be rewritten.
pleasing curves on buttons and input fields, while the one on the right, shows the Calendar Control. This control doesn't display properly on Windows Mobile or Blackberry, and will as a result have to be rewritten.Readers who are more interested in the IPad than Caseworks might be wondering if I looked at any of the apps and other facilities on this new toy. I did actually, and this image of the Transport for London App seemed the most visually appealing to include in my blog.
My verdict - if you want a portable device to browse the Internet, read emails, and show off your photos, buy it. It will compliment your fixed PC or laptop.
Caseworks on a Blackberry and IPhone
16 May 2010 08:52 | Blackberry, Mobile, IPhone, Caseworks | Permalink
Caseworks on a Blackberry? Yes it works!
But is it just me, or do other Blackberry users suffer from eye-strain to read such small text. HUBSolutions has just acquired its first Blackberry - the very latest version - 9700 - and I find that so often, when using it, the text is at the limit of what I can read.
I think we can make the text bigger, and that is going to be Selvi's next task on this project, but really this seems to me to be a big problem with the BB. Comments welcome from Adicts and Fans alike.
By contrast, we have also tried it on the iPhone, and what a joy that is to use. The text is large and so easily enlarged. Smooth rounded input boxes and buttons. Best of all, pick lists are converted automatically 
. If anybody reading this, hasnt seen the iphone pick list facility - I have copied it on the right. This isn't Caseworks - to be honest I am not a mac user, and I am really not sure how to screen dump from an iphone, but it does work just like this in Caseworks.
I dont own an iphone, but have effectively sold it to several friends, just by comparing it with my own phone!
The Wow Factor
30 April 2010 07:17 | East Durham, reports | Permalink
First Impressions
28 April 2010 00:45 | Report Writer, Riverside Housing | Permalink
The Caseworks Report Writer was deployed on a customer site for the first time this week, and first impressions where favourable.
Eileen from Riverside Housing Group emailed me
"Thanks for this [the Report Writer User Manual] – have had a quick go and it is really easy to use. I can see this being of great use to our Managers when they need to do reporting."
The report writer was mentioned in the last Blog,
but here are a few more screen shots from the User Manual.
Interested? Email caseworker@hubsolutions.co.uk for the full manual and more details
Eileen from Riverside Housing Group emailed me
"Thanks for this [the Report Writer User Manual] – have had a quick go and it is really easy to use. I can see this being of great use to our Managers when they need to do reporting."
The report writer was mentioned in the last Blog,
but here are a few more screen shots from the User Manual.
Interested? Email caseworker@hubsolutions.co.uk for the full manual and more details
Three months of exciting developments
07 April 2010 14:06 | Mobile, Hot spot, mapping, Report Writer | Permalink
It has been a long time since the last Blog. Why? Overwork! The whole team has been working flat out adding functionality to the system and meeting customer needs. My own thing has been the Domestic Abuse Module for Portmouth and the Supported Housing Module for Riverside, but I may save them for a later blog. I want to dedicate this blog to the amazing achievements of my developers, who have all expanded the system in different directions and stretched their own skills to the limit.
Below it is the same data automatically converted to "hot spot" squares where the shading indicates the number of points in the sqaure. This is Prathibha's work, and it doesnt stop there. She has created a facility to draw your own boundaries, label them and then automatically shade them according to the number of imported points within the boundary.
A Generic Report Writer
One of the clearest benefits of beginning the process of converting the system to ".net" has been the availability of third party products which we can manipulate and add to the system. The new Report Writer, integrated into the system by Krish in an amazingly short pe
riod of time is one example. Here is a combination of screen shots.
riod of time is one example. Here is a combination of screen shots.This new tool answers the problem of an entirely new report request, not fully covered by any of our library of Excel Pivot Tables. The user can select any field from any table to list, select and sort. The output can be written to Excel or Adobe. The system - Easy Query - really is easy to use. Completely intuitive with all of the selection options appearing as pick lists.
A hot mapping product
The next invention, with truly breathtaking potential is a hot-spotting "addin" for Microsoft Mappoint.
It genuinely turns this £300 package into a serious tool rivalling its more expensive rivals.
The screen shot opposite is data imported into mappoint. It isnt strictly a hotspot map.
Below it is the same data automatically converted to "hot spot" squares where the shading indicates the number of points in the sqaure. This is Prathibha's work, and it doesnt stop there. She has created a facility to draw your own boundaries, label them and then automatically shade them according to the number of imported points within the boundary.The ASB Module goes Mobile
Selvi, meanwhile has been developing a mobile version of the ASB Module. The latest "touch phones" with powerful browser facilites, really make the use of the system in the street, on a mobile, a real option. We could have just left it at that, and told customers that it is 100% web based, browse away on your matchbox size window. However, any mobile user will tell you that there is a world of difference between the BBC web site which is actually designed for mobile use and most others where you are scrolling around a screen three times bigger than your mobile.
I think the results of Selvi's efforts are quite stunning - at first site it looks more like an "app", so beloved of iphone users, than a web site.
Dashboard Version 2 - last blog of 2009
On the last day of 2009, and getting close to the last hour, I thought I would do a "first" and publish two blogs on the same day. Why? Mainly to give due credit to my colleague Krish, who carried on working until 9pm on New Years Eve to work out the best dashboard option for Caseworks. Version 1 (the previous blog) looked nice, but the underlying software was going to be a severe limitation for future enhancements. Krish started again at lunch time today, and worked on achieving the same result by a completely different route. Nine hours later, I think it is a pretty good prototype, and bodes well for an exciting New Year for Caseworks.
All of us wish our customers all the best for 2010.
