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.
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.
Select Mitigations from Select Import Type dropdown (Figure 1) to navigate to the Import Mitigations page.
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.
If the uploaded file contains more than one sheet, the user should select the sheet required.
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.
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.
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.
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.
Once the required fields have been mapped, Save the data to make it available in other pages.
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).
Copyright © 2021 PRC Software. All rights reserved