GlockTalk.com
Home Forums Classifieds Blogs Today's Posts Search Social Groups



  
SIGN-UP
Notices

Glock Talk
Welcome To The Glock Talk Forums.
Reply
 
Thread Tools Display Modes
Old 06-22-2009, 17:09   #1
Zell
IrregularMember
 
Zell's Avatar
 
Join Date: Apr 2007
Location: Utah
Posts: 6,582
Need Tech Help -- Not a basic tech question

I work for a company that has a hardcopy directory of people's names, addresses, phone #s, and email addresses. This directory is in print/paper form, but not available in softcopy/digital form.

Somehow, I need to get all of this contact information, or at least the names and addresses, from the hardcopy directory into an Excel spreadsheet where this information can then be edited and sortable.

I tried digitally "scanning" the text information from the hardcopy directory but that only scans the "image" of the text and does not convert the scanned text into editable/sortable information after it is pasted onto a spreadsheet. Obviously, other than hand-typing all of this information into Excel, I need to scan the data and somehow get it into Excel to be edited. But how do I do that?

Any suggestions on how to do this? Your help would be greatly appreciated.
__________________
Zell

mormon.org
Zell is offline   Reply With Quote
Old 06-22-2009, 17:14   #2
IndyGunFreak
RIP My Friends
 
IndyGunFreak's Avatar
 
Join Date: Jan 2001
Location: Indiana
Posts: 29,697
Send a message via ICQ to IndyGunFreak Send a message via AIM to IndyGunFreak Send a message via MSN to IndyGunFreak Send a message via Yahoo to IndyGunFreak Send a message via Skype™ to IndyGunFreak


Quote:
Originally Posted by Zell View Post
I work for a company that has a hardcopy directory of people's names, addresses, phone #s, and email addresses. This directory is in print/paper form, but not available in softcopy/digital form.

Somehow, I need to get all of this contact information, or at least the names and addresses, from the hardcopy directory into an Excel spreadsheet where this information can then be edited and sortable.

I tried digitally "scanning" the text information from the hardcopy directory but that only scans the "image" of the text and does not convert the scanned text into editable/sortable information after it is pasted onto a spreadsheet. Obviously, other than hand-typing all of this information into Excel, I need to scan the data and somehow get it into Excel to be edited. But how do I do that?

Any suggestions on how to do this? Your help would be greatly appreciated.
Hire some data entry temps..

IGF
__________________
Quote:
Originally Posted by GioaJack View Post
The fire is no longer my major concern since I am leaving immediately on an unexpected road trip to Indianapolis. Watch the national news over the next couple of days, I'll wave... well, only if I'm cuffed in the front.
RIP Jack
IndyGunFreak is offline   Reply With Quote
Old 06-22-2009, 17:35   #3
grokdesigns
Senior Member
 
grokdesigns's Avatar
 
Join Date: Dec 2004
Location: Chandler, AZ
Posts: 563
You need OCR software to turn the scanned images into editable text. ABBYY FineReader is one that works well from what I've seen.
grokdesigns is offline   Reply With Quote
Old 06-23-2009, 11:01   #4
Linux3
Senior Member
 
Linux3's Avatar
 
Join Date: Dec 2008
Posts: 1,396
It's been my experience that most scanners come with OCR, Optical Character Recognition software.
Seldom perfect but you would just have to clean up mistakes rather than typing the whole thing.

Check your scanner manufacturer's website.
__________________
It it's not on fire,
It's a software problem.

Linux3 is offline   Reply With Quote
Old 06-23-2009, 11:25   #5
Blitzer
Cool Cat
 
Blitzer's Avatar
 
Join Date: Jan 2004
Location: The communist's play ground of OHIO
Posts: 26,617
Send a message via AIM to Blitzer Send a message via Yahoo to Blitzer
Quote:
Originally Posted by Zell View Post
I work for a company that has a hardcopy directory of people's names, addresses, phone #s, and email addresses. This directory is in print/paper form, but not available in softcopy/digital form.

Somehow, I need to get all of this contact information, or at least the names and addresses, from the hardcopy directory into an Excel spreadsheet where this information can then be edited and sortable.

I tried digitally "scanning" the text information from the hardcopy directory but that only scans the "image" of the text and does not convert the scanned text into editable/sortable information after it is pasted onto a spreadsheet. Obviously, other than hand-typing all of this information into Excel, I need to scan the data and somehow get it into Excel to be edited. But how do I do that?

Any suggestions on how to do this? Your help would be greatly appreciated.
A search for OCR software that is targeted for comma delimited text output. (see this link for Optical Character Recognition)
__________________
It doesn't matter what the Joe on the street thinks, it is who pays the biggest bribes to the electoral college gets elected as President! :crying:
Blitzer is offline   Reply With Quote
Old 06-23-2009, 13:15   #6
MavsX
The Dude Abides
 
MavsX's Avatar
 
Join Date: Jan 2009
Location: Arlington, VA
Posts: 3,033
yeah i was going to post OCR as well. we use omnipoint version like 16 or something. Well, i don't use it. But the girls here use it. It's pretty cool. They scan documents in our copier as pdfs. Then open the pdfs up in omni page. Then that can convert it to a .doc and there you go.

good luck man
__________________
Glock 22 .40 S&W
CMMG M4 LEP II
Mossberg 500 Mariner
MavsX is offline   Reply With Quote
Old 06-23-2009, 13:41   #7
solomansousana
Senior Member
 
solomansousana's Avatar
 
Join Date: Oct 2007
Location: Hampton, Virginia
Posts: 1,614
Quote:
Originally Posted by grokdesigns View Post
You need OCR software to turn the scanned images into editable text. ABBYY FineReader is one that works well from what I've seen.

+1. I use this to scan patient medical records into digital patient records because sometimes, as an RN, I'm required by hospital to make home visits and use old charting methods.
__________________
לפעמים אדם מוצא את גורלו על הדרך אותה הוא לקח בכדי להימנע ממנו(Sometimes a man can meet his destiny on the road he took to avoid it)
solomansousana is offline   Reply With Quote
Old 06-24-2009, 09:43   #8
Green_Manelishi
Knicker Knotter
 
Green_Manelishi's Avatar
 
Join Date: May 2006
Location: On the edge but not quite over ...
Posts: 6,595
Scanning text into doc

Assuming your company does not pay some poor soul to verify the results of the scan, make certain to keep the hardcopy around somewhere so it can be referenced. The scanners are good but not perfect.
Green_Manelishi is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT -6. The time now is 17:03.



Homepage
FAQ
Forums
Calendar
Advertise
Gallery
GT Wiki
GT Blogs
Social Groups
Classifieds


Users Currently Online: 1,213
384 Members
829 Guests

Most users ever online: 2,244
Nov 11, 2013 at 11:42