Page History

This article has the steps for setting up Dropbox and adding CSV files for dataset conversion. 

What's in this article:

Background Information

...

Setting up a Dropbox integration with MSPbots is done by authorizing Dropbox in MSPbots and configuring the data source. Dropbox now supports both Teams Sync and Personal Sync. This article has the steps for setting up Dropbox and adding CSV files for dataset conversion. 

Required Permissions

...

Users with the admin role can set up Dropbox integration.

To set up and connect Dropbox to MSPbots

...

1. Log in to the MSPbots dashboard as an administrator .Go and go to Integrations 
   Image Added

2. Search and search for Dropbox in the search bar and click it to open.

   Note
   The Since the next steps require Dropbox login. Log , please log in to Dropbox before you proceed. Dropbox will prompt to authorize MSPbots to pull data. Click Click Yes, authorize MSPbots.

   Image Added

3. If you are a Teams administrator and need to synchronize files in the Teams folder, please authorize by clicking Teams Sync.
   If you are a personal user and need to synchronize files in personal folders, please authorize sync to the folders by clicking Personal Sync. 
   Image Modified 

4. A When a message saying that you have successfully linked Dropbox appears. Click the Save the Save button.
5. Test the connection. 

To add a CSV file

...

1. Go to to Integrations on the MSPbots app. 
2. Locate the Dropbox integration. 
3. Click the ellipsis ... button, then select
the Files
4. the Files option.
   
Image Removed
5. Image Added 
6. On the window that appears, select the user that has the CSV file in their profile. 
   Image Removed
   Next, enter the filename in the the File name field, then click Image Added the search button. You can also use the file extension for search. For example, if the file extension is .csv, search for for *.csv to  to show return all CSV files that the user has. 
   Image Added
   
7. On the search results, click the file for conversion into a dataset.
   
8. Click the Save button. 

...

1. Note

   Please ensure that the file you upload is in UTF-8 encoding format because it is the best format for compatibility with our system.Uploading files in other encoding formats may cause issues with the conversion of the dataset. For example, datasets generated from UTF-16 encoded files uploaded from Dropbox is generating spaces between units.You can check the encoding format of your CSV file by opening it in a text editor such as Notepad. If it is not in UTF-8 encoding format, please save the file as UTF-8 encoding format before uploading it. The CSV files cannot contain 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

...

Here is an example of a CSV error when the quotes are not in pairs: 

1. If your file upload triggers a rule, please delete the original datasets (named "Dropbox Data XXXXX_csv" and "Dropbox XXXXX_csv") before uploading again.

2. Click Save and Sync. 

...