Creating Task to Send CSV Data via Email

Allows you to create tasks to generate and email CSV data from a workbook, dashboard, or visualization.

1. On the New Task pane, enter the Name of the task. Ensure the name is unique.
2. Tap the Activated slider to turn it on.
3. Select the Trigger. You can either select:
   • Period then enter the Interval (in seconds), or

     

   • CRON then enter a CRON Expression on the format:

     sec mins hours dayofmonth month dayofweek (e.g., 09 02 18 ? * MON-FRI)

     

4. Select the task Type: Email CSV Data.
5. Enter the Description of the task.
6. Upon selecting Email CSV Data, the Scheduler page changes to allow specification of the following:
   • Select the Workbook Name in the drop-down list. These are the published workbooks available in the Workbooks page.

     You can also enter the workbook name in the Search box. For workbooks in folders, ensure to start with \ to include folder names.

   • Select dashboards or parts where to source the CSV data from, by checking their corresponding boxes in the Dashboards and Parts drop-down list.

     

   • You can also enter the Parameter Values that will be added as parameters to the subject line of emails or as dashboard values in the CSV Data.

     Such as Parameter=Value, and are comma separated. For example:

     Region=Europe,Industry=Financials

     NOTE:

     • See Setting Parameter Values in Scheduler Tasks for more information on the different syntax you can use to enter parameters with multiple values, as well as parameter values that contain comma.
     • The following Date/Time range querying parameters are also supported in the Email CSV Data task:
       • CurrentTime
       • LastWorkDay
       • WeekStart
       • QuarterStart

       For example:

       {CurrentTime:dd-MMM-yyyy}

       However, when there is no Date/Time format supplied, the default format yyyy-MM-dd will be used instead.

   • Enter comma-separated list of Output File Names.

     NOTE:

     • The items in the list must be either unique or empty.
     • Empty string items indicate that the default title should be used.
     • By default, the text box is blank causing the implicit naming to be used.
     •  If the supplied names are fewer than the selected data sets, the default naming comes into effect for non-specified names.
7. You can opt to tap the Zip CSV Data slider to attach a zipped copy of the CSV data in the email. 
8. Enter the email address of the recipient in the To field.
9. You can also enter the following:
   • Sender Name alias to use when sending email. If left blank, the value of email.sender_name property in Panopticon.properties will be used.
   • CC and/or BCC recipients of the email separated by a comma
   • The mail message subject to be used in the email notifications in the Subject field.

     NOTE: Supports dashboard parameters.

   • Content of the email in the Body box.
10.  Click  .
    • Once saved, you can opt to click  to manually run the task.
    • Click  to go back to the Tasks pane. A new task is added to the list.

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support