Solved

Import PDF Files to Oracle I/PM with Excel sheet containing Index fields

Posted on 2014-09-12
2
668 Views
Last Modified: 2014-09-12
Hi Experts,

I have a questions about Importing Data into Oracle I/PM.  I have several PDF files (check Images) and a Excel sheet (Index fields I want to import).  Is there a utility or way of importing this data while checking the excel file index files.  

Thank for all your help.  

-Jeff
0
Comment
Question by:storktech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 40320071
1) Import your pdf files into a table in your Oracle database with type either as "BFILE" or BLOB.
2) Save your Excel index fields as "csv" file
3) Attach that csv file to database as external table
4) Code an sql query to update the pdf table with the index info.
5) Go celebrate your success.
:p
0
 

Author Comment

by:storktech
ID: 40320209
Haha I will accept this as the solutions. Stream lined and it worked out. I have not run into a problem yet.  

Thanks Expert!
0

Featured Post

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!

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

710 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