Converse agora com nosso suporte
Chat com o suporte

Essentials for Office 365 2.14 - User Guide

Product Activation Tool Overview
General Tool Configuration Profile Manager Proxy Mode Azure Turbo and CSOM Creating User Mapping Creating User and Template Reports Support and Troubleshooting Modes of Migration
Home Tab Migration Analysis Tab Migrator Tab
Interface Connect to Resources Copy Sites Live Compare Hyper Mode Classic Mode Copy Alerts Orphaned Users Copy In-Place Tagging of SharePoint Items Incremental/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
Post Migration Compare 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 Scripts Troubleshooting Appendix About

Copy Google Shared Drive to SharePoint Online

This option allows administrators to move content of multiple Google Shared Drives to SharePoint Online default (Documents) libraries.



·If you have not already performed the prerequisite steps in Google, please go to this section first.  Once the prerequisite configuration is complete, return here to continue with the migration.

·Essentials will only copy to the default (Documents) library on the target. If the Documents library does not exist, the operation will fail.

·Google Shared Drive members are not migrated to SharePoint Online.


·The Google Drive pre-requisites must be configured successfully prior to the migration.

·The account used to perform the upload needs to be a minimum of Site Collection Administrator in this Office 365 tenant.

·A CSV file must have been created that maps each Google Shared Drive ID to the target SharePoint Online site.

·The person performing the migration will need to know the relationship (user mapping) between each source Google Shared Drive account and their corresponding SharePoint Online account.

·Each user account must have a SharePoint license assigned to it in Office 365.

To migrate content of Google Shared Drives, perform the following:

1.On the Drives tab click "Copy Google Drive" and select, Copy Google Shared Drive to SharePoint Online.
Google Shared Drive to SPO
The Google Shared Drives to SharePoint Online wizard opens.

2.Enter a Project Name.
Google Shared Drive to SPO Project Name

3.Provide your Google Admin login, P12 Key File and Service Account in the Google connection parameters area. This information is gathered directly from your Google environment, so if you have not already, please refer to this section for the required steps.  Once the values are entered, click Connect.  If you receive any message other than "Successfully connected to Google Drive", double check the prerequisite steps and then entered values.  If you are still experiencing issues, please contact Support for assistance.
Copy Google to OneDrive1

4.Specify your tenant SharePoint Administration Center URL and then click Connect.  When prompted, enter your Administrator login and password. Click Connect. If you receive any message other than Successfully connected to SharePoint Admin, double check the URL and make sure you are supplying a Global Administrator login for this tenant.  If you are still experiencing issues, please contact Support for further assistance.
Copy Google to OneDrive2

5. Click the Load From CSV or Load from Google Drive buttonNote that Load from CSV will allow you to load users from a CSV file, which is the faster option as only the listed users are loaded.
Select the account(s) you wish to migrate.


NOTE: For a large number of Google Drives, it's recommended to load them using the Load from CSV option.
The CSV requires only 1 Google user per.

copy google shared drive to spo


NOTE: Currently, the Load and Apply Report option is not available for this operation.

6.Click Load from CSV and select the csv file containing Google Shared Drive to SharePoint Online mappings.  Click Check for sites to begin the validation process. This process will validate that the supplied site mapping is correct (Google Drive users and SharePoint Online sites were located).

Google Shared Drive to SPO Check Sites

7. Click Next.

8.If necessary, change content and file format conversion options as described below:
Content Options:
Google Shared Drive to SPO Content Options

·Copy Content - A flag to determine if content is or is not included with this operation.  When not included the remainder of the options will become disabled.

·Include Versions - The process in which Google revision history will be converted into SharePoint  versions.  Please note that this option is only referring to the major revisions (those shown as the "less detailed revisions") and not those that are automatically generated within Google Drives (those shown as the "more detailed" revisions). You can select whether you would like to:

oInclude All Versions

oInclude The Most Recent Versions - this option allows you to specify how many recent versions you would like to copy the content from.

·Incremental Copy - When enabled, the migration process will identify and migrate only that content which was created, modified or versioned within the defined interval (days, weeks or months). To perform a Delta migration, enter zero in the field and select days as the time period. Delta migration is designed to be used in scenarios where both the source and destination may be modified during the course of the migration.


NOTE: delta migration compares dates between source and destination to determine which content to include, so it will take more time to process than an incremental migration.

·Skip Files Greater Than - When enabled, this option will skip any source files that are greater than the value specified (in MB or GB). An entry will be added to the post-migration log indicating which file(s) were skipped due to this configuration.

·Copy Permissions - When this option is selected, Google shared permissions will be converted to SharePoint Online permissions.

Google Drive Shared Permission

SharePont Online Permission


Full Control

Content manager








·Migrate to Folder - When this option is enabled, you can create, or use an existing, root folder structure in the destination library where your source content will be migrated.  You will need to define the path, for example:
/My Source Content/2017
In the above example, the folder "My Source Content" and sub-folder "2017" will be created in the root library of your destination and all source content will be migrated to this folder location.

·Skipped Non-Owned Files - This addresses the possible scenario where content exists in the user's Google Drive "My Drive" area which is not owned by this user.  Skipping these objects will prevent duplicate content from being migrated into SharePoint Online.

·Include First Reference File Only - This option addresses the possible scenario where a user creates reference objects (links using Shift + Z in Google Drive) of a file in various locations throughout their Google Drive environment.  Skipping these additional references will prevent duplicate files from being migrated into the SharePooint Document library by migrating only the first reference found.  Please note that the "first" reference is defined by a list of parent folders returned from Google Drive and the first may not always be the same one on subsequent or incremental migrations.  Please also note this option is only applicable to files, all referenced folders will be copied.

·Include Orphaned Files - For the purpose of this option, an orphaned file is defined as a file that was created in a folder that was shared with this user and after the file was created, their permission to the shared folder was removed.  The file still exists in the user's Google Drive, however it does not reside in any visible folder path and can only be located using the Google Drive Search Bar.  When enabled, the migration will identify these orphaned files and migrate them to the mapped  Document library.  In this library, a new folder named "Orphaned Files" will be created which will contain all the migrated orphaned files.  The use of this option can decrease overall migration performance.

·Re-Map Users - Use this option to load your user mapping CSV file (Please see this section for instructions on how to create a CSV User Mapping file for Google Drive)

·Apply Filter - This feature allows the inclusion or exclusion of items by user defined criteria, such as date, size, file extension, file name, or file owner.


NOTE:  The Apply Filter functionality is only applied to selected containers (i.e. site, lists or folders). If you select specific content (documents or items) then those objects will be included with the operation regardless of the filter applied. If you want to selectively include content, please select the container that this content resides in and apply the filter or apply the filter against the container first, then select the remaining content.

For the File Extension and Exclude Folders parameters only, you can use "," to set more than 1 criteria. For example, use this format "png,docx,pptx" to include multiple file extensions.
"Size" filter should have a whole number without decimals. It  is recommended that users not use the operators "Equal" and "Not Equal" to avoid difficulties with accurate file size, if the file size is greater than 1 MB.
Use the "Save Filter" option to save filter settings to a file and load them in different wizards or the Profile Manager.
Save Filter

Format Conversion:
Copy Google to OneDrive8

This set of options allows you to determine how Google formatted content will be converted into Microsoft compatible content.

Advanced Options:

advanced options in drives wizard Google to SPO

Enable Azure Turbo Mode: When enabled, this option utilizes Microsoft's SharePoint Online Migration API to increase the migration performance and throughput. A recommendation for optimal use of this API is larger sets of data; the more content, the better the throughput. Please review the User Manual for additional information as well as recommended configuration as this process is a resource intensive operation.

Because this API uses Azure storage as a staging area for the migration, it requires that you provide an Azure storage location. The options are to either utilize Microsoft supplied storage or to provide your own Azure storage location. If you wish to use your own Azure account, you must provide both the Azure Account Name as well as the corresponding Acces Key. If you cannot supply this information, please search our online Knowledge Base, User Manual or contact Support for additional information before proceeding or consider using the Microsoft Supplied Storage option. For more information please see the Azure Turbo Mode section.


NOTE: this function is optional and is only used to increase the migration performance to SharePoint Online or OneDrive for Business in Office 365. It does not provide any additional functionality that is not available when this option is disabled.

·Microsoft Provided Storage: This option allows you to use Microsoft provided Azure storage instead of providing your own for the purpose of utilizing Azure Turbo Mode.

·User Provided Storage: This option allows you to provide your own Azure Storage instead of using one provided by Microsoft for the purpose of utilizing Azure Turbo Mode. It requires that you provide both your Azure Blob Storage Account Name as well as its corresponding Access Key by clicking the "Select" button to the right. If you cannot supply this information, please search our online Knowledge Base, User Manual or contact Support for additional information before proceeding.


NOTE: User Provided storage will give you access to Azure logs for a longer period of time than Microsoft provided storage. It will also allow you to perform the migration faster with less throttling.

Send Notification: When selected, this feature will send emails to the listed recipients once Migrations are completed. Enter a specific user email address. For two or more, separate each email address with a comma. Set up User Notifications here in order to use this feature. 

9. Click Finish to begin the migration process.

Please visit the following link to view the list of unsupported Google Drive objects.

Please visit the following link for an overview on how to script and schedule jobs.

Mapping Google Groups, Users, and Permissions to Office 365

This section provides instructions for mapping Google groups, users, and permissions when migrating to Office 365.

Google Group Mapping

When migrating from Google Drive to Office 365, it may be necessary to re-map your Google based groups into existing target groups.

This may be necessary when you have a group on your Google document that you want to translate into another group in your Office 365 environment. You can do so automatically using the Mapping Report wizard within Essentials, or manually with the following steps:

1.In your Google Drive, open the 'share' pane of the file that you want to map the group from.
As is shown in the image above, "" is the group. When migrating this into OneDrive for Business or SharePoint Online, it will become "EDI At".

2.Find the Group that you want to map this Google Drive group into. On this screen, copy the Account for the group that you want to map into.

3.Make a new entry in your User Mapping file for the Group.

As you can see, use the information from the Google side on the leftmost column and use the information from your SharePoint side on the rightmost column. When you use this mapping file, your group should map from Google Drive to an existing group in Office 365.


NOTE: When creating your mapping you can use full group names and domains (,groupname) or you can simply set it up using the group name without the domain (edi,groupname)

Google User Mapping

When migrating from Google Drive to Office 365, it may be necessary to re-map your Google based user accounts into their target user accounts.


NOTE: For Google Shared Drives, Essentials adds the Google Service account as a member and will migrate it as a user with permissions on the target. Therefore, permissions for this account should not be mapped.

A migration example that may not require user mapping:

Google User Account

Office 365 User Account

Both the username (user1) and domain ( are identical between Google and Office 365.  (If you are using a email to authenticate against Office 365, then you will need to map all users even if the usernames and domain are identical.)

A few migration examples that would require the use of a mapping file:

Google User Account

Office 365 User Account

The username (user1) is the same between Google and Office 365, however the domain has changed ( |

Both the username (user1 | and the domain ( | is different.

The domain is the same (, but the username has changed (user1 |

Based on the examples above, if your situation requires the use of a mapping file, please create it using the Mapping Reports wizard, or manually using the steps below.

1.Create a new blank worksheet in Excel.

2.In Column A, enter the list of Google User Accounts.

3.In Column B, enter the list of Office 365 User Accounts next to their respective Google Accounts.

4.When complete, save this to a CSV file.

If you are not using Excel, then please create this mapping in a text file and then change the file extension to CSV when complete.  The file format should look similar to this when viewed in a text editor:,,,,,

Click here to download an example user mapping file.

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação