Deliver a Burst to FTP, Shared Drive, SharePoint Site

Metric Insights allows to configure and manage Bursts via FTP, Shared Drive, or SharePoint Site in addition to, or instead of, sending them via email.

PREREQUISITES:

  • Users must have "Create FTP Connections" Privilege to be able to create and edit FTP connections.

NOTE: Shared Drive/SharePoint Site connections can be created by the Admin only.

To be able to deliver files/attachments for External Reports and Other External Content, additional options must be specified:

  • External Report: Editor > Advanced tab > Collect additional files. NOTE: Image must be collected after configuring this option.
  • Other External Content: Editor > Configuration tab > Include files as attachments

Additionally, it is strongly recommended that the file type selected at the Element level corresponds to the file type selected for a Channel in a Burst Editor. For example:

  • External Reports: if Collect additional files = PDF, then Filetype = PDF
  • Other External Content:
    • SharePoint and Local Filesystem: if the type of the file that you select as an object for Other External Content creation is PDF, then Filetype = PDF

NOTE: Other External Content of type "Other" delivers only PDF. That's why in Burst Editor the Filetype option must be always set to PDF.

For more information on attachment rules, refer to this article.

[7.1.1] enabled the delivery of multiple PDF files for Filter combinations to FTP, Shared Drive, or SharePoint Site.

When set to "Y", the System Variable COMBINE_PDF_FOR_EACH_FILTER_COMBO, all Filter combinations for an External Report are merged into a single multi-page PDF. When set to "N", each Filter combination is sent as a separate PDF file. The setting is ignored if COMBINE_PDF_DOWNLOADS_IN_DIGEST is "Y" (the digest mode always merges PDFs). If both are set to "N", each Filter combination is delivered as a separate PDF.

Create and Send Burst via FTP/Shared Drive/SharePoint Site

NOTE: If a distribution channel option is not active, it has not been configured. Follow instructions below on how to set up an FTP connection/Shared Drive/SharePoint Site.

  1. Name the Burst and select content for it.
  2. Schedule: Select the required schedule.
  3. Send Burst via: Select the required distribution channel.
  4. Select one of the preconfigured destinations.
  5. Specify the required filetype:
    • The difference between "CSV:Raw" and "CSV:Formatted" file types is explained in the note below.
  6. [Save and Enable]
  7. [Send Now] will send the Burst immediately.

NOTE:

  • Metric Insights supports two CSV formats: "CSV Raw" and "CSV Formatted".  When using these file types, remember the following:
    1. "CSV: Raw" files contain unformatted data.
    2. "CSV: Formatted" is a file type that has been changed by a Metric Insights User (e.g, had a Display Mask applied to it, was reorganized in some way at Element level).
    3. CSV data contained in External Reports can only be passed in a raw CSV format.
    4. Email services usually transform CSV: Raw files to look more user-friendly. They are still considered unformatted (Raw) by Metric Insights' standards.
  • When a Burst includes multiple Tiles and PDF, PPT, or XLSX is selected as under Filetype, the delivered content will be merged into one file instead of delivering a separate file for each Tile. This rule does not apply to Other External Content.

To learn more about how to set up and manage Bursts, check Report Bursting.

Expand or collapse content Create FTP Connection

Access Admin > Distribution > FTP Connections

  1. Click [+Add FTP Connection]
  2. Protocol: Select one of the following:
    • FTP
    • FTPS: Specify whether to use Explicit (default) or Implicit FTPS.
    • SFTP
  3. Host: Choose the host server location. As a rule, this is <hostname>.metricinsights.com
  4. Port: Enter the port number:
    • The default ports are: 21 for FTP and Explicit FTPS, 22 for SFTP, 990 for Implicit FTPS.
  5. Directory: Specify the directory to which your content will be pushed.
  6. [Save]
    • It is recommended to [Test Connection] from the Editor.

Users can register one or more FTP Servers within Metric Insights and specify access credentials for each server.

Expand or collapse content Add Shared Drive
Expand or collapse content Create a New Shared Drive Folder

Prior to adding a Shared Drive profile in Metric Insights UI, make sure the needed folder is created in a Linux Server.

  1. SSH to the Linux server where MI app is deployed
    • Root user access is required
  2. Access a web container:
    • For Simple Installation – sudo mi-console
    • For orchestrated environments, use the corresponding command – docker exec -it <web container ID> -- bash
  3. Access the directory where you want to create a new shared drive folder
    • Example: cd /opt/mi/iv/data/temp
  4. Create a new directory: mkdir <new directory name>
    • Example: mkdir test_directory/ 
  5. Change user access for the newly-created directory: chown www-data:www-data <new directory name>/
    • Example: chown www-data:www-data  test_directory/ 
  6. Change access privileges for the directory: chmod 755 <new directory name>/
    • Example:  chmod  755 test_directory/
  7. Follow the steps below to add a new Shared Drive
    • It is recommended to [Test Connection] to the drive, once it's added in MI

Access Admin > Distribution > Shared Drives

  1. Click [+New Shared Drive]
  2. Name: Specify the name of the Shared Drive.
  3. Path: Define the path to the Shared Drive folder to which the content will be distributed.
  4. [Save]
    • It is recommended to [Test Connection] from the Editor.

Only admins can create Shared Directories. Users can only burst to shared directories to which they have access.

Expand or collapse content Add SharePoint Site

Access Admin > Distribution > Microsoft SharePoint

  1. Click [+New SharePoint Site]
  2. Name: Enter a descriptive name.
  3. Path: Specify a path to a SharePoint folder to which you want content to be delivered:
    • In this example https://<name.sharepoint.com>/Shared%20Documents/YG_Demo, the Path to a Folder is /Shared Documents/YG_Demo.
  4. Site URL: Specify the URL you use to access your SharePoint.
  5. Auth Type: Define the auth type and proceed providing the required details based on your choice.
    • Follow these instructions to configure an Azure app and locate the required parameters. NOTE: The Azure app must have the Application Files.ReadWrite.All permission with the Admin consent enabled (see the screen below).
  6. [Save]
    • It is recommended to [Test Connection] from the Editor.
Expand or collapse content Troubleshooting

If any failures occur when Bursting to FTP, a “File Upload Errors” email will be sent to the Burst Creator.