Customizing Downloads Settings

Several options may be managed from the Downloads menu, depending on the chart type of the visual. To see what options map to specific visual types, see the Visual Settings matrix.

To get to the options in the Downloads menu, follow these steps:

  1. On the right side of Visual Designer, click the Settings menu.

    Settings menu of Visual Designer
  2. In the Settings menu, click Downloads.

    Downloads settings
  3. Select one of the options:

Enabling CSV Download

Arcadia Enterprise supports download of data in a visual, in a CSV or an Excel format.

Availability Notes:
To enable CSV download at the visual level, select Enable "Download as CSV/Excel" in the Downloads menu. To disable CSV download, de-select the Enable "Download as CSV/Excel" option.
Enabling CSV download

Enabling Quotation Marks in CSV Download

If you download a CSV file and open in excel, leading zeros in a numeric string are truncated. To see the leading zeros, Arcadia Enterprise enables you to add quotes in a numeric string.

To enable quotation marks in a numeric string, select Quote numeric strings in CSV download in the Downloads menu.
Enabling quotation marks to see leading zeros in CSV download

To disable support of quotation marks in a *.csv file, de-select the Quote numeric strings in CSV download option.

Before enabling this setting, you must first Enable CSV download, in the Downloads menu at the visual level. Note that the site administrator can override the visual-level setting at the site level. See Downloading Maximum Number of Rows in CSV Files.

Enabling Excel Download in Visuals

You can enable or disable Excel data download for each visual in a *.xls file.

Availability Note. This setting is available on all visual types. Note that the site administrator can override this setting in the Enable "Download as CSV/Excel" by default in the Site Settings interface. See Downloading Maximum Number of Rows in CSV Files.
To enable Excel download, select Enable "Download as CSV/Excel" in the Downloads menu. To disable Excel download, de-select this option.
Enabling CSV/Excel download

Setting the Locale for CSV Downloads

By default, the locale settings for CSV download format match the system settings of the Internet browser. However, it is possible to specify a different locale for download.

Availability Notes:
  • This setting is available on all visual types.

To change the locale format for the CSV download, navigate to the Downloads menu, and change the Set "Download as CSV" Locale option.

CSV download locale option

Here, the default locale is en-US, and we use the Set "Download as CSV" Locale menu to select an alternate locale,Germany.

Changing locale settings for CSV download format to Germany