Export assets

You can export assets from a view. For example, this is useful if you want to create an overview in Excel.

Prerequisites

You have a global role that has the Export global permission.

Steps

  1. Open a view.

  2. Above the table, to the right, click Assets.

    The Export dialog box appears.

  3. Enter the required information.
    FieldDescription
    View

    Choose the view that you want to export.

    By default, your current view is filled in as view to export.

    Add the characteristic needed for reimport. (ID, Domain, Community, ...)

    Select this option if you want to reimport the export file later.

    By default, the export file only contains the characteristics that are displayed in the view. If you select this field, the export file will contain additional columns that are needed for the reimport.

    Remove text formatting

    Select this option to remove any formatting of attributes in the export file.

    Important When you reimport a file with this option selected, the columns are not automatically mapped to prevent overwriting formatted text. If you manually map the columns, you lose the text formatting.

    File name

    Type the name of the export file.

    By default, the name of the export file is set to the name of the view.

    File type

    Choose the file type of the export.

    By default, the exported file type is Excel, but you can change it to CSV.

    Sheet name

    Type the name of the sheet in the export file.

    This option only appears if you select Excel as the File type.

    Characters selector

    Select the characters you want to use as:

    • Separator: The default is ;.
    • Quote: The default is ".
    • Escape: The default is \.

    This option only appears if you select CSV as the File type.

  4. Click Export.

    A progress message appears. You can send this message to the background by closing it.

    When the export completes, the export file downloads according to the settings of your web browser.

  5. Close the progress message.

Note You can access the export file after finishing the export process by going to Settings → Activities and then clicking Results alongside the export action.