Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2014-09-12
2
Medium Priority
?
695 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
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

926 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