This is my revamped OLE reading code for PassPort. This version is driven by the WorkOrderDocs class and the OleDocument class itself is kind of driven by work orders, but the rest of it could be adapted for other purposes pretty easiliy by somebody that's good at slinging Java code.
Also, I added code to decode the internals of the "link" type documents to try to figure out what they were linked to before and extract that data.
We've used it to successfully extract a couple of thousand documents in bulk from our various PassPort databases.
It requires some dependancies, namely the little endian switcher from Canadian Mind Products, the Apache POI code and an ODBC driver.
LEDataStream - http://mindprod.com/jgloss/ledatastream.html
POI - http://poi.apache.org/download.html
(both are open source and freely available)
People probably already have the Oracle driver handy.
OLE reading code
This is my revamped OLE reading code for PassPort. This version is driven by the WorkOrderDocs class and the OleDocument class itself is kind of driven by work orders, but the rest of it could be adapted for other purposes pretty easiliy by somebody that's good at slinging Java code.
Also, I added code to decode the internals of the "link" type documents to try to figure out what they were linked to before and extract that data.
We've used it to successfully extract a couple of thousand documents in bulk from our various PassPort databases.
It requires some dependancies, namely the little endian switcher from Canadian Mind Products, the Apache POI code and an ODBC driver.
LEDataStream - http://mindprod.com/jgloss/ledatastream.html
POI - http://poi.apache.org/download.html
(both are open source and freely available)
People probably already have the Oracle driver handy.
Hopefully this will help somebody.
Eric Ladner