Export data sheet layout#

This topic explains formatted and unformatted exported sheets containing data.

General structure

  • Header and columns: The header and column layout of formatted and unformatted sheets correspond with the bulk load template sheet.

  • # Comment column: Displays “Exported data” in green for each row of data.

  • # Hierarchy Node column: Indicates the source hierarchy of each exported row.

  • Sheet header (hierarchy): Shows the hierarchy used during export.

Key columns

  • # Device: Lists the device’s business key (for example, host, port, hierarchy) if device data is exported.

  • # CFT Template: Displays the name of the applied configuration template (if used), also shown in the header. For example, if it applied to the Admin Portal form, the # CFT Template column will show this name for each row, as well as the template value in the sheet header. If the sheet is used for loading, row values override header values.

  • # Unique Identifier (pkid):

    • Identifies the exported resource in each row.

    • Used for modify, delete, execute, and custom actions to identify the resource instance on the database represented in the row data.

    • Takes precedence over search fields.

    • Unique to the resource on the particular database. Cannot be reused across different databases.

Sheet types

  • Formatted Excel Export: Columns match the bulk load template sheet.

  • Unformatted Excel Export: Columns reflect the properties of an exported JSON file (only non-empty strings and boolean values are included).

Reusability

  • Formatted, export sheets can be used as bulk load templates to bulk load data

  • For other actions, complete the # Search Fields column. Refer to Bulk load template sheet layout.

  • Remove Default values from ungrouped fields before bulk loading.

Limitations

  • Excel cell content is limited to the maximum length allowed in a Microsoft Excel cell (32 767 characters).

  • Longer property values will be truncated in the exported sheet.