Import Risks

Import risks by adding risk assessment to existing Jira issues or importing external Excel risk registers

1. Internal - Add risk to existing Jira issues

Select issues with JQL then optionally select issue risk custom fields. Custom fields values will be mapped to default Risk Matrix impact and probability. Valid values are risk matrix impact/probability e.g. Minor/Probable or the value array index starting from 1. If no custom fields are selected inherent/residual risk will be set to “Undefined“.

2. External - Import risks from Excel

For external risk registers with assignee and many custom fields. The first option “Internal - Add risk to Jira issues“ with Jira bulk import might be a better match

There are four types of Excel risk columns. Please rename your Excel headers to those and also remove empty starting columns and rows (download example excel).

Risk Columns
Jira Columns
Jira Custom Field Columns → info: cannot be mandatory in selected project issue screen. risks are created and populated in two steps
User Columns

Risk Columns (risk severity is calculated)	Comments

Risk Columns (risk severity is calculated)	Comments
`inherent probability`	default risk matrix value or index e.g. Probable or 1 with empty cell undefined
`inherent impact`	default risk matrix value or index e.g. Minor or 3 with empty cell undefined
`residual probability`	default risk matrix value or index e.g. Probable or 1 with empty cell undefined
`residual impact`	default risk matrix value or index e.g. Minor or 3 with empty cell undefined

Jira Columns	Comments

Jira Columns	Comments
`summary`
`description`
`priority`
`status`
`due date`
`labels`	comma (,) seperated
`created`	Jira automatically created value
`updated`	Jira automatically created value
`resolved`	Jira automatically created value

Jira Custom Field Columns	Comments

Jira Custom Field Columns	Comments
Text Field (single line) or Short text	Excel header shall match existing custom field name
Number field or Number	Excel header shall match existing custom field name
Select List (single choice)	Excel header shall match existing custom field name (Jira company-managed projects)

User Columns

User Columns
If a risk register is created as part of the import. Then all columns not matching above will be created as user columns in the risk register.