How does Quest Notes Migrator for SharePoint support SharePoint content types?
Quest Notes Migrator for SharePoint can automatically assign the content types of new documents to SharePoint based on the data in Notes. Quest Notes Migrator for SharePoint allows you to selectively migrate certain fields based on the content type.
For example:
1. In your Notes database, you have two forms - "Form1" and "Form2".
2. Create list on target and add corresponding content types to the list - CT1 and CT2.
As you see, content type name can have different name... in this case we need to use formula when extracting content type name on target:
In the Source Data Definition you need to create a field (FormFormula for example) with formula that converting a form name to a content type name. The formula looks as follows:
@if(form="Form1";"CT1";"CT2")
3. On the Map Data tab, map the FormsFormula field to the ContentType field and set up mapping rules for all other fields as required.
If you need to map more than 2 content types, use the following formula:
@If(condition1; action1; condition2;
action2; ...; condition99; action99;
elseAction)
Formula for 4 content types:
@if(form="Form1";"CT1";form="Form2";"CT2";form="Form3";"CT3";"CT4")
The whole list of Notes Formulas