Exporting data from a table to a file
The data tables of certain sections of the application web interface provide the capability to export data to files in the following formats:
- CSV
When exporting to this format, the file saves information from the columns currently displayed in the table. Certain data that is not displayed in the table (for example, additional fields and Process Control settings in device information) may also be stored in this format.
- JSON
When exporting a file in this format, all the data for table items is saved, including service information from the database (such as information about events associated with the devices).
You can export information for all items that satisfy the current filter and search settings, or selectively for items displayed in the table.
To export data for all items that satisfy the current filter and search settings:
- Click the Export link on the toolbar above the data table to open the menu and select the item with the desired file format: CSV or JSON.
- If the option to save supplementary settings is available for export, in the window that appears, select the check boxes for the settings that you want to export.
The file creation process starts.
- If it takes a long time (more than 15 seconds) to create the file, the file creation operation is transferred to the list of background operations. In this case, to download the file:
- Click the
button in the menu of the application web interface.
The list of background operations appears.
- Wait for the file creation operation to finish.
- Click the Download file button.
- Click the
Your browser will save the downloaded file. Depending on your browser settings, your screen may show a window in which you can change the path and name of the saved file.
To export data for the selected items:
- Select the items whose information you want to export to a file.
- Right-click to display the context menu of one of the selected items.
- In the context menu, select the relevant file format option: CSV or JSON.
- If the option to save supplementary settings is available for export, in the window that appears, select the check boxes for the settings that you want to export.
The file creation process starts.
- If it takes a long time (more than 15 seconds) to create the file, perform the necessary actions for step 3 as described in the procedure for exporting data for all items.