October 2021 Dashboard Release Notes
Release Name - pi.2021_10_28
Release Date - Nov 17, 2021
We are pleased to present our latest offering of pi - our October 2021 release! This page helps summarise and familiarise you with the changes we have made, and is supported (where applicable) with useful videos to help explain the changes we have delivered.
Dec 13, 2021 - in response to a Java security vulnerability around Log4J2, this version of the dashboard needs to be updated to a version from our patched November 21 (inclusive) - or mitigating actions taken to provide security assurances - more information can be found HERE
Before upgrading, we ALWAYS recommend taking a backup. You can find more information on how to do this here.
Known Issue - There's a breaking change on the database schema between our September and October releases, which means Blue-Green deployment is not possible between the two versions. Those using Blue-Green deployment can upgrade to October, by shutting down the old deployment and standing a new one up.
Here’s what we’ll cover;
- 1 Added
- 2 Changed
- 2.1 Exclude excel reader logic from excel - incompatible databases (Zendesk#16672)
- 2.2 Improve Category Filters step debug time (Zendesk#17278)
- 2.3 Change to external URL message text (Zendesk#17155)
- 2.4 Improve Configuration Tool --help
- 2.5 Use Linux services for managing the dashboard (Zendesk#16464,18107,18356)
- 3 Fixed
- 3.1 Replace [[variables]] in the exported/ scheduled file names (Zendesk#16704)
- 3.2 Remove old export link
- 3.3 Card Charts with no data not displaying correctly
- 3.4 Restore repo from filepath (Zendesk#18035,18131)
- 3.5 Word output of a report containing Card Charts (Zendesk#17284)
- 3.6 Charts not displayed when changes were made to colours used in the legend (Zendesk#17116)
- 3.7 Environment variables fix
- 4 Keeping An Eye On pi
Added
Rich Text Editing (Zendesk#12199,17277,8739,9168,9257)
Reporting/ Card Charts
Rich text editing allows you to change the appearance of text by using different fonts, changing the font size and colour, applying background colours and changing the alignment. The screenshot below shows how some of the new formatting options can be used.
The following screenshot shows the new formatting toolbar when creating/ editing a Card Chart.
Changing a font is really easy, select the text that you want to change and click the ‘Font Family’ icon to choose a new font.
Rich text editing has been added to the following areas of the dashboard:
Scheduling screen
Report text editing
Report header text editing
Card chart type
Users will be able to apply formatting to entire paragraphs of text, particular sentences or to individual words or characters.
You can see full details of this new feature here.
You can also find details of the changes affecting reports and scheduling by clicking this link and card charts by clicking this link.
In addition to the formatting options:
Users will now be able to download a Card Chart as a Word.docx
Card Chart types used in a report will appear when the report is downloaded as a Word.docx
Video
We’ve created a short video to explain this in a bit more detail.
Storage Access API (Zendesk#15468,15723)
Authentication
The Dashboard now supports the Storage Access API that some browsers offer (currently Edge, Safari and Firefox), which allows a user to permit usage of third-party cookies for a website e.g. when the Dashboard is embedded in another website. This allows the Dashboard to work embedded even when third-party cookies are blocked as long as the feature is supported and permission is granted.
Certificates for SMTP servers (Zendesk#15225)
Scheduler
A new option, ‘Allow Unverified Security Certificates’, has been added to Dashboard Configuration> Settings which allows users to ignore a self-signed/invalid certificate.
By default, the button will be unticked which will allow for the security checks to be carried out for the certificates used.
Changed
Exclude excel reader logic from excel - incompatible databases (Zendesk#16672)
Data Connections
Some extra logic has been introduced, which will now skip any excel-reader related logic if the data connection does not support the excel-reader. This change has been introduced in order to improve performance and will affect the following data connections; MYSQL, MYSQL_8, SINGLE_STORE, SQL_SERVER, FREE_FORMAT_JDBC
.
Improve Category Filters step debug time (Zendesk#17278)
Filters
The time taken to build category filter values in charts will now be visible in the dashboard.
Change to external URL message text (Zendesk#17155)
Charts
The message that was displayed when a user clicked on a drill down level on a chart that was launching an external URL has been changed from 'External URL link has been launched (Disable pop-up blockers)' to 'External URL link has been launched'.
Improve Configuration Tool --help
Configuration Tool
The --help
option of the configuration tool has been improved.
Use Linux services for managing the dashboard (Zendesk#16464,18107,18356)
Deployment
Added Linux services for managing the dashboard.
Fixed
Replace [[variables]] in the exported/ scheduled file names (Zendesk#16704)
Exports
When files were exported, any Variable values such as in ‘Report for [[TODAY]]’, were not replaced in the exported file. The Variable name will now be replaced in the exported file for example, Report_for_2021-10-02.pdf.
Remove old export link
More Options
The old import-export link in ‘More Options’ will no longer be visible when installing a slim-docker build. Users will be able to access it directly (if they still use it) when installing the full fat docker build.
Card Charts with no data not displaying correctly
Card Chart Types
Card Charts that contain text but no data were not being displayed correctly when saved.
Restore repo from filepath (Zendesk#18035,18131)
Dashboard Configuration
The path error which was shown in the configuration tool logs when the repository was being restored from the file path will no longer appear.
Word output of a report containing Card Charts (Zendesk#17284)
pi Reports
When a report that contained a Card Chart was exported to Word, the Card Chart was not being displayed correctly.
Charts not displayed when changes were made to colours used in the legend (Zendesk#17116)
Chart Types
When a legend item containing a numeric value was recoloured and the chart then filtered on this value no data was being displayed.
Environment variables fix
Variables
All Environment Variables should now be correctly applied. This specifically affected containerised and AMI deployments.
CUSTOMER NEWS - Our August 24 Release Is Now Available - Download It Now!