Importing data from cloud drive

Importing data from cloud drive

Analytics Plus allows you to import data from CSV, Excel (XLS and XLSX), JSON, HTML and zipped files stored on different Cloud Drive/Storage such as Google Drive, Dropbox, Box and OneDrive, for advanced reporting and analysis. You can also schedule periodical import from your Cloud Drive.

This section explains how to import data from Cloud Drive into Analytics Plus.

  1. What are the Cloud Storage services from which I can import data into Analytics Plus?
  2. How do I import data from Google Drive into Analytics Plus?
  3. How do I import data from Dropbox file into Analytics Plus?
  4. How do I import data from Box into Analytics Plus?
  5. How do I import data from OneDrive into Analytics Plus?
  6. Can I import data into an existing table?
  7. Can I import huge files into Analytics Plus?
  8. Can I map a column from my file into a column in Analytics Plus table while importing?
  9. Why do I see Warning Details in the Import Summary?
  10. How do I set On Import Error options?

1. What are the Cloud Storage services from which I can import data into Analytics Plus?

Analytics Plus allows you to import data stored on Cloud Drives such as Google Drive, Dropbox, Box and OneDrive, for advanced reporting and analysis. You can also schedule periodic imports from your Cloud Drive. 

Supported file formats:

  • CSV
  • Excel (XLS and XLSX)
  • JSON
  • HTML
  • XML
  • MS Access Database file
  • .zip file

2. How do I import data from Google Drive into Analytics Plus?

To import data from Google Drive: 

  • Goto your Home page → Click on the Import Your Data option → Select Cloud Storage/Drive.  

  • Select Google Drive option under the Choose Your Storage app window.

  • The import wizard will walk you through the steps displayed in the screenshot below. Click Start Wizard to continue. 
  • Copy the URL from the screen using the Copy URL button and click Next

  • Log into the Google API console and select a project from the drop-down. 
  • Create a new project if you don't have one already. 
  • Go to Library or click on ENABLE APIs AND SERVICES on the home page. 

  • Search for Google Drive API → Click Enable

  • Click on the Create Credentials button in the Google Drive API page and select OAuth client ID

  • Select Google Drive API and Web browser(Javascript) in the drop-down. Check the radio button User data.  

 

  • Give a name (preferably Analytics Plus) to your OAuth client and paste the authorized redirect URL copied from the wizard screen previously.  
  • Click on Create OAuth client ID button.

  • Click on I'll do this later and press Done

  • From the OAuth 2.0 client IDs list in the Credentials tab, click on Analytics Plus. 

  • Copy the Client ID and Client secret, and click Save
  • In the Analytics Plus import wizard, enter the Workspace name and paste the Client ID and Client Secret copied previously.   
  • Click Browse and select files to import from your Google Drive. 

  • Authenticate your Google account before selecting files to import.  
  • Note: Allow pop-ups on your browser to view the Cloud Uploader window. 

 

 

  • Once authenticated, you can view your files under Cloud Uploader - Select your file window. Select the required file and click OK
  • Now, the selected file will appear under Google Drive.  
  • Click the Create button. 

 

3. How do I import data from Dropbox into Analytics Plus?

To import data into Dropbox:

  • Click on the Import your Data button in the home page.  
  • Select Cloud Storage/Drive
  • Select Dropbox from Choose your Storage app window. 

  • The import wizard will walk you through the steps displayed in the screenshot below. Click Start Wizard to continue. 
  • Copy the URL from the screen using the Copy URL button and click Next

  • Check Dropbox API under Choose an API. 

  • Choose Full Dropbox under Choose the type of access you need.

  • Give a name to your app (preferably Analytics Plus) and check the box to agree to Dropbox API's terms and conditions.   
  • Click Create app

  • Paste the copied URL under the Redirect URIs and click the Add button. 

  • Click the Show button against App secret and copy the credentials (App key and App secret). 
     
  • In the Analytics Plus import wizard, give your workspace a name under the Workspace Name
  • Paste the App key and App secret under Client Id and Client Secret which were copied from the previous step. 
  • Click the Browse button.

  • Authenticate your Dropbox account before selecting files to import. Once authenticated, you can view your files in the Cloud Uploader window. Select the required file and click OK
  • Note: Allow pop-ups on your browser to view the Cloud Uploader window. 

  • Now, the selected file's name will appear under Dropbox
  • Click the Create button. 

4. How do I import data from Box into Analytics Plus?

To import data into Box:

  • Click on the Import your Data button in the home page.  
  • Select Cloud Storage/Drive
  • Select Box from Choose your Storage app window. 

  • Copy the URL from the wizard screen using the Copy URL button.   
  • Click Next

  • Select Custom App.   
  • Click Next

  • Select Standard OAuth 2.0 (UserAuthentication) under Recommended for Custom App window and click Next

  • Give a name to your app (preferably Analytics Plus) and click Create App.

  • Paste the copied URL in the OAuth 2.0 Redirect URI text box and Save Changes.

  • Make a note of the Client ID and Client Secret that appears on OAuth 2.0 credentials section. 

  • In the Analytics Plus import wizard, enter the Workspace Name and paste the Client Id and Client Secret copied previously.   
  • Click the Browse button. 

  • Authenticate your Box account before selecting files to import. 
  • Once authenticated, you can view your files in the Cloud Uploader window.
  • Select the required file and click OK

Note: Allow pop-ups on your browser to view the Cloud Uploader window.

  • Now, the selected file's name will appear under Box
  • Click the Create button.

5. How do I import data from OneDrive into Analytics Plus?

To import data into OneDrive:

  • Click on the Import your Data button in the home page.  
  • Select Cloud Storage/Drive
  • Select OneDrive from Choose your Storage app window. 

  • The import wizard will walk you through the steps displayed in the screenshot below. Click Start Wizard to continue. 
  • Copy the URL from the screen using the Copy URL button and click Next

  • Create a new app project if you don't have one already.   
  • Give it a name (preferably Analytics Plus) and click Create

  • Click Add platform and choose Web

  • Paste the previously copied URL in the Redirect URLs section and Save the changes. 

  • Click the Generate New Password button.   
  • Make a note of the password and copy the Application ID.   
  • Click Ok.

  • In the Analytics Plus import wizard, enter the Workspace Name and paste the Client Id and Client Secret copied previously. 
  • Click the Browse button. 

  • Authenticate your OneDrive account before selecting files to import.   
  • Once authenticated, you can view your files in the Cloud Uploader window.
  • Select the required file and click OK.   

Note: Allow pop-ups on your browser to view the Cloud Uploader window.

  • Now, the selected file's name will appear under OneDrive.   
  • Click the Create button.

6. Can I import data into an existing table?

Yes. Please follow the given steps to import data into an existing table.

  1. Open the table into which you want to import data.
  2. Click the plus icon "+" beside the Edit Design button and select Import Data / New Table.  An import wizard to guide you through the data import process will open.

7. Can I import huge files into Analytics Plus? 

Analytics Plus Agent has a restriction on the size of data import. The file size for upload cannot exceed 500MB. 
Larger files (>500MB) can be imported using the Analytics Plus Agent, which is a downloadable tool that can be installed in your machine.  You can also schedule data uploads using this tool.

Refer to the Analytics Plus Agent documentation section to learn more. 

 

8. Can I map a column from my file with a column in the Analytics Plus table while importing?

Yes, you can map columns while importing. Click the Join tables button below the Data Preview of the Import Setting. This will list the lookup columns. A lookup is a parent-child relation between the two matching columns, one from the existing table and the other from the table being imported. Matching columns are the two columns which share the same data type and the column name. With lookup, you can choose to map a new column with another from an existing table (which joins the two tables) in Analytics Plus during import. 

 

9. Why do I see Warning Details in the Import Summary?

Specifying a wrong data type for your column will generate errors on import. Analytics Plus will handle the errors condition as you have set in On Import Errors option. 

In case of such errors, the details of the same would be shown in the Import Summary dialog.

10. How do I set On Import Error option?

You can specify how Analytics Plus should handle import errors with predefined rules in the Import setting dialog of the Import Wizard.

These are the available options:

  • Set Empty Value for the Column (default) - Select this option to set empty values to the corresponding column value which had problems while importing.
  • Skip Corresponding Rows - Select this option to skip the corresponding rows in which an error occurs while importing.
  • Don't Import the data - Select this option to abort the import process, if any error occurs on import.

Error details (if any) will be shown in the Import Summary dialog which appears on completion of the Import process.

Share this post : FacebookTwitter