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...
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

What's new in Sharepoint 2016

Image
Microsoft confirmed that SharePoint Server 2016 will become generally available in Q2 2016, with a public beta planned for Q4 2015. What to expect in 2016? On-premises support will be around for the foreseeable  future. Continued support on combination of on-premises, cloud and hybrid deployments for many years to come. Microsoft is moving more to a cloud-based identification model with SAML and OAuth Nondefault ports can be used for connection encryption, rather than just using Port 25 Site creation is no longer a "heavy operation" but now will be "small and fast" Project Server will be integrated into SharePoint content databases (although you don't get it for free) Microsoft will make "durable links" for finding files so that it won't matter if the file name gets changed or if the file gets moved Microsoft is adding an ODF file saving capability Improved user experiences Cloud-inspired infrastructure Compliance and reporting...
Read more