In this article, we will review the migration steps of the Smartsheet - Project for the web migration scenario.
To launch the migration from Smartsheet to Project for the web, you will need to take several steps.
Step 1: Connect to source and target system
To start the migration process, perform the following:
1. Open the Project Migrator home page and click on the Smartsheet system icon, select the Smartsheet -> Project for the web scenario.
Alternatively, click on the Start Migration button and select the source and target systems manually.
2. Click on the 'Connect' button to connect to your Smartsheet account.
3. Provide your credentials and log in to your Smartsheet account.
Please refer to the Connection Account Requirements article for more details.
4. Click Allow in the window that appears to allow Project Migrator access to your Smartsheet environment.
When the credentials are added once, they are encrypted and stored for your convenience after launching the migration. The next time when you need to launch the migration process, you can select from the list of credentials added before.
If you need to change the account you have provided, click on the Change button.
5. On the next step click Connect to connect the target Project for the web account.
In the Environment field provide the URL of your Power Platform Environment where the Project for the web is deployed. Please refer to the 'How to find the Environment URL for Project for web' article for detailed instructions on how to find the required URL.
Provide the credentials and log in to Project for the web using your Office 365 account.
Project migrator allows mapping Attachments task field from Planner to Project for the web and creating custom fields in Project for the web from the mapping step directly. All types of dependencies can be migrated from Smarhseet to Project for the web. To use this functionality, it is required to generate a token when connecting to your Project for the web environment.
Please note: If you do not need to map the Attachments field or create custom fields, leave the 'Custom fields and attachments Token' field empty.
Click Proceed.
When connecting to Project for the web for the first time, Office 365 tenant Global Administrator consent (Admin Consent) is required to grant Project Migrator app permissions to access Office 365.
Admin Consent should be granted to Project Migrator only once. When consent is granted by Global Admin, any other account that meets the requirements can be used to add more connections within the same Office 365 tenant.
When the source and target systems are added and connected, you can proceed to the next step and select source data for migration.
Step 2: Select Source Data
Project Migrator allows selecting all data for migration or only the required items from the list.
'All' option is selected by default. If you select the 'All' option, all Smartsheet sheets to which the source connection account has access will be migrated.
'Selected' option allows migrating only the sheets which you select from the available sheet list will be migrated.
Click the 'Selected' button.
'Available sheets' window will be opened. There are several fields on this page that you can use to filter the information out and make the selection faster.
Select the required sheets from the list and click the 'Add Selected' button.
Please note: If you have not purchased any subscription plan yet, a free plan (for 2 projects) will be applied. If you have exceeded the limit of projects that you can select for migration according to your subscription plan (free or paid one), you can upgrade your plan from this page directly by clicking on the 'Upgrade to (number) of projects plan' button.
For more information, please refer to the 'Project Migrator Subscriptions' article.
When the items are selected, you can proceed to the next step: Step 3: Object Mapping.
Step 3: Object Mapping
1. Migration settings.
Microsoft 365 Group Creation Mode: In this section, you can select whether to create a separate group for each Project, create groups with source group names and settings, or create all Projects in one group (new or existing).
'Create groups using source workspace names': this group creation mode allows preserving source workspace names for the selected Sheets in the target. Target Microsoft 365 groups will be created with the same names as the source workspaces. The following users will be added to the created M365 group:
- Target account will be added to the Microsoft 365 group as owner and member if a new group is created if the group already exists then the target account will be added as a member.
- Workspace owner is added to the Microsoft 365 group as a group owner.
- Workspace members (users and contacts workspace are shared to) are added to the Microsoft 365 group as members.
- All selected sheet owners are added to the Microsoft 365 group as group owners.
- All selected sheet members are added to the Microsoft 365 group as group members.
Please note: if personal sheets are selected for migration or shared to the user Sheets but the corresponding workspace is not shared, the Microsoft 365 group with the name ‘Sheets’ will be created, and those sheets will be added to this group. Only selected sheets owners and members will then be added to this group as owners/members accordingly.
Please note: If there is an existing group with the same name and mail nickname in the target tenant, but the connection account is not a member or an owner of that group, a new group will be created with a bit different mail nickname.
'Create groups using Sheet names': if this option is selected, each project will have a separate group created. The groups will be created with the same names as the Sheet names in this case.
If a group with the same name already exists in Project for the Web, a new group will not be created. Project Migrator will find this group by name and will use it for migration (taking into account the setting below 'Create new or merge with existing Projects').
The following users will be added to the created Office 365 group:
- Target account will be added to the Microsoft 365 group as owner and member if a new group is created, if a group already exists then the target account will be added as a member.
- Workspace owner is added to the Microsoft 365 group as a group owner.
- Workspace members (users and contacts workspace are shared to) are added to the Microsoft 365 group as members.
- The selected sheet owner is added to the Microsoft 365 group as a group owner.
- The selected sheet members are added to the Microsoft 365 group as group members.
If the 'Create all Projects in one group' option is selected, all projects will be added to the same group during migration.
In the Group Name field, you can provide the name of an existing group or a new group name to create a new group during migration.
The following users will be added to the created Microsoft 365 group:
- Target account will be added to the Microsoft 365 group as owner and member if a new group is created if the group already exists then the target account will be added as a member.
- All workspace owners are added to the Microsoft 365 group as group owners.
- All workspace members (users and contacts workspace is shared to) are added to the M365 group as members.
- All selected sheet owners are added to the Microsoft 365 group as group owners.
- All selected sheet members (users and contacts sheet is shared to) are added to the Microsoft 365 group as group members.
Please note (valid for all settings): if the workspace or sheet is shared with a contact from another user contact list then this contact will not be listed in the user mapping and will not be added to the target M365 group. The source account can migrate only contacts from his own Contact list.
Project creation mode: In this section, you can select how projects should be created if there are Projects in Project for the web with the same names as Plans in the source system.
The 'Create new or merge with existing ones' option allows creating new Projects or merging the data to the existing Projects with the same names as the source Plans if any.
The 'Create new and remove existing Projects before creating' option allows creating new Projects from scratch, deleting the existing ones with the same names as the source Plans, if any. In this case, existing Projects with names that match selected source Plan names will be removed together with all their tasks.
2. Sheet Field Mapping
In this section, you can review Sheet field mapping. The Sheet name corresponds to the Project in Project for the web.
3. Column Mapping
This section is used to map the row columns from source Sheets with the target Project for the Web task fields.
You can review which column values are migrated from the source Smartsheet system to the target Project for the Web system.
Default columns will be mapped automatically by name and compatible type once the connection to the source and target systems is established and items to migrate are selected. In case multiple source columns compatible with a target field are found by the name, they all are added for mapping.
It is also possible to add custom fields for the mapping. All the compatible source columns and target fields available for mapping are listed and can be selected in the drop-down menus of Column Mapping.
You can also check the 'Multiple' checkbox and select several columns for mapping.
If you select several source columns for mapping, you can also select the 'Join Values' option. In this case, values from all the selected source columns will be added to the target field.
If the 'Use First Found' option is selected, the values from the first mapped row column found in the source Smartsheet will be migrated to the mapped target item field.
If a custom column that allows having multiple custom values (e.g. field of the Dropdown type) is selected for mapping, check the 'Use Custom Lookup' option to map particular values of the source row column with values of the target field.
If you do not need to migrate any field values, you can remove such fields from the mapping.
Please note: By default, Project Migrator will use the Sheet Primary Column field to map with the Title target field. In this case, your primary columns from all Smartsheet Sheets will be mapped to the Title field on the target. If needed, the Sheet Primary Column can be deleted and you can use any other compatible field (for example Task Name or Title) to map with the Title field.
If there is a need to map the primary column for some Sheets to the Title field, and Task Name/Title or any other compatible field for other Sheets with the Title field on the target, several fields can be selected in the source field value, but their position will be taken into account during migration.
If the Sheet Primary Column field is selected as the first one, primary columns will be taken for mapping for all Sheets. If other fields are selected first, and then the Sheet Primary Column field, then Project Migrator will map other selected source fields first, and for those Sheets where there are no such fields, the primary column will be taken for mapping with the Title target field.
The task field mapping can be edited and adjusted to a particular migration scenario to include all needed source task fields or remove the unnecessary ones. For more details, please refer to this article.
If the token was created when adding Project for the web connection, you can create target custom fields from the mapping page directly. For more details, refer to the 'How to create task custom fields' article.
Also, you can use the Add Mapping button to add more fields for mapping.
4. Users Mapping
This section is used to map the users from Smartsheet to the target Project for the web system.
Please note: User mapping will include all Smartsheet environment users and all contacts from the Contact list of the source connection account.
Please note: The users cannot be migrated from Smartsheet to the target Project for the web tenant. User accounts should already exist in the target environment (in the Active directory of your Project for the web tenant) before the migration starts. In this case Project Migrator will find the required users by their accounts and will map them automatically to migrate the assignments and other resources data to the target Project for the web environment.
If there is no corresponding account on the target system (Project for the web), then the line with such a user will be highlighted in red and will have a 'Not Mapped' status. Such users will not be taken for migration.
If there is incomplete correspondence for some of the users (for example, the email is the same but different user names), they will have the ‘Partial Match’ status and will be marked with yellow color. Pay attention to such lines and correct the mapping if needed.
If there is complete correspondence found, such users will be marked with green color with the 'Match' status.
You can review the mapping summary at the top of the section.
'Create resources for not mapped users' allows creating resources in the target Project for the web system and preserving the task assignments for users that were not mapped. However, users (new user accounts) will not be created in the Azure Active Directory on the target.
User Mapping can be exported to an Excel file. You can map the users in the Excel file if needed and upload the mapping from the Excel file to Project Migrator, User Mapping section.
Step 4 - Launching the migration process
When you complete all steps: set up the connection between source and target, select data for migration, and perform mapping you can launch the migration process.
To launch the migration process click on the Proceed button under the 'User Mapping' section.
Migration Summary window will be opened. Review the information in the Migration Information section and click the 'Start Migration' button to launch the migration process.
Please note: If you have not purchased any subscription plan yet, a free plan (for 2 projects) will be applied. If you have exceeded the limit of projects that you can select for migration according to your subscription plan (free or paid one) and did not upgrade your plan while selecting the projects, you will see the 'Proceed to Checkout' button instead of the 'Start Migration' one. You can upgrade your plan by clicking on this button and then launching the migration process.
Data Migration Summary window will be opened displaying the Summary Information and the progress for the migrated groups and Projects as well as Migration Settings and Mapping. You can close this window.
Also, the migrated sheets can be opened and reviewed in the target system from the Migration Summary page.
