Export a pagelet

In Axway Decision Insight (DI), you can export the text-based contents of a dashboard pagelet in its current state in either Excel or CSV format. 

Supported pagelets

The pagelet export tool is supported for the following pagelet types only:

Pagelet type Export file format
  • Datagrid

The data displayed follows the same layout as the pagelet.

For example, if you're exporting the results of a payments search, and you've sorted the results by descending amount in your pagelet, then the export file will also display the results based on your sort setting.

  • Activity

The acknowledge mashlet Html UI allows to enter a formatted comment. This rich comment will be rendered in the activity pagelet Excel export as much as possible:

  • Excel supports the character formats Bold, Underline and Italic.
  • Line alignment (left, center, right, justified) is not rendered as excel only support one alignment for the whole cell.
  • For comments containing an hyperlink, only the displayed text of the hyperlink is exported, not the URL.
  • Bullet list and ordered list are not supported in excel cell, they are simulated with bullet '•' chars.
  • Instance
  • ImageMap
The data is displayed on one line only.

For more information about pagelet types, see Pagelet types.

Supported mashlets

Whatever the chosen export format, the pagelet export tool only exports text-based data. As a consequence, classifier values are exported as text.

Chart mashlets (Multihistorical, Historical Baseline, Spark charts...) can be exported when they are presented in an Instance or Image Map pagelet.
If the chosen export format is Excel, then the first worksheet of the resulting Excel workbook will present all the supported non chart mashlets. There is an additionnal worksheet for each chart mashlet. Each chart mashlet will be referenced in this first worksheet, with a direct link to the worksheet containing the chart data.
If the chosen export format is CSV, then the export will result in a zip, with one CSV file for the global pagelet, with a reference to the file names of the exported charts, then one additional CSV file for each chart. 
Additional Excel worksheets or CSV files are named after the mashlet's "Header" label.

Spark chart present in a Datagrid pagelet will not be exported.

Action button and relation editors will not be rendered. 

For more information about mashlet types, see Mashlet types.

Export a pagelet

To export a pagelet, follow these steps.

Step Action
1 On the main menu, click the All dashboards button.
2 Select a dashboard.

Once you're on the desired dashboard screen, click the Actions button on the top-right side of your screen.

4 Click Export.The Export pagelet pop-up screen is displayed.
5 In the Locale drop-down, select the relevant locale. This is important for CSV export as the CSV separator varies from one locale to the next.
6 In the Time zone drop-down, select your time zone.

In the Pagelet list, hover over the different pagelets. As you hover on a pagelet in the list, the corresponding pagelet is highlighted in the dashboard. This is particularly useful if the pagelets in your dashboard are untitled.

Once you've found the pagelet to export, click Export to Excel or Export to CSV as needed.

8 When asked to save the file, click Yes. The pagelet export file is generated and you can choose where to save the file.

Maximum number of rows in a datagrid pagelet export 

In a dashboard, the maximum number of rows displayed in a datagrid pagelet is limited based on a platform.properties setting. The default number is 500. However, when exporting a pagelet, the output file will contain all returned rows even if there are more than the default max results numbers in the list displayed on the user interface.

To limit the number of rows in a pagelet export, restrict the row count of a pagelet. For example, if the row count of a pagelet is limited to 100, then the export file for this pagelet will also contain 100 rows only. 

To modify the row count of a pagelet, follow these steps.

Step Action
1 Edit your pagelet.
2 On the left menu, click Format
3 In the maximum number of rows displayed text box, enter the maximum number of rows allowed for this pagelet. 
4 Click Done, then Save.

Related Links