Are you running old and unsupported software? What about the risks?

by Frank 29. April 2012 20:59

Many years ago we released a 16 bit product called RecFind version 3.2 and we made a really big mistake. We gave it so much functionality (much of it way ahead of its time) and we made it so stable that we still have thousands of users.

It is running under operating systems like XP it was never developed for or certified for and is still ‘doing the job’ for hundreds of our customers. Most frustratingly, when we try to get them to upgrade they usually say, “We can’t justify the expense because it is working fine and doing everything we need it to do.”

However, RecFind 3.2 is decommissioned, unsupported and, the databases it uses (Btrieve, Disam and an early version of SQL Server) and also no longer supported by their vendors.

So our customers are capturing and managing critical business records with totally unsupported software. Most importantly, most of them also do not have any kind of support agreement with us (and this really hurts because they say they don’t need a support agreement because the system doesn’t fail) so when the old system catastrophically fails, which it will, they are on their own.

Being a slow learner, ten years ago I replaced RecFind 3.2 and RecFind 4.0 with RecFind 5.0, a brand new 32 bit product. Once again I gave it too much functionality and made it way too stable. We now have hundreds of customers still using old and unsupported versions of RecFind 5.0 and when we try to convince them to upgrade we get that same response, “It is still working fine and doing everything we need it to do.”

If I was smarter I would have built-in a date-related software time bomb to stop old systems from working when they were well past their use-by date. However, that would have been a breach of faith so it is not something we have or will ever do. It is still a good idea, though probably illegal, because it would have protected our customers’ records far better than our old and unsupported systems do now.

In my experience, most senior executives talk about risk management but very few actually practice it. All over the world I have customers with millions of vital business records stored and managed in systems that are likely to fail the next time IT updates desktop or server operating systems or databases. We have warned them multiple times but to no avail. Senior application owners and senior IT people are ignoring the risk and, I suspect, not making senior management aware of the inevitable disaster. They are not managing risk; they are ignoring risk and just hoping it won’t happen in their reign.

Of course, it isn’t just our products that are still running under IT environments they were never designed or certified for; this is a very common problem. The only worse problem I can think of is the ginormous amount of critical business data being ‘managed’ in poorly designed, totally insecure and teetering-on-failure, unsupportable Access and Excel systems; many of them in the back offices of major banks and financial institutions. One of my customers called the 80 or so Access systems that had been developed across his organization as the world’s greatest virus. None had been properly designed, none had any security and most were impossible to maintain once a key employee or contractor had left.

Before you ask, yes we do produce regular updates for current products and yes we do completely redesign and redevelop our core systems like RecFind about every five years to utilize the very latest technology. We also offer all the tools and services necessary for any customer to upgrade to our new releases; we make it as easy and as low cost as possible for our customers to upgrade to the latest release but we still have hundreds of customers and many thousands of users utilizing old, unsupported and about-to-fail software.

There is an old expression that says you can take a horse to water but you can’t make it drink. I am starting to feel like an old, tired and very frustrated farmer with hundreds of thirsty horses on the edge of expiration. What can I do next to solve the problem?

Luckily for my customers, Microsoft Windows Vista was a failure and very few of them actually rolled it out. Also, luckily for my customers, SQL Server 2005 was a good and stable product and very few found it necessary to upgrade to SQL Server 2008 (soon to be SQL Server 2012). This means that most of my customers using old and unsupported versions of RecFind are utilizing XP and SQL Server 2005, but this will soon change and when it does my old products will become unstable and even just stop working. It is just good luck and good design (programmed tightly to the Microsoft API) that some (e.g., 3.2) still work under XP. RecFind 3.2 and 4.0 were never certified under XP.

So we have a mini-Y2K coming but try as I may I can’t seem to convince my customers of the need to protect their critical and irreplaceable (are they going to rescan all those documents from 10 years ago?) data. And, as I alluded to above, I am absolutely positive that we are only one of thousands of computer software companies in this same position.

In fairness to my customers, the Global Financial Crisis of 2008 was a major factor in the disappearance of upgrade budgets. If the call is to either upgrade software or retain staff then I would also vote to retain staff. Money is as tight as it has ever been and I can understand why upgrade projects have been delayed and shelved. However, none of this changes the facts or averts the coming data-loss disaster.

All over the world government agencies and companies are managing critical business data in old and unsupported systems that will inevitably fail with catastrophic consequences. It is time someone started managing this risk; are you?

 

Managing Emails, how hard can it be?

by Frank 22. April 2012 00:22

We produce a content management system called RecFind 6 that includes several ways to capture, classify and save emails. Like most ECM vendors, we offer a number of alternatives so as to be better able to meet the unique requirements of a variety of clients.

We offer the ‘manual’ version whereby we embed our email client into packages like Outlook and the end user can just click on our RecFind 6 Button from the Outlook toolbar to capture and classify any email.

We also offer a fully automated email management system called GEM that is rule-driven and that automatically analyses, captures and classifies all incoming and outgoing emails.

At the simplest level, an end user can just utilize the standard RecFind 6 client and click on the ‘Add Attachment’ button to capture a saved email from the local file store.

Most of our customers use the RecFind 6 Button because they prefer to have end users decide which emails to capture and because the Button is embedded into Microsoft Office, Adobe Professional, Notes and GroupWise. A much smaller percentage of our customers use GEM even though it is a much better, more complete and less labour intensive solution because there are still many people that just don’t want email to be automatically captured.

This last point is of great interest to me because I find it hard to understand why customers would choose the ‘manual’ RecFind 6 Button, small, smart and fast though it is, over the fully automated and complete solution offered by GEM, especially when GEM is a much lower cost solution for mid-size to large enterprises.

A few years ago in 2005 the Records Management Association of Australia asked me to write a paper on this topic, that is, why don’t organizations make a good job of capturing emails when there is plenty of software out there that can do the job?  I came up with six reasons why organizations don’t manage emails effectively and after re-reading that paper today, they are still valid.

In my experience, the most common protagonists are the records manager and the IT manager.  I don’t think I have ever spoke to a senior executive or application owner who didn’t think GEM was a good idea but I have only ever spoken to a tiny number of records managers who would even contemplate the idea of fully automatic email management. Most IT managers just don’t want all their emails captured.

This is despite the fact that because GEM is rule-driven any competent administrator could write rules to include or exclude any emails they want included or excluded.

Another road block is that old red herring personal emails. In ninety-percent upwards of cases where my customer has decided against GEM this is given as the ‘real’ reason. It is of course rubbish because there are many ways to handle personal emails including an effective email policy and writing GEM rules to enforce that policy. This 2004 paper explains why we need to manage emails and also talks about an effective email policy.

The absolute worst way to mismanage emails is to mandate that end users must select and print them out for the records staff to file in cardboard file folders. This method is entirely appropriate to 1900 except for the fact that we actually didn’t have emails in 1990. It is entirely inappropriate and just plain ineffective, wasteful and stupid in 2012 but, tens of thousands of records managers all around the world still mandate this as the preferred approach.

Is it because they don’t understand the technology or is it because they stubbornly refuse to even consider the technology?

It can’t be budget because the cost of expensive staff having to be part-time records managers is monumental. You would be hard pressed to find a more expensive and less effective solution. So why are we still doing it?

Back to the title of this paper, “How hard can it be?”

The answer is that it is not hard at all and that every ECM vendor has at least one flexible and configurable solution for email management. More so, these solutions have been around for at least the last ten years. So why are we still doing it the hard, ineffective, incomplete and expensive way?

The answer is that it is to do with people and attitudes; with a reluctance to embrace change and a reluctance to embrace a challenge that just might force managers to learn a lot in a short time and extend their capabilities and workload for the period necessary to implement a new generation solution. I guess it comes down to fear and a head in the sand attitude.

I once had a senior records manager tell me he wasn’t going to install any new systems because he was retiring in five years and didn’t want the worry and stress. Is this really why you aren’t managing your emails effectively and completely? Isn’t it time you asked the question of your records and IT managers?

Project Management – just what does it entail?

by Frank 15. April 2012 06:00

In a previous career with mainframes I spent eight years as a large scale project manager and then a further two years as the international operations manager managing a number of project managers at troubled projects around the world. Those ten years taught me a great deal about what it takes to be a successful project manager and conversely, why some project managers fail.

Notice that I said why some project managers fail, not why some projects fail. It is cause and effect; projects only fail when the project manager fails to do the job required. This particular concept separates good project managers from bad project managers. Good project managers take full responsibility for the success or failure of their projects, bad project managers don’t.

Good project managers are ‘glass-half-full’ people, bad project managers are ‘glass-half-empty’ people. Good project managers are leaders, bad project managers are victims.

So the first piece of advice is to choose your project manager carefully. You want a strong willed, bright and energetic doer, not a facilitator or politician. You want a strong leader, not a careful and political follower; you want Jesus, not the disciples.

The next piece of advice is that you should set quantitative criteria for project success. No ambiguity or motherhood or weaselly words, as the Dragnet cop used to say, “Just the facts Mam.” In my day it was easy, we had to install the new hardware and software, convert from the old system, design and program the new applications and then take the whole system through a 30 day acceptance test with 99% uptime. There was always a contract and the conditions of acceptance were always clearly laid out and assiduously referred to by the customer. We knew what we had to achieve and there was no ambiguity.

Unfortunately, one of the problems with a lot of projects is that the conditions for acceptance and success are not clearly articulated or documented. But, a good project manager will always make sure that the scope and objectives and expected outcomes are clearly defined regardless before accepting the challenge. The bad project manager on the other hand is always happy that there isn’t a clear definition of success because the bad project manager wants to make judging his or her performance as difficult as possible.

I once fired a project manager who told me in three meetings in a row that he had not completed the requested project plan because the project was too complex. Obviously the more complex the project the more its needs a comprehensive project plan otherwise it will be impossible to manage. My failed project manager didn’t want to document the project plan because he didn’t want deadlines and he didn’t want to be judged on how well he was meeting deadlines.

It sounds like an over-simplification but if you want a successful project then choose a successful project manager, one who accepts full responsibility for all outcomes and one who is committed to success.

As part of the interview process, ask them what their philosophy of responsibility is. As an example, here is one I always used.

“Everything that happens is due to me because everything that happens is either due to something I did or something I didn’t do.”

I have never found a good project manager who had a problem with this credo. Bad project managers on the other hand, see it as anathema to their survival strategies. Good project managers accept full responsibility for success or failure, bad project managers do not.

Good project managers also don’t spend all day in an office playing with Excel and Microsoft Project. Nor do they spend all day in meetings or on conference calls. Good project managers integrate themselves into the very bowels of the project and ‘walk-and-talk’ on a daily basis.

Walk and talk refers to the practice of meeting with real workers at all levels of the project, especially end users. Good project managers make the time to talk to end users every day and because of this they know more about what is happening than any senior manager. They are ‘in-touch’ with the project and are constantly aware of changes, problems and successes. Good project managers who practice the walk and talk technique are never surprised in project or management meetings because they always know more than anyone else at the meeting and they always have the very latest information. This is probably why they are such good project managers. If you aren’t prepared to invest at least one hour of your time every day walking and talking to real users then you shouldn’t be a project manager.

Good project managers also always know how to select and manage their team. Because they are natural leaders, management is a natural and comfortable process for them. There is never any doubt in a good project manager’s team about who the leader is and who will make the final decisions and then take responsibility for them. There is no disseminated responsibility. The opposite is always true in a bad project manager’s team with disseminated responsibility and no clear record of who made what decision.

The calibre of the bad project manager’s team is always significantly lower than that of the good project manager’s team. This is because mediocre people always hire mediocre people and a bad project manager is afraid of strong capable staff because he or she finds them threatening. A good project manager on the other hands loves working with strong capable people and revels in the ongoing challenge of managing them. A good project manager is never threatened by strong capable staff, au contraire; he seeks them out because they make it easier for him (or her) to be successful.

There is no magical formula that will ensure a successful project, completed on time and on budget and with all contracted deliverables accepted and signed off. It also doesn’t matter what project management tool you use as long as you do use a project management tool. I don’t particularly like the latest version of Microsoft Project (and that is an understatement) but if required I could use it to manage any project no matter how big and how complex. It isn’t the tool; it is the person that counts.

This is simple advice like my favourite about how to do well on the stock market, “buy low and sell high.” If you want a successful project, always start with a successful project manager. He or she will take care of everything else.

Workflow – What does it really entail?

by Frank 8. April 2012 06:00

Workflow has been defined as “the glue that binds business processes together.” Depending upon your background and experience that particular definition may or may not be as clear as mud. Despite having been a key factor in business application processing for a very long time workflow is still very poorly understood by many in business and is more often than not too narrowly defined.

For example, you do not need to pay big bucks for a heavy-duty workflow package and all the services associated with it to implement workflow in your organization. Workflow is really about automating some business process using whatever tool is appropriate. You can automate a business process with Word or Excel or Outlook for that matter and the most common starting point is to first capture a paper document as a digital document using simple tools like a document scanner. You don’t even need a computer (apart from the human brain, the world’s best computer) to implement workflow.

Designing and implementing workflow is more about the thought processes, about evaluating what you are doing and why you are doing it and then trying to figure out a better and more efficient way to do it. It is about documenting and analysing a current business process and then redesigning it to make it more appropriate and more efficient. It is by making it more efficient that you make productivity gains; ideally, you end up doing more with less and adding more value.

You shouldn’t undertake any investigation of new workflows without first having defined objectives and metrics. You should also always begin with some basic questions of your staff or end-users:

  1. What are you doing now that you think could be done better?
  2. What aren’t you doing now that you think you should be doing?
  3. What are you doing now that you don’t think is necessary?

I call these the three golden questions and they have served me well throughout my consulting career. They are simple enough and specific enough that most end-users can relate to them and produce answers. These three simple questions provide the foundation for any business process re-engineering to come. They are also the catalyst to kick off the required thought processes in your end-users. Out of these three simple questions should come many more questions and answers and the information you need to solve the problem.

In every case in the past I have been able to add value well before using tools and creating workflows just by suggesting changes to current manual business processes. As I said earlier, workflow is really about thought processes, “How can I do this in a better and more efficient way?”

Adding value always begins by saving time and money and usually also entails providing better access to information. Real value in my experience is about ensuring that workers have access to the precise information they need (not more and not less) at the precise time they need it (not earlier and not later).  It sound simple but it is the root of all successful business processes, that is, “please just give me what I need when I need it and then I can get the job done.” Modern ‘just-in-time’ automated production lines only work if this practice is in place; it is fundamental to the low cost, efficient and high quality production of any product or service.

When something ‘just works’ very few of us notice it but when something doesn’t work well it frustrates us and we all notice it. Frustrated workers are not happy or productive workers. If we do our job well we take away the sources of frustration by improving work processes to the point where they ‘just work’ and are entirely appropriate and efficient and allow us to work smoothly and uninterrupted without frustration and delays. This should be our objective when designing new workflows.

Metrics are important and should always be part of the project. You begin by taking measurements at the beginning and then after careful analysis, predict what the measurements will be after the project. You must have a way of measuring, using criteria agreed beforehand with your end-users, whether or not you have been successful and to what degree. It is a very bad trades person who leaves without testing his work. We have all had experiences with bad trades people who want to be paid and away before you test the repaired appliance, roof or door. Please do not be a bad trades person.

Metrics are the way we test our theory. For example, “If we re-engineer this series of processes the way I have recommended you will save two hours of time per staff member per day and will be able to complete the contract review and sign off within two days instead of seven days.” The idea is to have something finite to measure against. We are talking quantitative as opposed to qualitative measurement. An example of a qualitative measurement would be, “If we re-engineer this series of processes the way I have recommended everyone will be happier.” Metrics are a quantitative way to measure results.

In summary, implementing workflow should always be about improving a business process; about making it better, more appropriate and more efficient. Any workflow project should begin with the three golden questions and must include defined objectives and quantitative metrics. The most important tool is the human brain and the thought processes that you will use to analyse current processes and design improved processes. Every new workflow should add value; if it doesn’t you should not be doing it.

Critically, workflow must be about improving the lot of your staff or end users. It is about making a process easier, more natural, less frustrating and even, more enjoyable. The staff or end users are the only real judges because no matter how clever you think your solution is if they don’t like it, it will never work.

The Importance of Document Imaging

by Frank 1. April 2012 06:00

 

Document imaging or the scanning of paper documents, has been around a long time. Along with workflow, it was the real beginning of office automation.

Document imaging did for office automation what barcode technology did for physical records management and asset management. That is, it allowed manual processes to be automated and improved; it provided tangible and measurable productivity improvements and as well as demonstrably better access to information for the then fledgling knowledge worker.

Today we have a paradox, whereas we seem to take document imaging for granted we still don’t utilize it to anything like its full capabilities. Most people use document scanners of one kind or another, usually on multi-function-devices, but we still don’t appear to use document scanning nearly enough to automate time-consuming and often critical business processes.

I don’t really know why not because it isn’t a matter of missing technology; we seem to have every type of document scanner imaginable and every type of document scanning software conceivable.  We just seem to be stuck in the past or, we just are not applying enough thought to analysing our day to day business processes; we have become lazy.

Business processes based on the circulation of paper documents are archaic, wasteful, inefficient and highly prone to error because of lost and redundant copies of paper documents; in fact they are downright dangerous. Yet, every organization I deal with still has critical business process based on the circulation of paper. How incredibly careless or just plain stupid is that?

Let’s look at it from the most basic level. How many people can read a paper document at any one point in time? The answer is one and one only. How many people can look at a digital image of a document at any one point in time? The answer is as many as need to. How hard is it to lose or damage a paper document? The answer is it is really, really easy to lose of damage or deface a paper document. How hard is it to lose or damage or deface or even change a secure digital copy of a document? The answer is it is almost impossible in a well-managed document management system.

So why are we still circulating paper documents to support critical business processes? Why aren’t we simply digitising these important paper documents and making the business process infinitely faster and more secure? For the life of me, I can’t think of a single valid reason for not digitising important paper documents. The technology is readily available with oodles of choice and it isn’t difficult to use and it isn’t expensive. In fact, digitizing paper will always save you money.

So why do I still see so many organizations large and small still relying on the circulation of paper documents to support important business processes? Is it a lack of thought or a lack of imagination or a lack of education? Can it really be true that thirty-years after the beginning of the office automation revolution we still have tens of thousands or even millions of so called knowledge workers with little knowledge of basic office automation? If so, and I believe it is true from my observations, then it is a terrible reflection on our public and corporate education systems.

In a world awash in technology like computers, laptops, iPhones and iPads how can we be so terribly ignorant of the application and benefits of such a basic and proven technology as document imaging?

Some of the worst example can be found in large financial organizations like banks and insurance companies. The public perception is that banks are right up there with the latest technology and most people look at examples like banking and payment systems on smartphones as examples of that. But, go behind the front office to the back office and you will usually see a very different world; a world of paper and manual processes, many on the IT department’s ‘backlog’ of things to attend to, eventually.

Here is a really dumb example of this kind of problem. I recently decided to place a term deposit with an online bank. Everything had to be done online and the website didn’t even offer the download of PDFs which would have been useful so you could read through pages of information at your leisure and find out what information they required so you could make sure you had it handy when completing the forms on the website.

I managed to find a phone number and rang them up and asked for the documentation in PDF form only to be told they were paperless and that everything had to be done online. So I persisted going from page to page on the website, never knowing what would be required next until the last page and yes, you guessed right. On the very last page the instructions were to print out the completed forms, sign them and mail them in. Paperless for me; much to my inconvenience and paper for them, again much to my inconvenience.  There is really no excuse for this kind of brainless twaddle that puts the consumer last.  Their processes obviously required a signature on a paper document so the whole pretence of an online process was a sham; their processes required paper.

Hopefully, when they received my paper documents they actually scanned and digitized them but I am willing to bet that if I could get into their back office I would find shelf after shelf of cardboard file folders and paper documents. Hopefully, next time I ring up they can actually find my documents. Maybe I could introduce them to the revolutionary new barcode technology so they could actually track and manage their paper documents far more efficiently?

The message is a simple one. If you have business processes based on the circulation of paper you are inefficient and are wasting money and the time of your staff and customers. You are also taking risks with the integrity of your data and your customer’s data.

Please do everyone a favour and look carefully at the application of document imaging, a well-proven, affordable, easy to implement and easy to manage business process automation tool.

 

Month List