Migrator for Notes to SharePoint 6.16 - User Guide

Mapping data

Mapping data

The Map Data tab is where you describe how the fields in your Data Source Definition map to the SharePoint fields in your Data Target Definition. In most cases, the Auto Map function will do the mappings for you, but you can also override the defaults.

If you have selected Source and Target Data Definitions, a default set of field mappings will be generated for you using the AutoMap Names property for the target data field definitions. You can refresh these mappings by clicking the Auto Map button.

If you have multiple source fields that you are mapping to one target Note field using the target field’s AllowMultipleSources property, the order of the concatenated fields depends on the order of the fields in this field mapping table.

To add new fields

1	Click Add.

The New Field Mapping dialog box will allow you to quickly select from a list of fields defined by your Target Data Definition. In addition to the fields you explicitly defined, a number of additional meta-data fields will also be available. These will be identified with {curly braces}.

You can map these data source fields to an unused existing SharePoint field (defined by your Target Data Definition) or add a new one. For each target data field of type WordDocument, you will see its metadata fields in the list of predefined fields as well. These are indicated in the list using the field name defined for the Word document (for example, Field0.Title).

The SourceType property can be set to any of the available types:

▪	None - Do not write to this SharePoint field

▪	Constant - Set the SharePoint field to a constant value. In the Source Value field, enter the constant value that you want written in SharePoint. If you are mapping a constant to a rich text field, you can use ‘\n’ to denote a new line in the Source Value field.

▪	TargetValue - Set the SharePoint field to the target value of a corresponding field. If the SourceType is set to TargetValue, you need to set the TargetValue option.

▫

Link to Parent Document - Creates a URL field that contains a link to the parent document when migrating parent/response documents to SharePoint “discussion” templates. It is especially useful if you are migrating a database containing parent/response documents to anything other than a discussion list. Without doing this mapping, you would lose any correlation between the response documents and their parents.

▫

Link to Primary Document - Creates a URL field that contains a link to the main “parent” document when migrating file attachments to alternate SharePoint library locations. The link uses the parent's Subject field as the display name. Without doing this mapping, you might not know where the main document for the attachments resides.

▪	SourceField - Set the SharePoint field to the value of a Notes Field.

▪	SourceValue - The name of the Notes Field to use

▪	MaxSize - The maximum number of characters to write to the SharePoint item

▪	Multi Value Disposition - Directs how any multi-valued Notes items should be written to SharePoint Lists. The options are:

▫	Default - Take the most appropriate action based on the source and target values being mapped

▫	First - Takes the first value found

▫	Last - Takes the last value found

▫	Merge - Take all the values and combine them into a single string separated by commas

▫	All - Take all values and attempt to map them to SharePoint. This will only succeed if the target column allows multiple values.

▪

Normalize - This option is only available for simple data types (text, date, number, choice) and only when migrating to a SharePoint list (not a document library, discussion, or calendar). Migrator for Notes to SharePoint will gather up all the possible values for Normalized mappings and write out multiple SharePoint list items, one for each value. Any mapping that is not flagged as Normalized will get copied to each of the resulting records. If more than one of the mappings is flagged as Normalized, then the one with the greatest number of elements will control the number of migrated records. For more information, see Normalizing multi-valued items to multiple documents

▪	Transform - Directs how data should be modified when writing to SharePoint Lists. The options are:

▫	UpperCase - Converts text to uppercase.

▫	LowerCase - Converts text to lowercase.

▫	CommonName - Converts Notes names to text fields formatted as Common Names.

▫	AbbreviatedName - Converts Notes names to text fields formatted as Abbreviated Names.

▫	Unmappable - Converts unmappable Notes names to text fields formatted as Abbreviated Names.

▫

CommonName, AbbreviatedName and Unmappable are useful in cases where you are NOT using the full User Mapping process, which maps Notes names to Active Directory accounts. User Mapping is still required when mapping to a User field in SharePoint. These transform types are useful when targeting "plain" Text fields in SharePoint, Word.

▫	XMLCompatible - Removes invalid XML characters.

▫	PreformattedText - Wraps in a <pre> tag (InfoPath only).

2	Select the Preserve Created/Modified Dates option to allow the Created and Modified fields to be set based on the respective properties of the original Notes document.

3

Select the Preserve Created/Modified Identities option to allows the Author and Editor fields to be set based on the $UpdatedBy property of the original Notes document. SharePoint tracks users as numeric indexes into the SharePoint Site Collection Users list. Migrator for Notes to SharePoint will attempt to map Notes names to Site Collection User identities based on the rules configured in the tool's User Mapping.)

4	Select the Preserve Response/Reply Hierarchies option to allow newly written SharePoint items to be linked with the correct parent items to reflect the parent/response relationships that existed.

5	Select the Map Event / Recurrence Data option will cause calendar information (appointment type, start date, repeat information) in Calendar items to be mapped to the equivalent fields in SharePoint Events.

Setting up user mapping and security mapping

Setting up user mapping and security mapping

SharePoint tracks "users" as numeric indexes into the SharePoint Site Collection Users list. When Migrator for Notes to SharePoint encounters user names, it will attempt to map them to Site Collection User identities based on the mapping rules in your Global Settings. For more information, see Customizing global options This can occur:

•	When using the "Preserve Created/Modified Identities" option in your Job Definition

•	When mapping Security Attributes

•	When attempting to migrate a Notes name field to a SharePoint User field

On a per-job basis, you can decide what happens if no user mapping is found for a particular Notes name. The record can be rejected or defaults can be applied depending on the If user mapping fails setting.

The details of how user mapping occurs is controlled by the Global Options.

Migrator for Notes to SharePoint 's security mapping options will map various access control properties of the source Notes database, QuickPlace, Quickr, or Domino.Doc cabinet to the equivalent constructs in SharePoint.

To enable security mapping at the job level

1	Select one or more of the five available Security Mapping check boxes of your Job Definition.

▪

The Map Notes Users to Domain Users option will cause any Notes users listed in the source database's Access Control List to be added to the target SharePoint list or library. The Notes user names are mapped to Site Collection identities based on the rules configured in the tool's User Mapping and those Users are granted access to the target SharePoint list or library.

The Map Notes Groups to Domain Groups option will cause any Notes groups listed in the source database's Access Control List to be added to the target SharePoint list or library. The Notes group names are added to the Site Collection as external groups and are granted access to the target SharePoint list or library. Each group name must correspond to an actual Domain group.

 

NOTE: If either the Map Notes Users to Domain Users or Map Notes Groups to Domain Groups options are checked in the Migration Targets tab, the Permission Mapping options will determine how the Notes database access levels (and related flags) are translated into SharePoint permission levels.

▪	The Expand Notes Roles to SharePoint Groups option causes a new SharePoint Site Collection Group to be created for each Role defined in the Notes database ACL.

▪

The Expand Notes Groups to SharePoint Groups option allows you to take what was once a Domino Directory group (scoped to the entire Notes Domain) and convert it to a SharePoint group (scoped to just one Site Collection). As part of this conversion, the tool will query the Domino Directory for any groups listed in the ACL, extract all its members (expanding any sub-groups as needed), and add those members to the new SharePoint group.

 

NOTE: If both the Map Notes Groups to Domain Groups and Expand Notes Groups to SharePoint Groups options are selected, Migrator for Notes to SharePoint will first try to find a mapping for the group name in the directory or mapping file. If it finds a mapping, it will map to the Domain group. If it doesn't, it will provision a SharePoint group instead.

▪

If the Map Reader/Author fields option is set, then any Reader Names or Author Names items encountered in a particular Notes document will cause a permission list to be generated on the corresponding SharePoint record. This new permission list will only grant read access to the users and groups named in the Reader Names field and will only grant edit access to the users and groups named in the Author Names field.

▪	To control precisely which security constructs are mapped to Notes, click the Advanced security settings link (this link is available when you select a check box).

2	Configure DocLinks handling. You can select:

▪

Convert to native notes:// URLs (for use with the Notes client) - When generating HTML or MIME documents from Notes Rich Text fields, any DocLinks, ViewLinks, and DatabaseLinks that are encountered are converted to "Notes URLs" (for example notes:///85256B20007EED50/38D46BF5E8F08834852564B500129B2C). On machines where the Notes client is installed, such a URL allows Notes to open to the correct document, view, or database.

CAUTION: Unfortunately, SharePoint does not currently allow Notes URLs in HTML fields, so the feature is not useful in those cases.

▪

Use the Quest Link Tracking Service - This option utilizes the Link Tracking Service, which ensures that Notes DocLinks continue to work before, during and after the migration process, regardless of the order of document migration. The service maintains a record of every document that is ever migrated and guarantees that users clicking on an intra-document link will always get redirected to the current location of the document.

 

NOTE: This feature requires the use of Migrator for Notes to SharePoint’s Link Tracking Service. For details, see the Understanding the Link Tracking Service section in the Migrator for Notes to SharePoint Installation Guide.

▪	Convert to a link to the specified URL - This option replaces each DocLink with a link to a fixed generic web page.

▪

Convert to http:// URLs (for use with the Domino server) - This option prompts you for an additional field URL for Converted DocLinks. To allows you to map the "notes:///" portion of the Notes URL to point to a Domino web server where the linked-to database exists. For example, if you specify "http://proposion.com/" in the URL for Converted DocLinks field, the URL would be changed to "http://proposion.com/85256B20007EED50/38D46BF5E8F08834852564B500129B2C".

▪	Convert to native notes:// URLs (plain text) - When generating HTML or MIME documents from Notes Rich Text fields, any DocLinks, ViewLinks, and DatabaseLinks that are encountered are converted to "Notes URLs" in plain text (for example notes:///85256B20007EED50/38D46BF5E8F08834852564B500129B2C).

Saving the job

Saving the job

To save the job

•	Click Save Job.

Validation issues can occur. A Validation Issues dialog box may appear showing the severity of the issue, the issue message, and its context. You cannot execute jobs if issues are marked Critical. To edit the job, click Cancel.

If you have only errors and warnings, you can save the job. Click OK, then Save.

Customizing global options

Customizing global options

To change the default Migrator for Notes to SharePoint options, click the Options button at the bottom of the tool or open the System Menu (at the top left corner). The Options dialog box that is displayed includes several tabs of options you can change.You can also apply different sets of settings (saved options files) for different migration jobs by selecting Options > Load Options. For more information, see Advanced configuration options

If you are using the Migrator for Notes to SharePoint Console, the Options button is not available. You can get to the Global Options by selecting the Global Settings link in the Advanced tab of the Job Designer. All of these options can also be edited using the Advanced Configuration Options dialog box of the Console.For more information, see Advanced configuration options