Mapping MS Project to Workfront

When importing MS Project files into Workfront, it important to understand how information translates from one program to the other.

Field Mappings

NOTE Planned dates do not always correspond between both systems. Discrepancies can be accounted for through schedule and differences in system preferences between Workfront and MS Project. These date discrepancies can also result in differences in effort, duration, and percent complete.

MS Project Field Workfront Field
Project Name Project Description
Project Planned Start Date Project Planned Start Date
Task Name Task Name
Task Planned Duration Task Planned Duration
Task Planned Effort
Planned Hours
Task Percentage Complete Task Percentage Complete
Planned Start and Completion Dates Planned Start and Completion Dates
Actual Start and Completion Dates Actual Start and Completion Dates
Task Assignments Task Assignments
Assignment Allocation Percentage Assignment Allocation Percentage
Task Note Task Description

Data That Is Not Included

There are a number of project elements that are not imported to or exported from Workfront. These include:

  • Document attachments
  • Custom fields (at the project or task levels)
  • Workfront notes
  • Issues
  • Negative lag in tasks with a start/finish predecessor relationship (tasks are imported without the lag)
  • Assignments