Page History

Some clients manually input data in a flat file and upload it to Dropbox. Can MSPbots perform an ETL on this data for use in creating client datasets, and how is this done?

Here is how you can set up Dropbox and MSPbots to allow ETL: 

1. Set up the MSPbots and Dropbox integration. Follow the steps in this article. 
2. Add the file for conversion. 
   1. Go to Integrations on the MSPbots menu. 
   2. Locate the Dropbox integration.
   3. Click the ellipsis ... button then the Files option. 
      Image Added
      
   4. On the window that appears, select

Wiki: https://wiki.mspbots.ai/x/vL4j  

1. Go to Integrations 

1. Locate for the Dropbox integration 

1. Click the Sync button 

• Important: This and the next steps require Dropbox login. Log in to Dropbox before you proceed. Dropbox will prompt to authorize MSPbots to pull data. Click Yes, authorize MSPbots.  

1. You will see a message saying that you have successfully linked Dropbox. Click the Save button. 

Adding a file 

1. Go to integrations 

1. Locate for the Dropbox integration 

1. Click the ellipsis button then the Files option. There’ll be a pop-up window that will appear 

1. Select
   1. the user that has the CSV file in their profile
    Enter
   1. .
   2. Next, search for the file
   name in
   1. from the File
   name field then click the search button to search for it
   1. Name field. You can also search using the file
   using their file
   1. extension.
      If
   the file extension of the file is a csv then
   1. looking for a CSV file, you can search for *.csv
   and it will
   1. to return all
   of
   1. the
   csv
   1. CSV files that the user has. 
   1. Click the file that you want to
   get converted
   1. convert into a dataset.  
   2. Click the Save button. 

...

1. 1. Add the file you want to use.

Note:Dataset creation is currently done manually by the MSPbots Data Engineers. This process will be automated soon. In the meantime, you can ask for help in converting your CSV file into a dataset by filing a support ticket. 

Please send a support ticket requesting to convert the csv file to a dataset.