Importing a Control Set and Control Set Responsibilities

You can import your own Control Sets into the 6clicks platform. To upload your Control Sets you will need to convert them into a JSON or CSV file using our pre-defined template.

Importing Controls Set using JSON 

An example of the template layout can be found below.

The above example will create a Control Set in the Control Set Builder as per below. Key things to note:
  1. Reference refers to the REF ID of each Control and you can select any reference framework you like, e.g. 1.1, 1.2 or A.1, A.2, etc.
  2. Order is the order in which each Control is displayed WITHIN each Control Domain. As an example, controls in Domain One will be ordered 1, 2, 3, etc., and controls in Domain Two will be ordered 1, 2, 3, etc.. 

Control Responsibilities  

You can also import Control Responsibilities as part of the JSON import, or alternatively, you can create them in 6clicks. To learn how to create Control Responsibilities head here.

Here is a copy of of the Control Set Import Template with Control Responsibilities included: Internal-Control-Set-Template-with-Responsibilities.json

Key things to note:

  1.  In the template, Responsibilities are called Statements
  2. Responsibilities are mapped to a single Control, and the order dictates how Responsibilities are displayed in the Control Set Viewer under each control 
  3. The period needs to be one of the pre-defined options, or if it isn't recurring, then leave blank:
    1. 1 Year
    2. 6 Months
    3. 3 Months
    4. 1 Month
    5. 1 Week
  4. the Action Status Name needs to be one of the predefined statuses:
    1. Planning
    2. In Progress
    3. Cancelled
    4. Review
    5. Closed
  5. To map the Responsibility to a Control, you will need to add the Control's name to ControlName and the Control's Domain to DomainName.

Importing Controls using CSV/Excel 

Select Policies & Controls Sets from the left navigation panel to open the Controls screen.

Click on Create a control set at the top right of the screen. 

This will generate the new control modal. Populate relevant fields of the new control set modal. Click on Create Control Set.  

Click on the More dropdown and select Import Controls (CSV). 

An Alert message will appear; select Yes to continue. 

An Import Data modal will appear; select Download Template to download the excel file. 

The Control Set Import Template has column headings that correspond with field names. Populate the respective information in each column. 

  • Control ID- Add the Control ID(s) in this column. Each ID should be unique to the respective control. 
  • Control Title- Add the Control Title in this column. 
  • Control Description- Add the Control Description in this column describing the function of the control. 
  • Control Domain- Add the Control Domain in which domain this control will fall under. 

Select More > Import Controls (CSV) to import your controls, then select the Browse button. Select your file or drag and drop it into the space provided next to Browse.

Once the file is ready to be uploaded, it will show the file name below the Browse button with the text 'Ready to upload,' select Upload.

Once the excel file has been uploaded, the control will populate in Control Set Builder. 

Importing Responsibilities using CSV/Excel 

Select Policies & Controls Sets from the left navigation panel to open the Controls screen.

Click on Create a control set at the top right of the screen. 

Click on the More dropdown and select Import Responsibilities.

 An Import Data modal will appear; select Download Template to download the excel file.

The Responsibility Import Template has column headings that correspond with field names. Populate the respective information in each column. 

  • Control ID- Add the Control ID in this column. The Control ID is the same ID you are attaching this responsibility to. 
  • Name- Add the Name of the responsibility in this column.
  • Description- Add the Description of the responsibility describing the course of action. 
  • Due Date- Add the Due Date when the responsibility is due in this column.
  • Owner -Add the Owners name in this column. Enter the email associated with the User or Advisor when populating this column.  
  • Recurring- Add Yes in this column if the responsibility reoccurs. Add No in this column if it does not reoccur. 
  • Time Period- Add the Time Period in this column. The Time period options are 1 year, 6 months, 1 month, and 1 week.
  • Assigned Members- Add Members in this column. Enter the email associated with the User or Advisor when populating this column.  

Select More > Import Responsibility to import your responsibilities, then select the Browse button. Select your file or drag and drop it into the space provided next to Browse.

Once the file is ready to be uploaded, it will show the file name below the Browse button with the text 'Ready to upload,' select Upload.

Once the excel file has been uploaded, the responsibility will appear under the Control.

In the right-side panel under the Responsibilities tab, a green checkmark indicates the responsibility has been linked. 

To learn more about Control Sets head here.