Skip to Main Content

MARKETPLACE

Export Modifications

By Sisense

  • Export Enhancements
Add-on Version 1.7.3
OS Support
Windows
Linux
Supported Sisense Versions (Linux) Latest
Supported Sisense Versions (Windows) Latest
Last Updated June 12, 2024
Tags
csv
excel
export

The Export Modifications add-on enables you to change the style of exported Excel files and add additional information to export CSV and Excel files, such as the dashboard information. The add-on also enables exporting to Excel for table and table with aggregation widgets.

Note: Export modifications are set from the Configuration Manager and apply to all users for all exports. A user cannot modify a specific Excel or CSV export.

Excel Modifications

Apply the following changes to Excel files:

  • Include dashboard information, such as dashboard date and last data update date
  • Cell content alignment
  • Include dashboard and widget filters
  • Insert an image – can be used to brand the Excel
  • Modify ‘rows’ columns to contain unmerged cells
  • Move the ‘grand total’ row to the top of the table
  • Make the ‘grand total’ row, ‘grand total’ columns
  • Make measures headers bold

CSV Modifications

Apply the following changes to CSV files:

  • Add filters below the widget data to CSV files

Screenshots

Dashboard Widget:

Export Modifications Off:

Export Modifications On (Report Tab):

Export Modifications On (Filters Tab):

CSV File:


Installation

The Export Modification add-on contains two components:

  1. Windows service Sisense.ExportModifications
  2. Client-Side plugin: exportModifications

To install the Export Modifications add-on:

  1. Download the Export Modifications add-on.
  2. Extract the .zip file.
  3. Save the /Plugin/exportModifications folder in the plugins folder: C:Program FilesSisenseappplugins.If the folder does not exist, create it.
  4. Run the /Service/PSE.Sisense.ExportModifications.msi file.
  5. Restart Sisense services:
    1. Open the Configuration Manager from your browser at http://localhost:3030.
    2. Click the Sisense logo five times to display the full list of service configurations on the left.
    3. Click Restart Services.
  6. Configure the Export Modifications add-on, as described below.
  7. Refresh your dashboard.

Configure the Export Modifications

  1. Open the Configuration Manager from your browser at http://localhost:3030.
  2. Click the Sisense logo five times to display the full list of service configurations on the left.
  3. Click the Export Modification tab.

Configuration options:

  1. Alignment – Excel cell alignment.
    1. alignmentNumber left/right/center. Alignment of number values.
    2. alignmentText left/right/center. Alignment of text values.
  2. General
    1. configuredFilterTitle text. Specify the title of a dashboard filter to be presented on the first Excel tab.
    2. enabledFilterSheet on/off. Includes an additional tab with the widget and dashboard filters.
    3. enabledReportName on/off. When toggled on, an additional row with the widget name and the configuredFilterTitle is added to the first tab above the table.
    4. grandTotalTop on/off. When toggled on, the grand total row is presented at the top of the table.
    5. make font bold on/off. When toggled on, the column headers are bold.
    6. minExcelColumnWidth number. Set the minimum width of Excel columns.
    7. showFiltersOnCSV on/off. When toggled on, the dashboard and widget filters are included in the CSV file.
  3. InsertImage – Can be used to brand the Excel and add a logo.
    1. enabled on/off. When toggled on, the configured image is added to Excel.
    2. imageHeight number
    3. imagePath text
    4. imageWidth number
  4. NewTextLines – Additional information
    1. dateFormat text. The format of the data date and the export date in the filters tab.
    2. explanatoryText text. The text is added to all Excel files on the Filters tab.
    3. newRowCharacter text. Character to split the explanatory text by.

This is a premium Sisense add-on. For pricing details please get in touch with your CSM

Version 1.7.3 – June 12, 2024

  • Updated payload format for internal requests for the latest Sisense version

Version 1.7.2 – March 14, 2024

  • Added support for Web Acess Token authentication

Version 1.7.1 – March 14, 2024

  • Bug fix: Add-on causes the Export to Excel failure with 404 on
    Live Models

Version 1.7.0 – Nov. 21, 2023

  • Bug fix: error message appears in case of exporting a table with aggregation with 1 row

Version 1.6.9 – Sept. 18, 2023

  • Bug fix: incorrect export in case a text column has numeric data
  • Bug fix: export truncates leading 0’s in numbers

Version 1.6.6 – May 24, 2023

  • Bug fix: compatibility issue with Report Manager and export to Excel V2

Version 1.6.4 – Mar. 22, 2023

  • Bug fix: compatibility issue with metadata translation add-on

Version 1.6.3 – Jan. 20, 2023

  • Added support for Excel export engine V2

Version 1.6.2 – Dec. 22, 2022

  • Bug fixes
  • Added max row/column amount to export in the configuration. This prevents requests being hung when exporting too large tables.

Version 1.4.0 – Mar. 11, 2022

  • Added support for L2022.3

Version 1.4.0 – Feb. 10, 2022

  • Added support for L2022.2
  • Installation steps have been changed to support installation with scripts

Version 1.4.0 – Jan. 20, 2022

  • Added support for L2022.1 and verified on L2021.12
  • Added support for v2 export engine

Version 1.2.0 – Dec. 10, 2021

  • Added support for L2021.12.0

Version 1.1.11 – Nov. 10, 2021

  • Added fix for limited number of records in exported table

Version 1.1.9 – Nov. 01, 2021

  • Added support for L2021.11 and W2021.9.0

Version 1.1.9 – Sept. 27, 2021

  • Added support for L2021.10.0

Version 1.1.9 – Sept. 03, 2021

  • Added support for L2021.9

Version 1.1.9 – Aug. 09, 2021

  • Added support for L2021.8
  • Fixed issue with formula in Pivot

Version 1.1.8 – 2- July 23, 2021

  • Added support for L2021.3.

Version 1.1.8 – July 15 , 2021

  • Added support for L2021.3.1, W20.21.4, W20.21.6
  • Fixed issue with unmerged cells

Version 1.1.5 – May 17, 2021

  • Increased plugin performance and stability

Version 1.1.4 – April 07, 2021

  • Added support for 8.2.5, 2021.2, L8.2.6, L2021.1.3

Version 1.0.0.35 – Dec 08, 2020

  • First release

Want the latest in analytics?