| Table of Contents |
|---|
...
ZenGRC allows data import for nearly every module in the application that houses multiple items. This streamlines the process and allows several object types, such as vendors, evidence requests, programs, surveys, workflows, to be imported at one time.
Overview
Unless you already have a template with headings matching ZenGRC application fields, there are a couple of substeps necessary to import new data into ZenGRC. They include the following:
...
The Data Import module provides two functionalities:
- Importing data.
- Downloading and import template.
| Tip | ||
|---|---|---|
| ||
To use data import to alter information already in the application, see Downloading Existing Items For Update. |
...
| Anchor | ||||
|---|---|---|---|---|
|
...
To download an empty spreadsheet containing data headings and columns that sync with the applicationimport a spreadsheet, complete the following steps:
...
- Click Tools | Data Import.
The Data Import page displays.
Info title NOTE The only area on this page requiring action when downloading when importing a template is in the Create a CSV template box. The Choose CSV file to import at left is where you import your newly populated template.
In the scrolling select box, click your desired template.
Continue selecting until all object types you want to download are displayed below the select box.Tip title TIP Once a selection is made, it's displayed below the select box and its column headings will be a part of the download.
Info title NOTE To remove object selections, please see Removing Selections from the Template.
- Click Download import template.
- Save to your computer as a CSV file. When opened, the spreadsheet contains all headings for each of the selections.
...
To remove section headings prior to downloading the template, complete the following:
...
Continue clicking icons until unwanted selections are removed.
...
Existing information in the application can be altered by conducting the following steps:
...
| Info | ||
|---|---|---|
| ||
To configure a report and download existing information from ZenGRC, see Downloadable Reports. Once the file is downloaded, you can update and import as described in the following sections. |
...
Whether you are altering existing information in a downloaded CSV or uploading new information in a template, the rules for populating the spreadsheet are the same.
Importing Multiple Objects
You can import data for several object types at once. The spreadsheet you download would look similar to the following:
Unique Fields
Information in the Code* and Title* columns must be unique within the object type.
...
| Tip | ||
|---|---|---|
| ||
If you're importing new data, we recommend the Code* column be left empty for autogeneration, unless you are also importing mappings to the item. |
Required Fields
Required fields are marked with an asterisk and must have data.
Optional Fields
Fields not marked with an asterisk are not required. If there is no data to import for these columns, they can be deleted to streamline the import. The application fields will be empty but can be updated at a later date.
Check Box
For a checkbox-type custom field, put "yes" (without quotes) if the checkbox should be checked. Leave the cell empty otherwise.
Leaving Fields Blank
If objects already exist, fields you leave empty are ignored. An object's attribute will not be replaced with empty information.
Mapping Items
To map items, complete the following:
...
| Tip | ||
|---|---|---|
| ||
In the following example, the first objective is mapped to an audit and a control. The map:audit column contains the audit code, which is "2017 FedRAMP Audit." And the map:control column contains the control code, which is "CTL-DFA-AC-10." |
...
| Tip | ||
|---|---|---|
| ||
More than one item can be mapped in the cell by separating them with a line break (command+return / ctrl+return) |
the Choose CSV file to import area. The Create a CSV template is where you download a template for import.
- Click Choose CSV file to import.
- In the dialog box, navigate to the newly populated CSV file and click Open.
A new page displays showing a list of items the import will create.
Tip title TIP If there are issues with the import, this page displays warnings. For example, it may list email addresses that don't exist in the application. This allows you to click Reset, correct the errors in the CSV file, and import the corrected data.
- Click Import data.
Alternative, to stop the import, click Reset.
Accessing and Downloading the Template
...
Unless you already have a template with headings matching ZenGRC application fields, there are a couple of substeps necessary to import new data into ZenGRC. They include the following:
- Downloading a template for population of data.
- Completing the template with new information.
Importing new information into the application.
To download an empty spreadsheet containing data headings and columns that sync with the application, complete the following steps:
- Click Tools | Data Import.
The Data Import page displays.
Info title NOTE The only area on this page requiring action when downloading a template is in the Create a CSV template box. The Choose CSV file to import at left is where you import your newly populated template.
In the scrolling select box, click your desired template.
Tip title TIP Once a selection is made, it's displayed below the select box and its column headings will be a part of the download.
Continue selecting until all object types you want to download are displayed below the select box.
Tip title TIP The order in which you make selections is the order in which the headings will display in the download.
Info title NOTE To remove object selections, please see Removing Selections from the Template.
- Click Download import template.
- Save to your computer as a CSV file.
- When opened, the spreadsheet contains all headings for each of the selections.
| Anchor | ||||
|---|---|---|---|---|
|
To remove section headings prior to downloading the template, complete the following:
- Click the trash can icon beside the data heading.
Continue clicking icons until unwanted selections are removed.
| Anchor | ||||
|---|---|---|---|---|
|
...
Existing information in the application can be altered by conducting the following steps:
- Downloading a report showing current attributes and mappings in ZenGRC.
- Populating the downloaded template.
- Importing updated information back into the application.
| Info | ||
|---|---|---|
| ||
To configure a report and download existing information from ZenGRC, see Downloadable Reports. Once the file is downloaded, you can update and import as described in the following sections. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Whether you are altering existing information in a downloaded CSV or uploading new information in a template, the rules for populating the spreadsheet are the same.
Importing Multiple Objects
You can import data for several object types at once. The spreadsheet you download would look similar to the following:
Unique Fields
Information in the Code* and Title* columns must be unique within the object type.
In the following screenshot, the highlighted code, DFA-AC-10, cannot be duplicated as a code for another objective. However, if you so choose, you could use the same code for another type, such as an issue or control.
| Tip | ||
|---|---|---|
| ||
If you're importing new data, we recommend the Code* column be left empty for autogeneration, unless you are also importing mappings to the item. |
Required Fields
Required fields are marked with an asterisk and must have data.
Optional Fields
Fields not marked with an asterisk are not required. If there is no data to import for these columns, they can be deleted to streamline the import. The application fields will be empty but can be updated at a later date.
Check Box
For a checkbox-type custom field, put "yes" (without quotes) if the checkbox should be checked. Leave the cell empty otherwise.
Leaving Fields Blank
If objects already exist, fields you leave empty are ignored. An object's attribute will not be replaced with empty information.
Mapping Items
To map items, complete the following:
Populate the cell under the unthe map:object to map column column header with the mapped object code.
Info title NOTE If you downloaded a template, the unmap columns would already exist in the spreadsheet.
Tip title TIP The In the following example uses the same objects mapped in the Mapping Items section. The unmap:audit column contains the code for the audit, the first objective is mapped to an audit and a control. The map:audit column contains the audit code, which is "2017 FedRAMP Audit." And the unmap:control column the map:control column contains the control code for the control, which is "CTL-DFA-AC-10."
Tip title TIP More than one item can be unmapped in the cell by separating them with a line break (command+return / ctrl+return).
...
To remove items from the application, complete the following:
...
| Tip | ||
|---|---|---|
| ||
To import a spreadsheet, please see Importing the Template. |
Changing the Code
The code of an item cannot be changed. However, you can delete the item and then import the identical information with a new code.
To change the code of an item through import, complete the following steps:
...
| Note | ||
|---|---|---|
| ||
To delete an item in order to change the code, be sure to save the information originally downloaded. This way, all data stays intact with the exception of changing the unique code. |
...
| Tip | ||
|---|---|---|
| ||
Make sure to remove the Delete column when you import the spreadsheet with the modified code. |
| Info | ||
|---|---|---|
| ||
To import a spreadsheet, please see Importing the Template. |
Deleting a User
...
| Info | ||
|---|---|---|
| ||
To revoke a user's access, please see Changing a User's Access. |
| Info | ||
|---|---|---|
| ||
Setting a user's access to No Access instead of deleting it allows all history to remain untouched and retrievable. And it means the user cannot log in to the application. |
...
"
Tip title TIP More than one item can be mapped in the cell by separating them with a line break (alt+return)
Unmapping Items
To map items, complete the following:
Populate the cell under the unmap:object to map column header with the mapped object code.
Info title NOTE If you downloaded a template, the unmap columns would already exist in the spreadsheet.
Tip title TIP The following example uses the same objects mapped in the Mapping Items section. The unmap:audit column contains the code for the audit, which is "2017 FedRAMP Audit." And the unmap:control column contains the code for the control, which is "CTL-DFA-AC-10."
Tip title TIP More than one item can be unmapped in the cell by separating them with a line break (altl+return).
| Anchor | ||||
|---|---|---|---|---|
|
To remove items from the application, complete the following:
In the Delete column for the rows being deleted, put "true" with no quotes. On import, this deletes the object, related data, and related mappings to other items.
Tip title TIP To import a spreadsheet, please see Importing the Template.
Changing the Code
The code of an item cannot be changed. However, you can delete the item and then import the identical information with a new code.
To change the code of an item through import, complete the following steps:
...
Follow steps in Deleting Information.
Note title
...
To configure a report and download existing information from ZenGRC, see Downloadable Reports.
In the Role column, change the information to one of the following:
...
No Access
...
Creator
...
Reader
...
Editor
...
CAUTION To delete an item in order to change the code, be sure to save the information originally downloaded. This way, all data stays intact with the exception of changing the unique code.
When the item has been deleted, modify the data in the Code* column of the originally exported spreadsheet and import it back again into ZenGRC
Tip title TIP Make sure the Delete column is cleared or empty when you import the spreadsheet with the modified code.
Info title NOTE To import a spreadsheet, please see Importing the Template.
Importing Values for a Checkbox Attribute
If you have a checkbox-type custom field, enter "yes" without the quotes if the checkbox should be checked. Leave the cell empty otherwise.
Assigning Owners
...
Deleting a User
A user cannot be deleted through data import.
| Anchor | ||||
|---|---|---|---|---|
|
To change a user's access through import, complete the following steps:
...
Download a report with the desired information.
Info title
...
Only email addresses existing in the application will be imported. An address that doesn't exist will prompt an error and be assigned to the person importing the data. A workaround is to create a placeholder account in ZenGRC with an email address to use for import until you decide an owner.
Import Limit
Technically, a spreadsheet can have up to 10,000 rows of information. However, we recommend reducing the number to a reasonable level.
...
To import a spreadsheet, complete the following steps:
...
NOTE To configure a report and download existing information from ZenGRC, see Downloadable Reports.
In the Role column, change the information to one of the following:
No Access
Creator
Reader
Editor
Administrator
Info title NOTE A user cannot be deleted. Setting a user's access to No Access instead of deleting it allows all history to remain untouched and retrievable. And it means the user cannot log in to the application.
Import the updated spreadsheet into the application.
Info title NOTE
...
The only area on this page requiring action when importing a template is the Choose CSV file to import area. The Create a CSV template is where you download a template for import.
...
To import a spreadsheet, see Importing the Template.
Importing Values for a Checkbox Attribute
If you have a checkbox-type custom field, enter "yes" without the quotes if the checkbox should be checked. Leave the cell empty otherwise.
Assigning Owners
To assign an owner, complete the following:
Add the person's email address in the Owner* column.
Alternative, to stop the import, click Reset
Tip title TIP If there are issues with the import, this page displays warnings. For example, it may list email addresses that don't exist in the application. This allows you to click Reset, correct the errors in the CSV file, and import the corrected data.
- Click Import data.
Only email addresses existing in the application will be imported. An address that doesn't exist will prompt an error and be assigned to the person importing the data. A workaround is to create a placeholder account in ZenGRC with an email address to use for import until you decide an owner.
Import Limit
Technically, a spreadsheet can have up to 10,000 rows of information. However, we recommend reducing the number to a reasonable level.