Wednesday, 8 June 2016

Learning from experience

When you're doing any sort of serious developmental work, whether it's solving a problem or exploiting a new opportunity, you have to start by defining your preferred outcome then look at all the possible options for getting you there. One of the things that constantly dismayed me when working in public libraries was just how limited "all the possible" usually was, and that these limitations were often imposed as a matter of principle rather than practice. Often summed up with a look of complacent contentment and the mantra: "Ah well, you see, they don't work the same as libraries." I still bump into this thinking quite regularly on the lists and social media, often as a dogmatic statement along the lines of "Libraries have got nothing to learn from…" This is, of course, the veriest nonsense: libraries can learn a great deal from other business operations, if only the reasons why adopting a particular policy or process would be a bad idea in a public library context (and that aren't "Ah well, you see, they don't work the same as libraries.")

The other reason why it is nonsense is that although a business operation may be very different to yours some of the operational functionality requirements may be very similar, or the same. There's no particular philosophical or ethical difference between opening the public doors to a library first thing in the morning and opening the public doors of a shop, for instance.

The exciting thing about not imposing any constraints on where ideas can come from is that you can often find alternatives to the organisation's "default setting" that are cheaper and more effective to apply.

The responsibilities in my last job included a transport management system called Tranman. Very generally speaking it was used to manage the council's fleet of vehicles and the jobs done in the vehicle workshop. Some of the jobs done in the workshop were part of the routine maintenance work included in the service level agreements with the council departments using the vehicles. A lot weren't: repairs necessitated by accidents or driver abuse were chargeable extras and the workshop also did a lot of private repair work, services and MOTs as part of the operation's income generation. Extremely different to the business operation and purpose of the public libraries I was also supporting.

They had a problem. A lot of the jobs were taking ages to complete and invoice on the system because they were missing information about the parts that were issued to them. Even worse, some jobs had been completed and invoiced without including the rechargeable costs of the parts. This was playing hob with their cash flow and making the accountants cross. So we had a look at it and basically the situation was:
  • There was a manual process involving somebody trying to catch up with a pile of paperwork at the end of the month
  • There was a technical solution which could automate the stock issue but wasn't being used
What was needed was for the parts to be issued to the jobs in as close to real time as possible and that wasn't going to be done manually from the paperwork.

We had a long, hard look at the technical solution. None of us were big fans. It was hard work to get set up and running and, frankly, was over-engineered for its purpose. On paper it looked great:
  • A piece of software on the stores manager's PC generated barcoded labels for each part, the barcode including the appropriate part number and bin, together with a human-readable description.
  • The parts bins were labelled up accordingly.
  • When a part was to be issued to a job the store man entered the job number into a PDA, read the appropriate barcode and entered the number of items being issued.
  • The PDA was then plugged into a console attached to the store manager's PC and the data uploaded into Tranman.
In reality it wasn't so hot:
  • The barcoded labels soon got scruffy and unusable.
  • We could make the barcodes on the labels as big as we wanted but the descriptive text was always tiny and difficult to read, especially in some of the darker corners of the store room.
  • The keys on the PDA were very small (6mm across), which was difficult enough for me with my never-done-a-stroke-of-hard-labour-in-his-life delicate fingers and not a lot of fun for workers who'd spent years bashing their finger ends on bits of metal on cold Winter's days. The incidence of input error was high.
  • Uploading the data was a bit hit and miss at first: it took quite a while for us to iron out the problems and making sure the solutions were properly packaged into the virtual application. (I for one was praying nothing happened to that PC as I wasn't confident we wouldn't have at least a few of these problems again with a new deployment of the software.)
  • It wasn't easy to see where and when something went wrong. The lack of transparency meant that you couldn't do any quality control to make sure that the right parts actually were being issued to the right job.
Something had to be done. 

We looked at various somethings: we spent far too long trying to sort out better barcode labels; then we had a fruitless quest for a more user-friendly PDA that could do the job. Over the next few months, in between a pile of other pieces of work we were doing with this system, we tweaked this process as best we could but in the end it felt more like we were working through levels in an arcade game rather than getting anywhere with improving the process and addressing the cash flow problem. By this stage I was thoroughly fed up and went and had a sulk in my tent. On reflection it was apparent that all we had been doing was following the same ploughed rut over and over again. 

We'd let our problem-solving be dictated by the "solution" rather than either the problem or the desired outcome.

So I looked again. And wondered why the issuing of parts to a job in a vehicle workshop was very much different to the issuing of library books to a borrower…

The solution I came up with was cheap, not especially elegant but did the job and could be seen to do the job. There were two elements:
  • A standard barcode reader, same as you'd see in a shop or library
  • A folder containing sheets of labels including all the information needing to be entered into the job record:
    • The description of the part in a large, readable font
    • The part number as a barcode (using the "3 of 9" font)
    • The bin number as a barcode
    • The store location as a barcode
The process was:
  • The request comes in for the part for the job
  • The stores man gets the part then opens the job record in Tranman
  • The part number, bin number and location are input by reading the barcodes from the appropriate sheet
  • The only manual input is the number of parts
  • The parts are issued to the workshop
For out-of-hours working the process was:
  • The request for the part is recorded on a paper job sheet
  • The fitter working on the job gets the part
  • Next working day the stores man issues the part in Tranman as above
Getting a working test sheet turned out to be a bit of a problem because initially I was doing it in MS Word and the formatting it imposed was disabling the begin and end codes of the barcode (an asterisk *). Jacking it in and doing the job in Wordpad gave us some test sheets we could use to demonstrate proof of concept. I used Crystal Reports for the final print out of all the parts.

Sadly, this is as far as I got with it by the time I was leaving. We'd checked that each step should work as expected but we'd not given the process much hammer and inevitably there'd be some snagging to do. One thing I'd have liked to have done, given the time, would be to modify the Crystal Report so that the first few pages were limited to the high-volume items, to save the stores men having to routinely wade through so many pages.

So that's how I applied a bit of standard public library functionality to a problem in a completely other environment.

So what are the takeaways from this?
  • Don't mistake differences in business operation with differences in operational functionality. In this case, issuing an item in real time is issuing an item in real time.
  • If your problem-solving energies are being devoted to the solution perhaps you've got the wrong solution.
  • To solve a problem you have to know what problem you're solving and the outcome you desire of the solution.

Saturday, 28 May 2016

A rose is a rose is a rose…

a sunny day in Rochdale On Tuesday afternoon me and Rochdale Borough Council go our separate ways. Strangely enough, of all the things I should be thinking about the one I keep coming back to is: "How should I describe myself on Linkedin?"

For a while (at least the four weeks I've promised myself) I'm not going to be in a job and have a job title. "Resting," while dead accurate doesn't really cut it, so I'm having a think. Besides which, I've long since been irritated by the way we all define ourselves by our jobs: when we're introduced to each other with the routine: "And what do you do?" We never boast of the many very splendid things we're capable of: we give a job title or rôle. That's a pity. Even in an employment context this tells so very little of us. So I decided to pick up the "And what do you do?" question and find a different answer.

Casting round amongst family and friends wasn't helpful, though I'll admit to being quite taken with "Provender of finely-wrought artisan drivel" and "Keen amateur idle beggar."

Thinking about my own experiences and the rôles I've assumed or had thrust upon me there are a few consistent strands:
  • Identifying and documenting operational processes and procedures
  • Helping lines of business find new ways of doing things that add value to the operation
  • Helping operations and people accept and adapt to change
  • Identifying and delivering ways of measuring continuous service improvement
Bearing this in mind I bounced a lot of descriptive phrases round in my head. Many sounded like the worst kinds of Management Speak. Many were either too vague or too narrow. A lot of them felt too much like I was parking my bike on somebody else's lawn. It boiled down to two in the end. And I'm still havering between them: one feels vague and one feels like I'm trespassing. One is the working assumption of many of the people I've said cheerio to over the past month. The other is the rôle I've taken on repeatedly over the past twenty-seven years and the one I've tended to feel has been the most productive and worthwhile.

I've a few more days for havering. Who knows, it might end up being Keen Amateur Idle Beggar after all!

Tuesday, 17 May 2016

Taskforce workshop: assessments

In Friday's workshop a few of us got talking about the idea of "voluntary assessments" raised in the Ambitions document. These weren't really defined so it was difficult to know quite which was the best approach for this topic.

There was some concern that any assessment would just be another stick to beat libraries with, like issue figures and visitor counts have become. Equally, would they become another set of targets to be gamed? Both are extremely valid concerns.

I think it's essential that public libraries have a solid suite of KPIs — not for comparison with so-called "peers" in a way that takes no heed of communities or contexts but for comparison with past performance and identifying strengths and weaknesses in the operation. But the "voluntary assessments" *shouldn't* be about KPIs: there are a couple of other useful functions they could perform.

One way would be to direct the stick upwards, towards the DCMS. It's vanishingly unlikely to happen but it could be that one of the Department's own performance narratives, published in its annual report, could include an assessment of the health of the national public library service derived from local returns. 
  • I don't like expenditure as a measure of performance (any bloody fool can spend money) but given that the audience for such a thing would be a political one that largely measures achievement by expenditure one of the assessment measures could be expenditure per capita population, which could be broken down into: investment in buildings; investment in skilled staff; investment in stock; and investment in community activities. (Did you spot the gear-shift there?) 
  • DCMS would — finally! — have to be able to report a definitive number of public libraries in the country, and any changes and trends. 
  • It would be interesting to see a national picture of:
    • The number of staffed library open hours
    • The number of library open hours manned by volunteers
    • The number of unsupervised library open hours
    • The number of "daytime" (9am — 5pm) hours libraries are closed and left fallow
  • And so on. I won't go into more detail because it's so unlikely to happen it's hardly worth the wishing for.
Another, possibly more plausible, function would use the assessment as a feedback mechanism for continuous service improvement (absolutely not a set of targets!). They would be used to evaluate rather than monitor the performance of the service and help direct local decision-making. 
  • The assessment criteria could be deliberately aspirational and impossible to achieve: the assessment would evaluate the direction of travel of the service and the impact on resources, staff and the needs of the communities that the service serves. 
  • Comparisons would be with past performance rather than against "peers," which would remove any unwelcome competitive friction between organisations that should be working collaboratively, 
  • This would also mean that it would be harder to game the figures and it would be harder to coast on past glories as assessments would be reporting the direction of travel towards the impossible goal rather than the successful negotiation of an arbitrary obstacle.
  • For example, one of the "impossible goals" could be 100% of the local population's being active members of the library (however that would be defined). Last year Library Service A could have attained 56% active membership and this year 58% while Library Service B managed 69% and 60%. Crude peer-to-peer analysis would suggest that Library Service B is performing better but A is actually making a better fist of continuous service improvement — it's the rate and direction of performance, not the absolute figures, that are the measure of how the service is being managed and resourced; they'll all have different baseline starting points.
There is a problem with this idea: while it works well in many organisations and is pretty standard performance management fare I don't think our political environment is adult enough not to try and turn this into a badly-fitting set of targets and league tables. It would be nice to be shown to be wrong, though.

Sunday, 15 May 2016

Having a say

I went to Friday's Library Taskforce workshop in Machester Central Library on Friday.The aim of the workshop was to get feedback on the Ambitions document and suggest practical detail that should go into the action plan for it. I was interested so I signed up and was accepted in my rôle of "interested member of the public." It was an interesting few hours, here's a few thoughts on it.

Something that concerned a few of us was the rôle of the Taskforce itself. You don't have to go very far into discussions about English public libraries before you'll hear somebody say: "The Taskforce should do…" And that's a problem. The Taskforce is no magic wand, it has a finite life and actually it's just that scant handful of people who were going round sticking bits of paper on the wall in the library on Friday. It has the same rôle as a business analyst: it can facilitate and stimulate discussion, it can identify work to be done but it's down to other agencies to get on and get things done.

A recurring theme in the workshop was the need for a skilled workforce to deliver library services. A decade ago this would have been couched in terms of CPD for "professionals," here the conversation concerned all library staff. And not just the "we need people with digital skills" thing: there was a recognition that there's a swathe of skills that need developing and supporting, including having properly-trained library managers who can manage operations, services, programmes and projects. This is a welcome contrast to the ongoing narrative of staff losses, closures and farming out the work to volunteers. It's good that the Taskforce is talking up the need for a skilled staff. Translating that into action will be a stern challenge!

Another recurring theme was the tension between local authority control and opportunities for cost-sharing and delivering services to communities that aren't defined by geopolitical boundaries. Even when we look at delivering "bigger" we still seem to be bound by lines on ancient maps: local metropolitan authorities don't often think of working across the Pennine border.

Evidently there'd already been some feedback about the thinness of the digital strand of the document: there were a few more ideas pinned to the wall for us to respond to than I'd been expecting. This suggests that somebody's listening. Actually, I've been consistently getting the impression that the Taskforce members are listening to people. And they're trying to have conversations with people aside from chiefs and politicians. I think the workshops could have been better publicised away from the usual channels to try and get more library customers into the mix because I think it would have proved very useful.

A few of us thought that "income generation" is a tricky topic. It's important that libraries try to maximise their income (good services don't pay their bills in daydreams) but the phrase "income generation" is unfortunately a bit loaded. It's important that libraries stay that safe, trusted place where nobody's asking you what's in your wallet and that shouldn't be compromised. And whenever libraries are told to be more commercially-minded it's conveniently forgotten that local authorities don't work in a commercial environment. The twelve- month budget lifetime isn't anything any commercial operation would be able to live with: the mad March spend it or lose it would be ludicrous in that context. There was a lot said about that! The other problem, of course is that as soon as you say that you're going to generate some income some clever body will impose an income target. Income targets work this way: you make a business case for spending £100 to set up a business selling apples from a barrow; you're told: great, go ahead and by the way we're going to assume that you're going to make a £50 profit so we'll take that off you now; and you're left with enough money to buy either the barrow or the apples but not both and your business plan fails. There's no real money to be had selling off odd scraps of thing or hiring out rooms or buildings. There is potentially funding out there for programmes, projects and activities that are entirely compatible with the traditional aims and purposes of public libraries and I think this is what is meant by "income generation" in this context. I think it would be more useful for the Taskforce to be talking about "maximising the take-up of funding opportunities" instead.

We've until 3rd June to contribute to the discussion. If you haven't already, please do so.

Wednesday, 27 April 2016

Ambitions 1998

Another bit of archaeology. In 1998 — back when we had only five libraries networked and on the library management system and before the reality of The People's Network — I was asked why the library service didn't have an IT strategy so I drafted one. This is some of the working-out.


Rochdale Library Service
Information/Communications Strategy — suggested bullet points

1         Factors informing the strategy
a)       Operational needs
i)        Lending
·         Stock management & control
  Making stock work harder
  Audit requirements
·         Borrower management & control
  Accessibility to library services across the Borough
  Fines/charges control
  Market analysis
·         Reservations management & control
  Reaching performance targets
  Managing costs of interlibrary loans
ii)      Reference
·         Increasing access to electronic information resources
  Access to new forms of material
  Access to wider ranges of material
  Making existing materials more widely available
  Increasing the accessibility of Council information
iii)    Access to Library information
·         Access to the Library Catalogue
·         Access to local history materials
  Digital formats
  Documents
  Pictures
  Indexing
  Local history collections
  Local newspapers
·         Accessibility
  Within libraries
  Mobile library provision
  Meeting special needs
  Telematic access
iv)    Management information
·         Stock management information
  Stock use analysis
  Stock age analysis
·         Statutory statistical requirements
  CIPFA
  Audit Commission
·         Performance indicator measurement
  Local
  National
·         Financial information & control
  Stock ordering management
  Book fund analysis
  Budget monitoring
v)      Administrative requirements
·         Word–processing
·         Contact management — shared resources
  Council telephone numbers
  Emergency numbers
  Professional contacts
  Suppliers
·         Bibliographical information (all formats)
  Records for requests
  Approvals
  Bibliographical records
b)      Staffing/support issues
i)        Training
·         Designing systems to minimise training needs
·         Commitment to empowering staff — enabling local problem–solving
·         Resources for delivery
  Staff time
  Cover for staff being trained
  Trainers
  Opportunity and resources for preparation
ii)      Support
·         Ownership issues
  Enabling local problem–solving
  Spreading skills widely
  Agreeing what can be expected of staff locally
  Support structures within the Library Service
  Professional Librarians taking responsibility for library systems
  Other staff
  Third–party support
  Within the Council
  Suppliers
  Cost implications
·         Providing support at the front line
  For staff
  For the public
c)       External pressures
i)        National issues
·         New Library: People’s Network
·         National Grid for Learning
·         Audit Commission: Due for Renewal
·         Information for All
ii)      International perspectives
·         European information issues
  Information 2000
  IRISA–LAPSA & successor organisations
·         Internet access
d)      Technological possibilities
i)        Dynix library system
·         OPACs
  Graphical interfaces
  Web PACs
  OPACs for special needs (e.g. Libris Envisage)
  Off–line PACs (“OffPACs”)
·         Cash management
·         Acquisitions
  Order management
  Supplier performance monitoring
·         Community Resources
  Community organisations
  Events
  Newspaper indices
·         Internet publishing
ii)      PC–based systems
·         Word–processing
·         Spreadsheets
·         Custom databases
·         SQL–compliant systems
·         Electronic reference materials
·         Tutorial materials
·         Web browsers
·         Windows NT networks
·         Intranet systems
iii)    Unix–based systems
·         Electoral roll
·         Corporate financial data
iv)    Self–service opportunities
·         Reservations
  OPACs
  Web–based telematic systems
·         Circulation
e)       Restraints
i)        Funding for projects
·         Capital funding
·         Revenue funding for maintenance, etc.
·         Staffing costs
ii)      Expertise
·         Within the Library Service
·         Within the Council
  Knowledge of library systems
  Networking
iii)    Staff time
iv)    Support issues (see above)
v)      Corporate policies

2         Suggested outcomes
a)       Dynix Library System
i)        Aim to stay with Dynix for the period of this strategy provided the development and support of the system meets the needs of the Library Service.
·         Join forces with other Dynix users to lobby for enhancements to the system to meet outstanding needs
·         Keep a watching brief as to the development of the product as a graphical system based on PCs 
·         Pending proper reassurance on the life expectancy of the Dynix system, add remaining libraries to the system
  Circulation
  OPACs
·         Implement procedures to automate parts of the stock editing system
  Transfers of some fiction collections
  Flagging up “tired” or “under–used” stock
  Collection inventory systems
·         Implement the Acquisitions module — automating the order process; book fund monitoring; supplier performance monitoring
·         Developing the use of Community Resources
  Making the Community Organisations database available
  On OPAC
  On Council intranet via WebPAC technology
  On World–Wide Web via WebPAC technology
  Making local newspaper indices (currently in card format) available on OPAC
  Could be made available on the World–Wide Web and Council intranet via WebPAC technology
·         Investigating the effectiveness & viability of the Dynix Cash Management system
·         Develop new OPAC functions
  Kids’ Catalogue
  Graphical interfaces
  Publishing the Library Catalogue on the World Wide Web, including allowing “WebPAC” access to search for particular items
  Requires web access to the processor housing the library system
 Allows the possibility of allowing self–service reservation via the WWW
·         Telephone access
  Investigate the effectiveness and viability of potential options
  Automated telephone renewals
  Automated telephoned messages — overdues/charges/reservations notices
ii)      Where possible, create interfaces between the Dynix Library System and PC–based software
·         Management information
  Collating data between Dynix and proprietary software (e.g. for spreadsheet analysis)
  This would require a third piece of software to act as an interface between the two
  Investigating the effectiveness & viability of the Dynix “Executive Information System” — data warehousing/reporting system
·         Catalogue information
  Envisage — OPACs for visually–impaired
  Off–line copies of the Catalogue on CD–ROM (using the data conversions already taking place for Envisage)
  Replacing microfiche at off–line libraries
  Replacing microfiches as “back up” at on–line libraries
  Could be available on laptop on Mobile Library
  Could be available on laptop on Housebound Service
·         Using WWW technology (especially Java) to enable telematic delivery of library services (available from Dynix release 162E)
  Access to the Library Catalogue
  Potentially including placing reservations
  Access to library information
  Community Organisations
  Events
  Newspaper indices
  Constraints
  Requires a change in Council policy on web access to networked data
  Requires web access to the processor housing the library system
b)      Workstation access to other information systems
i)        PC–based information
·         Access to PC–based electronic references
  Networked electronic references based on a Windows NT server
  Allows resources to be shared between libraries
  Expensive references kept secure centrally
  CD–ROMs cached to hard disk to improve speed of access
  Using existing networks where feasible
  Networking dependent on licensing regimes — some material may not be networked; some networked licences may be prohibitively expensive
  May be able to derive use statistics for individual references
  Potential for differential access — different reference materials for different client groups
  Intranet connection with the rest of the Council
  Council information
  Statutory papers/minutes
  email
·         Library intranet
  Staff manuals in hypertext format
  Staff notices
  Staff training materials
  Contact information
  Shared bookmarks for WWW
ii)      The Internet (more probably, just the WWW)
·         Staff workstations
  Including email
  Access to appropriate lists
·         Public workstations
  See below
iii)    Other systems
·         Reference Enquiry Desk workstations access to Electoral Roll
·         Administrative/management systems
Financial systems
 Suppliers database
c)       PC–based services to the public
i)        Extension of Open for Learning facilities
ii)      Maintenance of text–reading and Brailling facilities
iii)    Word–processing facilities
·         Support?
·         Cost of consumables?
iv)    Computers Don’t Bite and successors
d)      Public Internet access
i)        Controlled access
·         ?Timed out by software on PC
·         ?Time booked and issued to “borrower”
·         Use of Net Nanny et al. To prevent inappropriate access
·         ?Users registered, including disclaimers
  Promise not to look for illegal/immoral materials (how defined?)
  Promise not to hack machines
  Accept responsibility for own actions
  Agree that Library Service not responsible for anything the customer does during their time on the Internet
  Accept that service may be withdrawn from the customer if they break the rules
·         Costs
  To Library Service
  Service provider subscriptions
  Line costs
  To the customer
  ?How to be as inclusive as possible
  ?How nominal is a nominal charge
  ?Charge period — session or season
e)       Local history collections
i)        Access to the Local History Catalogue
·         Staff at Heywood and Middleton need access to the Catalogue at Rochdale
  Cost
  Training load
  Is there OPAC access?
  Why not Dynix at Local Studies?
  Cost
  Training load
  Why not both in both places?
  Compatibility?
  The Library Catalogue on Dynix will be searchable from a Web browser with 162E. If both catalogues Z39.50 compliant, both could be searched from a Web browser (as per draft Telematics strategy)
·         Practical issues
  Large cataloguing task
  May require some modification of the Dynix Catalogue record to include additional MARC fields (e.g. additional media fields; URL tags; image data)
  Would need to look at how other libraries/museums approach the job
ii)      Digitising local history materials
·         Security of primary materials
·         Making materials more widely accessible
  PAC–style picture catalogues
  Intranet/WWW access
·         Pictures
  Scanned into JPEG format
  Catalogued
  ?Dynix (how catalogued?)
  ?Proprietary database system
  PAC access
  ?Dynix
  ?Proprietary system
  Electronic watermarking for copyright purposes
·         Documents
  Copyright issues
  Imaging
  Investigate routes taken corporately through Document Imaging Working Group
  Transcription
  Investigate effectiveness/viability of scanning and OCR (optical character recognition) systems
f)        Office applications at main libraries
i)        Word–processing facilities — MS Word
ii)      Use of MS Word and MS PowerPoint for DTP/notices
iii)    MS Excel for spreadsheet analyses
iv)    MS Access for local databases (created by Systems Manager for local use — e.g. for enquiry desk statistics)