Icon

02 - extract content from DB and send email

extract content from DB and send email

This workflow shows how one can extract content from a database (SQLite in this case) and send by email.

Some notes:
- I used Mailhog (see link below), an open source local mailserver to test the workflow. This is very handy, if you don't want to use your personal email accounts for testing
- In Mailhog, it seems at first glance that you don't have an attachment. But if you download the email from Mailhog as eml file and open it (e. g. in Outlook or Thunderbird email clients) you will see that the spreadsheet is attached
- This is more or less based on a post by Ivan on the KNIME forums, also added as a link below

This workflow goes along with my weekly newsletter about data analytics called "The Data Alchemist", click on the link below to find out more or subscribe for free.

This workflow utilizes an open source local mailserver called "Mailhog". You don't even need to install it, just download it from the link below and run it, ifyou want to test this workflow locally (without using any "real" email address.Link to download Mailhog: https://github.com/mailhog/MailHog importconnect to example DBwithin this wf'sdata areaselectBUYERStableread the contentfrom the databasewrite locally toExcel file (in this workflowsdata area)open Mailhog anddownload the email(it has attachments, although it mightnot seem like it)convertfile location tostring so it can beattached to email SQLite Connector DB Table Selector DB Reader Excel Writer Send Email Path to String(Variable) This workflow utilizes an open source local mailserver called "Mailhog". You don't even need to install it, just download it from the link below and run it, ifyou want to test this workflow locally (without using any "real" email address.Link to download Mailhog: https://github.com/mailhog/MailHog importconnect to example DBwithin this wf'sdata areaselectBUYERStableread the contentfrom the databasewrite locally toExcel file (in this workflowsdata area)open Mailhog anddownload the email(it has attachments, although it mightnot seem like it)convertfile location tostring so it can beattached to emailSQLite Connector DB Table Selector DB Reader Excel Writer Send Email Path to String(Variable)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: philk
Created at: 2023-10-13
On NodePit since: 2023-10-15
Last update: 2024-05-02
Created with KNIME version: v4.7.7
Tags: emaildatabase

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!