Selection Formula madness 

Notes Migrator for SharePoint includes the ability to use the Notes formula language for selecting documents. 

image 

This is almost exactly the same thing as specifying a Selection Formula for a view in Domino Designer.  I say "almost", because you can use things like the current time of day or the current user, which you can't do in Notes.

Of course not everyone running migration jobs is a Domino developer.  So we get a lot of questions along the lines of "how do I write a formula that does such and such?" 

Here are is a listing of some of the most commonly requested examples:

 

Select documents that were created with the "Memo"form:

FORM = "Memo"

Select documents that have attachments:

@Attachments > 0

Select documents that are under a certain size:

@DocLength > 100

Select documents based on certain keyword values:

@IsMember(status; 'open':'delayed')

Select documents that were created after a certain date:

@Created > [12/31/2006]

Select documents that were last modified after a certain date:

@Modified > [12/31/2006]

Select one document based on it's UNID:

@Compare(@Text(@DocumentUniqueID); "123456789012345678901234567890ab"; [CASEINSENSITIVE]) == 0

Exclude one document based on it's UNID:

@Compare(@Text(@DocumentUniqueID); "123456789012345678901234567890ab"; [CASEINSENSITIVE]) != 0

Select response documents only:

@IsResponseDoc

 

Of course you can use AND and OR to combine expressions, etc. 

Remember that Notes views can have selection formulas too.  If you find a view that has the filtering you need already built into it, you can get much better performance by using that view because the select formulas may have been evaluated already and the results cached on your Domino server.

Specifying a view and a formula together can be very powerful as well.  In this case, the formula is only evaluated on the documents selected by the view and a strict subset of the view contents is selected.

 
Posted on 23-Jul-08 by Steve Walch
2 Comments  |  Trackback Url  |  Link to this post | Bookmark this post with:        
Tags: Migration projects, Notes Migrator for SharePoint, Tech Notes
 

Links to this post

Comments

Friday, 15 Aug 2008 01:48 by Uma
What would be the best way to migrate Responses and Sub Responses (Response to Response) from Notes to Sharepoint

Monday, 18 Aug 2008 07:35 by Steve Walch
Our tool supports migrating to discussion lists in SharePoint. As discussion lists are the only things in SharePoint that really support responses, etc., many customers attempt to build custom list templates on top of that (using their own content types, etc.) Just check the Preserve Responses check box on the mapping tab of our tool.

Name:
URL:
Email:
Comments: