FluentPro FluentBooks is a desktop application that uses public APIs provided by Microsoft (PSI, CSOM, OData, SharePoint Foundation RPC Protocol, SharePoint 2013 Web Services) for data migration between Project Server On-Premises and Project Online, as well as between different Project Online instances.
Direct operations with the database are not performed during migration with FluentBooks (i.e. it is not a database to database migration); data is downloaded via API from a Source PWA as a local copy to FluentBooks workspace files (PWA Configuration, SharePoint Content) and FPP packages (Projects Content) and then this data is uploaded to a Destination PWA also via API.
During data upload PWA Config, Projects, SharePoint Content entities are created in the Destination PWA, therefore, system read-only fields like Created, Last Published, Last Modified are set to the date of migration and will be not the same as in the Source PWA.
1. PWA Configuration
Migration of the following configuration entities is not supported:
|Configuration Entity||Support Notes|
|Enterprise Global||Customizations to Enterprise Global Template will need to be re-created in the Destination PWA, if necessary (Project Professional filters, views, tables, etc., are not supported for migration).|
|Active Directory Resource Pool Synchronization settings||AD Groups will need to be specified manually.|
|OLAP cubes||OLAP cubes are not supported in Project Online.|
|Reporting||Reporting settings may need to be adjusted manually (only for Project Server -Project Online migrations).|
|Project Server 2010 Workflows||Project Server 2010 Workflows are not supported in Project Online, therefore, will need to be re-created specifically for Project Online.|
|Workflows created not in SharePoint Designer||
Migration of third-party workflows is not supported.
Only workflows created in SharePoint Designer will be migrated.
|Status Reports||Migration of Status Reports is not supported.|
|Approvals||Migration of Approvals is not supported.
Please note that all status updates should be approved and published to projects before the projects are downloaded, otherwise, they will be lost.
|Invalid Delegations||Delegations for inactive users, users with no Logon permission, with no Can Be Delegate permission expired Delegations cannot be migrated.|
|Users in Active Directory||FluentBooks migrates Project Server Resources and Users, given that the appropriate user account already exists in the Destination Active Directory and account mapping was performed correctly.|
|Security Groups vs AD Groups association||AD Groups will need to be set manually for Security Groups, if AD Sync will be used.|
|Portfolio Analyses||Portfolio Analyses will need to be adjusted manually if projects are missing from the Destination PWA.
Portfolio Analysis Baseline Scenario with Constraint Type: “Resource” cannot be migrated and will need to be re-added manually.
|Dependencies||Dependencies will not be migrated if projects are missing from the Destination PWA.|
|External Links in Quick Launch||External Links in Quick Launch will be migrated as-is. Manual adjustments might be required after the migration (e.g. for Power BI Apps links).|
|Enterprise calendars||Migration of Enterprise calendars is supported.
However, the migration of Work Weeks settings in the calendars for resources is not currently supported.
|Workflow stage||The migration of Workflow stages is supported.
However, the date in the Entry Time,
Completion Time fields for Workflow stages
will be set to the migration date.
Please note: The migration of workflows and solutions developed in Visual Studio is not supported.
2. Projects Content
Due to the reduction in available functionality in the CSOM API provided by Microsoft in July-August 2016, migration of the following project-related entities is not supported:
|Project-related Entity||Support Notes|
|Project Timelines||Project Timelines created in the Source PWA will need to be manually re-created in the Destination PWA.
Project Timelines created in Project Professional will be migrated for project schedules as part of *mpp files (if Project Timeline was edited in PWA and any tasks were added to timeline, they will not be migrated, as they are not being saved to *mpp file).
|Project Owners for Master Projects||
Project Owners for Master Projects will be set to the migration account.
Project Owners for Standard & Subprojects will be migrated correctly if the corresponding user account is available in the Destination PWA and settings were selected correctly during upload.
|Status Managers for Master Projects||Status Managers for Master Projects will be set to the migration account. There is a workaround to set Status Manager for Master projects described in this article.
Status Managers for Standard & Subprojects will be migrated correctly if the corresponding user account is available in the Destination PWA and settings were selected correctly during upload, except for tasks that have cost resources assigned – for such tasks Status Manager will be set to the migration account.
|Status Managers for Summary Tasks||Status Managers for Summary Tasks in Standard & Subprojects will be set to the migration account.|
|Assignment level custom field project data||
Migration of custom fields data on an assignment level is not supported
|Migration of custom fields values to Project Summary Tasks||Migration of custom fields values to Project Summary Tasks is not supported.|
|Migration of Rejected and Draft Resource Engagements||Only Resource Engagements, which have a Committed or Proposed state are migrated. Draft and Rejected Engagements will not be transferred.|
|Local custom field values
||Values for the local customs field cannot be migrated as Project Professional does not use field names or their UIDs during the migration. It uses its internal IDs for local custom fields, which FluentBooks does not support.
|Project Workflow History
||Linking of the Workflow History list items to the project workflow (to preserve workflow history) is not supported for migration starting from Project Server 2016 and higher.
Please note: The migration of the following field "Created" OOB Project Field ("Created Date") is not supported in FluentBooks. It is a system read-only field and it cannot be updated either manually or programmatically. The date of Project migration will be set as Project Created date (FluentBooks performs project upload through API, so in fact, a project is created in Project Online on the day of migration).
Please note: During the migration of projects FluentBooks requires the Microsoft Project Pro application installed. The version of Project Professional should be the same as the version of the source PWA. Project Pro should be in the English language. Also please make sure that the Project Pro application is configured to start with the default account without any dialogs and is activated.
3. SharePoint Content
Migration of the following SharePoint entities is not supported:
|SharePoint Entity||Support Notes|
|Custom SharePoint solutions and/or web parts||Migration is not supported due to changes in architecture in Project Online.|
|SharePoint web parts
||Only filters between the web parts are not supported (the 'Get filter values from' setting).|
|Site/Site Collection Features||Only Feature Status is migrated, given that the Feature exists in the Destination PWA. The features enabled on the source (Active) will be enabled on the target PWA by FluentBooks during migration.|
|Managed Copies of files in Document Libraries
|Document Libraries Files which have no checked-in version|
|SharePoint workflows created not in SharePoint Designer||Migration of third-party workflows is not supported|
|Project Server 2010 Site Templates||Project Server 2010 Site Templates are not supported in Project Online, therefore, will need to be re-created in Project Online.|
|“Microfeed” List||Migration of the specified list is not supported|
|SharePoint Libraries||Migration of Created By, Modified By, Created Date, Modified Date column values for folders in SharePoint Libraries|
|SharePoint Documents||"Document ID" field values are not preserved if the document version history option is selected for migration and a document has more than one version.
|Migration of SharePoint Survey Items||Migration of Survey item is not supported in case the account of the user who completed the survey does not exist n target PWA|
|Top Link Bar (Links & Settings)
|Lists (OOB, Custom)
||Migration of list item ID´s is not supported.
Migration of the list item versions is supported.
If there are users in the Multi Person Columns fields of the list/document items and there is a semicolon (;) sign in the user name, such users will not be migrated.
If the list versions are not in order on the source (for example, a few versions were deleted and there are versions number 1,2,4,7), the numbering will change on the target to be in order (1,2,3,4).
Please note that Solutions (Templates from Project Server 2010) cannot be migrated directly. The following article provides a workaround allowing to migrate Solutions from Project Server 2010 to Project Server 2013, Project Server 2016 or Project Online.
Migration of the following entities is not supported:
|All kinds of reports that use a database connection||
Only reports that use OData will be migrated.
However, OData connections created using Power Pivot will be migrated as is, without processing the URLs inside.
|SSRS Reports||SSRS Reports are not supported in Project Online.|
Please note: Power BI reports will need to be adjusted manually when migrating to a different Project Online tenant.
5. Timesheets Content
Timesheets Migration is provided as a service. Please contact firstname.lastname@example.org to get assistance with such migration.
6. Support preserving GUID from a Source PWA when creating an object in a Destination PWA using FluentBooks
Please note: The table below applies only to the case when object/entity is created by FluentBooks, GUID for object/entity that already exists in the Destination PWA cannot be updated.
|Project Server Object||GUID from Source preserved|
|Project Plan Template||No|
|Enterprise Project Type||Yes|
|Project Detail Page||No|
|Project Site Template||Yes|
|All SharePoint Related Content GUIDs||No|
Please note: Project Server 2010/2013/2016 and Project Online do not allow duplicates - Projects/Custom Fields/Resources with identical Names or GUIDs. As FluentBooks ensures data integrity, Projects/Custom Fields/Resources with identical Names or GUID details will be matched by Name or GUID. As a result, an update of discrepancies will take place on a target PWA.
1 By default, Resource GUIDs are not preserved. To preserve Resource GUIDs, clear ‘Do not preserve Resource UID’ checkbox. For more information, please refer to the article.