How to migrate Lotusnotes contents to Oracle UCM


Introduction

 Migrating Lotusnotes data to Oracle UCM is one of the challenging tasks in the Data migration. There is not many tools available to migrate the Lotus Notes data to Oracle UCM at this point. I post this article by thinking that it may help someone out there.

 Lotus Notes to Oracle UCM contents migration approach :

 The document structure of Oracle UCM is not the same as Lotusnotes. The Lotusnotes richtext fields contains all text, images and attachments , whereas Oracle UCM the contents are stored as text,images and attachments separately as files.

 In my data migration , there was no ACL and doc links migration , so the migration was simple.

Lotus Notes Data Export :

 Lotusnotes Richtext field contents has to be extracted as follows :
Here is some guidelines on how to extract the contents as html :
http://www.nsftools.com/tips/NotesTips.htm#richtexttohtml

Here is some guidelines on how to extract the images :
http://www.openntf.org/Projects/codebin/codebin.nsf/0/DE60568D19EA514F86257057006BF308

Here is some guidelines on how to extract the attachments :
http://searchdomino.techtarget.com/answer/LotusScript-to-extract-and-move-attachments-to-a-Lotus-Notes-mailbox-or-file-folder

If you want to place some text on the attachment placeholder, you have to use Notesrichtextnavigator class to navigate through the embeddedobjects.
Oracle UCM import :

 RIDC API was used to import the contents to Oracle UCM. Following are some guidelines to RIDC API content upload :

 http://docs.oracle.com/cd/E23943_01/doc.1111/e10807/c23_ridc.htm#CIHCHACB

http://senasystems.blogspot.sg/2012/03/ucm-file-operations-add-edit-delete.html

In my data migration , there was a need to create a dynamic UCM folders to store my contents in a structured hierarchy. This was done with the RIDC API methods to create folders on the fly. Attachments and Images were uploaded to a folder called DigitalMedia under IWRHOME folder. Image URL references has to be tweaked at the source html with your webcenter url.

 Data Verification :

 Finally , the data has to be verified to add doc links and grant access. Some of the design elements like Twisties , are not converted as html , so not migrated. This has to be updated manually.
Summary :

The Lotus Notes data was exported as HTML and imported in to Oracle UCM with RIDC API. I believe there will be some better suggestions on this to do this in much simpler way. Please update your comments below.

If you are looking for Lotusnotes data migration consultancy to migrate any applications, please contact me at ganesanrajeshkumar@gmail.com

The knowledge that can best be shared is knowledge that can help a mind to grow.

Comments

Post a Comment

Popular posts from this blog

Application Lifecycle Management - SDLC with ALM

Image
SDLC with ALM  Development is certainly the fundamental part of application lifecycle management. Once the business case is approved, the software development lifecycle begins. If we expanded the SDLC parts of the Development line shown in the figure below, a modern process would probably show software development as a series of iterations. Each iteration would contain some requirements definition, some design, some development, and some testing. This iterative style of development isn’t always appropriate—some projects are still better done using more traditional methods—but it’s becoming the norm in many areas. Once the SDLC process for version 1 of the application is complete, the application is deployed. For most applications, however, deployment doesn’t mark the end of development. Instead, the application needs periodic updates, as shown in the figure, and perhaps one or more full SDLC efforts to create new versions, as in this example. For some applications, the mon
Read more

8 Principles of Document Writing

Image
8 Principles of Document Writing :   1.Cohesive            The statements have to be well-integrated and unified.   2.Complete     The document has to be complete.   3.Consistent     The statements should have consistent presence through out.   4.Correct     The information must be correct.   5.Feasible     The document should be readable by the Users.   6.Modifiable     Contents are grouped so the changes doesn't need to modify.   7.Testable     A document must be reviewable   8.Unambiguous     Statements should be not give more than one interpretation.
Read more

Sharepoint 2010 : Crawl issues - Search refiners

Image
For troubleshooting managed property for search refiners : Type the <Managedpropertyname>=<the value> in the search box. If the search results return the searchresults filtered by the managed property, the managed property is available for search refiners. Managed properties also can be queried with the < (lesser than) , > (greater than) symbols. Happy Sharepointing!
Read more