Using Terminal Digits to minimize “Squishing”

by Frank 13. May 2012 06:00

Have you ever had to remove files from shelving or cabinets and reallocate them to other spaces because a drawer or shelf is packed tight? Then had to do it again and again?

One of my favourite records managers used to call this the “Squishing” problem.

The squishing problem is inevitable if you start to load files from the beginning of any physical filing system, be it shelving or cabinets and unload file files from random locations as the retention schedule dictates. If you create and file parts (a new folder called part 2, part 3, etc., when the original file folder is full) then the problem is exacerbated. You may well spend a large part of your working life shuffling file folders from location to location; a frustrating and worthless, thankless task. You also get to inhale a lot of toxic paper dust and mites which is not a good thing.

You may not be aware of it but there is a very simple algorithm you can utilize to make sure the squishing problem never happens to you. It is usually referred to as the ‘Terminal Digit’ file numbering system but you may call it whatever you like. The name isn’t important but the operation is.

Importantly, you don’t need to change your file numbering system other than by adding on additional numbers to the end. These additional numbers are the terminal digits.

The number of terminal digits you need depends upon how many file folders you have to manage. Here is a simple guideline:

·         One terminal Digit (0 to 9) = one thousand files

·         Two Terminal Digits (00 to 99) = ten thousand Files

·         Three Terminal Digits (000 to 999) = greater than ten thousand files

Obviously, you also have to have the filing space and appropriate facilities available (e.g., boxes, bays, etc.,) to hold the required number of files for each terminal.

It is called the Terminal Digit system because you first have to separate your available filing space into a number of regular ‘terminals’. Each terminal is identified by a number, e.g., 0, 1, 2, 09, 23, 112, 999, etc.

The new terminal digit is additional and separate from your normal file number. It determines which terminal a file will be stored in. Let’s say your normal file number is of the format YYYY/SSSSSS. That is, the current year plus an automatically incrementing auto number like 2012/000189 then 2012/000190, etc. If we use two terminal digits and divide your available filing space into one hundred terminals (think of it as 100 equally sized filing slots or bays numbered 00 to 99) then your new file number format is YYYY/SSSSSS-99. The two generated file numbers above may now look like 2012/000189-00 and 2012/000190-01.

File folder 2012/000189-00 is filed in terminal number 00 and 2012/000190-01 is filled in terminal number 01. In a nutshell, what we are doing is distributing files evenly across all available filing space. We are not starting at terminal 00 and filling it up and then moving on to terminal 01, then terminal 02 when 01 is full etc. Finding files is even easier because the first part of the file number you look at is the terminal digit. If a file number ends in 89 it will be in terminal 89 in file number order.

The other good news is that when we unload files from the shelves say at end of life or at the point in the lifecycle when they need to sent offsite we will also unload files evenly across all available filing space. If the terminals are actually big enough and if you have calculated everything correctly you should never again suffer from the ‘squishing’ problem and you should never again have to ingest paper dust and mites when tediously shuffling files from location to location.

Obviously, there is a little more to this than sticking a couple of digits on the end of your file number. I assume you are using a computerised records management system so changes have to be made or configured to correctly calculate the now extended file number (including the new terminal digit) and your colour file labels will need to be changed to show the terminal digit in a prominent position.

There is also the question of what to do with your existing squished file store. Ideally you would start from scratch with your new numbering systems and terminals and wait for the old system to disappear as the files age and disappear offsite to Grace or Iron Mountain. That probably won’t be possible so you will have to make decisions based on available resources and budget and come up with the best compromise.

I can’t prove it but I suspect that the terminal digit system has been around since people began filing stuff. It is an elegantly simple solution to an annoying and frustrating problem and involves nothing more complicated than simple arithmetic.

The surprise is that so few organizations actually use it. In twenty-five plus years in this business I don’t think I have seen it in use at more than one to two-percent of the customers I have visited. I have talked about it and recommended it often but the solution seems to end up in the too-hard basket; a shame really, especially for the records management staff charged with the constant shuffling of paper files.

It may be that you have a better solution but just in case you don’t, please humour me and have another look at the terminal digit filing solution. It may just save you an enormous amount of wasted time and make your long-suffering records staff a lot happier and a lot healthier.

 

Have you considered Cloud processing? There are significant benefits

by Frank 6. May 2012 06:00

Most of us have probably become more than a little numbed to the onslaught of Cloud advertising and the promotion of the ‘Cloud’ as the salvation for everyone and the panacea for everything. The Cloud is promoted by its aggrandizers as being both omnipotent and omniscient; both qualities I only previously associated with God.

This is not to say that moving business processing to the Cloud is not a good thing; it certainly is. I just wish that the promoters would tone down the ‘sell’ and clearly explain the benefits and advantages without the super-hype.

Those of us with long memories clearly recall the early hype about what was then called ASP or Application Service Processing or even Application Service Provider. This was the early progenitor of the Cloud and despite massive hype it did not fly. The reasons were simple, neither the technology nor the software (application and system) were up to the job. Great idea, pity it was about five years before its time.

Unfortunately, super-hype in our industry is usually associated with immature and unproven technology. Wiser, older people nod sagely and then wait a few years for the technology to catch up with the promises.

As an older (definitely) and wiser (hopefully) person I am now ready to accept that all the technology required for successful and secure Cloud processing is now available and proven; albeit being ‘improved’ all the time so still take care not to rush in with experimental technology.

As with many new technologies the secret is KISS; Keep It Simple Stupid. If it seems too complex then it is too complex. If the sales person can’t answer all of your questions clearly and unambiguously then walk away.

Most importantly, make sure you know all about all of the parties involved in the transaction. For example:

1.    What is the name of the data centre?

2.    Where is it located?

3.    Who ‘owns’ the rack and equipment and software at the data centre?

4.    What are the redundant features?

5.    What are the backup and recovery options?

6.    Is your vendor the owner of the co-hosted facility or do they subcontract to someone else? If they sub-contract is the company they subcontract to the owner or are they too just part of a chain of ‘hidden’ middle-men? It is critical for you to understand this chain of responsibility because if something goes wrong you need to know who to chase.

There are a lot more questions you need to ask but this Blog isn’t the place to list them all. I am sure your IT team and application owners will come up with plenty more. If they don’t, wake them up and demand questions.

Most small to medium organizations today simply do not have the time or expertise to run a computer room and manage and maintain a rack of servers. There is also a dearth of ‘real’ expertise and a plethora of phonies out there so hiring someone who is actually smart enough to manage your critical infrastructure is a very difficult exercise made more so by most business owners and managers simply not understanding the requirements or technology. It often becomes a case of the blind hiring the almost blind.

Most small to medium enterprises also cannot afford the redundancy required to ensure a stable and reliable infrastructure. A fifteen minute UPS is no substitute for a redundant bank of diesel generators and a guaranteed clean power supply.

Why should small to medium enterprises have to buy servers and networks and IT support? It isn’t part of their core business and this stuff should not be weighing down the balance sheet. Why should they be devoting scarce and expensive management time to activities that are not part of their core business?

In-house computer rooms will soon be become as rare as dinosaurs and this is how it should be, they are an anachronism in this time and age; out of time and out of place.

All smart and business savvy small to medium organizations should be planning to progressively move all their processing to the Cloud so as to lower costs, improve service levels and reduce management stress. I say progressively because it is still wise to get wet slowly and to take little steps. Just like with your first two-wheel bicycle, it pays to practice with the training wheels on first. That way, you usually avoid those painful falls.

I like to think I am a little wiser because I still have scars from gravel rash when I was a kid. I am moving my RecFind 6 customers to the Cloud and I am moving my in-house processing to the Cloud but just like you, I am doing it slowly and carefully and triple-checking every aspect. I don’t take risks with my customers or my business and neither should you.

One last thing, I have the advantage of being very IT literate and of having a top IT team working for me so we have the in-house expertise required to correctly evaluate and select the most appropriate technology and options. If you do not have this level of in-house IT expertise then please take extra care and try to find someone to assist who does have the level of IT knowledge required. Once you sign up, it is too late. Buyer’s remorse is not a solution to any problem.

Physical Records Management Systems – Why?

by Frank 18. March 2012 06:00

Twenty-eight years ago we released our first records management product, DocFind I.

Twenty-six years ago we released the first version of our iconic records management product RecFind 1.0.

Twenty-five years ago we released our first imaging enabled records management product, ImageFind 1.0.

Thirteen-years ago we shipped our first fully featured Electronic Document and Records Management Solution (EDRMS) with a full complement of records, document, imaging and workflow functionality, RecFind 3.2.

Twenty-five years ago I used to do a lot of trade show and seminar presentations about the coming paperless office yet here we are today with more paper records in existence than I would have ever imagined all those years ago. The fabled paperless office as far away now as it has ever been.

It isn’t because of a lack of functionality to deal with the problem. Most of the other vendors did what we did and produced products merging records, document and imaging functionality many years ago so the functionality to facilitate the paperless office has been around for a very long time. Yet, governments and private companies are still using paper as records and are still using and storing billions of sheets of paper each year. Organizations like Iron Mountain and Crown are rushing to build new warehouses all over the world to store boxes of paper records and there seems to be no end in sight. We are drowning in paper.

In order to understand why we are still storing millions of boxes of paper every year we have to ask ourselves two very important questions:

  1. What are we (still) doing we shouldn’t be doing?; and
  2. What is it we should be doing that we are (obviously) not doing?

Answering number one is easy; we are still using paper and are using it at a rate many, many times that of twenty-five years ago.

Answering number two is also easy; we are not taking advantage of available technology.

The next and most important question to ask is why? Why are we still using paper and why aren’t we taking advantage of available technology?

I have pondered the above questions for a long time and have discussed them at length with my customers and staff and associates in the industry for many years. Whereas you are likely to get any number of responses from industry experts, I am going to narrow it down to four simple issues.

  1. Paper is actually still a great medium for many applications and its convenience, cost and flexibility is hard to beat;
  2. Most electronic document management systems on the market today are expensive to buy, difficult and expensive to roll out, difficult to use and difficult to maintain;
  3. Most EDRMS implementations fail (albeit over time) because very few organizations budget for or are prepared to pay the huge ongoing cost to retrain workers as software changes or train new workers as staff turns over; and
  4. Records management is not a core business activity in most organizations and it is seen as a cost centre, not a profit centre so it gets little senior management attention and little funding.

Basically, in most large organizations senior management is aware of the paper problem but it is not high on their agenda and it is easier to just maintain the status quo; keep packing files into boxes and sending them off to Iron Mountain. It is a lot like the Greek Debt problem, that is, keep ignoring the problem and leave it to someone in the future to solve.

To summarize, management says, “It works and isn’t my major priority so I will leave it for someone else to solve.” Or, applying that time-honoured old maxim, “If it ain’t broke, don’t fix it.”

The reality is that we have to find ways to manage paper. The additional reality is that very few of the ECM/EDRMS software packages on the market today do the job well or even at all. SharePoint 2010 for example is hopeless at managing physical records so don’t even think about paying a consultant hundreds of thousands of dollars to configure it for you to solve the problem.

Luckily for us, and largely because we started developing applications for physical records management back in 1984, we have incorporated a rich subset of physical records management functionality (our legacy if you may) into our latest product suite, RecFind 6.  This means we are one of the few vendors with a product that can easily handle any physical records management requirement.

Also, and this still surprises me, we are receiving more and more inquiries for a product that just does physical records management. To be honest, if anyone had told me twenty-five years ago that I would still be receiving requests for a physical records management product in 2012 I would have laughed at them. Yet, here we are today in a world swimming in paper with organizations all around the world desperately needing to solve a paper records management problem.

Now I am really glad that I insisted that my design teams maintain upwards compatibility through all of our product releases and that they should continue to refine and improve our physical records management capabilities.

I hope I am happily retired in another twenty-five years but just in case I am not, I will set myself a reminder to re-read this post and once again review how far we have progressed in replacing paper records with digital records. With luck, I will be living in a luxury apartment converted from an old Iron Mountain warehouse and there won’t be a sheet or paper or archive box in sight.

What will they do with all those warehouses?

Month List