Solved

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

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 5 123
MS SQL 2014 get SPIDs of users 6 27
SQL JOIN 6 39
MS SQL Pagination for Complex Query 5 32
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now