How to map JIRA Issue Priority to MS Project Task Priority
15 December 2012 08:17 AM

Q: How to map JIRA Issue Priority to MS Project Task Priority

A: It is not possible to map Issue Priority to Task Priority directly. However, Issue Priority can be mapped to a text field (e.g. Text3) and a macro that updates the task priority based on the text field can be written. You will need to run the macro from time to time manually to set the priorities after synchronisation.

The macro should look as follows:

Sub SetPriority()
Dim i As Integer
For i = 1 To Application.ActiveProject.Tasks.Count
Dim task As task
Set task = Application.ActiveProject.Tasks(i)
Select Case task.Text3
Case "Blocker"
task.Priority = 700

Case "Critical"
task.Priority = 700

Case "Major"
task.Priority = 500

Case "Minor"
task.Priority = 300

Case "Trivial"
task.Priority = 100
End Select
End Sub

A project that demonstrates the approach is attached.

 setpriorityexample.mpp (230.00 KB)
(0 votes)
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako