Migrating from Lotus Notes to MCMS

Migrating from Lotus Notes to MCMS

Post by VEw » Fri, 21 Apr 2006 11:04:02


Does anyone know of any tools to convert documents from Lotus Notes to MCMS


Migrating from Lotus Notes to MCMS

Post by Stefan [MS » Fri, 21 Apr 2006 16:18:15

Hi TL,

there is a migration tool from a 3rd party company which might be useful:


This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://www.yqcomputer.com/
Check out the new book as well: Advanced MCMS development:


Migrating from Lotus Notes to MCMS

Post by stevekgood » Tue, 02 May 2006 10:05:08

I recently converted my client's notes-based solution to MS CMS. Having
no Notes programming experience, and 0% desire to learn any, I used
NotesSQL 3.02g which is a free ODBC driver for Lotus Notes (from IBM)
to access the Notes DB, and a custom utility written in C#.

Basic flow was:
1. Read data from Notes DB
2. Write to SqlServer (primarily to improve speed, NotesSQL performs
3. Perform some sanity checking of the data (sql-based).
4. For each row
4a. Scrape page from existing site using .Net WebClient class (because
NotesSQL doesn't expose HTML formatting, only plaintext, we needed a
combination of simple database fields, and some formatted text)
4b. Extract relevant chunks of text using regexes.
4c1. Download attached PDFs/images
4c2. Add PDF/images to resource gallery.
4c3. Fixup links to PDF/images.
4d. Create new Posting
4e. Add text to placeholders.
4f. Commit.

Worked very well. The biggest mistake I made was forgetting times in
MCMS are UTC based, so some pages are expiring 10 hours late. There
weren't many pages that did that, so I bought a big cup of coffee and
fixed that manually the other day.

The other issue is there's no easy way (that I know of) to sort the
postings of a channel automatically, so make sure you create the
postings in the correct order if that's important to you.

If you want the utility, let me know, but it's very bespoke to the
issues we had. It was also written knowing it would be thrown away
(which we have done), so it ain't pretty. And I was playing with a few
techniques I hadn't used before.

Good luck.