Page-Wise Export Support for Grid and Card Widgets
We have introduced support for page-wise export functionality for grid and card widgets in Bold BI. This feature allows you to export the entire dataset as a paginated PDF, enhancing the flexibility and usability of your data exports.
Enabling Page-Wise Export
To enable page-wise export for a Grid or Card widget, follow these steps:
- Open the Export Dialog: When you attempt to export a grid or card widget, the export dialog will appear.
- Enable Page-Wise Exporting: In the export dialog, you will find an option labeled Enable Pagewise Exporting. Enable this option to export the entire dataset as a paginated PDF. If this option is disabled, only the current view of the dashboard will be exported.
Configuring Page-Wise Export Record Count
The default setting for exporting data in Page wise Export is 500 records. To change the number of records included in page wise of the PDF export, you can modify the PageWiseExportRecordCount property in the appsettings.json file. This property enables you to specify the number of records to be included in the PDF export.
You will need to manually edit the PageWiseExportRecordCount flag count in your appsettings.json file. Once change the flag count you need to restart the IIS or service.
Locating the appsettings.json File
The appsettings.json file can be found in the following locations:
Windows
<Installed_Directory>/Bold-services/bi/dataservice/appsettings.json
Linux:
/var/www/bold-services/application/bi/dataservice
Example Configuration
{
"PageWiseExportRecordCount": 300
}
In this example, the PDF export will contain 300 data entries in the grid or card format.
Limitation
- Maximum Data Export: We recommend exporting a maximum of 2000 data entries, which is equivalent to approximately 150 pages. Exporting more than this may result in a time-out error or memory issues.
