Solved

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

Posted on 2014-09-12
2
674 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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 ?
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to recover a database from a user managed backup
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

631 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