PPO's bi-directional integration with MSP allows for data to be transferred quickly and easily from MSP to PPO and back to MSP. However, as with any integration, there are some basic problems or errors that present themselves from time to time. This article covers the most common errors associated with MSP and explains how to resolve them:
- Progress in MSP reflects a negative value
- Resources are mapped incorrectly
- Project plan is too big
- No tasks are being imported
- How to show the Project Task (line 0) in MSP
- Validation for required fields
1. Progress in MSP reflects a negative value
The problem
The problem is related to the Date1 calculation introduced when implementing the planned progress % calculation. More specifically the calculation is not being automatically updated to reflect the current date.
When attempting to import your schedule PPO will display the following error message.
The fix
Set your project to calculate after each edit by navigating to File >> Options >> Schedule >> Enable the "Calculate project after each edit" option.
It is good practice to check your planned progress % prior to importing your schedule into PPO. Should there be no changes to your project schedule or the planned progress is still displaying a negative value you can manually calculate your project by pressing F9 or navigating to Project >> Click on the "Calculate Project" action button.
2. Resources are mapped incorrectly
Background
PPO’s Resources entity maintains a pool of resources that are used by PPO users to allocate Issues, Risks and Tasks. When Microsoft Project (MSP) is used for project planning and the project plan is then imported into PPO, resources recorded in MSP are not automatically imported into PPO as MSP has its own resource pool. However, if PPO’s MSP Add-In is used to synchronise the resources in MSP with the resources in PPO and the resources field is mapped in PPO's System Configuration, then resources can be imported automatically with the user's project plan, using the Import Tasks Wizard (for detailed steps on how to sync resources, see the following FAQ)
The result of syncing resources in MSP is that every resource is awarded a phonetics key:
This key corresponds with the resource's key in PPO:
The problem
The resources are not imported because PPO cannot find an exact match for the resources that are being imported and therefore cannot assign the resource to the applicable task.
The fix
To resolve the problem, open MSP and connect to the MSP add-in, ensure the current instance's URL is provided when connecting, and then import the resources again from the Import resources tab.
The resources will be updated, showing the correct resource key and the next import should be successful.
3. Project plan is too big
The problem
PPO has a 50MB upload limit per document - the same rule applies to project plans. If a project plan is uploaded that is bigger than 50MB, a time-out error or the following error message will appear:
The fix
The following two methods can be employed to reduce the file size:
1. The MSP file can be compressed to a zipped folder and the zipped folder can then be imported into PPO. The size of the zipped folder will need to be under 50MB to import successfully.
2. MSP accumulates data as and how the users add lines, baseline schedules, update progress and perform other updates on the plan. All the history of all the changes made to the MSP plan is stored within the plan itself, increasing its file size. It often helps to copy the whole project plan over into a new MSP document to clear it of all history. This should reduce the MSP's file size and the new document can then be imported into PPO.
4. No tasks are being imported
The problem
Often when a project plan is imported, no tasks are uploaded:
The fix
This problem can occur due to:
All the tasks have already been completed, are all marked as 100% and are therefore being filtered out by the global filter.
The way to check this is to go to the Task List page and disable the tasks global filter. If the reason why no tasks are showing is indeed because of the tasks global filter, the tasks should all appear once the global filter has been disabled.
5. How to show the Project Task (line 0) in MSP
The problem
Users often notice that PPO has 1 additional task on their task list compared to their MSP plan. The reason for this is that the Project Summary Task was not selected to be viewed in MSP.
The “Project Summary Task” in MSP maps to the “Project Task” in PPO. The Project Task is also referred to as the “line 0” task and encapsulates the whole project, from start to finish. This Task is identified in PPO as the Task where the sort order is 0 and the task type is Project Task.
If you do not insert the Project Summary Task in MSP you also run the risk of having a duplicate Summary Task with the same name as the Project Task.
Line 0 & Line 1 is the same, showing the duplication:
The Fix
The below screenshot shows the schedule starting at Line 1.
On the MSP schedule select “Format” and select “Project Summary Task”.
Line 0 which is the actual Project Task will show:
6. Validation for required fields
The Problem
In MSP as well as when using the Excel Template, there is a possibility of leaving the Planned Start and Planned End dates empty before importing. If you try to import with the blank required fields, PPO will show a validation error.
The Fix
Update your MSP / Excell document by ensuring that the Planned Start Date, Planned End Date, and all required fields are populated, then re-import.