Review and export

The Review step is the last step of a mapping. It shows what is still open, and exports the mapping as a Mapping Sheet for the transformation flows.

Check what is still open

At the top, a card per step shows how many rows are mapped, and either N unmapped or ✓ All mapped. Click a card to open that step.

Below them are two lists.

Rows without a target

For every step with unmapped rows, the list says how many are left. Click Fix to open the step with only the unmapped rows shown. Map each row, or set it to No op to leave it out of the migration. When nothing is left, the list shows Everything is mapped.

Sheet checks

The sheet checks look at the rules, the source paths and the target fields of the Metadata step. Each check is marked Fix (an error) or Check (a warning). Click Open to go to the row. The same checks are shown on the row itself, in the table and in the details panel.

Level	Check	What to do
Fix	The target field doesn't exist on the target content type. This happens when you change the target content type after mapping its fields.	Pick the target field again.
Fix	A Fixed value or Value list rule has no Parameter.	Fill in the Parameter.
Check	The field has no source content store path, so there is no value to copy.	Add the path, or use a fixed rule.
Check	A Fixed value rule is set on a field that has a source path. The path isn't used.	Nothing, if the fixed value is what you want.
Check	Max length is set, but the target field isn't a text field.	Remove the max length, or check the target field.

When there are no issues, the list shows No issues found.

Export the Mapping Sheet

Click Export Mapping Sheet. Your browser downloads Mapping Sheet - <name of the mapping>.xlsx.

If rows are still unmapped, if rows fail the sheet checks, or if there are unsaved changes, the first click only shows a warning. Click Export Mapping Sheet again to export anyway. Unsaved changes are saved before the file is created.

The Export preview below the button shows the sheets as they will be exported. Use the tabs to switch between them.

What the file contains

• The five mapping sheets: Structures, Content Types, Metadata Fields, Principals and Permissions. Every column is filled in from the mapping: your choices, your settings, the calculated target details, and your extra columns after the template columns.
• Only mapped rows. Unmapped rows and No op rows are left out, because the transformation flows take every row in the sheet as a mapping.
• The five target sheets, such as Target Structures. With them, you can import the file again to continue the mapping.
• Plain values. No formulas, no dropdowns and no checks. You can open and edit the file in Excel.

Use the export in the transformation

The transformation flows read the Mapping Sheet from the path in their mappingSheetPath setting. To use your export:

1. Find the path of the Mapping Sheet that the transformation uses, for example C:/Migrations/Mapping Sheet.xlsx.
2. If your Metadata step uses Value list (lookup sheet) rules, copy the lookup sheets from the current Mapping Sheet into the exported file. Keep their names the same as the Parameter of the rules.
3. Back up the current Mapping Sheet.
4. Put the exported file at that path, and rename it to the original name, for example from Mapping Sheet - Mapping 1.xlsx to Mapping Sheet.xlsx.
5. Run the transformation.

Change the mapping in the Mapping Tool

To change the mapping later, change it in the Mapping Tool and export again. If someone edits the exported file in Excel, import it as a new mapping, so the Mapping Tool has the latest choices.