Notes Migrator for SharePoint (NMSP) includes the ability to use the Notes formula language for selecting documents.
If using the Notes @ formula language to filter record selection a syntax error may occur during a migration
or during a Preview Data Query. This will result in no records migrating.
An example of a Notes @ Formula which will result in this error is:
@Created > [06/30/2008],
The error that will be seen:
System.ArgumentException: Invalid command: syntax error
at Proposion.N2N.NsfCommand.a(Boolean )
at Proposion.N2N.NsfCommand.ExecuteReader()
at Quest.NSP.Transform.QuickplaceQueryEngine.b.l()
at Quest.NSP.Transform.QuickplaceQueryEngine.a(Int32 A_0, Int32 A_1)
at Quest.NSP.Migrator.SourceDefinitionForm.btnDoQuery_Click(Object sender, EventArgs e)
NMSP does not properly escape special characters in formulas in QuickPlace the same way it does for Notes.
WORKAROUND
Use backslashes to escape the square brackets, for example:
@Created > [06/30/2008]
STATUS
Waiting for a fix in a future release of NMSP.
