AvePoint Docs
Graph API
My support tickets
Graph API
My support tickets
English

    Home > Perform SharePoint Online Migrations > Create Migration Mappings

    Export to PDF

    Create Migration Mappings

    After creating a project, create migration mappings to define the source and destination objects.

    You have two accesses to create mappings for a project.

    - You can create mappings directly after creating the project using any of the following methods. - Add mappings - Import mappings - Auto map (Only available for SharePoint Online to SharePoint Online migrations) - You can also click **Projects** in the left pane to access the **Projects** page, and click the project name of the project for which you want to create mappings. On the **Project mappings** page, you can directly click **Create mapping** to add mappings one by one or import mappings in bulk. For a SharePoint Online to SharePoint Online project, you can also click the down arrow next to **Create** **mapping**, and then select **Add/Import mapping** or **Auto map** to create mappings.

    Add mappings:

    To manually add mappings, refer to the following steps:

    1. Click Add on the Add/Import mapping page.

    2. For SharePoint Online to SharePoint Online migrations, enter the full source and destination object URLs like the screenshot shown below.

    3. Examples for source and destination object URLs.

    4. For SharePoint Online to Google Drive migrations, enter the source and destination like the screenshot shown below.

    5. Examples for source and destination objects.

    6. There are some notes need your attention:

      • If the destination is a shared drive, make sure the shared drive exists in the destination. Otherwise, the migration job will fail.

      • If there are multiple user drives or shared drives with the same name in the destination, the migration job will fail.

      • If there are user drives and shared drives with the same name in the destination, the object will be migrated to destination shared drives.

    7. Select the object level for the source objects. If the destination is SharePoint Online, you also need to select the object level for the destination objects.

    8. Select a migration Method for the mapping to define how to migrate the source objects.

      • Merge – Select this option to migrate all content in the source object to the destination object.

      • Attach – Select this option to migrate the source object to the destination as a child under the destination object.

    9. Click Save after you finish adding mappings to the project.

    10. If there are mappings that already exist in another project, the Alert panel will appear. You can select to remove duplicate mappings from the current project, or move duplicate mappings found in other projects to the current project. Then, click Save to save the updates.

    Import mappings:

    To import mappings in bulk by importing a configured Excel file, refer to the following steps:

    1. Click Import on the Add/Import mapping page.

    2. In the Import panel, you can download the template for mapping examples and configure mappings directly in the file; or you can click Export on the Add/Import mapping page to export a mapping file and modify it.

    3. For SharePoint Online to SharePoint Online migrations, configure the information of each mapping in one row, and save the file. You can refer to the table below for how to configure the mappings.

      SharePoint Online mapping fle

    ColumnValue
    Source URLThe full URL of the source site collection/site/list/library/folder.
    Source object levelSelect any of the following values to indicate the object level of the source node.Site collectionSiteListFolder
    Destination URLThe full URL of the destination site collection/site/list/library/folder.
    Destination object levelSelect any of the following values to indicate the object level of the destination node.Site collectionSiteListFolder
    MethodMerge Attach
    Refer to the table below to see the supported methods for different object levels:
    MethodMethodDestination Object LevelDestination Object LevelDestination Object LevelDestination Object Level
    MethodMethodSite CollectionSiteListFolder
    Source Object LevelSite CollectionMerge/AttachMerge/Attach--
    Source Object LevelSiteMerge/AttachMerge/Attach--
    Source Object LevelListAttachAttachMerge-
    Source Object LevelFolder--Merge/AttachMerge/Attach

    1. For SharePoint Online to Google Drive migrations, configure the information of each mapping in one row, and save the file. You can refer to the table below for how to configure the mappings.

    2. There are some notes need your attention:

      • If the destination is a shared drive, make sure the shared drive exists in the destination. Otherwise, the migration job will fail.

      • If there are multiple user drives or shared drives with the same name in the destination, the migration job will fail.

      • If there are user drives and shared drives with the same name in the destination, the object will be migrated to destination shared drives.

      Examples for source and destination objects.

    ColumnValue
    SourceThe full URL of the source list or folder.
    Source object levelSelect any of the following values to indicate the object level of the source node.SiteListFolder
    DestinationThe full URL of the library or folder.
    Destination object levelFolder
    MethodMerge Attach
    Refer to the table below to see the supported methods for different object levels:
    MethodMethodDestination Object Level
    MethodMethodFolder
    Source Object LevelSiteMerge/Attach
    Source Object LevelListMerge/Attach
    Source Object LevelFolderMerge/Attach

    1. After the configurations, import the mapping file by dragging the file or browsing the file from the local location. Click Save to save the mapping file to the project.

    2. Click Save after you finish adding mappings to the project.

    Auto map (Only available for SharePoint Online to SharePoint Online migrations):

    To auto map the site collections, make sure you have configured and scanned the objects in AvePoint Online Services.

    After you click Auto map, the source and destination site collections will be automatically mapped based on URLs. You can click Re-scan to map the source and destination site collections again. If there is no mapped URL in the destination, enter one in the field.

    If the destination site collections of the same relative URL as source site collections do not exist, an Alert window will appear for indication. Click Yes in the window if you want Fly to automatically add the destination site collection URLs using the source site collection information, or you can click No to configure your desired destination site collection URLs for source site collections. The domain of the destination service account or app profile must match with the SharePoint admin center URL. If the destination domain does not match with the SharePoint admin center URL, you can click AvePoint Online Services in the window to edit the URL.

    Click Save after you finish adding mappings to the project.

    Other Actions

    You can also perform the following actions to manage migration mappings in the project.

    - Refresh stage status – Click **Refresh** to retrieve the stage’s latest status of the mappings. - Prioritize mapping job – Select desired in queue mappings under the **Migration** stage, click the More (![Button: More button.](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image501.png "Button: More button.")) button, and click **Prioritize mapping job** to move the mappings to the front of the queue. Fly will prioritize running migration jobs for these mappings when resources are available. - Edit Mapping – Select a mapping, click the More (![Button: More button.](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image502.png "Button: More button.")) button, and click **Edit mapping** to update the mapping. > ***Note**: If a mapping contains successfully migrated data or is running, you cannot edit it. - Clear mapping report – To clear the migration details of mappings, select the mappings, click the More (![Button: More button.](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image503.png "Button: More button.")) button, and click **Clear mapping report**. Once finished, the source data scan report **migration data** **report, and migration error report** of the selected mappings will be cleared. - Move mappings – To move mappings from the current project to a different project, select the mappings, click the More (![Button: More button.](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image504.png "Button: More button.")) button, and click **Move mapping**. Select a project and click **Move** in the **Move mapping** panel. You can enter the keyword of a project in the **Search** **project** text box and click the Search (![Search button.](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image505.png "Search button.")) button to search the project. - Delete mappings – To delete mappings that are not needed, select the mappings, click the More (![Button: More button.](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image506.png "Button: More button.")) button, and click **Delete mapping**.

    Generate migration report – When the migration jobs are finished, you can generate summary reports and detailed reports of objects for selected mappings. Refer to Generate Report for details.

    - Categorize with color – You can categorize your mappings with a desired color. What the applied color represents is left up entirely to your organization. - You can hover your mouse over a mapping and click the apply color (![Icon: Apply color](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image507.png "Icon: Apply color")) button. Select a color in the **Select a color** window to apply to the mapping. - You can also select one or multiple mappings, click the More (![Button: More button](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image508.png "Button: More button")) button, and click **Categorize with color**. In the **Select a color** window, select a color and click **Apply**. - Export mapping – To export mappings in a project to an Excel file, select desired mappings, click the More (![Button: More button.](/en/fly-user-guide/perform-sharepoint-online-migrations/images/image509.png "Button: More button.")) button, and click **Export** **mapping**. - Manage columns – Click **Column** to select the columns you want to display on the page, and click **Apply** to apply the display conditions. The **Source** column cannot be deselected. - Filter mappings – Click **Filter** to filter mappings by desired conditions. - Create personal view – This allows you to create a personal view for the configuration of filters or displayed columns for convenience. Click the **System view** drop-down list behind **Filter**, and click **Save as**. In the **Save as** window, enter a name for your view. To make this view available only to you, enable the **Make this a private view** button to save it as a private view. To make it available to all accounts of your AOS tenant, leave the **Make this a private view** button disabled to save it as a public view. - After creation, either a private or public view can be set as default, renamed, or deleted. A private view can also be made public. - Search mappings – Search mappings by entering the keyword of the source/destination in the search box.