Import Mitigations – Risk Register

The Import Mitigations page allows the user to import mitigations.  This functionality is important when you need to download a large amount of data from an existing file to the Risk Register.

 

import_miti

Figure 1

 

Navigate Page:

To go to the Import Mitigations page, navigate from the Import Risk Register page.  The option for navigation from one page to another is located at the top of the page and is shown in Figure 1.

Steps:

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

To navigate to the  Import Risk Register page or the Import Opportunity Register page from the Import Mitigation page, check the steps below.

Steps:

Select Opportunities from Select Import Type dropdown (Figure 1) to navigate to the Import Opportunity Register page.

                                                                                Or

Select Threats from Select Import Type dropdown (Figure 1) to navigate to the Import Risk Register page.

Upload File:

Files of type csv, xls which contain mitigation 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. Select Mitigations (Threats)/Mitigations (Opportunities) from the dropdown.  (Figure 1)
    3. Click the Browse button.  Select the required file.  (Figure 2)
    4. Click the Upload File button to finish.  (Figure 3)

 

Figure 2

 

Figure 3

Select Sheet:

If the uploaded file contains more than one sheet, the user must 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 Risk ID field and Mitigation Step Name must be mapped, otherwise the file will not be imported.  The mapped Risk ID should correspond to the Threat/Opportunity (depends on the risk type selected).  If the Threat/Opportunity does not match the Risk ID, the file cannot be imported and a validation message will be shown indicating that the Risk ID does not match.

Proposed Mitigation Start, Proposed Mitigation Finish, Actual Mitigation Start and Actual Mitigation Finish each have a date format displayed next to its field.  (Figure 4)  The date format is set during user creation in the Administration —> Manage Users page under the Date Format section.  Imported mitigation fields should have the same date format shown in the page.  All other formats will generate an invalid date format message.

 

import_miti_dates

Figure 4

 

There are four possible values for Field Mitigation Status.  The user must map the value as Proposed, In-progress, Rejected or Complete in order to import the Mitigation Status field.  In Figure 5 we have mapped the mitigation status value as In Progress.

 

import_miti_status

Figure 5

 

For the Qualitative score fields: Probability, Cost, schedule and additional impacts, (Figure 6) the user should map the corresponding fields if the score must also be imported.

 

import_miti_impacts

Figure 6

 

In the Simulation Probability field, the box for Percentage Formatted (Figure 7) should be checked if the simulation probability data is represented in percentage form.

 

import_miti_simprob

Figure 7

 

Import Mitigation Details:

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

Steps:

  1. Risk Register —> Imports
  2. Select the Mitigations (Threats)/Mitigations (Opportunities) from the dropdown.  (Figure 1)
  3. Click the Import Mitigation Data button to save the imported file.  (Figure 1)

If the Imported file contains a duplicated mitigation, a validation message (Figure 8) will be generated.  Click the OK button (Figure 8) to confirm, and on confirmation the mapped data is overwritten.  If you do not want to overwrite the data, click the Cancel button.  (Figure 8)

 

Figure 8



Copyright © 2021 PRC Software. All rights reserved

This will close in 0 seconds


This will close in 0 seconds

The PRC Enterprise Risk Register is a web-based risk management software solution which allows for the tracking of risk at the project and portfolio level.  Audit logs for all risk updates and changes are available at the click of a button to aid with audits, claims and the flow of information.  The power of the PRC Enterprise Risk Register is in the simplicity of the user interface, which is designed to navigate easily at both project and portfolio levels without compromising functionality or data.  The PRC Enterprise Risk Register allows for mapping across project levels so the data can be reported at the portfolio level, even if the work, risk and organizational breakdown structures are not standardized.

Read More

This will close in 0 seconds

The PRC Enterprise Cost Risk Analysis is a customizable web-based solution for simulating estimate cost and determining cost contingency, cost drivers, and risk hotspots. The key to a good risk analysis is good inputs.  The software cannot be a roadblock to success. Good risk software should be easy on the end user. Monte Carlo simulation is already a complex.  The software should simplify the process.

Read More

This will close in 0 seconds

The PRC Enterprise Schedule Risk Analysis is a customizable web-based solution for simulating schedule duration and dates. At PRC Software, we believe that the key to good risk software is through good inputs and excellent user friendliness. A Monte Carlo simulation is already a complex.  The software should not be complicated as well.

Read More

This will close in 0 seconds

PRC specializes in risk analysis, audit, and training.  We have cross-industry experience in fields such as Aerospace & Defense, Oil & Gas, and Engineering & Construction.  We believe that over-complicating the risk process often leads to wasted effort and poor results.  Our goal is to "make it simple."

Read More

This will close in 0 seconds