This feature is particularly useful for System Administrators who must respond to internal requests to process data contained in the Dossier Manager database.
In fact, it allows the user to extract data contained in the Dossier Manager database or in that of DbTransito, using either the logical views or stored procedures that have already been predetermined, in addition to free queries.
The procedure guides the user in defining the extraction mode and any parameters: the result of the extraction is shown in a preview and then saved in an excel file defined by the user. The excel file can also have a template for the definition of the layout.
Each extraction performed is stored in the database with the name of the user, the date and time of extraction and the name of the file produced: each user will see only the list of his own extractions, while an administrator user will see all of them.
The system also allows you to clone a previous extraction to give you the ability to perform the same extraction at later times.