Chat now with support
Chat with Support

Metalogix Content Matrix 8.8 - SharePoint Edition User Guide

Introduction Entering the License Key Content Matrix Console End User Interface Enabling Advanced Mode Connecting to SharePoint Preparing for a Migration How Content Matrix Handles Various SharePoint Components Initiating a Migration Configuring Copying Options Saving or Running a Migration Action Copying SharePoint Objects as a Separate Action Self-Service Migration Incremental Migration Log Files Using PowerShell with Content Matrix
Configuring PowerShell for Use with Content Matrix
Registering Metalogix Command DLL Files 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 and Self-Service Migration Frequently Asked Questions
DB_Owner Permission Migrating with the Fabulous 40 Templates Item Count Discrepancies Keyboard Shortcuts License Key Troubleshooting Determining the Status of a Migration Running in the Background MySite and User Profile Migration Issues Optimal Setup for Best Performance Using Proxies, Load Balancing or Alternate Access Mappings Troubleshooting the Extensions Web Service Installing the Extensions Web Service on Specific Systems Extensions Web Service Installation Files Using Older Versions of the Extensions Web Service Preserving IDs when Migrating a Custom List as a Folder Migrating JavaScript Migrating Site Variations Migrating with SharePoint 2010/2013/2016 Document IDs Changing a Job Configuration for Multiple Files SharePoint 2003 Version Migration Limitations SharePoint 2013 and 2016 Site Collection Creation Issue Job List Database fails to Load After Upgrade Customized Wiki Page Web Part Zones Not Being Migrated Preserving SharePoint List Item IDs with a CSOM Connection Type Retrying Failed Document Copies to O365 CSOM Connections Migrating Content When the Source Custom List Template is Missing Are SharePoint Online Migrations Throttled? What to Expect when Migrating with StoragePoint on the Target Migration Error Message 'There was an Error Reading from the Pipe: The Pipe has been Ended (109, 0xd6)' How do I Remove Items from My Azure Blob Storage Account? Azure Batches Getting Stuck Supported Nintex Actions for SPO Migration "Insufficient Credentials" Message Connecting to Modern Team Site Using Web Browser Authentication Error Making a Browser-Based Connection with PowerShell Console Open
About Us

Extracting Source Content from Property Columns

You can pull out (extract) a specific set of data from within an existing source property column and place it within another property column for an entire folder or individual items.

Only results that can be pulled directly from the item's metadata value will be returned when the extraction is run. This type of extraction can be useful for pulling content from a single item, or pulling a set of content from all items at one time.

Before an extraction action is started, make sure you have a good, clear idea of what content is to be extracted.

Advanced Mode Icon  This option is only available when Advanced Mode is enabled.

To Extract Content from a Property:

1.In Explorer View, select the folder that contains the content you want to extract.

2. To display the Extract Content from Property dialog, use on of the following options:

§To extract content from the entire folder, right, click and choose Metadata Modifications > Extract Content from Property.

§To extract content from one or more items, switch to Items View, select the item(s) and choose Metadata Modifications > Extract Content from Property.

Extract Content from Property

3.Enter the search parameter in the Find field.

4.This can be an XPath query, plain text, a number value, part of a user name, etc

Select a Search value from the drop-down.

5.Select a Search Logic option, based on the type of data that you want to extract.  Options are:  

§XPath Query - If the property contains XML, an XPath query can be used to extract information.

§Regular Expression - Uses a "Regular Expression" search expression to find text.

When this options is selected the Multiline option becomes available and, if checked, regular expressions will search past new line characters.

§Text Search - Runs a text search through the selected property field, looking for a value that matches the text in the Find option.

When this option is selected the Match Case option becomes available which, if checked will make the search  case sensitive.

6.If you want to run the extraction on any sub-folders under the currently selecte folder, check the Recursive box

7.Set the desired Extract option. Use the information in the following table for guidance.

If you want to ...

Then ...

count the number of matches Metalogix Content Matrix can find in the source content that matches to the Find value and enter that number in the selected output column

For example,  if a property column contains values that are written in HTML, and you want to find out how many "<P>" tags are in the property value, you can enter an XPath query to select all "<P>" tags, and run the extraction. The number of "<P>" tags in that property column value will be returned in the selected column. So if there are five paragraphs in the property value, the extraction will enter "5" in the selected output property column.

select Counts only.

search for and extract the first match value found for each item

First Match Only.

search through the selected content and extract all values that match the Find value and appended them as a string of text into the output property column

All matching results.

8.If you selected All matching results, enter a Separater value so that each returned result will be separated within the same cell in the Workspace:

§; - Adds a semi-colon between results.

§: - Adds a colon between results.

§\t - Adds a "Tab" between results.

§\n - Places the new results on a new line.

§\r\n - Adds a carriage return and new line between results.

9.If you elected XPath Query as the Search Logic, set the desired Format option:

§Text - When selected, this option will run the search through the text level of the code (within the property value), and the output will only contain the text, and not any of the actual code. For example, in the xml node: <xml><inner>text</inner></xml> the returned extracted value would be "text."

§Inner XML - When selected, this option will search and extract any text values as well as any of the inner XML coding. For example, in the xml node: <xml><inner>text</inner></xml> the returned extracted value would be "<inner>text</inner>."

§Outer XML - When selected, this option will return all of the xml code that matches the XPath value. For example, in the xml node: <xml><inner>text</inner></xml> the returned extracted value would be"<xml><inner>text</inner></xml>."

10.In the Extract to column drop down menu, select a new or existing property column that the data will be extracted into.

If a target column for the extraction does not already exist, click [New] and add the column.

11.Click [Run] to run the extraction 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 Jobs List section

OR

§schedule the job to run at a specified time, either as a Windows Scheduled Task or straight from PowerShell.

Related Documents