search cancel

ETCs are missing for one task in MSP after exporting from Clarity


Article ID: 144204


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


When exporting a project from Clarity to Microsoft Project (MSP), the task is changing the ETC to 0 for a fixed work task with an assignment.

Checking further, the allocation for the resource is showing as 0% in the Resource column in MSP.


Release : All Supported Releases

Component : MICROSOFT PROJECT (MSP) Integration


  1. The max % Load / units for that the assignment is set as 0


  2. MSP Assignment Units Mapping with PPM Assignment is checked on the Administration side of Clarity

This combination means that when the project is exported to MSP, it looks at the max % load value in Clarity, and not the team allocation value.

How to check if it's pulling from Max % Load:

  1. In Clarity, go to Administration->Project Management->Settings
  2. Check if the check box for 'MSP Assignment Units Mapping with PPM Assignment ‘Max % Load'’ is checked

How to check the Max % Load for the assignment:

  1. In Clarity go to a task that has the issue
  2. Click Options->Configure in the Assignments section of the task
  3. Bring ‘Max % Load’ over to 'Selected Columns' and save


The below solution applies if you have 'MSP Assignment Units Mapping with PPM Assignment ‘Max % Load' checked. (See cause section for more details)

  1. Export the project from Clarity to MSP
  2. Uncheck the milestone checkbox if the task has been incorrectly changed to a milestone (this can happen if the task changes to 0 day duration because of the 0 allocation on the assignments)
  3. Change the user's assignment units to 100 for the task:
    1. Double click on the task
    2. Click on the Resources tab and update the units there
  4. Update the dates of the task and ETC to desired amounts
  5. Save changes back to Clarity

Additional Information