/
Importing from Microsoft Project

Importing from Microsoft Project

Owned by Shunsuke Osawa (Unlicensed)
Last updated: Jun 14, 2022 by Yasuhiro Kawamura -Ricksoft-
2 min read

Importing Microsoft Project files to Jira

If you are using Jira 8.4.0 - 8.4.1 Data Center, using this feature will cause an error and will not import issues.

This problem is caused by the following bugs in Jira and has been fixed in Jira 8.4.2 Data Center.
https://jira.atlassian.com/browse/JRASERVER-69968

mpp files saved with MS Project version 2204 (Build 15128.20178) or higher may not be correctly parsed by WBS Gantt-Chart.
We are working to solve this problem, but it will probably take some time to resolve this problem.

If you cannot wait for the problem to be fixed, please consider using the workaround described in the portal card below.

https://portal.productboard.com/ricksoft-inc/6-wbs-gantt-chart-for-jira-server-and-data-center/c/254-ms-project-import-function-does-not-work-properly-with-mpp-files-saved-with-the-latest-ms-project?utm_medium=social&utm_source=portal_share

You can import tasks from Microsoft Project as Jira issues by clicking Data ⇒ MS Project import on the operations bar. 
In order to use this function, you need to have global administrator permission to "Bulk change" issues .

Each Microsoft Project field is imported as Jira issue field with the following conversion table. The destination Jira field of the planned dates (Start Date, Finish Date, Baseline Start Date, and Baseline Finish Date) and % Complete varies depending on the configurations in the WBS Gantt-Chart for Jira.

Microsoft Project field

Jira field

Notes

Microsoft Project field

Jira field

Notes

WBS code

Summary

WBS code and Task name are combined under Summary. 

Task name

Memo

Description



Task mode

Manual mode (WBSGantt)

When the Task mode is "manually schedule", the value of Manual mode (WBSGantt) is set as Yes.

Start date

Field configured as Start Date in WBS Gantt-Chart

If read-only (non-editable) fields such as Created and Sprint are configured in WBS Gantt-Chart, those values will not be imported. 

Finish date

Field configured as Finish Date in WBS Gantt-Chart

Baseline start

Field configured as Baseline Start Date in WBS Gantt-Chart

Baseline finish

Field configured as Baseline Finish Date in WBS Gantt-Chart

% complete

% done

If % done field is configured as "Calculate with time tracking automatically" or "Calculate with specific fields automatically" in WBS Gantt-Chart, those values will not be imported. 

Work

Original estimate



Remaining work

Remaining estimate



Resource 

Assignee

Searches users registered in Jira in order of "Username" and "Full name." If there is a match, the matched user is selected as the assignee.
If there is no matching user, the user who performs the import is selected as the assignee.

The import will fail if the selected user does not have "Assignable" permission.

Deadline

Due date





Reporter

Configures the user who performs the import as the reporter.



Created

Configures the imported date.



Priority

Configures the default priority.



Related content