Save widget data as a CSV file

You can save the current data visualized in a widget as a CSV file.

The aggregation and the value rounding are taken from the column configuration set in data assignment (Assign data 2/2 dialog). The sorting is taken from the data feed result based on the feed definition.

Note that when exporting data from a widget, the export may fail if the stream size is too large. In this case you can increase the maxPostSize value of the HTTP Connector of your Tomcat installation. If not already specified, you can set this attribute to 2097152 (2 megabytes). You can set this value in the server.xml file.

Procedure

  1. Open a dashboard in dashboard view mode.
  2. Click a widget.
  3. Click the Show menu Menu icon.

    The menu is available if the Widget menu option is enabled for the widget.

  4. Click Save as CSV.
  5. Make your settings if required.
    1. Select a separator character from the Separator drop-down menu. The default separator is ,.
    2. Select a masking character from the Masking drop-down menu. The default masking is ".
    3. Select an encoding type from the Encoding drop-down menu. The default encoding is UTF-8.
    4. Enable the Define formatting option to change the default data format. You can select a data format for each column in the corresponding drop-down menu.

      The data are saved in the default data format or in the format set in data assignment (Assign data 2/2 dialog).

    5. Click OK.

      Depending on which Web browser you are using, you can select an application that you want to open to view the data, or you can save the data directly as a CSV file.

The widget data is saved as a CSV file.

Note that CSV files can pose a security risk when they are opened in MS Excel. Certain characters in the CSV file can be used for unwanted code execution.

Enclose all values beginning with =, +, -, or @ in single quotation mark before exporting as CSV file. For details, refer to https://www.contextis.com//resources/blog/comma-separated-vulnerabilities/.