Minitab Connect®  Support

OneDrive

Learn more about Minitab Connect
Use this connection to communicate between OneDrive® and Minitab Connect.

In This Topic

Set up a new connection

Complete the following steps to set up a connection in Minitab Connect.
  1. From the Home screen, select the Add button under Tables.
  2. Enter a Name that identifies the table and select a Folder to save the table.
  3. In Datasets, enter OneDrive and select the connector from the results.
  4. On the Setup tab, select Authorize Microsoft Account. Enter the Microsoft credentials for the account that you want to use. The button will change to Authorization Successful when you are connected.
  5. Select Save .

Import a table

Complete the following steps to import data from a file on OneDrive and create a new table in Connect.
  1. From the Home screen, select the Add button under Tables.
  2. On the Dataset tab, enter a Name that identifies the table and select a Folder to save the table.
  3. Under Documents, Collaboration, File Sharing & Email, select OneDrive.
  4. Under Connection, select the OneDrive connection that you previously set up. If you have not previously set up a connection, select New Connection.
  5. Under Update Frequency, specify how often you want Connect to update the table. You can import the data one time or have Connect continuously import the data at a set time interval. Connect automatically creates a flow for your import. If you select Once, you can use the flow at a later time to automatically run the import again.
  6. Under Drive, select the OneDrive connection that you just authorized. Select Next.
  7. Select Next.
  8. Under Files, select the file you want to import and select Next. If your file is nested in a folder, you have to select the folder and select Next before you can select the file. If your file is nested in multiple folders, you will have to do this step for each folder.
  9. Under Delete Files, select to delete the file from OneDrive, move it to the Historic folder, or do nothing. If a Historic folder does not exist, Connect creates one.
  10. Optionally, specify any of the following options.
    File Pattern
    Enter a string to match files for subsequent imports. Enter a percent symbol (%) before and after the string. For example, each day you import a file named "Measurements" that also has the date appended to it. You can enter %Measurements% to import any file name that has the word "Measurements" regardless of the date that is appended to it. If you leave this blank, subsequent imports look for files that are identical matches to the name of the original import.
    Pattern Delimiter
    If you enter multiple patterns in File Pattern, enter the symbol that separates the patterns. By default, the symbol is a comma.
    API limit
    Set the maximum number of files in your OneDrive that Connect searches through when looking for matches for patterns you entered in File Pattern. The default is 200 files and the maximum is 1,000 files.
    Download limit
    Set the limit for the number of files Connect uses to pull data into the table. The default is 200 files and the maximum is 1,000 files.
  11. Select Save . If you go to the Prep Tool and select Run , Minitab Connect displays the imported data.
    Note

    If no data appears after you select Run, select Reset Config .

When you save the import, Connect creates a flow with the settings that you selected. For more information on how to schedule a flow and add more data processes to clean data, go to Overview of the Flow Tool .

Export a file

Complete the following steps to export data from a Minitab Connect table.
  1. Open the Outputs tab of the Flow Tool .
  2. Select the plus sign beside Export to add a new export.
  3. Under Export, select New Export. If you select One Time Download, Connect downloads the file to your computer and does not create an export.
  4. Enter a Name for the export.
  5. Under View, select a saved view of the table. If you select None, Connect exports all the data from the table.
  6. Under Delivery, select Connection.
  7. Under Connection, select the OneDrive connection that you previously set up.
  8. In Please Select A Folder To Export To under the Delivery column, enter the path to store the file. The path name must end with a backslash (/). If you want to export to a subfolder, then enter the path to an existing subfolder. Leave a single backslash to export to the root folder.

You can specify the file type and file name along with other options. After you save the export, Connect adds it to the list of exports in the Outputs tab. Select Run to run the export.

Copyright © 2024 Minitab, LLC. All rights Reserved.