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:

1. Click Export in the toolbar above the data table to open the menu and select the item with the desired file format: CSV or JSON.
2. 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.

3. If file generation takes a long time (more than 15 seconds), the operation is moved to the background. If this is the case, follow these steps to download the file:
   1. Click in the application web interface menu.

      The list of background operations opens.

   2. Wait for the file generation operation to complete.
   3. Click Download file.

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:

1. Select the items whose information you want to export to a file.
2. Right-click to display the context menu of one of the selected items.
3. In the context menu, select the relevant file format option: CSV or JSON.
4. 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.

5. 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.

Page top