Bulk Import to Populate Advanced Attributes

In Data Mapping Automation, you can populate your existing advanced attributes in bulk using the Link Personal Data to Inventories template.

Important:

If you leave any columns blank, existing data in the corresponding fields will be overwritten. If you do not want to update the values for any attributes, remove these columns from the template.

Recommendation: Before beginning this process, you should export your Processing Activity or Asset inventory and copy/paste the values from the Personal Data tab into this template.

To populate advanced attributes through bulk import

  1. On the Global Settings menu, select Import Templates from the Data Import section. The Import Templates screen appears.
    Note:

    In order for advanced attributes to display, you must have existing advanced attributes. If you have not already created advanced attributes, see Configuring Advanced Attributes.

  2. Click the Download button on the Link Personal Data to Inventories template.
  3. In Microsoft Excel, complete the downloaded template fields. For more information, see Personal Data Import Fields for Advanced Attributes.
  4. On the Import Templates screen, click the New Import button. The New Import modal appears.


  5. Complete the fields. For more info, see New Import Screen Reference.
  6. Click the Submit button.
    Note:

    To view the status and result of your bulk import, go to the Bulk Import screen.

    If there is an error in the upload, click in the Result column for the import to download a report indicating the error(s).

New Import Screen Reference



Field
Description
Import Name

Enter the name of the import.

Import Description

Enter a brief description of the import.

Import Type

Select the Link Personal Data to Inventories template.

File

Click the Upload File button.

Use the file explorer to select the spreadsheet you want to import.

Note:

Be sure the spreadsheet is saved as an XLSX file (Microsoft Excel).

Personal Data Import Fields for Advanced Attributes

Asset

Field
Description
Asset ID

Enter the Asset GUID.

Asset Name

Enter the name of the Asset.

Asset Organization

Enter the organization of the Asset.

Asset Hosting Location

Enter the hosting location of the Asset.

Data Subject Type Name

Enter the name of the Data Subject Type.

Data Element Name

Enter the name of the Data Element.

Note:

Any field after this will be an Advanced Attribute you have created.

Processing Activity

Field
Description
Processing ID

Enter the Processing Activity GUID.

Processing Activity Name

Enter the name of the Processing Activity.

Processing Activity Organization

Enter the organization of the Processing Activity.

Data Subject Type Name

Enter the name of the Data Subject Type.

Data Element Name

Enter the name of the Data element.

Note:

Any field after this will be an Advanced Attribute you have created.

Is Data Sold?

  • Not Sold

  • Sold for monetary value

  • Sold for other benefit or valuable consideration

Is Data Disclosed?

Yes/No response to whether the data collected is disclosed.

Data Retention Period

Period which the data will be retained.

Collection Purpose

Purpose for which the data was collected.

Minimization Controls

Efforts to minimize data exposure.

Entity

Field
Description
Entity ID

Enter the Entity GUID.

Entity Name

Enter the name of the Entity.

Entity Organization

Enter the organization of the Entity.

Entity Primary Operating location

Enter the primary operating location of the Entity.

Data Subject Type Name

Enter the name of the Data Subject Type.

Data Element Name

Enter the name of the Data Element.

Vendor

Field
Description
Vendor ID

Enter the Vendor ID.

Vendor Name

Enter the name of the Vendor.

Vendor Organization

Enter the organization of the Vendor.

Vendor Type

Enter the type of Vendor.

Data Subject Type Name

Enter the name of the Data Subject Type.

Data Element Name

Enter the name of the Data Element.