从 CSV 新建迁移(可选)Creating a new migration from a CSV (optional)

有时要导入上千个用户和一个复杂的目录架构。Sometimes you have thousands of users and a complicated directory schema that you want to import. 在这些情况下,最好在电子表格中规划迁移。In these cases, it's desirable to plan out your migration in a spreadsheet.

对于这些情况,我们相信 CSV 上传选项很有用。In these cases, we trust the CSV upload option is useful. 这样,你就可以对你的所有用户和目录进行布局,然后以 .csv 格式向我们提供此信息,以创建你的迁移。This lets you lay out all your users and directories, and then provide that information to us in .csv format for us to create your migration.

要迁移的用户Users to migrate

CSV 文件必须遵循以下格式:Your CSV file must follow this format:

源标题和目标标题,后跟路径,每行都有可选标记。A heading for the source and destination, followed by the paths, and optional tags on each line.

Source Path,Destination Path,Tags
user1@example.com,user__1@corp.example.com,"Pilot, IT"
user2@example.com,user__2@corp.example.com,"Pilot, Sales"
user3@example.com/src dir,user3@example.com/migrated,"Pilot, IT"
Source Shared Drive,user4@example.com/Team Folder,"Pilot, Sales"
https://TENANT02.sharepoint.com/sites/SiteName/Shared%20Documents,user5@example.com,"Marketing, Sales"

备注

确保 CSV 的每个逗号分隔值后均不包含空格。Ensure your CSV has no spaces after each comma separated value. 需要逗号的值必须用引号引起来。Values that require commas must be wrapped in quotation marks.

示例 CSV 文件格式:Sample CSV file format:

源路径Source Path 目标路径Destination Path 标记Tags
user01@domain.comuser01@domain.com user_01@domain.comuser_01@domain.com
团队文件夹Team Folder user_02@domain.comuser_02@domain.com
共享驱动器Shared Drive user_03@domain.comuser_03@domain.com
/C:/folder/C:/folder user_04@domain.comuser_04@domain.com
user01@domain.comuser01@domain.com https://TENANT01.sharepoint.com/sites/SiteName/Shared%20Documentshttps://TENANT01.sharepoint.com/sites/SiteName/Shared%20Documents
https://TENANT01.sharepoint.com/sites/SiteName/Shared%20Documentshttps://TENANT01.sharepoint.com/sites/SiteName/Shared%20Documents https://TENANT02.sharepoint.com/sites/SiteName/Shared%20Documentshttps://TENANT02.sharepoint.com/sites/SiteName/Shared%20Documents

备注

将 URL 映射到 SharePoint 时,必须删除/Shared 文档后的所有内容;否则,URL 将失败。When URL mapping to SharePoint, you must remove everything after /Shared Documents; otherwise,the URL fails.

例如,此完整 URL 无效: https://TENANT01.sharepoint.com/sites/SiteName/Shared Documents/Forms/AllItems.aspxFor example, this full URL won't work: https://TENANT01.sharepoint.com/sites/SiteName/Shared Documents/Forms/AllItems.aspx

将其更改为:https://TENANT01.sharepoint.com/sites/SiteName/Shared DocumentsChange it to: https://TENANT01.sharepoint.com/sites/SiteName/Shared Documents

在 Excel 中创建 CSVCreating your CSV in Excel

使用 Excel 电子表格创建 CSV:To use an Excel spreadsheet to create your CSV:

  1. 确保有两列,一个标题为 Source Path,一个标题为 Destination PathEnsure you have two columns, one titled Source Path, and one Destination Path.

  2. 在随后的行中列出相对路径、域和用户名。List the relative paths, domains, and usernames on the subsequent rows.

  3. 将电子表格导出为 CSV:Export your spreadsheet as a CSV:

    1. 选择“文件”。Select File.
    2. 选择“另存为”。Select Save As.
    3. 从“文件格式”选项中,选择“CSV”。From the File Format options, select CSV.