Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

After a your successful integration of Microsoft OneDrive to MSPbots, you are now ready to import your data for dataset creation. This article shows how you can add the CSV files that you want to convert into a dataset.  

What's in this article: 

Table of Contents

...

What are the requirements for adding a CSV file?

You need the following before you can add a CSV file for conversion: 

  • Admin role - Only admins and roles with editing privileges for Integrations can add CSV files. 
  • CSV files in OneDrive - You need to upload the CSV files to OneDrive before you can add these for conversion. 
  • OneDrive integration - MSPbots should be successfully connected to OneDrive before you can perform the steps below. 

...

How can I add a CSV file? 

Be guided by the following steps for adding a CSV file:

  1. Navigate to Integrations in the MSPbots app and search for OneDrive in the search bar.


  2. Click the ellipsis Image Modified and select Files. 
    Image Removedadd filesImage Added

  3. Select the user account and the CSV files in OneDrive. Do the following steps: 
    find csv file
    1. Type the user's account in the User Account field and click the Search Image Modified icon.
      Tipnote

      The User Account field is case-sensitive. Ensure that you type are typing the user account correctly. 


    2. Drives: Click the dropdown button  Image Modified to and select the appropriate drive where the file or files are located.
    3. File Name:Type Enter the file name in the File Name field and click Image Removed.Another way is by searching the Search Image Added icon.
      Alternatively, you can
      search for the file extension in the File Name search bar. For example, if the file extension is ' .csv', just type in '*.csv' to return all CSV files associated with the user. 
      Once you see your the search results are available, simply click on the file you want to convert into a dataset. 

  4. Click the Save and Sync button. 
title
Info
Warning

The CSV files cannot contain any of the following: 

  • Blank rows
  • Blank column headers
  • Duplicate column headers
  • Symbols in column headers
  • Column headers that are more than 25 characters long
  • Numbers with commas


Content by Label
showLabelsfalse
max5
showSpacefalse
titleRelated Topics
excludeCurrenttrue
cqllabel in ("onedrive","csv")