SharePoint Online：使用 PowerShell 将术语集导出为 CSV

要求：必须在 SharePoint Online 中将术语集中的所有术语提取为 CSV 格式。

遗憾的是，无法从 Web 浏览器 UI 导出 SharePoint Online 导出术语集。但 PowerShell 可以提供帮助！

SharePoint Online PowerShell 导出术语集

您可能为开发、测试和其他目的设置了一些不同的 SharePoint Online 环境。您可能希望在每个环境中使用相同的术语集。如果有一种简单的方法可以从一个域导出术语集定义并将其导入另一个域，那不是很好吗？嗯，有！本博客文章将向您展示如何使用 PnP PowerShell 在 SharePoint Online 中导出术语集。

以下是用于从 SharePoint Online 术语库中的给定术语集中导出所有术语的 PowerShell：

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Taxonomy.dll"
  
#Variables for Processing
$AdminURL = "https://crescent-admin.sharepoint.com/"
$TermGroupName = "Regions"
$TermSetName = "East Africa"
$CSVFile="C:\Temp\TermSetData.csv"

Try {
    #Get Credentials to connect
    $Cred = Get-Credential
    $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

    #Setup the context
    $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($AdminURL)
    $Ctx.Credentials = $Credentials

    #Get the term store
    $TaxonomySession=[Microsoft.SharePoint.Client.Taxonomy.TaxonomySession]::GetTaxonomySession($Ctx) 
    $TermStore =$TaxonomySession.GetDefaultSiteCollectionTermStore()
    $Ctx.Load($TaxonomySession)
    $Ctx.Load($TermStore)
    $Ctx.ExecuteQuery()

    #Get the Term Group
    $TermGroup=$TermStore.Groups.GetByName($TermGroupName)

    #Get the term set
    $TermSet = $TermGroup.TermSets.GetByName($TermSetName)

    #Get all tersm from the term set
    $Terms = $TermSet.Terms
    $Ctx.Load($Terms)
    $Ctx.ExecuteQuery()

    Write-Output $TermsetName > $CSVFile
    #Export Terms to CSV
    Foreach($Term in $Terms)
    {
        Write-Output $Term.Name >> $CSVFile
    }     
    Write-host "Term Set Data Exported Successfully!" -ForegroundColor Green
}
Catch {
    write-host -f Red "Error Exporting Term Set!" $_.Exception.Message
} 

此脚本将给定术语集中的每个术语提取到 CSV 文件中。可是等等！每个术语最多可以达到 7 级深度！虽然上面的脚本在单个级别导出术语，但这是另一个 PowerShell 脚本，用于导出给定术语集所有级别的术语和子术语。

使用 PowerShell 在 SharePoint Online 中导出术语集：

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ISAPI\Microsoft.SharePoint.Client.Taxonomy.dll"
  
#Variables for Processing
$AdminURL = "https://crescent-admin.sharepoint.com/"
$TermGroupName = "Sectors"
$TermSetName = "Political Geography"
$CSVFile="C:\Temp\TermSet.csv"

#Custom Function get child terms of a given term
Function Get-Terms([Microsoft.SharePoint.Client.Taxonomy.Term] $Term,[String]$ParentTerm,[int] $Level)
{
  $ChildTerms = $Term.Terms
  $Ctx.Load($ChildTerms)
  $Ctx.ExecuteQuery()
  if($ParentTerm)
  {
    $ParentTerm = $ParentTerm + "," + $Term.Name
  }
  else
  {
    $ParentTerm = $Term.Name
  }

  Foreach ($SubTerm in $ChildTerms)
  {
     $Level = $Level + 1
     #Terms may have upto 7 levels
     $NumofCommas =  7 - $Level
     $commas =[string]::Empty
     
     #Append Commas
     For ($j=0; $j -lt $NumofCommas; $j++)  
     {
        $Commas = $Commas + ","
     }
    
    #Append the Output to CSV File
    "," + "," + "," + $Term.IsAvailableForTagging + ",""$($Term.Description)""," + $ParentTerm + "," + $SubTerm.Name + $Commas >> $CSVFile
    
    #Call the function recursively
    Get-Terms -Term $SubTerm -ParentTerm $ParentTerm -Level $Level
  }
}
Try {
    #Get Credentials to connect
    $Cred = Get-Credential
    $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

    #Setup the context
    $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($AdminURL)
    $Ctx.Credentials = $Credentials

    #Get the term store
    $TaxonomySession=[Microsoft.SharePoint.Client.Taxonomy.TaxonomySession]::GetTaxonomySession($Ctx) 
    $TermStore =$TaxonomySession.GetDefaultSiteCollectionTermStore()
    $Ctx.Load($TaxonomySession)
    $Ctx.Load($TermStore)
    $Ctx.ExecuteQuery()

    #Write Termset CSV Header (As in the standard format)
    "Term Set Name,Term Set Description,LCID,Available for Tagging,Term Description,Level 1 Term,Level 2 Term,Level 3 Term,Level 4 Term,Level 5 Term,Level 6 Term,Level 7 Term" > $CSVFile

    #Get the Term Group
    $TermGroup=$TermStore.Groups.GetByName($TermGroupName)

    #Get the term set
    $TermSet = $TermGroup.TermSets.GetByName($TermSetName)
    $Ctx.Load($Termset)
    $Ctx.ExecuteQuery()

    #Get all tersm from the term set
    $Terms = $TermSet.Terms
    $Ctx.Load($Terms)
    $Ctx.ExecuteQuery()

    #Write 2nd line as Termset properties(As per standard format)
    $TermSet.Name + ",""$($TermSet.Description)""," + $TermStore.DefaultLanguage + "," + $TermSet.IsAvailableForTagging + ",""$($Terms[0].Description)""," + $Terms[0].Name + "," + "," + "," + "," + "," + "," >> $CSVFile
    
    #Process each Term in the termset
    Foreach($Term in $Terms)  
    {
        write-host $Term.Name
        Get-Terms $Term -Level 1 -ParentTerm ""
    }     
    Write-host "Term Set Data Exported Successfully!" -ForegroundColor Green
}
Catch {
    write-host -f Red "Error Exporting Term Set!" $_.Exception.Message
}

SharePoint Online：使用 PnP PowerShell 导出术语集

使用 Export-PnPTaxonomy cmdlet 导出 SharePoint Online 中的术语集：

#Config Variables
$AdminCenterURL = "https://Crescent-admin.sharepoint.com"
$TermSetId="286f9c03-193d-4f23-9863-c1b7ccd2c451"
$FilePath="C:\Temp\TermsetData.txt"

#Connect to PnP Online
Connect-PnPOnline -Url $AdminCenterURL -Credentials (Get-Credential)

#Export Term set
Export-PnPTaxonomy -TermSetId $TermsetID -Path $FilePath

此 PowerShell 还可以导出多重身份验证 SharePoint Online 网站中的术语集。我的任期：

和结果：