Ceptah Bridge >

Ceptah Bridge is a Microsoft® Office Project add-in that allows MS® Project and Atlassian® JIRA® to be integrated in order to build an effective project management solution.

Below is a list of the typical steps you take when using the Bridge to make tasks of your project available to JIRA users and to assign and track the tasks.
The illustration below shows the blocks the Bridge consists of and the features it provides.

Ceptah Bridge uses the following concepts.

Connection Settings are used by the Bridge to connect to a JIRA server. These are a server URL (internet/intranet address), JIRA user name and password. The Bridge uses the settings by default if there are no specific connection settings specified for the project. The settings are unique for each Windows user (profile).

Project settings consist of synchronization mappings and project connection settings .

Synchronization mappings define the way data is synchronized between JIRA and MS Office Project. You can specify the fields of MS Project tasks and JIRA issues to copy data to or from during synchronization and the direction of the transformation (from MS Project to JIRA or from JIRA to MS Project). Also, you can set the default values to be used for JIRA fields when there is no relevant data in the project document.

Project connection settings can be specified to override the global connection settings for a particular project.

Unlike the global connection settings, project settings are stored in a document itself and are specific for each project. Please be advised that your JIRA password is stored in the Project document as part of connection settings. Although it’s protected and cannot be used to log into JIRA, any person who has access to the project can perform JIRA-related operations provided by the Bridge under your name.

The Synchronize feature ensures the data integrity between tasks in MS Project documents and issues in JIRA according to the mappings provided.

Among other conditions, the mapping settings define which project tasks should be synchronized with JIRA. Each such task has a JIRA issue associated with it. There is a custom text field (Text1…Text30) defined for each synchronized project that is used to store the keys of the issues the tasks of the project are linked with.

Synchronization of a project starts with identifying differences between the data in MS Project and JIRA to be resolved. The Bridge prepares a list of proposed changes to be made in JIRA. A change in the list can be either creation or update of an issue.

For the tasks that have to be synchronized, but haven’t been linked with issues, the list is filled with “creates”. The mapping settings define the rules to be used to evaluate values for the fields of the new issues. The values can be derived from tasks as well as set to default values provided by the mappings. After an issue is created, its key is stored in the mentioned above field of the respective task.

If a task already has its respective issue linked, but the data doesn’t match completely on the terms provided by the mappings, an “update” change will proposed. This change specifies which fields of the issue and which fields of the task should be set to which values.

Before applying the changes, the user has a chance to review them and deselect the ones he or she does not want to be progressed. Besides, it’s possible to reverse the direction of synchronization for some fields. For instance, you have a task assigned to the user Bob, and your mappings specify that the issue field “Component/s” should be taken from the task field “Text14” during synchronization. Bob found out that you had mistakenly set the field to ‘Kitchen’ when it was supposed to be ‘Bathroom’ and updated it. While reviewing proposed changes, you see that the correct value “Bathroom” is about to be replaced back by “Kitchen”. You can reverse the direction of synchronization and make the value ‘Kitchen’ be replaced in your project instead.

After having the changes reviewed, a user can launch the synchronization itself. This updates both MS Project tasks and JIRA issues concerned.

You may find helpful the following list of things to consider before starting using the Bridge.

After having your Bridge deployment roadmap ready, you can proceed to the following steps.

Copyright 2013 Ceptah Solutions