Concatenate Reports and Send by Email
You can easily download and run the workflow within your KNIME installation. For optimal performance, we recommend using the latest version of the KNIME Analytics Platform.
This workflow aims to demonstrate the features of the Reporting nodes. Specifically, we aim to create three dashboards, paginate them, and generate a PDF report for emailing.
We used Google Analytics to download anonymous data from our website and created three CSV files in the workflow data area.
We have organised our report pages by encapsulating different views and text in each component. To edit your page layout, right-click on the component and choose "Open layout editor". You can arrange the items for your report page. Make sure to select "Enable Reporting".
Here are some helpful tips for using the layout editor:
- There is no need to add lateral padding as it will be added automatically by the Report PDF Writer node.
- The "Text View " node helps create page headers, divide elements, and add tooltips or comments to charts.
- The "Table view" node now supports HTML. Use the Column Expression node to create links or add color to cells. Check out the "Events" component in this example to see how.
After you have enabled the "Enable Reporting" option, a blue input and output port will appear in the component. Connect the "Report Template Creator" node to the newly created input port and define the page size and orientation in the "Report Template Creator" dialogue to generate the report.
To combine the report, begin by connecting all output ports of the components to "Report Concatenate." The preview will display three pages that are ready to be shared. To create a PDF of the report, utilise "Report PDF Writer."
We write the report to a temporary folder in the workflow data area and pass the path as a flow variable. Later, we use this path to attach the PDF to our email in the "Send Email" node.
After obtaining our PDF file, we must configure the "Send Email" node. In this example, we configured the node to send an email from a Gmail account, open the configuration window and set up the node:
1. On the mail tab, you can compose an email by entering the recipient's email address and typing the body of the message.
2. The Mail Host (SMTP) tab has already been set up for you. Your only task is to generate an application password for your Gmail account. To do so, please refer to the "Sign in with app passwords (GMAIL) - Docs" link in the External resources section. This link will provide you with detailed instructions on how to generate the application password. Once you have created the application password, be sure to use it as the node's password.
URL: Sign in with app passwords (GMAIL) - Docs https://support.google.com/mail/answer/185833?hl=en
URL: KNIME Collection: First Steps with KNIME Reporting https://hub.knime.com/knime/collections/First%20Steps%20with%20KNIME%20Reporting~BmSxAYmlmIJtTh7i
Nodes
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Expressions
- FeatureKNIME Math Expression (JEP)
- FeatureKNIME Reporting
- FeatureKNIME Views
Links
- No links available