Once you have created a new SharePoint BCS column to the source Metabase project and set BCS values to the File System documents, you can map the columns like any other metadata when you configure your migration.
However, the following should be considered when setting up a mapping.
·The external content type associated with the source SharePoint External (BCS) column must match the content type associated with the target External Data column in SharePoint.
·Values in SharePoint External (BCS) columns can only be mapped to lists on the same SharePoint instance to which the column is connected to.
·Mapping to a new column with a SharePoint External (BCS) column as the source will result in the creation of a single line of text column in the SharePoint list.
Metalogix Content Matrix - File Share Edition has a special dialog that allows you to edit Long String column type values into more "readable" text prior to migration..
NOTE: A "Long String" column may be displayed as Read Only, however, these values can still be edited.
To edit Long String column values:
1.In Explorer View, select the folder containing the items whose long string column values you want to edit.
2.Switch to Items View.
3.Select the long string value that you want to edit
4.To display the Edit Text - Long String dialog, either:
§Double-click to enable editing.
§Click the Show Properties icon then click the [...] button that displays to the right of the selected property.
5.In the Text Visualizer tab lets users edit the contents of the long string property.
NOTE: If the long string text value is in structure XML, the XHTML Visualizer tab becomes available, which is useful for viewing the value as structured XML, as well as rendered content.
6.To view/edit a different long string column properties for the same item, select it from the Property drop-down.
Note that only long-string properties are listed in this menu.
You can create new SharePoint site collections, sites, folders, and lists via the Metalogix Content Matrix Console.
You can create a new SharePoint site via Metalogix Content Matrix under an existing site collection or site except for Database connections and the new site can use any site template that is installed on the SharePoint environment.
To create a new SharePoint site:
1.In the Explorer View, select the site collection or site under which you want to create the new site.
2.Right-click and choose Create Site.
The Create Site dialog displays, prompting you to enter the Site Title, Site URL Name, Description, and Template for the new site.
NOTE: For Site Url Name, it is only necessary to enter the name of the site as you want it to appear in the url, not the entire url path.
3.When you have completed the fields on the Create Site dialog, click [OK].
The new site will now display in Explorer View.