Lotus Notes to SPS Conversion

I recently had an opportunity to convert old Lotus Notes database applications to SPS. Granted, I had a little bit of a time understanding the whole form/view document collection thing in Notes but Visual Studio came to the rescue.

After analyzing the Notes db through a SQL lens I got a feel for the data set. I then set up a Visual Studio 32 bit project and then added a reference to Interop.Domino.dll. With that I created the extract process seen in the NotesExtract class (links to a text file). This little standalone connects to a Domino server, database and view then iterates over all the items. It writes these items to a delimited text file. If the item has file attachments it records it in the item record (for later streaming into SPS) and then physically extracts the attachment.

The second project is the 64 bit SharePoint Object model piece that uses the text data file and instantiates new Policy objects which are stored in a List collection. It then connects to SPS where we get a SPWeb and then create a SPListItemCollection which we use to create new List items from the data stored in the Policy collection. You can see this in the SPImport class excerpt (links to a text file).

The code was just a utility which we used several times over on different databases through the Summer during our conversion process from Notes to SharePoint versus buying a product we’d used for a time and then archive.

Posted in sharepoint

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Activity

  • Weight Training
    On February 21, 2018 4:53 pm rode 0.00 mi. during 00:20:00 hours climbing 0.00 ft.
  • Afternoon Run
    On February 20, 2018 3:43 pm rode 3.56 mi. during 00:35:29 hours climbing 144.03 ft.
  • Workout
    On February 17, 2018 4:43 pm rode 0.00 mi. during 01:30:00 hours climbing 0.00 ft.
  • Afternoon Walk
    On February 15, 2018 4:59 pm rode 1.40 mi. during 00:30:00 hours climbing 0.00 ft.
  • Afternoon Run
    On February 14, 2018 1:32 pm rode 3.78 mi. during 00:40:07 hours climbing 168.64 ft.
  • Afternoon run
    On February 12, 2018 5:22 pm rode 3.20 mi. during 00:30:00 hours climbing 0.00 ft.