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