Chat now with support
Chat mit Support

Content Matrix 9.10 - SharePoint Edition

Introduction Activating the License Key Selecting the SQL Database You Want to Connect to Content Matrix Console End User Interface Enabling Advanced Mode Multilingual Support Connecting to SharePoint Preparing for a Migration How Content Matrix Handles Various SharePoint Components
Team Site to Modern Team Site Migration SharePoint Sites to Modern Communication Site Migration Promotion of First Level Subsites to Site Collections MySite Migration "Share With" Metadata and "Sharing Links" Access Permissions Migration Records Center to SharePoint Online Migration Using the Import Pipeline Master Page Migration List Template Gallery Migration Content Types Migration Document Version and Checked Out File Limitations Ghosted and Un-Ghosted Page Migration Document Set Migration Navigation Migration Classic Web Parts Migration Site Theme Preservation Site Feature Migration Managed Metadata Migration Users and Permissions Migration BCS/BDC Data Migration OneNote Notebooks Migration Customized Form Pages Migration InfoPath Forms Migration SharePoint Workflow Migration Nintex Workflows and Forms Migration Link Correction StoragePoint Content Migration
Initiating a Migration Configuring Copying Options Saving or Running a Migration Job Copying SharePoint Objects as a Separate Action Configuring Hub Sites Incremental Migration Using PowerShell with Content Matrix
Adding PowerShell Snap-Ins for the Application Framework Content Matrix PowerShell Commandlet List
Metalogix.System.Commands Metalogix.SharePoint.Commands Metalogix.Jobs.Reporting.Commands Metalogix.SharePoint.Migration.Commands
Modifying Content Matrix Configuration and Settings Configuring Content Matrix for Distributed Migration Frequently Asked Questions
DB_Owner Permission Keyboard Shortcuts Activating the License Key Silently License Key Troubleshooting Errors Connecting to SharePoint 2019 or SharePoint Server Subscription Edition in a FIPS-Enabled Environment Determining the Status of a Migration Running in the Background MySite and User Profile Migration Issues Optimal Setup for Best Performance Migrating SharePoint On Premises Using Proxies, Load Balancing or Alternate Access Mappings Extensions Web Service Installation Files Migrating JavaScript Migrating Site Variations Migrating with SharePoint Document IDs Changing a Job Configuration for Multiple Files SharePoint Site Collection Creation Issue Customized Wiki Page Web Part Zones Not Being Migrated Preserving SharePoint List Item IDs When Migrating to SharePoint Online Retrying Failed Document Copies to SharePoint Online CSOM Connections Import Pipeline Batches Getting Stuck Migrating Content When the Source Custom List Template is Missing When Migrating to SharePoint Online HTTP Status Code 429 (“Too many requests”) or 503 (“Server Too Busy”) Message Returned How Do I Identify and Remove Containers and Queues from My Azure Private Storage Account? Error: 'The object is associated with property AssociatedMemberGroup.' Migration Error: 'ERROR, the batch will be resubmitted to the import pipeline' Item Count at Target is Increased When Migrating Using the Import Pipeline Custom Lists with Versioning Enabled Not Being Migrated When Using the Import Pipeline Supported Nintex Actions for SPO Migration Support for GCC High Tenants
About Us

Transforming List Columns into Managed Metadata Fields

1.In the Managed Metadata Options tab, make sure you select the appropriate option(s):  

§Transform specified site columns to managed metadata columns

AND/OR

§Transform specified columns in lists to managed metadata columns

2.Click the […] button to the right of the selected option to display the Configure List Column Transformations options window.

3.In the Explorer View section of the Configure List Column Transformations window, navigate to the top level site or list node to which the transformation(s) should be applied.

The top level node displayed in this window will be the target node that was selected for the migration. This allows users to either:

§Select the top level node and apply the transformation to content beneath it

OR

§Select a specific sub-site, list, or document library and apply the transformation to selected items.

Configure Site Column Transformations

NOTE:  In the case of site column transformation, the site column will be applied to all instances of that site column from the top level node down.

4.Select the appropriate configuration option to apply: Use the information in the following table for guidance.  

If you want to …

Then …

transform a column from the selected site or list

Select Configure Transformation for a Column.

NOTE:  The Configure Transformation for a [Object] Column dialog > Transform Columns tab pre-populates the Source List field with the URL for the selected site or list.

select one or more sites or lists containing the column to transform based on filter conditions

A.Select Configure Transformation using a Rule.

B.Click the […] button and apply filter conditions

For example, you can choose to transform columns for all lists that whose internal name contain the word “Library.”

CONTEN~1_img123

5.In the Transformation Columns tab - Source section, specify the Site Column or List Column to which you want to apply the transformation.   Click the […] button and apply a filter to narrow the scope to which that the transformation will be applied.  For example:

§If you set the List Filter Conditions to "DisplayName Contains Marketing" then only content that contains "Marketing" within the DisplayName column will be included in the transformation.

CONTEN~1_img124

§If you set the Site/List Column Filter Conditions to if the value is set as "Name Contains Sales" then only columns that contain "Sales" within the Name value will be transformed into Managed Metadata columns.

 

CONTEN~1_img125

6.Complete the Transform Columns tab – Target section as follows:

a)Select the Term Store to use for the new Managed Metadata field on the target from the drop-down.

This drop down menu displays all of the available Term Stores for the target node.

b)Select a Term Group from within the selected Term Store from the drop-down.

NOTE: If you want to create a new Term Group and/or Term Set instead of using a pre-existing one, you can manually enter a text value in the Term Group and/or Term Set field, and Content Matrix will create the new group/term within the Term Store, and apply it to the transformation.

7.If you want to set an anchor point below the selected Term Set for adding new taxonomy terms, enter the Term Anchor.

EXAMPLE:  The selected Term Store contains a Term Group called People, within which is a Term Set called Department.

CONTEN~1_img126

If you do not set a Term Anchor, Content Matrix will add new terms directly below the Department Term Set.

CONTEN~1_img127

If you were to set the Term Anchor to Engineering, new terms would be added as child terms of the Engineering Team.

CONTEN~1_img128

 

To set a Term Anchor further down in the term hierarchy, use the “>” sign to “drill down” to the desired level.

You can even create a new term as a parent for transformed terms.  For example, if you want to create a new term, Toronto, as a child term of existing term DEV, you would enter the Term Anchor as Engineering>DEV>Toronto.  New terms would then be added below Toronto.  

 

CONTEN~1_img129

8.If you want the transformation to apply to a column other than the column that corresponds to the selected source column, check the Transform to New or Existing Column box.

The following table describes how Content Matrix handles transformations when this box is checked.

If …

Then …

both the Name and Display Name entered are identical to an existing column on the target

the column on the source will be transformed into that column on the target.

either the Name or the Display Name do not match an existing column on the target

·a new column is created on the target with a new Name and Display Name, and

·the Managed Metadata transformation is applied to this new column.

EXAMPLE:  If there is a column on the source named "Author", and the values in this column are to be transformed into Managed Metadata values, then this option could be used to create a new column named "AuthorID". All the values from the "Author" column on the source would be copied into the "AuthorID" column on the target, and the Managed Metadata transformation is only applied to "AuthorID", leaving "Author" unchanged.

9.If you checked the Transform to New or Existing Column box, enter the Internal Name and Display Name of the new column you want to create or the existing column you want to use.

NOTE:  The Internal Name should not contain spaces.  If you are transforming to an existing column, make sure you enter both the Internal Name and Display Name exactly as they appear on the target.

10.If you want to substitute source item values with new values that will be used as Managed Metadata terms:

b)Select the Substitute Source Item Values tab

Either:

§enter the Value you want to substitute exactly as it appears on the source

OR

§click the Filter icon (CONTEN~1_img130) and apply one or more filter conditions.

CONTEN~1_img131

11.Enter the Substitute value exactly as you want it to appear on the target.

CONTEN~1_img132

12.Click [OK] to close the Configure Transformation dialog.

CONTEN~1_img133

13.Click [OK] to close the Configure Transformation for a List Column dialog.

The new transformation now displays in the bottom (Configurations) section of the window.

NOTES:

·When a site column transformation is set, the Transform specified columns in list to Managed Metadata columns option in the Managed Metadata Options tab will now be selected as well. Because a site column is still a column in a list, the site column transformation will also be visible in the list column transformation dialog. However, you will be unable to edit the site column transformation from the Configure List Column Transformations dialog even though it is visible. The List Filter value in the "Configuration" section of this dialog will also be empty, which will help you differentiate between a list/field transformation and a site column transformation.

·If a site column transformation is being applied, and the specified site column exists within a content type, you must also check the Copy Content Types option in the Site Options tab of the configuration options. If this option is not set when applying a transformation to a site column in a content type, then not all of the columns will be available for edit in SharePoint's item edit dialog, after migration.

Using PowerShell to Create Custom Transformations

When you select the Add Transformer > Invoke PowerShell script option for an Available Definition, you can use custom PowerShell scripts to create your own transformations beyond the built-in capabilities of the Content Matrix.

Specify when you want the script to run by selecting one of the following options:

Begin Transformation – The transformation script will run before the migration of the affected objects, allowing you to read and make changes to objects on the source before objects themselves migrate.  

Transform – The transformation script will run while the migration of the affected object(s) is in progress.  For example, the user mapping between source and target would be run using the Transform option.

End Transformation – The transformation script will run after the migration of affected object(s), allowing you to read and make changes to objects on the target.  

EXAMPLE:  The following Transformer consists of two scripts for disabling and re-enabling the Required setting for a column list.

·The first script entered into the Begin Transformation tab sets the setting of any columns that are Required to false before copying begins.

Configure PowerShell Transformer

·The second script, entered into the End Transformations tab, sets the setting back to true after item migration has completed.

CONTEN~1_img135

Saving or Running a Migration Job

When you finish configuring a migration action, you can run it immediately or save a copy of the settings to a job file, which displays in the Job List section.  You can then:

·run a migration directly from the Job List section

OR

·If your environment is configured for Distributed Migration, submit a Distributed Migration job.

OR

·create a PowerShell script and schedule it to run as a Windows Scheduled Task

OR

·trigger jobs in the Content Matrix Console to run using PowerShell.

You can also save the job configuration as a template so that you can preserve and reuse settings for future migration jobs.

When the migration starts, a status dialog box will appear. The job logs can be viewed (in progress or after the migration is finished) by clicking [Details>>]. The Status section of the status box will list a live count for the number of successes, warnings, failures, etc. for the migration. The Progress section of this dialog will list any completions and the type of completion (Sites, lists, items, users, groups, etc.). A Migration Completed message will appear when finished. Click Close to exit the status dialog.

Connecting to a Full SQL Job Database

If you are using SQL CE to host your Content Matrix Jobs Database, you will receive a warning in the job log (and as a pop-up if you are running the job from the Console interface).

The use of SQL CE in a production environment is discouraged because of the following limitations:

·It uses a single .list file that is less robust and reliable and may be corrupted after the database reaches 4 GB.

·Data compression is not supported.

·Support for large objects is limited.

To switch to a full-feature SQL Server for the Content Matrix Job Database:

1.From the Job List choose File > Connect to Job Database.

Switch Jobs Database

2.Complete the Connect to SQL Server dialog:

§If you are connecting to an on premises SQL database, create (using the New Database option) or select the database you want to use.

Select Jobs Database

§If you are connecting to an Azure SQL database, select the database that has been created in Azure Portal for use by Content Matrix.  (Note that the New Database and Delete Database options will be disabled.)

SQL DB List Azure

3.If you want to use an encrypted connection to the database, check the Encrypt Connection box.

NOTE: If the certificate used for encryption is not trusted, you will also need to check the Trust Server Certificate box.

4.Select an Authentication method for connecting to SQL server:

·Use Current Windows User

OR

·Use SQL Server Login

NOTE:  Currently, Use SQL Server login is the only valid option for an Azure SQL server.

5.Click [OK].

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen