Icon

03.Generate_​Daily_​Recap_​Report

Generate Daily Recap Report

This workflow reads
- The new feedback and its calculated sentiment.
- The list of user who opted-out of receiving emails
and generates a recap report containing the list of users who lately left feedback and whether a followup email can be sent to them or not. The execution waits for up-to-date data.

03. Generate Daily Recap ReportThis workflow reads - The new feedback and its calculated sentiment.- The list of user who opted-out of receiving emailsand generates a recap report containing the list of users who lately left feedback and whether a followup email can be sent to them ornot. The execution waits for up-to-date data. Executed by: WORKFLOW ACTION(02.Feedback_Analyzer) Clean new_entries.csv file. Old feedback will not beprocessed again. Read new feedback and append email_allowed field Wait for updated dataBefore generating the report, make sure that the list of email unsubscribers has been updated today. Therefore, check theemail_unsubscribers.csv file metadata and - If updated within the last 5 minutes, go on with the execution.- If not updated within the last 5 minutes, wait X seconds and check again These parameters can be configuredwhen executing the workflow from theserver (Configuration Options panel) readnew_entries.csvclean filenew_entries.csvread empty filereademail_unsubscribers.csvup: email opt-outbottom: email allowedemail_allowed=noemail_allowed=yesSaved toDaily Reports folderfilter file path toemail_unsubscribers.csvwait X secondsand check againmax attemptswaiting time (sec)CSV Reader CSV Writer CSV Reader CSV Reader Reference RowSplitter ConstantValue Column ConstantValue Column Concatenate Generate DailyRecap Report List Files/Folders CASE Switch Start Wait... Counting Loop Start CASE Switch End File last edit IntegerConfiguration IntegerConfiguration Variable Loop End 03. Generate Daily Recap ReportThis workflow reads - The new feedback and its calculated sentiment.- The list of user who opted-out of receiving emailsand generates a recap report containing the list of users who lately left feedback and whether a followup email can be sent to them ornot. The execution waits for up-to-date data. Executed by: WORKFLOW ACTION(02.Feedback_Analyzer) Clean new_entries.csv file. Old feedback will not beprocessed again. Read new feedback and append email_allowed field Wait for updated dataBefore generating the report, make sure that the list of email unsubscribers has been updated today. Therefore, check theemail_unsubscribers.csv file metadata and - If updated within the last 5 minutes, go on with the execution.- If not updated within the last 5 minutes, wait X seconds and check again These parameters can be configuredwhen executing the workflow from theserver (Configuration Options panel) readnew_entries.csvclean filenew_entries.csvread empty filereademail_unsubscribers.csvup: email opt-outbottom: email allowedemail_allowed=noemail_allowed=yesSaved toDaily Reports folderfilter file path toemail_unsubscribers.csvwait X secondsand check againmax attemptswaiting time (sec)CSV Reader CSV Writer CSV Reader CSV Reader Reference RowSplitter ConstantValue Column ConstantValue Column Concatenate Generate DailyRecap Report List Files/Folders CASE Switch Start Wait... Counting Loop Start CASE Switch End File last edit IntegerConfiguration IntegerConfiguration Variable Loop End

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: emilio.silvestri
Created at: 2022-07-06
On NodePit since: 2022-11-05
Last update: 2024-04-26
Created with KNIME version: v4.6.3
Tags: Education

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

Try NodePit Runner!