View exports to XLSX format

The document describes the functions of exporting any view in the AMAGE system to the XLS format. Often, users want to perform additional operations in addition to the standard view presented by the AMAGE system, send a list to an external user or enter it into another system without having to configure data exporters. To do this, virtually all views provide an export of this data. This is available not only for lists, but also for trees, i.e. nested structures. This document describes this functionality.

List views (i.e. tables) have an additional XLS button available at the bottom in the status bar. Pressing the button allows you to export all visible data to the XLS format in a representation exactly as the user is currently viewing it, i.e. the order of the columns and their visibility are preserved.

The generator exports all columns including image and blank columns. Sometimes it may export html links to, for example, embedded images. Nevertheless, it does not affect the full functionality.

The system generates an export from all the data (not just the visible rows) so the generation may take a while, as the system has to load all the records corresponding to the current view.

We will show the export of tree data using the example of exporting a list of inspection plans in the inspection work module. When you display the inspection work plan for the selected period, you get a tree related by the periods of activity execution, i.e., today, this week, next month, etc.

After generating the view we need with the appropriate date range, we get a view with a single grouping element corresponding to the given range

The view also has an XLS button at the bottom of the screen, activating which will start generating the view as a file.

The generated file retains the information and tree structure, i.e. the subordinate elements are appropriately shifted relative to the main elements.