So, please ensure you have followed all below mentioned steps one-by-one to properly upload large term sets presents in comma separated value (.csv) file in to the SharePoint Central Administration. However, a small mistake can mess everything up.<\/p>\n
Presents below are two ways of uploading the large .csv file into the Central Administration.<\/p>\n
By using power shell script<\/span><\/span><\/h6>\n[code lang=”c”]<\/p>\n
$ver = $host | select version<\/p>\n
if($Ver.version.major -gt 1) {$Host.Runspace.ThreadOptions = “ReuseThread”}<\/p>\n
if(!(Get-PSSnapin Microsoft.SharePoint.PowerShell -ea 0))<\/p>\n
{<\/p>\n
Write-Progress -Activity “Loading Modules” -Status “Loading Microsoft.SharePoint.PowerShell”<\/p>\n
Add-PSSnapin Microsoft.SharePoint.PowerShell<\/p>\n
}<\/p>\n
$siteUrl=Read-Host “SiteUrl”<\/p>\n
$filepath=Read-Host “File Path”<\/p>\n
$usedForNavigation=$false<\/p>\n
$groupName=Read-Host “Group Name”<\/p>\n
$termsetname=Read-Host “Term Set Name”<\/p>\n
##Site URL<\/p>\n
$site = Get-SPSite $siteUrl<\/p>\n
##CSV file<\/p>\n
$file = get-item $filepath<\/p>\n
$filename = $file.FullName<\/p>\n
$session = Get-SPTaxonomySession -Site $site.Url<\/p>\n
write-host $site.Url<\/p>\n
$store = $session.DefaultKeywordsTermStore<\/p>\n
#### Checking the Group name, if not present and getting the Site collection group<\/p>\n
if($groupName -eq “”){<\/p>\n
$group = $store.GetSiteCollectionGroup($site)<\/p>\n
}<\/p>\n
else{<\/p>\n
$group = $store.Groups[$groupName]<\/p>\n
}<\/p>\n
if ($group -eq $null)<\/p>\n
{<\/p>\n
write-host “Group not found” -ForegroundColor Red<\/p>\n
return<\/p>\n
}<\/p>\n
##Getting the Termset<\/p>\n
$termset = $group.TermSets[$termsetname]<\/p>\n
if ($termset -eq $null)<\/p>\n
{<\/p>\n
##Getting Import manager for the Term Store<\/p>\n
$manager = $store.GetImportmanager()<\/p>\n
$reader = new-object System.IO.StreamReader($filename)<\/p>\n
$alltermsadded = $false<\/p>\n
$errormessage = “”<\/p>\n
write-host “Importing $filename”<\/p>\n
$manager.ImportTermSet($group, $reader, [ref] $alltermsadded, [ref] $errormessage)<\/p>\n
$reader.Dispose()<\/p>\n
$termset = $group.TermSets[$termsetname]<\/p>\n
##Checking if Site Navigation is enabled for the Term store<\/p>\n
##One can add more custiom properties below depending upon the need<\/p>\n
if ($usedForNavigation -eq $true)<\/p>\n
{<\/p>\n
$termset.SetCustomProperty(“_Sys_Nav_IsNavigationTermSet”, “True”)<\/p>\n
$termset.SetCustomProperty(“_Sys_Nav_AttachedWeb_SiteId”, $site.ID.ToString())<\/p>\n
$termset.SetCustomProperty(“_Sys_Nav_AttachedWeb_WebId”, $site.RootWeb.ID.ToString())<\/p>\n
$termset.SetCustomProperty(“_Sys_Nav_AttachedWeb_OriginalUrl”, $site.RootWeb.Url)<\/p>\n
}<\/p>\n
if ([string]::IsNullOrEmpty($errormessage) -eq $false)<\/p>\n
{<\/p>\n
write-host $errormessage<\/p>\n
}<\/p>\n
}<\/p>\n
$store.CommitAll()<\/p>\n
$site.Dispose()<\/p>\n
sleep 20<\/p>\n
[\/code]<\/p>\n
By using Import functionality of Managed metadata service present in Central Administration<\/span><\/h6>\n1. Go to the Central Admin<\/p>\n
2. Under \u201cService Applications\u201d, click \u201cManage Service Applications\u201d<\/p>\n
![\"SoftreeConsulting\"](\"https:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/Untitled1.png\")
<\/a><\/p>\n3. Select \u201cManaged Metadata Service\u201d, then click on \u201cManage\u201d from ribbon<\/p>\n
![\"SoftreeConsulting\"](\"https:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/Untitled2.png\")
<\/a><\/p>\n4. Now, you can download a sample template of managed metadata structure by clicking on \u201cView a sample import file\u201d<\/p>\n
![\"SoftreeConsulting\"](\"https:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/Untitled3.png\")
<\/a><\/p>\n5. Please add all your term details in this comma separated value (.csv) file.<\/p>\n
![\"SoftreeConsulting\"](\"https:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/dsfas.jpg\")
<\/a><\/p>\n6. Once the (.csv) file is ready, then again go to the Managed metadata page (as it step 4)<\/p>\n
7. Click on \u201cNew Group\u201d from the context menu of \u201cManaged Metadata\u201d<\/p>\n
![\"SoftreeConsulting\"](\"https:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/Untitled4.png\")
<\/a><\/p>\n8. Please provide a group name (here I have provided as \u201cOrganisation\u201d)<\/p>\n
![\"SoftreeConsulting\"](\"https:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/Untitled5.png\")
<\/a><\/p>\n9. Now click on \u201cImport Term Set\u201d and browse the file to import back to SharePoint. Now click on \u201cOk\u201d button after browsing the .csv file.<\/p>\n
![\"Untitled6\"](\"https:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/Untitled6.png\")
<\/a><\/p>\n10. Please wait while it is uploading the terms, once complete you can find all your term sets under the group \u201cOrganisation\u201d.<\/p>\n
1. Go to the Central Admin<\/p>\n
2. Under \u201cService Applications\u201d, click \u201cManage Service Applications\u201d<\/p>\n
3. Select \u201cManaged Metadata Service\u201d, then click on \u201cManage\u201d from ribbon<\/p>\n 4. Now, you can download a sample template of managed metadata structure by clicking on \u201cView a sample import file\u201d<\/p>\n 5. Please add all your term details in this comma separated value (.csv) file.<\/p>\n 6. Once the (.csv) file is ready, then again go to the Managed metadata page (as it step 4)<\/p>\n 7. Click on \u201cNew Group\u201d from the context menu of \u201cManaged Metadata\u201d<\/p>\n 8. Please provide a group name (here I have provided as \u201cOrganisation\u201d)<\/p>\n 9. Now click on \u201cImport Term Set\u201d and browse the file to import back to SharePoint. Now click on \u201cOk\u201d button after browsing the .csv file.<\/p>\n 10. Please wait while it is uploading the terms, once complete you can find all your term sets under the group \u201cOrganisation\u201d.<\/p>\n![\"SoftreeConsulting\"](\"http:\/\/blog.softreeconsulting.com\/wp-content\/uploads\/2016\/08\/Untitled1.png\")
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n