The content of this Space is not the latest version of WBS Gantt-Chart for Jira.
We have separate Space for each version of the product. If the version you are using differs from the one in this Space title, please find the correct one from the below page. https://ricksoft-support.atlassian.net/wiki/spaces/WGC/overview

Exporting to Microsoft Project

Owned by Shunsuke Osawa (Unlicensed)
Last updated: Dec 03, 2018
1 min read
On this page:



Exporting to Microsoft Project

You can export projects, versions and issues displayed in WBS Gantt-Chart as XML files that are readable in Microsoft Project by clicking Data ⇒ MS Project export on the operations bar.

The Microsoft Project field for each Jira field is shown in the table below.

Jira fieldMicrosoft Project fieldNotes
SummaryTask name

Assignee 

Resource name
  • Makes the assignee's username and workload as the output.
  • If the workload is 0, Microsoft Project specifies the duration of the task as 0 days as a default. Therefore tasks with no milestones and 0% workload are exported with a 1% workload.

  • If square brackets are used for the full name of the assignee, convert to parentheses. In Microsoft Project, you cannot use square brackets for resource names.

Workload
Start dateStart dateUses the value of the field configured as "Start date in WBS Gantt-Chart for Jira
Finish dateFinish dateUses the value of the field configured as "Finish date" in WBS Gantt-Chart for Jira
Baseline start dateStandard start dateUses the value of the field configured as "Baseline start date" in WBS Gantt-Chart for Jira
Baseline finish dateStandard finish date Uses the value of the field configured as "Baseline finish date" in WBS Gantt-Chart for Jira
% done % complete

Uses the value of the field configured as "% done" in WBS Gantt-Chart for Jira

However, in Microsoft Project, the % completion rate of a summary task is automatically calculated including accumulated  % completion of child tasks as well. Therefore the value shown may differ from % done in WBS Gantt-Chart for Jira.

Due dateDeadline




If you have any questions please feel free to ask a member of the Ricksoft community!