Scheduled Report Delivery Via Email or sFTP

Created:
Updated:
Avatar
by C.W. Holeman III
Follow

Overview

Reports can be scheduled to be delivered by either email, sent to an sFTP server under your control, or both.

Note: The sFTP functionality must be enabled by Technical Support before you can begin. You will need to Submit a Ticket to us if you are interested in utilizing this functionality.

Only Super Admins can schedule reports to be sent to an sFTP server (in addition to emailed reports).

Emailing Reports

To schedule a report, open a custom or saved report, scroll down to the ‘Schedule Report’ section. Specify the date and time, and select one or more of the following check boxes:

Screenshot 2023-10-26 at 2.54.53 PM.png

Rules Engine

Admins can use the Rules Engine to configure recipients of Scheduled Custom Reports when they check the Send to users with access to report checkbox.

When checked, Admins will be given a preview statement of the default rules for that report which also shows the number of users that have access to the specific Custom Report.

  • In order to receive an emailed Custom Report, users will need to have a profile in the LMS with a valid email, as well as have access to the Custom Report via a role.
    • Access to the Custom Report can be granted via the Admin Tool -> Users -> Roles -> Role Abilities -> Reports.

Screenshot 2023-10-26 at 2.58.17 PM.png

If there is a desire to refine the list of recipients, Admins can click the Edit button to bring up the Rules Engine and can add more rules to narrow down the list.

Screenshot 2023-10-26 at 3.01.58 PM.png

Send To Myself

The next option for receiving scheduled Custom Reports is the ability for the Admin to send it to themselves.

Screenshot 2023-10-26 at 3.04.07 PM.png

Registered Emails

To support clients that are sending scheduled Custom Reports to ‘non-user’ emails, like store emails or department emails, Super Admins can whitelist these emails in the LMS and select them for report distribution.

Please see this article for more details.

Screenshot 2023-10-26 at 3.27.48 PM.png

Custom Names for Reports Sent via Email

Reports sent via email can be given a custom name. This custom name will show up in the subject of the email, as well as being the name of the provided CSV file:

Custom report names are not currently available for reports sent via SFTP.

Reports via SFTP

Custom reports can be scheduled to be sent to an SFTP by Super Admins. Partial Admins will not see the Send to an SFTP checkbox.

Screenshot 2023-10-26 at 3.09.30 PM.png

How to set up SFTP

  1. SFTP Setup
  2. SFTP profile creation is in System
  3. Up to 5 SFTP profiles can be created

 

 

 

  1. Testing the sFTP Connection
  2. sFTP connection success notification
  3. Click “Save” to save credentials and close the notification
  4. sFTP connection failure notification
  5. Click “Okay” to close the notification and edit credentials
  6. Activate the sFTP profile