View exports to XLSX format

Introduction

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.

Export data from lists

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.

common export treetable to xls 6242c

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.

Data generation may take a while. The system announces the action via a message at the bottom of the window. After generating the file, it is transferred to the browser as a separate window. ATTENTION please check whether the browser will not prohibit access to create a new window with an attachment. You must ensure that your browser does not BLOCK pop-up windows.

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.

Exporting tree data

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.

common export treetable to xls 23476

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

common export treetable to xls 99a86

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

common export treetable to xls c263e

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

common export treetable to xls 5fee4
In the case of multiple nestings, the system generates a view with a transition to each child element, i.e. it will export all elements in the tree up to the very end of a given branch.
The Howto is based on system version 1.17.0.2 (03.2022) and presents features that may not be available in your system. Ask AMAGE about making this functionality available.
Due to the ongoing development of the system, some screens or configuration files may look slightly different, but will still retain the full functionality described here. This does not affect the essential functions described in this document.