Scoped view & mapping headers

G Suite to G Suite migration

Use the following headers when you're creating a CSV file for a scoped view or mapping for a G Suite to G Suite migration.

CSV file format

  • All headers and entries are case-sensitive.
  • When using a mapping CSV file, make sure that the column headers belonging to the source connection are prefixed with Source and the target connection column headers are prefixed with Target.
  • Make sure the character encoding of the CSV file is set to UTF-8. 

Example scoped view CSV file for G Suite:

Example mapping CSV file for G Suite:

In this example, the source domain is example.com. The target domain is solarmora.com.

CSV file headers

Header Use and examples

GCalendar

Must be preceded by a GUser column and value

To map a user’s secondary calendar, use the GCalendar header with the email address of the G Suite user and the secondary calendar’s ID. To find the calendar’s ID, go to Create and share a group calendar.

Example
GCalendar
5dr3m09gactu6swuprcct6d@group.calendar.google.com

GCalendarResource To map a calendar resource, use the GCalendarResource header with the calendar resource ID. Find the calendar resource ID by opening your calendar. Point to the calendar resourceand then""and thenSettings and sharing.

Example
GCalendarResource
example.com_37362173432@resource.calendar.google.com

GDrive

Must be preceded by a GUser column and value

To map data to a user’s My Drive or to a shared drive, use the GDrive header with one of the following strings:
  • GMyDrive
  • GSharedDrives

Example
GDrive
GMyDrive

GFolder

Must be preceded by a GUser column and value

To map data to a folder inside a user’s My Drive or shared drive, use the GFolder header with the folder’s ID. Find the ID value by navigating to the folder and inspecting the URL. For example, the URL https://drive.google.com/drive/u/0/folders/BDEz25J3DzFb has an ID value of BDEz25J3DzFb.

Example
GFolder
BDEz25J3DzFb

GGroup To map data to a group in Google Groups, use the GGroup header with the group’s email address.

Example
GGroup
group1@solarmora.com

GOrgUnit To map data to a specific organizational unit, use the GOrgUnit header and the path to the organizational unit.

Example
GOrgUnit
/Org_Unit/Sub_Org_Unit

GService

Must be preceded by a GUser column and value

To map data to a user’s G Suite service, use the GService header with one of the following strings:

  • GDrive
  • GCalendarService
  • GContactService
  • GMailService
  • GSitesService

Example
GService
GMailService

GSharedDrive

Must be preceded by a GUser column and value

To map data to a shared drive, use the GSharedDrive header with the shared drive’s ID. Find the ID value by navigating to the shared drive root folder and inspecting the URL. For example, the URL https://drive.google.com/drive/u/0/folders/BDEz25J3DzFb has an ID value of BDEz25J3DzFb.

Example
GSharedDrive
BDEz25J3DzFb

GUser To map data to a G Suite user, use the GUser header with the email address of the G Suite user.

Example
GUser
user1@solarmora.com

MapChildrenOnly

Must be preceded by a column with a folder value

To map the contents of the folder, but not the folder itself, use the MapChildrenOnly header with the (case-insensitive) string "true". To map the folder and its content, omit the column or use the (case-insensitive) string "false".

Example
MapChildrenOnly
true

Sub Path To map data to a folder that doesn't currently exist in your G Suite account, use the Sub Path header. Add the path and name of the new folder below. During a migration, G Suite Migrate creates the path and folder and migrates the data to the new folder.

Example
Sub Path
Folder1#Folder2

Related topics


Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.