Exporting data from the UI - Advanced export

Clicking the Advanced export option of an object listing interface in Kentico opens one of two possible Advanced export dialogs, depending on the type of user performing the operation.

Using advanced export

Once you have the options adjusted, click Export to export the data to the chosen type of file. Clicking Preview creates an export file with up to 100 records – the preview can be useful to verify the output when exporting a very large number of records.

Advanced export - global administrator

When the Advanced export option is selected by a user with the Global administrator privilege level, the system displays an Advanced export dialog.

Using advanced export as a global administrator

Advanced export options

Export to

The type of file to which the data will be exported. You can choose from the following:

  • Excel - exports data to an XLSX spreadsheet.
  • CSV - exports data to a CSV file.
  • XML - exports data to an XML file.

Delimiter

Displayed only when you select export to CSV. Sets the character used to separated values in the CSV file. The character can either be a comma (,) or a semicolon (;). See the Configuring UI data export topic for more details.

Export raw database data

The format of data displayed in listings is not always identical to the actual data stored in the database columns. For example, the Enabled column in the user listing shows Yes/No values, but the CMS_User table actually stores True/False values in the UserEnabled column.

With this option enabled, the exported data is exactly as stored in the database, and column headers are identical to database column names. If disabled, column headers and the data are exported as shown in the listing interface.

Current page only

If enabled, the export only includes the data displayed on the currently selected page of the listing interface. If disabled, all records on all pages of the listing are exported (limited by the Number of records setting).

Note: The Current page only setting is not compatible with manual adjusting of the Order by or Where condition settings.

Number of records

Specifies the maximum number of data records included in the export. Set an empty value to export all available data. The specified number of exported records can be limited by enabling the Current page only option.

Export column header

If enabled, the export file includes column headers. This option is not available when exporting to XML, since the column header names are used for the corresponding XML elements.

Order by

Standard SQL ORDER BY expression. The exported data in the file is ordered according to the expression.

Note: You can only select columns that have a corresponding physical column in the database.

Use grid filter

If enabled, the export only includes data matching the filter above the listing in the interface. If disabled, all data is exported regardless of the filter settings.

Where condition

Standard SQL WHERE condition that filters which data items are included in the export file.

Columns

Allows you to choose which data columns the export contains.
If the Export raw database data option is enabled, the listed column names are identical to the actual database columns name. If the option is disabled, column names are shown as in the listing interface.

Advanced export - standard user

When the Advanced export option is selected by a standard user who is not a global administrator, the system displays a simplified Advanced export dialog. Options are restricted compared to the global administrator version for security reasons.

 Using advanced export as a non-admin user

Advanced export options

Export to

The type of file to which the data will be exported. You can choose from the following:

  • Excel - exports data to an XLSX spreadsheet.
  • CSV - exports data to a CSV file.
  • XML - exports data to an XML file.

Delimiter

Displayed only when you select export to CSV. Sets the character used to separated values in the CSV file. The character can either be a comma (,) or a semicolon (;). See the Configuring UI data export topic for more details.

Current page only

If enabled, the export only includes the data displayed on the currently selected page of the listing interface. If disabled, all records on all pages of the listing are exported (limited by the Number of records setting).

Note: The Current page only setting is not compatible with manual adjusting of the Order by setting.

Number of records

Specifies the maximum number of data records included in the export. Set an empty value to export all available data. The specified number of exported records can be limited by enabling the Current page only option.

Export column header

If enabled, the export file includes column headers. This option is not available when exporting to XML, since the column header names are used for the corresponding XML elements.

Order by

Determines the order of the data records in the exported file.

The first selector allows you to choose one of the object’s data fields. The exported data is ordered according to the values in the given field, either in ascending or descending order (determined by the second selector). After you make a choice, you can use additional pairs of selectors to choose how data is ordered in case of identical values in the previously selected field.

Columns

Allows you to choose which data columns the export contains.