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

Tip

How to convert excel to PDF


According to a recent report,Adobe estimates that there are about 300
million PDF in circulation,the amount and use of PDF format is still growing exponentially.People nowadays cannot live without PDF files.
Sometimes,you need to convert excel to pdf files,but how to convert excel spreadsheets to pdf with retains all the features of the original excel file?

you will need pdf converter to convert excel to pdf.

1.Run the pdf converter program.

2.Add PDF files,specify output folder.

3.Start conversion.

Note: you cn add PDF properties to the output PDF file, like author, passwords, allowed actions, etc.

on Mar 08, 2010 | Computers & Internet

1 Answer

Add a excel format in tally


Sir,

What to Export ?
Tally has a facility to export its data to other applications like spreadsheets, word processing software and other database software. Export of data is provided mainly for summaries and statement reports like Trial Balance, Stock Summary, etc. You can export it to another company using Tally that will import it directly.

How to Export?
You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Thanks
Good Luck

Aug 14, 2009 | Adaptec Computers & Internet

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

1 Answer

I have purchased another computer and I am trying to re-install OmniPage Pro 12, and it keeps giving me a error message of some type of "Threat Detected!" Threat name: Frojan Hores Dropper...


Frozen **** are always a problem! hehe! It's possible that your new computer has a more sophisticated AntiVirus program on it, and it thinks your OCR software carries a Trojan Horse type of worm. If your Omnipage is a genuine disc, and the same disc that you used before, i'd suggest you disable your antivirus while installing the program. With Norton antivirus, you'd double-click the yellow circle/button in the system tray and then disable. Since you haven't mentioned which antivirus you have, i'll leave it to you to work that part out, eh? =-]

Aug 23, 2008 | Computers & Internet

1 Answer

User manual for JVC GZ-MG57


Hi, this is a tough order, but try this:

An English manual in PDF format is available from JVC
(Japanese Victor Company, named after the old RCA Victor):

===========================================
http://books.jvcservice.com/booklist.asp?Model=GZ-MG57
===========================================

1) Download the English version first.

2) Next...

Process the PDF file using and OCR program like ABBYY
SOFT to recover the original text and graphics into a more
user-friendly format such as the "Word for Windows"
document file format (.DOC), or even plain text.

===========================================
"http://www.abbyy.com/products/"
===========================================

OCR = "Optical Character Recognition".

ABBYY Soft makes a good program for doing this, and
you can download and try it for free.

Other more expensive OCR applications are also available
from people like ADOBE, but I prefer ABBYY Soft.

A free (limited) version of ABBYY Soft also comes free
with the purchase of a $100 Epson document scanner,
like my "Perfection V200 Photo".

3) Once you have extracted the English text from the user's
manual, you can feed it into an on-line translation machine,
or download a demo translation program:

http://translator.imtranslator.net/ (free online)
http://www.etranslator.ro/english.html (download trial)

4) Once you have it translated, you can print it back into
PDF using "acrobat" or "foxit"

Good luck.
Please rate my answers,
Martn

file:///P:/Documents%20and%20Settings/N_Lfg_Martin/Desktop/JVC/LYT1639-001A.pdf
Martin





Jul 22, 2008 | Computers & Internet

5 Answers

Microsoft office excel encountered error


This problem may occur if a noncontiguous selection is included in any one of the following: • Sheet selection • AutoFilter • Publishing Excel data to a Web page • Conditional formatting • Pivot Table reference • Pivot Table area • Pivot Table location • Unknown XML

it that does not work then goto control panel and reinstall office

Jun 23, 2008 | Computers & Internet

1 Answer

When i try to save, extract or print document error (14) comes up... please help?


To extract and print PDF files from your PC, you need a PDF reader, like Adobe reader. Yuo can download one from online. Try version 8.0

May 06, 2008 | Computers & Internet

1 Answer

How to save scanned document to where you can type on it.


you need one of those OCR (optical character recognition) software to scan documents as text. Your scanner may have a free version of this. A good example is Omnipage pro

May 02, 2008 | Computers & Internet

4 Answers

How can i export tally data to excel format?


Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. excelexport.jpgIf you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

excelexport2.jpgThe special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.

Feb 27, 2008 | 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

98868 Answers

David Payne
David Payne

Level 3 Expert

14086 Answers

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

Answer questions

Manuals & User Guides

Loading...