Question about Computers & Internet

2 Answers

How do i use omnipage pro 14 (software) to OCR a .pdf file and extract data to an excell format file?

Posted by on

  • paulwinford Aug 22, 2008

    here is the text of the chat that I did with the fixya expert. please help if you can?






    Technical Support, Instructions & Repair Service





    Chat session in progress.
    Hi. I am Bubbabear64 and I will be assisting you with your problem.
    Bubbabear64 says:
    Hi paul

    paulwinford says:
    cool

    paulwinford says:
    hi

    Bubbabear64 says:
    This is easy

    Bubbabear64 says:
    Does Omnipage support pdf?

    paulwinford says:
    it seems to

    Bubbabear64 says:
    It would be clear on the box if they did

    Bubbabear64 says:
    You just want to scan to PDF?

    paulwinford says:
    it is. i can load the .pdf file ( its a bank statement) the run the ocr process then select an ouput type but the file does not come out in a form that has enough info to be usefull

    Bubbabear64 says:
    Hmmmm.

    paulwinford says:
    it comes out as a .csv file currently

    Bubbabear64 says:
    really

    paulwinford says:
    because i selected that option.

    Bubbabear64 says:
    I got a few customers out there looking for something like this

    paulwinford says:
    my goal would be to be able to scan this 54 page .pdf file and extract the line items into an excell spread sheet

    Bubbabear64 says:
    Usually PDF is nothing more than a fancy graphics file format that Adobe like to charge people bick bucks to work with.

    paulwinford says:
    each line item is three lines thick and has transaction numbers and

    Bubbabear64 says:
    ok

    paulwinford says:
    ammounts and stuff all in collumns but how do i create that into a spreadsheet

    Bubbabear64 says:
    Doesn't Adobe make something to do this with?

    Bubbabear64 says:
    ok

    paulwinford says:
    ?

    Bubbabear64 says:
    I was looking at this PDF Converter 5 on Nuancestore.

    paulwinford says:
    i could look ? can I log back into a chat session layter?

    Bubbabear64 says:
    Says that it converts PDF files into fully formatted Excel spreadsheets

    paulwinford says:
    I tried that one and it did not pickup any txt in my pdf file

    Bubbabear64 says:
    I wonder if OCR is a good idea.

    paulwinford says:
    it says that this image contains no text

    Bubbabear64 says:
    Bummer

    paulwinford says:
    but omnipage picks up the txt

    Bubbabear64 says:
    yes

    paulwinford says:
    but how do i get it into the table format ?

    Bubbabear64 says:
    but the problem with Acrobat is that text isn't text, it's graphics

    Bubbabear64 says:
    What you need is a program that will convert it into text. It will probably work with an Adobe program

    Bubbabear64 says:
    Lets see

    paulwinford says:
    yep thats where the ocr comes into play and the sophistication of each software package like omnipage may or may not work

    Bubbabear64 says:
    .com

    Bubbabear64 says:
    I'm looking some stuff up here

    Bubbabear64 says:
    What version of Excel are you using?

    paulwinford says:
    FYI. this .pdf file is truely an image. it was nor created with ( adobe) it was scanned from a minolta copier which uses a license from adobe to convert scanned images to .pdf files

    paulwinford says:
    excell 2003

    Bubbabear64 says:
    Youre in luck, Im an NEC dealer

    Bubbabear64 says:
    which makes copiers for Minolta

    Bubbabear64 says:
    which model are you using?

    paulwinford says:
    konica minolta ??? we cal it the 501.

    Bubbabear64 says:
    Have you tried using Tiff on the copier to scan in?

    paulwinford says:
    no do you think that would help with the OCR?

    Bubbabear64 says:
    It might because Word can convert it into OCR that way.

    Bubbabear64 says:
    Have you ever used the Microsoft scanner software?

    paulwinford says:
    are there any special instructions to open a .tif file with work besides right click on the file and open with (word) ?

    paulwinford says:
    yeah ive used that software

    paulwinford says:
    i'm a network admin FYI

    Bubbabear64 says:
    I used to work with this file format for Microsoft projects.

    Bubbabear64 says:
    Me too

    Bubbabear64 says:
    There shouldn't be

    paulwinford says:
    ok i'll try .tif format and MSword 2003

    Bubbabear64 says:
    I did this once where I took a set of labels, scanned them and converted them into an Excel file.

    Bubbabear64 says:
    ok

    Bubbabear64 says:
    It may slip up a bit but it can be corrected

    paulwinford says:
    is there anywhwere on this service where we can leave this question open for someone who might be able to answer this question definatively?

    Bubbabear64 says:
    You can post it.

    Bubbabear64 says:
    on the regualar forum

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

Something went wrong with my pdf reader. I wanna convert pdf to text first. Any suggestion will be appreciated. Thanks in advance. How about this one?
http://www.pqscan.com/pdf-to-text

Posted on Feb 28, 2016

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 2,794 Answers

By the way, if you can get Omnipage to convert it into a csv file it will import into excell as long as the end of line is marked. You might be able to write a VB script to get it to mark it if it doesn't.

Posted on Aug 22, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

5 Answers

How Repair of Excel file?


If there was such problem, the simplest decision is described here:
http://www.excel.repair/ - Excel Repair Kit. A Microsoft Excel repair tool for corrupted Excel spreadsheets. Program open, read and save data from damaged Excel files.
If at you it didn't turn out to solve a problem, it is possible to try to solve it otherwise:
1. Click the Microsoft Office Button Office button image, and then click Open.
2. In the Open dialog box, select the corrupted workbook that you want to open.
3. Click the arrow next to the Open button, and then click Open and Repair.
4. Do one of the following:
3. To recover as much of the workbook data as possible, click Repair.
(a) To recover as much of the workbook data as possible, click Repair.
(b) To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.

Oct 17, 2015 | Computers & Internet

1 Answer

I have a project going in my company. I want psion teklogic to automatically send the scanned data into Excel. Please help me in understanding how can I do this ?


you may need an ocr to excel software converter
http://www.simpleocr.com/OCR_to_Excel
in excel you would have a work book that you put the resulting scan into as an excel format. Then you have another workbook that is referenced to the workbook and particular cell with part number
then you would have a workbook with a list of cells part number and pdf files .
then lookup function would take part number and use it to lookup from the reference list.

Mar 28, 2014 | Psion Teklogix 7535 G1 WiFi PDA w/Long...

1 Answer

Can the scanner software scan to pdf file


en.. try PDF Editor Software Pro,Best PDF Editor Software for Mac,adds OCR technology, covers all the PDF editing power and the 6-in-1 PDF conversion functions on the basis of the standard version, PDF Editor Software, to provie you a smarter way in dealing with PDF documents.
PDF Editor Software,Outstanding OCR accuracy and format preservation, OCR enables you to search, correct, and copy the text in a scanned or image PDF directly,Support 17 OCR recognition languages:: English, Turkish, Greek, German, French....


http://www.pdf-editor-software.com/

Nov 14, 2011 | Ricoh Aficio 1027 All-In-One Laser Printer

1 Answer

Can this device scan to a pdf format?


This printer originally came with ScanSoft®, PaperPort®, and OmniPage® OCR software for Windows® and Presto!® PageManager® software for Macintosh® environments.You'll need to check these software packages to see if they will save the scanned image as a pdf file.

Jul 18, 2011 | Brother MFC-5840CN All-In-One InkJet...

4 Answers

How to convert scanning documents to MS-words


You are going to want to find any OCR software that works for your printer. OCR is 'Optical Character Recognition'. It will take the scan and convert it into a text document, which is either already compatible for MS Word, or easily converted itself.

Feb 24, 2011 | Office Equipment & Supplies

1 Answer

I have hp color printer with scanner. I need to scan document and generate pdf document. Dont find ocr software any help?


If you do not have the install CD that came with third-party software (or you have a OS that is not compatible with that software), you will need to get a OCR program. SimpleOCR (http://www.simpleocr.com/Download.asp ) is free but doesn't handle pages with columns well. (It merges across the column breaks instead separating the paragraphs.) It also doesn't handle handwritten text. This software outputs to a file for a Word Processor (such as Microsoft Office's Word). Most word processors either come with a PDF converter or have one available as an add-on. The commercial OCR software packages will include the save as a PDF function and do not have the limitations of SimpleOCR; although they also default initially to a format for Word Processing (to correct any mistakes). (I have used OmniPage at times personally.)

With most all-in-ones, if you have the full software installed, there will be an option for saving as a PDF. (This is true even on the versions that weren't bundled with OCR software.) If you have a generic OS driver or the basic driver, this will usually not be available Take a look at the screens that come up if you start the scan from the computer. (There will be a place to adjust settings, including the resolution and the output type.) This won't be editable unless you go through the OCR software.

I hope this helps.

Cindy Wells

Jul 23, 2010 | Dell 922 All-In-One InkJet Printer

2 Answers

I want to scan a paper and i want to save it as word so that i modify it. How can i do it?


It depends on if you have the full software installed. The MP160 documentation indicates it came wth ScanSoft OmniPage SE. Open MP Navigator and choose this program, you can output the scan as a text file. If you did a custom install, you may or may not have installed the program. If you omitted the program, do a new custom install.
OmniPage is an OCR program and will output to a number of formats (you will choose File, Save as) after scanning. Word can import RTF and most other choices as well as .doc files.

If you don't have the software disc, the software can be obtained from this URL:
http://www.usa.canon.com/consumer/controller?act=ModelInfoAct&tabact=DownloadDetailTabAct&fcategoryid=334&modelid=13368

Alternatively, there is a free OCR program (simpleOCR.com) that will do the same thing. However it doesn't handle text in columns (newspaper or magazines) very well.

I hope this helps.

Cindy Wells

Feb 18, 2010 | Canon PIXMA MP160 All-In-One InkJet...

3 Answers

Nuance omnipage 17. Can anyone give me a step by step guide how I can keep my coloured letterhead intact whilst adapting as rules change the rest of the document. Thank you Regards


hi jwmikey

here is the manual for the software. you can find what you need beginning with page 37 onwards.

http://www.nuance.com/imaging/resources/quick-reference-user-guides.asp

http://www.nuance.com/imaging/pdf/ug_OmniPage17UserGuide.pdf

hope this helps.

regards,

voodoo

Jun 10, 2009 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

136 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

100387 Answers

David Payne
David Payne

Level 3 Expert

14160 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...