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]/Files	Boomsync, Box, Dropbox Business, Egnyte, Google Workspace, OneDrive, pCloud, Sharefile, Sharepoint, Legacy Sharepoint, Amazon Workdocs
/teamdrive:<team drive name>	/teamdrive:My Team Drive/Files	Boomsync, Dropbox Business, Egnyte, Google Workspace, Huddle, Sharefile
/teamdriveid:<team drive ID>	/teamdriveid:0AI2ezk6QbPvvUk9PVA/Files	Google Workspace
/<drive letter>:/<path>	/D:/Company Data/Files	Windows/OSX Agent
/<uncpath>/<path>	/REMOTESERVER/Shared Data/Files	Windows/OSX Agent
/mailbox:<email_address>	/mailbox:[e-mail]/@MAIL/Inbox	Exchange, Office 365 Outlook, Google Workspace Gmail, IMAP
/sharepointsite:<site path>:<document library path>	/sharepointsite:/sites/Site1:/Docs	Sharepoint, OnPrem Sharepoint
/hub:<hub_name>	/hub:HubName/Files	BIM360
/project:<project_name>	/project:ProjectName/Files	BIM360
/bucket:<bucket_name>	/bucket:BucketName/Files	Amazon S3, S3 Compatible, BiFrost Cloud, Digital Ocean, Filebase, IDrive Cloud, Lyve Cloud, Wasabi
/publicfolders:<path>	/publicfolders:/Files	Exchange, Office 365 Outlook via EWS
No prefix	/Files	Backblaze B2, SFTP, Dropbox Personal, Google Cloud, Google Drive Personal, Azure Blob, Azure Files

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]