Skip to main content

Varicent ELT Help Center

Microsoft OneDrive export

Abstract

Connect your Varicent ELT and Microsoft OneDrive accounts to export your data.

Connect your Varicent ELT and Microsoft OneDrive accounts to export your data.

Before you begin

You must have a pre-existing Microsoft account, either business or personal.

When you create a new Microsoft OneDrive connection, you are redirected to sign in to your Microsoft account. If you have multiple Microsoft accounts, enter the credentials for the account containing the Microsoft OneDrive you want to export your files to. You are then prompted to give permission to Varicent ELT to write the files in your Microsoft OneDrive. This permission is required so Varicent ELT can list available directories, and export the files you select.

Create the connection

Create the connection between Varicent ELT and Microsoft OneDrive. Generate a new connection or use an existing one.

Creating a new connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down menu.

  4. From the Connection drop-down, click + New connection.

  5. Create the new Microsoft OneDrive connection for the Export tool.

    1. In the File name field, enter the file name.

    2. In the Export type field, choose either the CSV or Excel file type.

      Note

      Due to a restriction, you cannot export to the Root and Shared with me folders.

      Any sub-folders within the Shared with me folder is available for export.

    3. In the Export destination field, choose the directory that you want to export your files to.

    4. Click Export now, or Schedule.

      Note

      For more information on scheduling exports, see Schedule data.

    5. In the Create an export pane, add an optional Export name, and review the input and output.

      The export is created and you will see the export in the Export log.

Using your existing connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration, click the Connection drop-down menu.

  4. Search for and select your existing Microsoft OneDrive export connection.

  5. In the Export tool configuration panel, enter the following information:

    1. In the File name field, enter the file name.

    2. In the Export type field, choose either the CSV or Excel file type.

    3. In the Export destination field, choose the directory that you want to export your files to.

    4. Click Export now or Schedule export.

      Note

      For more information on scheduling exports, see Schedule data.

    5. In the Create an export pane, add an optional Export name, and review the input and output.

      The export is created and you will see the export in the Export log.

Error handling

The following errors may appear during the export process:

Error

Description

Solution

(error code: xxxx)

Export failed with the Microsoft OneDrive error.

To fix this error, review the Microsoft OneDrive documentation: Code property.