Chat now with support
Chat with Support

Metalogix Essentials for Office 365 2.7 - User Guide

Copyright Tool Overview
General Tool Configuration Profile Manager Proxy Mode Azure Turbo and CSOM Creating User Mapping Creating User and Template Reports Support and Troubleshooting Activation Modes of Migration
Home Tab Migration Analysis Tab Migrator Tab
Interface Connect to Resources Copy Sites Live Compare Copy Lists and Libraries Copy, Move, and Tag SharePoint Content Copy Alerts In-Place Tagging of SharePoint Items Incremental and Delta Copy Forms Migration Workflow Migration Save Site to XML
File Manager Tab Drives Tab
Interface Overview Migration Job Structure Connecting to Resources Copy Google Drive Copy File Share Copy My Sites to OneDrive for Business Copy Tenant Copy Box Copy Dropbox Nintex Deployment
Security Manager Tab Term Store Manager Tab Administrator Tab Backup Tab
Interface Overview Backup Job Structure Advanced Search Retention Policies Storage for Backup Import/Export Backup Archives Connecting to SharePoint and OneDrive for Business Connecting to Cloud Storage Hyper vs Classic Backup Setup Hyper SharePoint Online Backup Hyper OneDrive Backup Hyper Office 365 Groups Backup Smart Backup Classic SharePoint Online Backup Classic OneDrive Backup Classic Office365 Groups Backup Classic Mailbox Backup Change Properties for Backup Admin Management Scheduling Backup Jobs Backup Project Conversion
Help Tab View Tab Architect Tab Public Folders for SharePoint Tab Informant Tab Scripts Appendix About

Export to CSV

Essentials provides users with the ability to Export a list of Box users to a CSV file. This report can then be used for User Mapping or Source-To-Target CSV file creation for Mass Migrations from the Drives Tab.

Box-Users-CSV-Report

 

The following steps will run through the process of Exporting Box users to a CSV file.

1.In the Essentials console, click on the Drives tab, and select Box. This will open the Connect to Box window.
Export to CSV 1

2.On the Connect to Box window, enter a project name, a Box Admin account and its corresponding Password. Check on the "User Service Account" option. Click on Connect or Claims (depending on the authorization settings for your Box service).
Export to CSV 2

3.Once you're connected to box the Select Box Users window will pop up. Select the users you wish to export to a CSV report and then click the Export to CSV button.
Export to CSV 3

4.Provide your CSV file with a name and click Save.
Export to CSV 4

Connecting to Google

In order to be able to use the Metalogix Essentials Content and Navigator panes in order to copy the contents of your various Drives by dragging and dropping, you will first need to connect to them within Essentials. The following are detailed steps on how to connect to your respective Drives.

Connecting to Google Accounts

If you wish to connect to a Google account, then follow these steps:

1.Start by selecting the Google option in the Connect To section under the Drives tab.
Connecting to Google

2.On the Connect to Google Screen, enter the email for the Google account you wish to connect to.
Connect to Google2

3.Enter the Password for the Google Account.
Connecting to Google3

4.Allow Metalogix International GmbH to use your information in accordane with our terms of service and privacy policies. You can do this by selecting Allow on the following screen. Connecting to Google4

info

NOTE: if you wish to run bulk migrations of Google Drives to Microsoft OneDrive then you must next complete the steps in this section.

5.This connection is now available in the Navigator Pane.
Navigator Pane 1

Connecting to Google Admin Console

This sections describes the process required in order to connect to Google's Admin Console in order to run bulk migrations of Google Drives to Microsoft OneDrive.  

Note: If you are planning to migrate each drive individually, you can skip this section.

1.Open the Google Cloud Developer Console and login with your Google Admin Account. https://console.developers.google.com

2.From the dashboard, select the drop down list next to Google API's.
Google Prerequisites2

3.Now select the New Project button.
google api 1

4.Give your project a name, specify the organization it will belong to, and its location. Click Create.
google api 2
 

5.Once the Project has been created you will receive a notification. Select the project from the drop down menu, and navigate to it's API "Library" on the left side navigation pane.
google api 3

6.Search for, and enable the Google Drive API and the Admin SDK.
google api 4

7.Switch to the credentials section by selecting Credentials in the left hand panel.
Google Prerequisites4

8.On the Credentials screen click Create Credentials, and then Service Account.
google api 5

9.On the Service Account Details Screen give your service account a name, assign an account ID, and give it a description. Click Create.
google api 6

10. On the next page, select the role drop down and select Project and then Owner. Click Continue.
google api 7

11.You can now choose to list accounts that will be able to function as users and/or admin for this service account. Click Done to complete setup.  
google api 8

12.You will automatically be taken to the Credentials overview screen. Click Manage Service Accounts.
google api 9

13.Next to the service account you just created, select the three dots, and click Create Key.
google api 10

14.Specify P12 as the key file type and click Create.
google api 11

15.In a few seconds the key file will be downloaded to your computer and you will be provided with a password for this key file. Copy this password, you will need it in the next steps.  
google api 12

16.In your browser's downloads, open the Key file that was automatically downloaded. This will open the Certificate Import wizard. Select your store location and click Next.
google api 13
 

17.Specify the file you want to import, in this case it is the key file. Click Next.
google api14

18.Enter the password you were given after creating the Key and select your security setting for the Key file. Click Next.
google api 15

19.Select whether you want the certificate key to be stored automatically or in a specified store. Click Next.
google api 16

20.On the overview page review the information and click Finish.
google api 17

21.Back on the Service Accounts page, select the three dots next to your service account and select Edit, this will open the service account details page.
google api 19

22.On the Service Account details page, select the "Show Domain-Wide Delegation" drop down.
google api 20

23.Check the box to "Enable G Suite Domain-wide Delegation". A new field "Product name for the consent screen" may appear, if it does enter any name you wish in this box and click Save. If it does not just continue to the next step.

24. You should now see “View Client ID” in the Options section for your service account. Click on View Client ID.
google api 21

25.When the page opens, copy and save the following parameters to a new text file on your computer:

oClient ID

oService Account
Google Prerequisites13

26.Open a new tab in your browser and go to https://admin.google.com. Login with your admin account if necessary.

27.From the Admin Home page, select the menu button on the top left hand corner, and click the Security menu option, and .
Google Prerequisites14

28.On the Security page select Advanced Settings, and then Manage Domain Wide Delegation.
google api 28

29.On the Domain Wide Delegation page select Add new.
google api 29

30.In the "Add a new client ID" pop up, paste in the Client ID value you generated in step 25.
google api 30

24.In the OAuth Scopes section, add the following string exactly as it appears here and Click Authorize:
 
https://docs.google.com/feeds,https://www.googleapis.com/auth/admin.directory.group.member.readonly,https://www.googleapis.com/auth/admin.directory.group.readonly,https://www.googleapis.com/auth/admin.directory.user.readonly,https://www.googleapis.com/auth/drive,https://www.googleapis.com/auth/drive.file,https://www.googleapis.com/auth/userinfo.email,https://www.googleapis.com/auth/userinfo.profile
 
(Also available in .txt file format here)

25.Start Metalogix Essentials software, go to Drives tab and click Copy Google Drive in the ribbon. Select "Copy Google Drive to OneDrive" from the drop down list.
copy google drive 1

26.Enter the Google Drive parameters as follows and then click Connect:

a.Admin User – the username of the account that was just used to create the service account.

b.P12 Key File – click the Load button and select the .p12 key file you downloaded earlier

c.Service Account – paste in the service account ID that you saved to a text file earlier. You want to paste the service account that is formatted like an email address.
Google Prerequisites19

32.In a few seconds, you should receive the message “Successfully connected to Google Drive”.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating