Import Risk Register

The Import Risk Register page allows you to import threats.  This functionality is helpful when the user needs large amounts of data to be added and the user has the file which contains the threat details which can be imported.  The accepted file types are .csv and .xls.

import_threat

Figure 1

 

Navigate Page:

This functionality is used to navigate from the Import Risk Register page to the Import Page for opportunities or mitigation.  To navigate to the Opportunity or Mitigation page, click on the corresponding radio button shown in Figure 1.

Steps:

  1. Risk Register —> Imports
  2. Select Opportunities from Select Import Type dropdown (Figure 1) to navigate to the Import Opportunity Register page.

                                   Or

Select Mitigations from Select Import Type dropdown (Figure 1) to navigate to the Import Mitigations page.

Upload File:

Files of type csv, xls which contain threat details can be uploaded.  The Clear All button (Figure 3) is used to clear uploaded files.  The Clear link (Figure 3) also clears the uploaded file.  After the file is uploaded, it must be mapped with the correct fields before saving.

Steps:

  1. Risk Register —> Imports
  2. Click the Browse button. Select the required file.  (Figure 2)
  3. Click the Upload File button to finish.  (Figure 3)

 

select file

Figure 2

 

upload file threat (fig 3)

Figure 3

 

Select Sheet:

If the uploaded file contains more than one sheet, the user should select the sheet required.

Steps:

  1. Risk Register —> Imports
  2. Select the sheet required and click the Change Sheet button to change the sheet.  (Figure 1)

Map Data:

The Id field must be mapped for the file to be imported.  There are five available values: Open-mitigated, Open-unmitigated, Closed-no impact, Closed-rejected, and Closed-occurred.  The field status requires the value to be mapped if the status field needs to be imported.  In Figure 4, the value Open-unmitigated is being mapped for the field status for all the threats in the file.

 

import_threat_status

Figure 4

 

Start date and End date has a date format displayed next to its field.  (Figure 5)  This date format is set during user creation in Administration —> Manage Users page under the Date Format section.  The Imported Threat fields should also have the same date format shown in the page or a validation message will appear indicating the date format is invalid.

 

import_threat_dates

Figure 5

 

For the Qualitative score fields such as Probability, Cost, Schedule and Additional Impacts, the user should map the corresponding fields if the score must also be imported.

 

import_threat_impacts

Figure 6

 

The Simulation Probability field (Figure 7) includes a checkbox for Percentage Formatted.  When the simulation probability data is represented as a percentage, this box should be checked.

 

import_threat_simprob

Figure 7

 

Import Threat Details:

Once the required fields have been mapped, Save the data to make it available in other pages.

Steps:

  1. Risk Register —> Imports
  2. Click the Import Risk Data button to save the imported file.  (Figure 1)

If the Imported file contains duplicated threats, a validation message (Figure 8) will be shown.  Click the OK button (Figure 8) to confirm.  Upon confirmation, the mapped data is overwritten.  If you don’t want to overwrite the data you can click the Cancel button (Figure 8).

 

threat and opp popup

Figure 8