Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Info
  1. Internal - Add risk to existing Jira issues

  2. External - Import risks from

...

  1. Excel

...

1. Internal - Add risk to existing Jira issues

Select issues with JQL. Then select issue risk custom fields (value blank or 0-4 as number or string). If no custom fields are selected inherent/residual risk will be set to “Undefined“.

...

2. External - Import risks from Excel

...

Info

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

Excel column headers are parsed and mapped into four categoriesThere are four types of Excel risk columns. Please rename your Excel headers to map to the desired columns 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. since risks are first created and custom fields then populated in two steps

  • User Columns

Risk Columns (risk severity is calculated)

Comments

inherent probability

value 0-4 (empty cell is assigned undefined risk)

inherent impact

value 0-4 (empty cell is assigned undefined risk)

residual probability

value 0-4 (empty cell is assigned undefined risk)

residual impact

value 0-4 (empty cell is assigned undefined risk)

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

...