Skip to main content
Matrix42 Self-Service Help Center

Export Data

Overview

Available in the system data can be exported in a number of formats and for a single record, multiple entries or all data.

Data can be downloaded by users who have access to Export action. For more information see How to Set Audience in Solution Builder page.

Export Action

Export data is a generic action available for most Configuration Items by default. Use Export action to download data of single or multiple selected records. 

To export data with Export action:

  1. In the navigation area, click the search page with the Configuration Item data you want to export;
  2. Select necessary items;
  3. Click Export action;
  4. Choose the file format;
  5. Click Export

export_action.png

The following export formats are provided:

  • Excel: downloaded file has .xlsx format and along with the exported data includes the heading row with the same columns as displayed on the Dataset View of the exported Configuration Item
  • CSV: selected items are exported into a file as comma-separated-values;
  • XML: the downloaded file has XML structure and .dat extension. The exported file is actually a schema script that allows creating data based on the exported items;
  • Delete statements: this option exports selected data into a file with XML structure and  .del extension. The exported file is actually a schema script containing information about the data objects that will be removed from the database when the script applied, whilst the exported data remains in the application intact.

export_action_formats.png

Export action: downloaded data formats

Export All Data 

To export all data to a .xlsx format:

  1. In the navigation area, click the search page with the Configuration Item data you want to export;
  2. On the toolbar, click Export all:

export_all.png

Export All option is available in the Dataset View layouts, as on the example above, and certain Grid Controls that were added as a part of other layouts and have export option configured accordingly.    

  • Was this article helpful?