Notes Migrator for SharePoint includes the ability to use the Notes formula language for selecting documents.
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:
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:
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.