Import CSV Mappings

The easiest way to add mappings to a project at scale is via a CSV file. CSV mappings are added to a project as individual transfers/move jobs and you can then treat them like any other mappings.

Uploading a CSV file

Within your project, click + Add Transfer. Select Import Transfers from CSV.

CSV Formatting

When executing a file migration, the CSV uses a simple source, destination format.

source,destination
/user:[e-mail]/Files,/user:[e-mail]/Files
/sharepointsite:/sites/Accounting:/Documents,/teamdrive:Accounting

CSV prefixes can target special objects like users, drives, on-premises agents, or mailboxes.

/user:<username or email>	/user:[e-mail]
/teamdrive:<team drive name>	/teamdrive:My Team Drive
/teamdriveid:<team drive ID>	/teamdriveid:0AI2ezk6QbPvvUk9PVA
/hostname:<agent>	/hostname:DFS8/c:/Users
/hostname:<agent>/<uncpath>/path	/hostname:DFS8/REMOTESERVER/Shared
/mailbox:<email_address>	/mailbox:[e-mail]
/sharepoint:<drive id>	/sharepoint:!bssfsf32fs455533333
/sharepointsite:<document library path>	/sharepointsite:/sites/Site1:/Docs
/sharepointurl:<document library url>	/sharepointurl:cd.sharepoint.com/sites/Site1:/Docs

CSV Formatting - IMAP Credentials

When moving to/from an IMAP server, you can provide credentials for each user directly in the CSV file by specifying a "source_secret" and/or "destination_secret" column.

The format for these columns are shown below.

Example (IMAP source):

source,source_secret,destination
/mailbox:[e-mail],[e-mail]:P@ssw0rd1,/mailbox:michael@newdomain
/mailbox:[e-mail],[e-mail]:P@ssw0rd2,/mailbox:[e-mail]

For help with CSV mappings, get in touch with support via [e-mail]