JIRA project management and time tracking plug-ins - Ceptah

Get help with linking your JIRA to Microsoft Project

Please try to find the answer using the below resources. If you still have a question, please get in touch with us. Our office hours are from 9am to 6pm Sydney time, Monday to Friday. We will reply to you within 8 hours.


Contact Support

Tutorials > Implementing Complex Hierarchies

This tutorial provides an example of how a complex work breakdown structure (task hierarchy) created in Microsoft Project can be reflect in JIRA using Ceptah Bridge and then updated based on feedback from JIRA. It requires basic knowledge of Cepath Bridge and some experience with configuring simpler mappings.

We are going to implement the following scenario:

  1. A task structure is created in MS Project. The first level of the hierarchy should be represented as Epics in JIRA. The second level will be Stories. Under the stories we are creating a varying number task levels.
  2. The project is published in JIRA.
  3. Team members may split the tasks (issues) on the last level further by creating sub-tasks.
  4. The project manager imports the new sub-tasks from JIRA into the existing structure in MS Project.

The project plan we are starting with looks as follows:

Original project plan

First, we will need to configure the synchronisation mappings.

Basic mappings

In addition to entering the regular settings, do the following:

  1. Tick Populate Epic Name. This will set the Epic Name field, which is mandatory, to the same value as Summary.
  2. Select the Task Name option. We will not need the composite issue names because we are setting up a hierarchy in JIRA.
  3. Map Issue Type to a text custom field as we will need to create issues of different types and define filters based on this field.

Now we will need to configure the mappings that determine the issue hierarchy - Epic Link, Issue Link and Sub-task mappings. Each of these mappings must be applied to a particular group of issues/tasks so that no other mapping is applied to the group. If this rule is not observed, that is if there is more than one hierarchical mapping applied to the same issue, synchronisation will not work the way we want it to because the mappings will compete for the place of the issue in the hierarchy.

We will use issue type filters to split issues/tasks into the groups and Outline Level conditions to divide the issues of the same type further by their hierarchy level in Microsoft Project. The issue type filters select issues by their type in JIRA if the data is coming from JIRA into MS Project or using the value from the MS Project field mapped to Issue Type if data is copied from MS Project to JIRA.

Create a mapping for the parent-child link in JIRA (you will need to add this link if it does not exist).

Link mappings

  1. Select the link and the end of the link to be mapped. The link type 'Hierarchy' in the screenshot is just an example. You need to select from the dropdown list a link type available in your JIRA.
  2. Tick the Parent mapping mode.
  3. Set the From level to 3. This is required to prevent Ceptah Bridge from creating links from the 2-nd level issues to the 1-st level issues, which will be Epics and should be linked to using Epic links instead.
  4. Tick Only for these issue types and select all types except Epic and Sub-task. We need to exclude sub-tasks as they will have their own reference to the parent. Excluding Epics does not make any difference in practice, but we are during that just for the filter to make more sense.

Sub-task mappings

  1. Turn on the Sub-tasks mapping.
  2. Set the direction from JIRA to MS Project so that if a sub-task is moved under a different parent, this change will be reflected in MS Project.
  3. Tick Only for these issue types and select 'Sub-task'. That mapping should be applied only to sub-tasks. If we apply it to all tasks, during synchronisation they will be moved on the first level if they are not linked to sub-task issues, which may be desirable in other cases, but not in ours.

Epic mappings

  1. Turn the Epic Link mapping on.
  2. Select the Parent mapping mode.
  3. Set the level selector to 2..2. That will ensure that only the issues linked to MS Project tasks on the 2-nd level are included into Epics.
  4. Tick Only for these issue types and select all types except Epic and Sub-task. We need to exclude sub-tasks because we do not want redundant epic links to be created for sub-tasks on the second level. Similar to the Links mapping, excluding Epics does not make any difference in practice, but we are not including them for the sake of common sense.

After we have saved the settings, the mapped fields will be added to the current view. Enter issue type for the tasks whose linked issues should have a non-default type in JIRA in the Issue Type (Text3) field in MS Project.

Issue types

Once synchronisation has been run, new issues reflecting the task hierarchy from Microsoft project will be created in JIRA.

Epic link

Story

Task

Nested Task

Now the assignee of the Implementation task (stieve) splits it into sub-tasks in JIRA.

Sub-tasks created in JIRA

Let's import these new sub-tasks into MS Project.

Import sub-tasks

We need to provide criteria for selecting the issues originating from our project and tick Import Subtasks to make sure that all sub-tasks under them are imported.

Press Import to detect the changes.

Sub-tasks to import

After we have applied the changes, new tasks representing the additional decomposition created in JIRA will be placed under the Implementation task.

Imported sub-tasks