OCR data gathering - how?

I need to look at a solution to gather information from some single page forms via scanner and import the results into Excel.

The forms are single page and consist of multi-choice tickbox answers. I need to be able to feed them into a scanner and have them imported into an Excel spreadsheet to increment totals so I can analyse the answers.

I.E. forms are fed in and I get a total of how many A,B,C,D or E answers there are for each question on the forms.

I realise this will probably require some dedicated software to produce but need some pointers as to what I will need and how it can be done.

Any suggestions
LVL 1
mtechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jaakovsCommented:
ABBYY makes the most recognized applications for optical character recognizion, but beware, they're also quite expensive. I have used ABBYY for many OCR purposes, but unfortunately not like how you attempt to use an OCR program, but I do recommend the ABBYY program, as it is quite smart in converting its data, and might also be able to convert it to Excel data.

See: http://www.abbyy.com/finereader8/?param=44890
0
mtechAuthor Commented:
jaakovs
Thanks for that but Abbyy is a normal OCR recognition program. I dont want to scan a copy of the form but identify the unique data entered on it i.e. the A's B's and C's of the question answers.
0
nobusCommented:
we did something a like like this :
1- scan document
2-display document on screen
3-select wanted area(s)
4-copy  info from selected area to txt file
what we used to accomplish this is a macro, and a program allowing us to apply OCR to the selected areas
the program was Kleptomania :

www.structurise.com/kleptomania/
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

mtechAuthor Commented:
nobus
Looks like a useful tool but we need this to be automated so we feed in the forms and gather the results - like they use for surveys or marking multi-choice exam papers
0
nobusCommented:
well, i pointed out how we did it, and i hapo it helps you a bit further. And it was a fully automated process, but we got the info directly on the screen, not from a scan. But i think a programmer can help you out here.
0
mtechAuthor Commented:
Looks like I have identified a product that will do what I need:
http://www.acumensoft.com/ver2.htm
Data goes straight from scanner to data file - if it does what it says that is!

Thanks for the suggestions
0
nobusCommented:
No problem - i hope i helped to solve your problem !
0
samb39Commented:
Scantron is the product we used for that, and it worked very well.  But you need use special forms, or use their software to make your own.
0
noam_dzCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Irwin SantosComputer Integration SpecialistCommented:
What you want is a combination of 2 programs
http://www.digitalriver.com/v2.0-img/operations/scansoft/site/html/omnipage/omnipage_pro15_pp_promo.html

Omnipage which does the OCR, then use Paperport, which is used for filing.

Paperport can transpose data to whatever format you want.  So if you create a "pre-formed xls" file, for example

 T   F   I'm hungry
[x] [ ]

 T   F   I'm feverish
[ ]  [x]

you can take the values of the pre-selected areas of a template, and export the data to a .csv file.  In excel you can import via VBA/macro, interpret the file and populate your spreadsheet.

Paperport also allows you to setup keywords and database so that whatever is filed, can be retrieved (document management)
0
noam_dzCommented:
FormReader whixh I gave as an answer is correct for this q.
0
mtechAuthor Commented:
I had missed closing this question - sorry for the delay. noam_dz was right - FormReader is the best fit for our needs
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.