Using barcodes to raise productivity and lower costs in Records Management processes

by Frank 6. August 2014 06:00

Did you know that in the spring of 1969 the first true bar code systems were installed? One went into a General Motors plant in Pontiac, Michigan, where it was used to monitor the production and distribution of automobile axle units. The other went into a distribution facility run by General Trading Company in Carlsbad, New Jersey, to help direct shipments to the proper loading-bay doors.

Did you also know that the very first product to be sold with a barcode and scanner was a single packet of chewing gum at a Marsh supermarket in Troy, Ohio on June 26, 1974?

Both these interesting facts came from an excellent article on the history of barcodes by Tony Seideman. Please see this link.

The overall advantages and benefits of barcodes are well known; speed, accuracy, ease of implementation and cost-effectiveness.

In a nutshell, barcodes are cheap to produce, easy to implement and easy to read. They are infinitely better than a human keying in information. Barcodes are reliable and they just work.

Modern supermarkets simply couldn’t function without barcodes on products and barcode readers at checkouts.

Most well-run records management facilities also use barcodes to great advantage to track file-folders and boxes, run audits and speed up the entering of information. Most offsite records storage facilities use barcodes to track boxes on shelves. It is what we call a “no brainer.”

However, despite the obvious benefits, especially the cost benefits, many organizations today still manage physical assets bereft of barcodes. You may well ask “why?” and so do I. Given the low cost of both barcodes and barcode readers and the well-proven technology, I honestly can’t think of any reason for not using barcoding technology to manage physical assets like file-folders and archive boxes. It just doesn’t make any sense whatever to me. It is analogous to running ten miles to deliver a message rather than just phoning or texting. How many messages a day can you deliver by running and how many can you deliver a day by phoning or texting?

Why ask staff to write down file-folder numbers or enter them on a keyboard when you can ‘wand’ or 'scan' them much more accurately and infinitely faster using a barcode reader? Why put up with processing 20 file movements a day by hand when you can easily process 200 a day using a barcode reader?

If you have 30 file-folders on your desk that you have to process why would you do it manually by keying in each file number (and making mistakes) over 30 minutes when you could process the same number of file-folders in 30 seconds using a fixed barcode reader (and not making any keying mistakes)?

When you have 500 file-folders to add to archive boxes provided by your offsite storage provider why would you take hours to do it laboriously with lists and the keyboard when you could do it in minutes using a barcode reader? Simply use your portable barcode reader to read the box barcode then read each file-folder barcode number as you add it to the box and then read the box number again when finished to complete the transaction. What could be faster or simpler?

So, what do you need to convert your slow and error-prone manual-entry records management processes to fast and accurate barcode-enabled processes?

1.       A records management software package that supports barcodes (I don’t know of any modern RM system that doesn’t)

2.       *A supply of pre-printed barcodes (or you can print them out of your records management software package)

3.       Some fixed or wedge barcode readers (expect to pay $150 to $250 each)

4.       One or more portable barcode readers (expect to pay $1,000 to $2,000 including cables, battery chargers, etc.)

*A word on barcode labels. It pays to make them as durable as possible. This usually means laminating them as un-laminated barcodes produced on a laser printer tend to have a short life expectancy. The easiest way to obtain high quality, laminated barcode labels is to order them from a specialist print house. This way you can specify exactly what you need in terms of format and size and be assured of a long life and reliability. Nothing frustrates more than a worn barcode that doesn’t read properly.

Of course someone has to stick the barcode label on the file-folders and then tell the computer system (i.e., file-folder number AB/2003/00067 is now barcode number 1000049). You have a choice of how to do this. If you don’t have too many file-folders you can bite the bullet and add them all as a special project. Or, you can decide just to add them to every new file-folder created and to add barcodes to existing file-folders when they cross your desk. It is your decision based on volume and resources. However, you need to invest the effort to reap the benefits.

Then if you really want to benefit you will assign a different class of barcode to ‘locations’. That is, offices, shelves, rooms, etc., and even people. This is so you can do an audit on a regular basis using your portable barcode reader. Wouldn’t it be nice to know where everything is and even, where some things aren’t?

Finally, assign yet another set of barcodes to your archive boxes so it is as easy and as fast as possible to move file-folders into and out of archive boxes.

The above describes just the simplest application of barcodes but even so, the benefits and cost savings are significant. The more creative of you will comes up with many more ways to make barcodes pay big dividends. We have one customer for example, that automatically allocates barcodes to emails in Outlook to make them easier to monitor and track both electronically and physically. See this link:

Barcodes are simple to use, low cost and well-proven, ‘risk-free’ technology. The effective use of barcodes and barcode readers can remove drudgery, lower costs and massively improve productivity.

If you aren’t using barcodes your boss should be asking you “why not?”

Records Management in the 21st century; you have computers now, do it differently

by Frank 1. June 2013 06:32

I own and run a computer software company called the Knowledgeone Corporation and we have specialised in what is now known as enterprise content management software since 1984 when we released our first product DocFind. We are now into the 8th iteration of our core and iconic product RecFind and have sold and installed thousands of RecFind sites where we manage corporate records and electronic documents.

I have personally worked with hundreds of customers to ensure that we understand and meet their requirements and I have also designed and specified every product we have delivered over the last 29 years so while I have never been a practicing records manager, I do know a great deal about records and document management and the vagaries of the practise all around the world.

My major lament is that many records managers today still want to run their ‘business’ in exactly the same way it was run 30 or 50 or even a hundred years ago. That is, as a physical model even when using computers and automated solutions like our product RecFind 6. This means we still see overly complicated classification systems and overcomplicated file numbering systems and overcomplicated manual processes for the capture and classification of paper, document images, electronic documents and emails.

It is a mindset that is locked in the past and can’t see beyond the confines of the file room.

I also still meet records managers that believe each and every employee has a responsibility to ‘become’ a junior records manager and both fully comprehend and religiously follow all of the old-fashioned and hopelessly overcomplicated and time-consuming processes laid out for the orderly capture of corporate documents.

I have news for all those locked-in-the-past records managers. Your approach hasn’t worked in the last 30 years and it certainly will not work in the future.

Smart people don’t buy sophisticated computer hardware and application software and then try to replicate the physical model for little or no benefit. Smart people look at what a computer system can do as opposed to 20,000 linear feet of filing shelves or 40 Compactuses and 30 boxes of filing cards and immediately realize that they have the power to do everything differently, faster, most efficiently and infinitely smarter.  They also realize that there is no need to overburden already busy end users by a forcing them to become very bad and very inconsistent junior records managers. End users are not hired to be records managers they are hired to be engineers, sales people, accountants, PAs, etc., and most already have 8 hours of work a day without you imposing more on them.

There is always a better way and the best way is to roll out a records and document and email management system that does not require your end users to become very bad and inconsistent junior records managers. This way it may even have a chance of actually working.

Please throw that old physical model away. It has never worked well when applied to computerised records, document and email management and it never will. Remember that famous adage, “The definition of insanity is to keep doing the same thing and to expect the results to be different”?

I guarantee two things:

1.     Your software vendor’s consultant is more than happy to offer advice and guidance; and

2.     He/she has probably worked in significantly more records management environments than you have and has a much broader range of experience than you do.

It doesn’t hurt to ask for advice and it doesn’t hurt to listen.

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.

 

Month List