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


To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures.
Zell is offline   Reply With Quote
Old 06-22-2009, 17:14   #2
IndyGunFreak
KO Windows
 
IndyGunFreak's Avatar
 
Join Date: Jan 2001
Location: Indiana
Posts: 30,139
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:
Ronald Reagan
"If we ever forget that we are One Nation Under God, then we will be a nation gone under."
"Man is not free unless Government is limited"
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,399
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.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures.
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,764
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.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures.
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 10:10.




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


Users Currently Online: 1,185
305 Members
880 Guests

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