Creating Groups, Terms and Termsets using Powershell Script. HashTable is used to create multiple Terms and TermSets at a time. Purpose of this article is the usage of HashTable and Powershell script at multiple levels of Managed MetadatService to create Termsets and Terms.
Introduction
Term Store Management. Create Groups, TermSets and Terms using powershell Script. Hash table to create multiple Terms and Termsets at a time in Managed Metadata Service. This is to create multiple Terms at multiple levels in Term Store Management of Sharepoint.
Note : Should have administrative rights to run the code.
Objective
This is an article to create TermSets at multiple levels to a
Group using PowerShell Script and Hash Table.
Using the code
Step 1 :
Create Groups on the Managed
Metadata Service :
Example: GroupName
Step 2 :
Create TermSet under ‘GroupName‘
using PowerShell script is as follows:
A. Create a .ps file giving the site URL and save it. Ex:
PS1.ps.
|
param(
[string] $termSetName = $(Read-Host -prompt "Specify
the Term Set name :") )
$snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'}
if ($snapin -eq $null)
{
Add-PSSnapin Microsoft.Sharepoint.PowerShell
}
$taxonomySession =
Get-SPTaxonomySession -Site 'http://siteurl'
$termStore = $taxonomySession.TermStores["Managed
Metadata Service"]
$group = $termStore.Groups["GroupName"]
$termSet = $group.TermSets | Where-Object { $_.Name -eq $termSetName }
if($termSet -eq $null) {
$termSet = $group.CreateTermSet($termSetName)
}
$termStore.CommitAll()
Write-Host "Created
Successfully" $termSetName "TermSet"
|
B.
Open the Windows PowerShell
window as Administrator and execute it.
Give the name of the TermSet as
TermSet1 or any name as per the choice.
TermSet1, TermSet2 are created as
below in the Term Store Management:
Step 3 :
Create Terms under TermSets using
a HashTable :
a) Create
a .ps file specifying in which Group and TermSet you wanted to add Terms and
save it as a .ps file. Ex: PS2.ps
|
[string] $termSetName = $(Read-Host -prompt "Specify
the Term Set name :")
[string] $TextfilePath = $(Read-Host -prompt "Specify
the Terms file path (.txt) :")
$hash=Get-Content -Path $TextfilePath |
ConvertFrom-StringData
$hash
for($i = -1; $i -lt (($hash.Count)-1); $i++)
{
write-host $i
write-host $hash[$i].values
$snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'}
if ($snapin -eq $null)
{
Add-PSSnapin Microsoft.Sharepoint.PowerShell
}
$taxonomySession =
Get-SPTaxonomySession -site 'http://siteurl'
$termStore = $taxonomySession.TermStores["Managed
Metadata Service"]
write-host "Connection
made with term store -"$termStore.Name
#Connect to the Group and Term Set
$termStoreGroup = $termStore.Groups["GroupName"]
$termSet = $termStoreGroup.TermSets["$termSetName"]
#Create term, term description, and a
synonym
$term = $termSet.CreateTerm($hash[$i].values, 1033)
write-host "Term
Created -"$term.Name
#Update the Term Store
$termStore.CommitAll()
}
|
b) Create
a hash table with all the Term values and save it as .txt file. Ex : TermLevel1.txt
|
TermSet1=India
TermSet2=Australia
TermSet3=Brazil
TermSet4=China
|
c) Open
the Window PowerShell Administrator window and execute it.
Terms under Termset1 using
Hash Table are created as below :
Step 4 :
This is the step
to create Terms under Terms which is a useful one to create multiple levels of
Terms using Hash Table.
a) Create
a .ps file specifying in which Group, TermSet and the SubTermSet name you
wanted to add Terms and save it as a .ps file. Ex: PS3.ps
|
[string] $TextfilePath = $(Read-Host -prompt "Specify
the Terms file path (.txt) :")
$hash=Get-Content -Path $TextfilePath |
ConvertFrom-StringData
$hash
for($i = -1; $i -lt (($hash.Count)-1); $i++)
{
$snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'}
if ($snapin -eq $null)
{
Add-PSSnapin Microsoft.Sharepoint.PowerShell
}
$taxonomySession =
Get-SPTaxonomySession -site 'http://siteurl'
$termStore = $taxonomySession.TermStores["Managed
Metadata Service"]
write-host "Connection
made with term store -"$termStore.Name
#Connect to
the Group and Term Set
$termStoreGroup = $termStore.Groups["GroupName"]
$termSet1 = $termStoreGroup.TermSets["TermSet1"]
$termSet2 = $termSet1.Terms["India"]
#Create term,
term description, and a synonym
$term = $termSet2.CreateTerm($hash[$i].values,1033)
#Update the
Term Store
$termStore.CommitAll()
}
|
b) Create
a hash table with all the Term values and save it as .txt file. Ex : TermLevel2.txt
|
TermSet1=Gujarat
TermSet2=Kerala
TermSet3=Tamilnadu
TermSet4=Haryana
|
c) Open
the Window PowerShell Administrator window and execute it.
The whole hierarchy of the
Groups, Terms and TermSets created looks like this:
Conclusion
This completes creating
Terms at Second level. This can be extended to any level of creating Terms.
Reference
http:// www.c-sharpcorner .com/UploadFile/anavijai/5815/
http://pacsharepoint .com/2010/06/create-new-term-in-managed-metadata.htmlhttp://pacsharepoint.com/2010/06/create-new-term-in-managed-metadata.html