| Live Search | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Benefits
The Data Export module provides an easy way to conduct the following activities:
- Create a unique configuration using only the attributes you specify.
- Export information displaying mappings between programs, controls, or any other item in the application.
- Save 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.
Accessing Data Export
To access Data Export, complete the following steps:
Click Tools | Data Export.
- The Data Export page displays.
Exporting Information
To export, complete the following steps:
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 configuration, see Accessing a Saved configuration. To save a configuration for later use, see Storing a configuration for Future Use.
Info title NOTE To add more than one object type in the export, please see Adding Additional Export Types
Select the attributes and mappings to include in the configuration.
Info title NOTE For information on attributes and mappings, please see Attributes Overview and Mappings Overview.
Include Page DI:Tip - Code Attribute in Reports DI:Tip - Code Attribute in Reports 
Tip title TIP The page defaults to all attributes and mappings selected. The selections can be removed in two clicks: click Select none beside Attributes; click Select none beside Mappings. Then select the applicable information for the configuration.
- At the bottom of the page, click Download Export.
- 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.
- Click OK.
The CSV file downloads in the manner you have specified in your browser.
Info title NOTE To save the selections made for the configuration download, please see Storing a configuration for Future Use.
| Anchor | ||||
|---|---|---|---|---|
|
On the Data Export page, the attributes are the first selections and are outlined in red below.
Once the information is downloaded, the attributes display in a CSV spreadsheet as highlighted below (attributes displayed depend on selections made).
| Include Page | ||||
|---|---|---|---|---|
|
Selecting and Deselecting Attributes and Mappings
When the Data Export page is initially accessed, all attributes and mappings are selected.
To deselect all attributes, complete the following steps:
- Click Select none beside the Attributes heading.
- All attributes are deselected, which allows individual selection of each attribute's check box.
- Alternatively, click Select All beside the Attributes label.
- Continue with configuration set up or click Download configuration.
| Anchor | ||||
|---|---|---|---|---|
|
ZenGRC is designed to map related objects many-to-many, so the 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 export and are outlined in red below with names beginning with map:.
Once the information is downloaded, the mappings display in a CSV spreadsheet as highlighted below (mappings displayed depend on selections made). The columns displaying mapped items have map:item to map column headers.
Using the Filter Query
The Filter Query lets you search key words. For more information, please see Filter Query Help.
| Anchor | ||||
|---|---|---|---|---|
|
The Data Export module allows you to export more than one type of object in a configuration. 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:
Click Add another object type at the bottom of the page.
The page refreshes with a new Export Object Type drop-down box and selections for attributes and mappings.
Select applicable attributes and mappings.
Continue with set up or click Download export.
Deleting An Additional Export Object Type
To delete an object type you created under Export Object Type, complete the following:
Click the trash can between the heading and the drop-down box.
Note title CAUTION There is no dialog box asking whether you're certain you want to delete the export object type. Once the trash can is clicked, the export type is deleted. However, this does not delete the export object type from the 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:
- Select Controls under Export Object Type.
- Under Filter by Mapping Relevance, click Add New Rule.
- Choose Programs and then SOC 2/3 Program.
- Click Download export.
Adding Rules
To add a rule, complete the following steps:
- Under the Filter by mapping relevance heading, click + Add new rule.
A new line displays with selections to refine the export.
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:
Click the trash can beside the drop-down box.
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 title TIP This does not delete any mappings from the Data Export module. It only deletes extra ones created for the export.
| Anchor | ||||
|---|---|---|---|---|
|
To save selections for future use, complete the following steps:
Click Save export configuration at the bottom of the page.
In the dialog box, add a name in the Stored configurations and click Save.
Tip title TIP If you are altering a stored configuration and click Save without changing the name, an error displays requesting you to rename the export.
Alternatively, click Close to cancel without saving.
| Anchor | ||||
|---|---|---|---|---|
|
To find a stored configuration, complete the following steps:
- Click the arrow in the drop-down box under Stored Configurations and select a configuration name.
- The page populates with the saved selections.
Altering a Stored Configuration
A stored 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 configuration with a different name, complete the following steps:
Access or create the configuration.
Info title NOTE For instructions on finding a stored configuration, please see Accessing a Stored Configuration.
- Make necessary changes.
Click Save export configuration at page bottom.
Info title NOTE For instructions on saving the export, please see Storing a Configuration for Future Use and note that the configuration will need to be saved with a different name.
Info title NOTE If necessary, you can delete the original configuration. Please see Deleting a Stored Configuration.
| Anchor | ||||
|---|---|---|---|---|
|
To delete a saved configuration, complete the following steps:
Click the arrow in the drop-down box under Stored Configurations to display all saved configurations.
- Select a configuration and click Delete beside the name. A dialog box displays.
- Click Delete.
- Alternatively, click Cancel to exit the dialog box without deleting the configuration.