Page Comparison

Benefits

The Downloadable Reports Data Export module provides an easy way to do conduct the following activities:

• Create a unique report configuration using only the attributes you specify.
• Export information displaying mappings between programs, controls, or any other item in the application.
• Save the report configuration the configuration for later use by any team member.
  

Overview

Information within ZenGRC, such as programs, objectives, and controls, along with all their mappings, can be downloaded into a CSV file. In addition, the downloaded file can be used to make updates and changes that can then be imported back into the application where the changes are saved.
Image Removed
Image Added

Accessing

Data Export

To access Downloadable ReportsData Export, complete the following steps:

1. Click Tools | Downloadable ReportsData Export.
   Image Removed
   Image Added
   
   

2. Image Removed
   The

   Downloadable Reports

   Data Export page displays.

Exporting Information

To create a reportexport, complete the following steps:

1. Click the arrow in the drop-down under Export Object Type and select the information type for download.

   Info
   title NOTE
   To find a saved report, see Accessing a Saved Report. To save a report for later use, see Storing a Report for Future Use.

   Image Removed
   

   Info
   title NOTE
   To add more than one object type in the export, please see Adding Additional Export Types

        Image Added
   
   

2. Select the attributes and mappings to include in the report.
   

   Info
   title NOTE
   For information on attributes and mappings, please see Attributes Overview and Mappings Overview.

   configuration.

   Include Page
   DI:Tip - Code Attribute in Reports DI:Tip - Code Attribute in Reports

   Image RemovedImage Added

      

   Tip
   title TIP
   The page defaults to all attributes and mappings selected. The selections can be removed in two clicks: click None Select none beside Attributes: ; click None Select none beside Mappings. Then select the applicable information for the reportconfiguration.

        

3. At the bottom of the page, click Download Report.
       
   Image RemovedExport.
   
   Image Added
4. In the displayed window, select the check box beside Remove HTML formatting characters from rich-text fields if the data being exported is solely for reporting purposes. You do not want to select this if the information is to be re-imported into ZenGRC. For complete information on this feature, please see Removing HTML From Exports.
5. Click OK. 
   
   Image Added
      

6. The CSV file downloads in the manner you have specified in your browser.
   
   

   Info
   title NOTE
   To save the selections made for the report configuration download, please see Storing a Report configuration for Future Use.

   
   

Anchor
attributesoverview attributesoverview

Attributes Overview

borderColor	FireBrick
bgColor	AntiqueWhite
titleColor	black
borderWidth	1
titleBGColor	AntiqueWhite
borderStyle	solid

  DEFINITION: Attributes
      The necessary information, such as title, description, or primary contact, that is typically populated when an item is created.

---

On the Downloadable Reports On the Data Export page, the attributes are the first selections for the report first selections and are outlined in red below.
Image Removed
Image Added

Once the report information is downloaded, the attributes display in a CSV spreadsheet as highlighted below (attributes displayed depend on selections made prior to running report).
Image Removed
  Include PageDI:Tip - Code Attribute in Reports
DI:Tip - Code Attribute in ReportsImage Added

Selecting and Deselecting Attributes and Mappings

When the Downloadable Reports Data Export page is initially accessed, all attributes and mappings are selected.

To deselect all attributes, complete the following steps:

1. Click None Select none beside the Attributes labelheading.
   Image Removed
   Image Added
   
   
2. All attributes are deselected.
   Image Removed
   

To select attributes, complete the following steps:

1. Select , which allows individual selection of each attribute's check box individually.
2. Alternatively, click Select All beside the Attributes label.
   Image Removed
   Image Added
   
   
3. Continue with report configuration set up or click Download Reportconfiguration.

Anchor
mappingsoverview mappingsoverview

Mappings Overview

  DEFINITION:

---

ZenGRC is designed to map related objects many-to-many, so the Downloadable Reports Data Export page allows for the selection of all mappings potentially available to the downloaded information.

The mappings are the second set of selections for the report export and are outlined in red below with names beginning with map:.
Image Removed
Image Added

Once the report information is downloaded, the mappings display in a CSV spreadsheet as highlighted below (mappings displayed depend on selections made prior to running report). The columns displaying mapped items have map:item to map column headers.
Image Removed

Selecting and Deselecting Mappings

When the Downloadable Reports page is initially accessed, all attributes and mappings are selected.

To deselect all mappings, complete the following steps:

Image Removed

Image Removed

To select mappings, complete the following steps:

Image Removed

Image Added

Using the Filter Query

The Filter Query lets you search key words. For more information, please see Filter Query Help.
Image Removed
Image Added

Anchor
AddingTypes AddingTypes

Additional Export Object Type Overview

The Downloadable Reports Module Data Export module allows you to export more than one type of object in a reportconfiguration. This provides the ability to include all application information you want in one CSV file.

Adding An Additional Export Object Type

To add the export of an another object type, complete the following steps:

1. Click Add another object type at the bottom of the page.
   Image Removed
   Image Added
   
   

2. The page refreshes with a new Export Object Type drop-down box and selections for attributes and mappings.
   Image Removed

3. Select applicable attributes and mappings.

4. Continue with report set with set up or click Download Reportexport.

Deleting An Additional Export Object Type

To delete an object type you created under Export Object Type, complete the following:

1. Click the trash can between the heading and the drop-down box.
    
   Image Removed
    
   Image Added

   Note
   title CAUTION
   There is no dialog box asking whether you're certain you want to delete the additional export object type. Once the trash can is clicked, the export type is deleted.
   Tip
   title TIP
   This However, this does not delete the export object type from the Downloadable Reports module. It only deletes extra ones created for the report. Data Export module.

   
   

Rules Overview

Rules allow you to narrow results according to relevance to selected information.

For example, if you wanted to see all controls mapped to your SOC program, one way to find them is as follows:

1. Select Controls under Export Object Type.
2. Under Filter by Mapping Relevance, click Add New Rule.
3. Choose Programs and then SOC 2/3 Program. 
4. Click Download Reportexport.

Adding Rules

To add a rule, complete the following steps:

1. Under the Filter by Mapping Relevancemapping relevance heading, click + Add a New Rulenew rule.
    
   Image RemovedImage Added
      
2. Click the arrow in the drop-down under Relevant to and make a selection.
   Image Removed
    

   A new drop-down box A new line displays with selections to refine the reportexport.
    
   Image Removed
    
   Image Added

   Tip
   title TIP
   Additional rules to further refine the results can be added by clicking + Add a New Rule.

   
   

Deleting Rules

To delete a rule you created under Filter By Mapping Relevance, complete the following:

1. Click the red trash can between the heading and beside the drop-down box.
   Image Removed

   title

   Note
   title CAUTION
   There is no dialog box asking whether you're certain you want to delete the rule. Once the trash can is clicked, the rule is deleted.
   Tip
   	TIP
   This does not delete any mappings from the Downloadable Reports module. It only deletes extra ones created for the report.

   
   

Anchor
CreatingSavingReport CreatingSavingReport

Storing a

Configuration for Future Use

To save report selections for future use, complete the following steps:

1. Click Save report export configuration at the bottom of the page.Image Removed
   

2. A

   In the dialog box

   displays.
   Image Removed
   

   Enter a report , add a name in the text box.
   

   Tip

   title	TIP

   The report name must be unique.

   Stored configurations and click Save.
   
   Image Added

   Tip
   title TIP
   If you are altering a stored report configuration and click Save without changing the name, an error displays requesting you to rename the reportexport.

3. Click Save.

4. 
   

5. Alternatively, click Close to cancel without saving.

Anchor
accessingstoredreport accessingstoredreport

Accessing a Stored

Configuration

To find a stored reportconfiguration, complete the following steps:

1. Click the arrow in the drop-down box under Stored Configurations.
   Image Removed
   Select a report and select a configuration name.
   Image Removed
   Image Added
   
   
2. The page will populate populates with the saved configurationsselections.

Altering a Stored

Configuration

A stored report configuration cannot be altered and then saved with the same name. However, the new configuration can be saved with a different name.

To save a stored report configuration with a different name, complete the following steps:

1. Access the report.
   

   Info

   title	NOTE

   For instructions on finding a stored report, please see Accessing a Stored Report

   or create the configuration.

2. Make necessary changes.

3. Click Save report export configuration at page bottom.
   Image Removed

   Info
   title NOTE
   For instructions on saving the reportexport, please see Storing a Report Configuration for Future Use and note that the report configuration will need to be saved with a different name.

   Info
   title NOTE
   If necessary, you can delete the original report. Please see Deleting a Stored Report.

   
   

Anchor
deletingastoredreport deletingastoredreport

Deleting a Stored

Configuration

To delete a saved reportconfiguration, complete the following steps:

1. Click the arrow in the drop-down box under Stored Configurations. The saved reports display.
    
   Image Removed
    

   Click the red trashcan icon beside the report

   Configurations to display all saved configurations.

2. Select a configuration and click Delete beside the name. A dialog box displays.
     
   Image RemovedImage Added
   
   
3. Click Delete.
4. Alternatively, click Close Cancel to exit the dialog box without deleting the reportconfiguration.