Transferring data to Microsoft OneDrive

This guide explains how to transfer data to Microsoft OneDrive to store and further process information.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Create a datastream whose data you want to transfer to Microsoft OneDrive. For more information on creating a datastream, see Collecting data in Adverity.

Procedure

To transfer data from a datastream to Microsoft OneDrive, follow these steps:

  1. Add Microsoft OneDrive as a destination to the workspace which contains the datastream or to one of its parent workspaces.

  2. Assign the Microsoft OneDrive destination to the datastream.

  3. Enable data transfer to the destination from the datastream.

  4. Configure transfer settings.

Adding Microsoft OneDrive as a destination

To add Microsoft OneDrive as a destination to a workspace, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Destinations.

  2. Click + Add Destination.

  3. Click Microsoft OneDrive.

  1. In the Configuration page, fill in the following fields:

    Name

    (Optional) Rename the destination.

    Folder

    (Optional) Enter the name of the folder (or file path to the folder) in Microsoft OneDrive to which the data is sent. Ensure the name of the folder or filepath begins and ends with a forward slash (/). For example, if you were sending a data extract to a folder called "Data", enter the name of the folder as /Data/.

    Drive ID

    (Optional) Select the ID of the drive in Microsoft OneDrive to which the data is sent.

    Data Mapping

    Choose to enable Data Mapping during the data transfer. Choose one of the following options:

    • Disabled - Do not use Data Mapping. This option is selected by default.

    • Enabled (with metadata) - Enable Data Mapping during the data transfer that also adds three columns containing metadata to the transferred file.

    • Enabled (without metadata) - Enable Data Mapping during the data transfer without adding the new metadata columns to the transferred file.

  1. Click Create.

Assigning Microsoft OneDrive as a destination

To assign the Microsoft OneDrive destination to a datastream, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

  2. Open the chosen datastream by clicking on its name.

  1. In the Transfer section, below the Store section, click + Assign destination.

  2. Click Assign existing destinations.

  1. Select the Microsoft OneDrive checkbox in the list.

  2. Click Save.

Configuring transfer settings

To configure transfer settings, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Datastreams.

  2. Open the chosen datastream by clicking on its name.

  1. In the Destinations section, find the Microsoft OneDrive destination in the list, and click on the right.

  2. Click Destination settings.

  1. Fill in the following fields:

    Filename

    Specify the target file in the destination where to transfer data from the datastream. The name can contain alphanumeric characters and underscores. For example, target_file.

    To transfer data to sub-folders within the folder defined in the Filename field, specify a file path. For example, folder1/target_file.

    By default, Adverity saves data from each datastream in a different file named {datastream_type}_{datastream_id}_{scheduled_year}_{scheduled_month}_{scheduled_day}.

    If you specify the same target file for more than one datastream, the existing file will be overwritten with the new data.

    Use placeholders to create unique, dynamic names in the destination. Use the following placeholders:

    Placeholder

    Description

    {app_label}

    The Datastream Type's short name.

    {datastream_id}

    The datastream ID.

    {datastream_name}

    The datastream name.

    {extension}

    The file extension of the data extract.

    {extract_id}

    The data extract ID.

    {id}

    The datastream ID.

    {meta[*]}

    Replace * with a metadata placeholder to use metadata in the name. For example, {meta[datastream_URI]} uses the datastream URI as the name. For more information on metadata and placeholders, see Using placeholders.

    {name}

    The automatically generated filename of the data extract.

    {scheduled_day}

    The day when the data fetch was scheduled to run.

    {scheduled_month}

    The month when the data fetch was scheduled to run.

    {scheduled_year}

    The year when the data fetch was scheduled to run.

    {upload_day}

    The day when the data extract is transferred to the Microsoft OneDrive destination.

    {upload_hour}

    The hour when the data extract is transferred to the Microsoft OneDrive destination.

    {upload_minute}

    The minute when the data extract is transferred to the Microsoft OneDrive destination.

    {upload_month}

    The month when the data extract is transferred to the Microsoft OneDrive destination.

    {upload_second}

    The second when the data extract is transferred to the Microsoft OneDrive destination.

    {upload_year}

    The year when the data extract is transferred to the Microsoft OneDrive destination.

  2. Click Save.