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:[email protected],/user:[email protected]
/sharepointsite:/sites/Accounting:/Documents,/teamdrive:Accounting

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

Prefix Format	Example	Supported Store Types
/user:<username or email>	/user:[email protected]	Boomsync, Box, Dropbox Business, Egnyte, Google Workspace, OneDrive, pCloud, Sharefile, Sharepoint, Legacy Sharepoint, Amazon Workdocs
/teamdrive:<team drive name>	/teamdrive:My Team Drive	Boomsync, Dropbox Business, Egnyte, Google Workspace, Huddle, Sharefile
/teamdriveid:<team drive ID>	/teamdriveid:0AI2ezk6QbPvvUk9PVA	Google Workspace
/<drive letter>:/<path>	/D:/	Windows/OSX Agent
/<uncpath>/<path>	/REMOTESERVER/Shared Data	Windows/OSX Agent
/mailbox:<email_address>	/mailbox:[email protected]	Exchange, Office 365 Outlook, Google Workspace Gmail, IMAP
/sharepointsite:<site path>:<document library path>	/sharepointsite:/sites/Site1:/Documents	Sharepoint, OnPrem Sharepoint
/hub:<hub_name>	/hub:HubName	BIM360
/project:<project_name>	/project:ProjectName	BIM360
/bucket:<bucket_name>	/bucket:BucketName	Amazon S3, S3 Compatible, BiFrost Cloud, Digital Ocean, Filebase, IDrive Cloud, Lyve Cloud, Wasabi
/publicfolders:<path>	/publicfolders:All Public Folders	Exchange, Office 365 Outlook via EWS
No prefix	/Files	Backblaze B2, SFTP, Dropbox Personal, Google Cloud, Google Drive Personal, Azure Blob, Azure Files

Mapping Subfolders

You can select a specific subfolder to be transferred by specifying the folder path after the prefix.

Examples:

• /user:[email protected]/Interview Videos/2024

• /teamdrive:Finance/Reports/2024/Q4

• /sharepointsite:/sites/HR:/Documents/2024/Review Process

Additional Mapping Options

Setting	Behaviour
Migrate folder contents (Don't retain root folder)	Enabled: Only the contents of each specified source folder are migrated - the folder itself is not created in the destination. Disabled: The specified source folder is retained, and a matching subfolder is created in the destination.
Ignore checks on import	Skip validation of CSV source/destination paths (e.g. prefix formatting). Contact support before enabling.

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:[email protected],[email protected]:P@ssw0rd1,/mailbox:michael@newdomain
/mailbox:[email protected],[email protected]:P@ssw0rd2,/mailbox:[email protected]

For help with CSV mappings, get in touch with support via [email protected]