MailScheduler Product Guide

For the installation we refer to the enterprise installation manual overview page.

Automate the distribution of user-specific dashboards with MailScheduler. Determine the recipients, dashboards and format and schedule your information to be delivered to those who need it, when they need it.

Send expansive reports with multipage PDF’s, data for analysis with XLS or CSV’s and an update with an inline PNG of your desired dashboard. 

Getting started

To start using MailScheduler, simply head over to the URL configured during installation and create your first Schedule.

Schedules determine when tasks are triggered, tasks determine what is sent and to whom it is sent. Sending out an email starts with configuration of the Schedule, followed by the underlaying Tasks. Before being able to create a schedule, the following resources must be configured (see relevant chapters):

• A Server
• A Token
• A Site

Adding Tasks can only be done after the Schedule has been created and saved. In the Schedule overview, navigate to the newly created Schedule to add Tasks.

Frequencies

The frequency determines when the schedule will trigger its tasks. There are several options:

• Hourly: Specify the time at which the schedule will trigger each hour, between what hours each day and if it should be triggered on weekdays, weekends or both
• On days of the week: Once per day at a specified time, the schedule will trigger. Which days of the week can be specified aswel.
• Every Month: once per month, on a specified day or on the first workday of the month, the schedule will trigger. Specify the time of day aswel.
• Every Quarter: once per quarter, on a specified day or on the first workday of the quarter, the schedule will trigger. Specify the time of day aswel.

Export/Import of Tasks

Tasks can be imported and exported to or from a schedule under “additional settings”. Exporting results in a CSV file that can be edited and reimported to the same or a new schedule.

Edit Tasks in CSV

To edit an existing task, leave the task_id in place. To create a new task, Leave it empty to create a single view in a task. When using multiple views in one task, please give it a fake id that does not yet exist in the database.

Task_id, task_name, filename, emails, mailing_lists, and save are settings that apply to one task. So multiple views within the same task should be similar. Otherwise, the MailScheduler will take the final row into account.

The view_id will be empty for new tasks. To update an existing view, leave the id the same. We recommend using each view in only 1 task and do not reuse a view. By filling the view_url (case sensitive!), the MailScheduler will search for the exact name match on your Tableau. You can put filtering queries in the query column, and multiple export types are supported: pdf-v, xls, csv, image.

When you are done editing the CSV file, import it again. Select choose file, select the CSV file, and hit upload.

A schedule can consist of multiple tasks. We already know when to send it, now we need to specify what to send in the email. Tasks consist of the email settings, content, recipients, and Tableau views and filters.

Email Settings

The subject line of a an email can contain the date using the following format: {yyyy-mm-dd hh:mm:ss}. Note: when lines are left empty, they will be pulled from the .env file used by MailScheduler.

Mailing Lists

Add recipients for the task, either through mailing lists or separately with email addresses. Using this last option only adds the email to this specific task without saving it as a recipient or as part of a mailinglist. For advanced configuration such as recipient or mailinglist filters, instead add the recipient to a mailinglist.

Views

A Task consists of views and an email body (message). A task can only access views from workbooks within the site that is associated with the Schedule the task is part of.

Select the workbook and view to be added to the task. For more information on applying filters in a View, see the Filters section of the guide. By selecting the checkbox, the corresponding export format is attached to the mail. All PDFs that are exported will be merged before they are attached, with the order of views from top to bottom being used to determine the order for the PDF. You can edit and delete the view by clicking the buttons in front of the view.

When creating a view, select the relevant workbook and view and add filters if required (for more details on filters, see the relevant chapter).

PDF filename and CSV options only apply when one or more views use the PDF or CSV format.

In the message, we can create the email content, this will be the message your users will receive in their email. Each element in the email can consist of either an image or text, with the ability to save templates for reuse.

Rich text

Add your content in the rich text box, you can format your message such as changing the style, linking websites and adding inline images.

Image

Add an image which is placed in the folder img, next to the phar file on the server. Be sure to specify the size of the image.

Here you can also format the image you’re attaching to your task, this can be a company logo for example. Create a label so you can reuse in another task, a filename which will be the name where the file is saved in your folder. Decide on the size and alignment of the image to give your message the best look. Uploaded images can be found and managed in the “Templates” tab.

Templates

Reuse a template from the list. Here will show all the labels of your stored text and images to reapply to message elements as you see fit. Templates can be linked to a task via the import/export schedule tool. You cannot create a new template from a csv file. This must be done in the MailScheduler front-end. Templates with views only work within a task targeting the same workbook, as these views are only available within this workbook.