Exporting Hit Lists

yuuvis® RAD client • 9.x »

The results of a search will be displayed in a hit list of all objects that were found. You can export the content of a hit list and further edit it using an external program (Microsoft Excel, for example). You can choose from the following export options:

  • Export parts of the hit list

    You can use the standard Windows commands Ctrl+C and Ctrl+V to export one or more lines of the hit list. Only the data that is displayed in the hit list will be exported. If necessary, change the display via the configuration menu in the header of the hit list.

  • Export the entire hit list

    You can use the Export as CSV file icon 'Export as CSV file' function in the hit list header to export the entire hit list. The exported data is output according to the settings in the hit list configuration menu. Sorting and other changes made in the hit list view, such as filters and hidden columns, are ignored during export. The data fields (columns) are separated with semicolons. The separation settings can be customized by your administrator.

  1. Select one or more objects from your hit list and press Ctrl+C.

    You can select hit list lines by

    • holding the Ctrl key and then clicking one or more individual hits.

    • holding the Shift key ⇧ and then clicking the first and last object in a sequence of consecutive hits.

    The contents of the hit list will be copied to the Windows clipboard.

  2. Switch to an external program (e.g., Microsoft Excel) and press Ctrl+V.

The contents of the Window clipboard will be pasted.

The table header is not exported. In spreadsheet programs such as Microsoft Excel, the rows and columns of the hit list will be retained.

The exported data is available in the same format that it is stored in in the Elasticsearch database. As a result, the date and datetime fields are output in the standard international format. That means, for example, that dates in YYYY-MM-DD format are output regardless of the language settings in yuuvis® RAD client. Decimal numbers are exported in the relevant format used in the preset language.

Instead of user names, ID values are exported in the corresponding columns when exporting hit lists with reference fields. If you want to receive, for example, the resolved user data for the export instead of these ID values, then the system must be configured accordingly by your administrator. Please contact your administrator in this case.