Frankie-the-frustrated worker dealing with lack of direct Line of Business integration and Manual Data Entry

1For this particular blog post I would like to use a light-hearted approach to a major problem.  The problem is lost productivity and user frustration around populating data into Line of Business applications via Manual Data Entry versus Automation.

To illustrate my point let’s take one of the most popular Software as a Service (SaaS) applications ever, Salesforce.com.  And while the application is absolutely simple to use and easy to manage, what lacks is the ability to take information from paper and/or an image and put it directly into Salesforce.com database fields.

 

1.  Let’s take a moment to go through the steps to import data into Salesforce.com and follow the steps Frankie-the-frustrated worker must take to get this task done.
2
2.  Commentary of Frankie-the-frustrated worker:

 

“Frustrating!  Step 1 of 7????”

 

3
3.  Commentary of Frankie-the-frustrated worker:

 

“MORE FRUSTRATING!!!  WASTING TIME!!!”

 

4
4.  Commentary of Frankie-the-frustrated worker:

 

“MORE THAN EVER FRUSTRATED!!!!!!!!!  WASTING TIME, MONEY, AND ENERGY!!!!!!!!!!!” 

 

5
5.  Commentary of Frankie-the-frustrated worker:

 

 “FORGET IT!!!!!!!!!!!! 
 THIS WILL NEVER END!!!!!!!!!!!!!!!!! 
 WHY IS IT LIKE THIS????? 
 ISN’T THERE AN EASIER WAY????????????????” 

 

6

 

Education and modern technology reduce Frankie’s frustration

Are we still living in the stone age when it comes to data entry into computer systems?  Isn’t there a more efficient method to automatically populate data in your software application instead of costly manual data entry?  It’s 2012 after all, not 1912.  Why do we accept such primitive methods of data entry?

 

Answer:  Because we need to educate the market on the capabilities of capture technologies.  We also need to strive to make integration and usage as easy as possible.  If you build it, they will come.

 

7
Eliminating Frankie’s frustration with Ubiquitous Information Capture
Realizing the dream of Ubiquitous Information Capture directly into applications is much easier than you might think but we must educate the market on current capabilities.  The idea is simple, yet highly effective.  Embed the ability to take photos with a smart phone and/or capture paper documents from a scanning device directly into your software application.  Note that all I’ve done in the screen prints below is add a small icon of a camera and scanner directly into my CloudConnectMashup software application.

 

8

 

Now, I can offer my users a truly great user experience because contributing information is nearly effortless and removes pain associated with manual data entry.  This translates directly into reduced operational costs, improved efficiencies and an overall better work environment.

 

9
Think about all the lost opportunities to drastically reduce labor costs, most likely in the billions if not trillions of dollars, associated with manual data entry in just the use cases below:

 

1.  Transportation applications with Bills of Lading, Proof of Deliveries, Trip Sheet or Scale Tickets

 

2.  Field Service applications with Proof of Work delivered, Vehicle Identification Number, Work Orders or Assessment documentation

 

3.  Contracts Management applications with Amendments, Terms and Conditions or License Agreements

 

4.  Invoice Management applications with Invoices, corresponding Packing Lists or Proof of Performance

 

5.  Sales/Contact Relationship Management applications with Business Cards, Agreements or Correspondences

 

Do you know a Frankie in your organization?  Do you have a story, good or bad, to tell?  I’d love to hear your feedback.

 

Thanks,
Kevin

Demystifying Forms Processing and Data Capture

Demystifying Forms Processing and Data Capture

Forms Processing is a proven technology that allows organizations of all sizes to benefit by improving efficiency and decreasing operational costs.  There are many case studies available online to support these facts.  When implemented properly the cost of a Forms Processing solution can easily be justified with a tangible 12-18 month return on investment.  With such overwhelming evidence of decreased operational costs and drastically improved efficiency then a logical question would be why wouldn’t every business in the world be using this wonderful technology?  Traditionally only large organizations with dedicated technical staff and humungous IT budgets could consider implementing a sophisticated Data Capture solution but times are changing.  No longer does it have to take years to realize the benefits of Forms Processing once only available to Fortune 1000 type companies.  In this blog post I hope to dispel the myth that this useful technology is only available to Enterprise organizations.

While the concept of automatically extracting information from a hard copy document is not new, what is new is a different method of implementation.  Specifically, the “cloud” offers an intriguing opportunity for Data Capture.  Why?  First, Data Capture is a very CPU intensive process and the cloud offers unmatched processing power within gigantic data centers.  Second, sharing resources and ‘renting’ a cloud service such as ‘Cloud Capture’ reduces the barrier to entry.  No longer is it the case where the upfront cost to implementing Data Capture should be an issue.  The cost of Data Capture can now be a Operating Expense versus a Capital Expenditure.

I have written previously about the “No Folder Zone” and in this blog post I will elaborate on the solution to avoid using Folders as a cop-out for a truly effective Information Capture solution.  In a traditional installation environment of on-premise software.  After the Forms Processing system is installed, tuned and tested then it is ready for deployment.  This is the point where the Document Capture system Crosses the Chasm and the organization can now truly benefit from the 80% investment and turn this effort into 80% benefit.

The basics of Forms Processing are quite simple and straight-forward.  The idea is to create a template overlay of the form for which you wish to extract information.  As seen in the photo to the left, you would basically draw zones over the image where you can capture typed text (Optical Character Recognition, or OCR), handwritten text (Intelligent Character Recognition, or ICR) or even check boxes (Optical Mark Recognition, or OMR).  After the template is created then the next time the system encounters this type of form then these fields will be automatically captured and eliminate manual data entry.

One of the most important objectives of any data capture system should be the quality of the information being captured versus just the pure speed of the system.  The accuracy of information captured is based on many factors including original document quality, image enhancement or scan resolution but a critical step is to validate, or verify, any questionable data BEFORE it enters your information system.  There are many effective methods to capturing highly accurate data including logic such as a Social Security Number field should contain only numbers instead of letters and, therefore, the number “5” would not be incorrectly recognizing as a letter “S”.  In a perfect world you would hope for no verification at all but this is simply not reasonable all the time.  A good rule of thumb is that 2% verification is acceptable which means 98% of work is done for you quickly and automatically.  This translates into major efficiency gains.

A key misconceptions about Data Capture, or Forms Processing, is that the integration into back-end systems needs to be complicated or costly.  While this could be true the fact of the matter is that all electronic information systems rely on some flavor of a database.  And basically a database is composed of a bunch of tables with fields.  In context of Forms Processing think about a table of Document Types.  Then in the Document Types table you have the various types of documents you wish to capture and the Fields are the index values you wish to extract from an image.  So the real magic is “matching” the extracted index values to the fields in the database.  I think the term “Field Mapping” most accurately describes this integration of Data Capture technology with Electronic Information Systems.  Fortunately, new trends in open connectivity such as Web Services and Content Management Interoperability Services (CMIS) is making the connectivity between Capture and Storage much more affordable and less time-consuming than ever.

As I mentioned earlier in this blog post, all applications have some flavor of a database to store information.  It’s just a fact of how things operate and if you really think about it all we have to do is match Data Capture fields with database fields to make a fully integrated Data Capture solution.  Often times we get wrapped-around the axel on the technical details but when we simply integration to it’s lowest common denominator then we can truly dispel the myth that Forms Processing is too complicated or expensive for everyone to utilize.

Now that I’ve covered the basics of Forms Processing and illustrated the fact that interoperability can be achieved rather easily in certain cases, I hope that we can move out of the stone ages of manual data entry and realize a truly efficient organization with Automatic Data Capture.

AIIM has just published a whole suite of educational videos on a collection of interesting topics including one on Information Capture (http://www.aiim.org/Training/Certification/Get-Trained/Videos/Capture-Manage).