?
Solved

PDF Converter 4.0/ Omnipage Pro / PDF Conversion to excel

Posted on 2007-07-20
6
Medium Priority
?
643 Views
Last Modified: 2012-08-13
I am using Nuance's PDF Converter 4.0 to convert a large number of PDFs into Excel spreadsheets.  The PDF files are all very lage due to some image manipulation done in photoshop, they range in size from 200-400 megabytes.  PDF Converter works normally, though slow for obvious reasons, when converting one file at a time.  However when I try to open more than one file, it converts the first succesfully and then I get the error message "Conversion finished but some files could not be converted (error) or may have problems (warning)."  The remaining files are not converted.  The largest number of files I have tried at once is 6.  
I need to convert them multiple files at a time because I have about 1,000 to do.  Does anyone have any suggestions as to how to get this to work?

Thanks,

Arthur

PS-
I also have OmniPage Pro 15 if that would help, I haven't gotten it to run batches as smoothly as PDF Converter
0
Comment
Question by:rpreiss
  • 4
  • 2
6 Comments
 
LVL 30

Expert Comment

by:SteveGTR
ID: 19534274
You could create a batch file to perform the processing. If all the .xls files were located in a certain directory you could run this batch processing from the directory:

@echo off

setlocal

for /f "tokens=*" %%a in ('dir *.xls 2^>NUL') do pdfprocessing %%a

pdfprocessing would be the command line executable you use to covert the Excel spreadsheets to PDF. We can fine tune that. In the above example  %%a in the name of the Excel sheet returned from the dir *.xls command.
0
 
LVL 30

Expert Comment

by:SteveGTR
ID: 19534284
Probably should double quote the file name in case you use spaces:

@echo off

setlocal

for /f "tokens=*" %%a in ('dir *.xls 2^>NUL') do pdfprocessing "%%a"
0
 

Author Comment

by:rpreiss
ID: 19534324
I am trying to go from PDF into excel.  PDF converter and Omnipage will do this.  But I don't think either is command line opperable.  I am new to this though.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 30

Expert Comment

by:SteveGTR
ID: 19534815
I looked a the Omnipage 15 information and didn't see any command line processing from DOS.
0
 

Author Comment

by:rpreiss
ID: 19535684
Ok-
After spending the afternoon on the phone with nuance, I am going to try to use a batch file.  I am pretty new at using batch files.  The executable file name is pdfrouter.exe, so i will substitute that for pdfprocessing .  What else do I have to customize?  Thanks.

Arthur
0
 
LVL 30

Accepted Solution

by:
SteveGTR earned 2000 total points
ID: 19535820
You'll need to get the command line argument format for the command. You can normally get this by doing:

pdfrouter /?
pdfrouter -?
pdfrouter /h
pdfrouter -h

You did say you are converting from pdf to xls, so the batch processing will have to also be changed:

@echo off

setlocal

for /f "tokens=*" %%a in ('dir *.pdf2^>NUL') do pdfrouter "%%a"
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question