IBM Notes database archiving to SharePoint

In IBM Notes environment decommission projects clients have different options what to do with the Notes databases. Some will be deleted. Other databases still in use will be migrated to SharePoint (Notes content and functionality). There is always a group of Notes databases that are no longer actively used, but the content cannot be deleted. For these databases the content can be archived to SharePoint. This means that, in a cost effective way, the Notes content will be stored in SharePoint or on a disk drive. In the archive approach the Notes functionality will no longer be available.

The bottom line result of archiving a Notes databases is:

  • the Notes database content (text, images, attachments, embedded objects, document and response structure) is available in SharePoint or on a disk
  • the archived content looks the same in SharePoint as it was in Notes
  • the archived content may not be edited

Lets archive a Notes document library.

Subject to this archive demo is a typical Notes document library database with a Notes document response structure, with attachments, text and images.

ionet archive 1

For this job we use an archive tool from our partner IONET.

Lets manually add this particular Notes database. Its also possible to add many databases in one go.

ionet archive 2

In the image below I have configured what to export. I want to export Notes documents created with 3 Notes forms (main topic, response and responsetoresponse). Lets do the export to HTML and render the HMTL will result in a HTML document looking the same as the Notes document.

ionet archive 3

 

There are two more settings that are important which are illustrated below. The formula will set the file name of the response and of the main documents.

ionet archive 4

All responses will be stored in the Response folder.

The IONET tool runs on a Domino server, it can archive one or many Notes databases in one go.

The archive result is illustrated below.

ionet archive 5

The files created are HTML files with the extension aspx.The responses are stored in the Response folder and all attachments are stored in the att_files folder.

The next step is to copy all these files to a SharePoint library. I have created a new SharePoint library and I open the library using Internet Explorer because only with this browser you can open the library with the Windows explorer.

ionet archive 6

Pressing the “Open with Explorer” button results in the SharePoint library opened in the Windows Explorer.

ionet archive 7

Now I can copy the files created by IONET to this library using drag and drop.

ionet archive 8

 

The result in SharePoint is displayed below.

ionet archive 9

The SharePoint library contains aspx files which can be opened simply by clicking on them, resulting in for example:

ionet archive 10

At the top links are displayed to the two attachments stored in the Notes document body field.

Links to all responses are displayed.

At the bottom the Notes document is displayed in Notes style.

The attachment links have the option ?web=1 added, this will open the file in the online office program which is very convenient for the end users, for example:

ionet archive 11

 

In this example we did not recreate the Notes categorized view. This would be possible using ShareGate. With ShareGate the notes categories which are part of the file name can be retrieved from the file name and added to a new column in SharePoint.

Any Notes and Domino database can be archived in this way. Using IONET the archive result can be changed in many ways.

Lialis uses this tool in several projects to archive many Notes databases.

Only IONET is supporting embedded objects in Notes by the way.

Finally a legal note, the aspx files stored in SharePoint can not be edited via Sharepoint.

 

Please contact me on marten@lialis.com if you have Notes databases to be archived in this way.

Thank you.

2017-03-20T21:06:27+00:00