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.
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.
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).
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.
4.Provide your CSV file with a name and click Save.
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.
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.
2.On the Connect to Google Screen, enter the email for the Google account you wish to connect to.
3.Enter the Password for the Google Account.
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.
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.
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.
3.Now select the New Project button.
4.Give your project a name, specify the organization it will belong to, and its location. Click Create.
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.
6.Search for, and enable the Google Drive API and the Admin SDK.
7.Switch to the credentials section by selecting Credentials in the left hand panel.
8.On the Credentials screen click Create Credentials, and then Service Account.
9.On the Service Account Details Screen give your service account a name, assign an account ID, and give it a description. Click Create.
10. On the next page, select the role drop down and select Project and then Owner. Click Continue.
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.
12.You will automatically be taken to the Credentials overview screen. Click Manage Service Accounts.
13.Next to the service account you just created, select the three dots, and click Create Key.
14.Specify P12 as the key file type and click Create.
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.
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.
17.Specify the file you want to import, in this case it is the key file. Click Next.
18.Enter the password you were given after creating the Key and select your security setting for the Key file. Click Next.
19.Select whether you want the certificate key to be stored automatically or in a specified store. Click Next.
20.On the overview page review the information and click Finish.
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.
22.On the Service Account details page, select the "Show Domain-Wide Delegation" drop down.
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.
25.When the page opens, copy and save the following parameters to a new text file on your computer:
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 .
28.On the Security page select Advanced Settings, and then Manage Domain Wide Delegation.
29.On the Domain Wide Delegation page select Add new.
30.In the "Add a new client ID" pop up, paste in the Client ID value you generated in step 25.
24.In the OAuth Scopes section, add the following string exactly as it appears here and Click Authorize:
(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.
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.
32.In a few seconds, you should receive the message Successfully connected to Google Drive.