How to extract binary files Powerpoint, PDF etc.) from Oracle Portal

Thread view:

Ben Engbers - 21 Sep 2004 11:54 GMT

hi,

I need to extract all the content that is stored in an Oracle Portal
database (8.1.xxx) And save it to a file system.

The first step is to extract all the information on the items from the
table portal30.wwv_things and portal30.wwv_corners.
After some transformations, I can construct a call to CopyByteItem.copy()
The code for this method is as follows:

InputStream is;
public void copy(int ID, String wd, String inputFile, String
outputFile) throws IOException {
String tmpUrl, tmpName;
tmpUrl = wd.substring(0,wd.lastIndexOf("/") +1 );
tmpName =
URLEncoder.encode(wd.substring(wd.lastIndexOf("/")+1,wd.length()),"UTF-8");
URL url=new URL(bronSite+tmpUrl+tmpName);
System.out.println(url.openConnection().getContentType());
// Create inputstream
is = url.openStream();
BufferedInputStream bis = new BufferedInputStream(is);
// Create outputstream
File outPut = new File(outputFile);
FileOutputStream out = new FileOutputStream(outPut);

synchronized (bis) {
synchronized (outPut) {
byte[] ins = new byte[256];
for (;;) {
int i = bis.read(ins);
if (i == -1)
break;
out.write(ins, 0, i); } } }
is.close();
out.close();
}

When I issue these 4 following testcalls, the first two calls give me
the desired output.
try {
CopyByteItem.copy(73937,
"/docs/Folder/DLG_INTRANET/DLG_HOME/WERKVELDEN/DIENSTBREDE_PROJ/OESTERS_EN_PARELS/AESHIPDI.HTML",
"AESHIPDI.HTML",outputDir+"10157.HTML");
CopyByteItem.copy(182520,
"/docs/Folder/DLG_INTRANET/NOORD_BRABANT_HOME/WERKVELDEN/PROV_PROJECTEN/RECONSTRUCTIE/RECONSTRUCTIEBULLETINS/PERSBERSTUWENI.DOC",
"PERSBERSTUWENI.DOC",outputDir+"42744.DOC");
CopyByteItem.copy(24254,"/docs/Folder/DLG_INTRANET/DLG_HOME/WERKVELDEN/RESERVE/GEOPLAZA_OUD/GEBRUIKEN/GIS
IN PROJECTEN.PDF","GIS IN PROJECTEN.PDF",outputDir+"1606.PDF");
CopyByteItem.copy(182590,"/docs/Folder/DLG_INTRANET/NOORD_HOLLAND_HOME/WERKVELDEN/REGELINGEN/POPNH/PP
PRESENTATIE DLG NH OKT 2003.PPT","PP PRESENTATIE DLG NH OKT
2003.PPT",outputDir+"42784.PPT");
} catch(IOException e) {
System.out.println("Probleem bij het copieren: "+e.getMessage());
}

System.out.println(url.openConnection().getContentType()) results in
text/html and application/octet-stream.

The second two calls however produce output similar to this one:
<HTML>
<BODY bgColor="#FFFFFF" onLoad="document.LoginForm.submit();">
<SCRIPT LANGUAGE="JavaScript">
function show_context_help(h) {
newWindow = window.open(h,"ContextHelp",
"menubar=1,scrollbars=1,resizable=1,width=600, height=400");
}
</SCRIPT>
<FORM
ACTION="http://<host>/pls/portal30_sso/portal30_sso.wwsso_app_admin.ls_login"
METHOD="POST" name="LoginForm">
<INPUT TYPE="hidden" NAME="site2pstoretoken"
VALUE="v1.1~1321~37D032EEA1FD88FFBE1FF8591FB4C1A27141BADA2D7997CD1DF2EC87860A6872CD966A6FCABE1C1BC17044DA0AB0EE7663AB8299311EB6B3193BE5AE5AF02225CD5CFF23980733834426B29B4833294C8A6BDEF1513391E5928EEB03235BAC0561E76FDE0A6E7223349A1DFA756DDDDFEBDCA044E0042ED763BC6AD56108D54846B57600E288A59E6890404BC097F6D9609E3E046D8F874BEBFF6D70A8E59FD3FA73B1C787F691E5298AB03D2787F1A73B2911783BF42B8CC92AB95D69FAFF676A671405C17166F591E70A376D082854274C8800BD77AA85F8C870B06431B48495E1ACA1878611EC162FC6BA96C26C240FFC25544852B2BF7499C4CE1F2930442CE35157321782C8DBE942F9999C37F99BD754DFD41EC09733C6771657DE12FBEBEF42E7C8A7244F">
</FORM>
</BODY>
</HTML>

and System.out.println(url.openConnection().getContentType()) now
results in text/html.

I guess that the MIME-type is not set. (I don't know if this can be done
by the client).

Does anybody know how I can extract all the content from the Oracle
database without having to set manually the mime-type for each item?

Thanks,
Ben

Reply to this Message

Ben Engbers - 21 Sep 2004 15:19 GMT

> hi,
>
> I need to extract all the content that is stored in an Oracle Portal
> database (8.1.xxx) And save it to a file system.

After using the same arguments for one week, I decided to give new
arguments a try.

CopyByteItem.copy(24304,"/docs/Folder/DLG_INTRANET/DLG_HOME/WERKVELDEN/RESERVE/GEOPLAZA_OUD/BEHEREN/HANDBOEKGI.PDF","HANDBOEKGI.PDF",outputDir+"1607.PDF");

CopyByteItem.copy(27516,"/docs/Folder/DLG_INTRANET/DLG_HOME/WERKVELDEN/DIENSTBREDE_PROJ/KENNISMANAGEMENT/AGENDAVERSLAGEN/KM_KC_DAG_2.PPT","KM_KC_DAG_2.PPT",outputDir+"1892.PPT");

To my surprise, the procedure worked well with the new arguments and the
only difference I see is that the new filenames do not contain any
namespaces. This means that I still haven't found a solution but at
least I know that the basic functionality works.

Ben

Reply to this Message

How to extract binary files Powerpoint, PDF etc.) from Oracle Portal

Free Magazines