SharePointTechnicalSupport

SharePoint Technical Support Blog in SharePoint Online | office 365 | azure

  • Home
  • Home
  • Solutions
    • SharePoint Server
      • SharePoint 2010
      • SharePoint 2013
      • SharePoint 2016
      • SharePoint Online
      • CU Patch Update
    • Project Server
      • Project Server 2010
      • Project Server 2013
      • Project Server 2016
      • Project Server Online
      • CU Patch Update
        • PWA2016
          • DECEMBER
        • PWA2013
      • News Project Server
    • Workflow
      • Nintex
      • SharePoint Designer
    • PowerShell
    • Windows Server
      • IIS
      • DNS
      • Active Directory
      • Windows Server 2016 Networking
    • Cloud
      • Azure
      • Office 365
  • Download
    • SharePoint Tools
    • Patch Update
      • SharePoint Patch
      • Project Server Patch
        • PWA2016
          • December
      • Office Patch
    • White Papers
    • Webinar
    • Presentation
      • SharePoint 2013 PPT
    • Video
  • MSDN Links
    • SharePoint
      • Gallery
      • Wiki
      • Forum
    • Microsoft Tech Community
    • Microsoft Docs
    • Microsoft Learn
    • Roadmap
    • Azure Update
    • SharePoint Fest
    • IIS
    • ProjectServer
      • Forum
    • Powershell Gallery
      • Powershell Forum
    • Microsoft Partner
    • sharepoint best practices
  • Contact Me

Home › Metadata › managed metadata taxonomy

managed metadata taxonomy

By Deviprasad Panda on 19/05/2015

One of the most talked about capabilities since the launch of SharePoint 2010 is the Managed Metadata Service.  For those of you who aren’t already familiar with this service and the support it provides for modelling and deploying a rich corporate taxonomy.   For those who need get to the basics, configuration & related features for it, we would recommend going thru the links available at “Managed Metadata and Taxonomy in SharePoint Server 2010”

We would use this blog post  to bring about some additional information on situations which you might face in day to day work .

The Taxonomy Field is lookup field.

The taxonomy field is a lookup field. The lookup list associated with this field is called the Taxonomy Hidden List. This list is located at http://siteURL/lists/taxonomyhiddenlist. It exists only on the root web of the site collection, and is used as lookup by all the site/list taxonomy fields within that site collection.

Every time a term is used for tagging an item, an entry is made for that term in the Taxonomy Hidden List. The entry will differ depending upon whether the term was used in a Managed Term field/ Enterprise Keywords field.   Here is a blog which talks  about this in more details   Dissecting the SharePoint 2010 Taxonomy fields

Users  can’t see the  values of the  Managed Metadata Columns  for list items

Users can browse to the site & see list items etc.  but they are not able to see values in a metadata column on a SharePoint list. The only users who can view the item are Site Collection Administrator and any user who was given permissions from policy for Web Applications.   This occurs because of missing permissions  on “TaxononyHiddenList”  for the site collection .   By default the “TaxonomyHiddenList”  has unique permissions assigned as below  for a Classic Mode Web-Application .

permission inherit

permission inherit

 

Read Permissions should exist for the following principals based on the Classic Claims  mode of the Web-application

NT AUTHORITYAuthenticated Users Read Classic  Web-Application
All Authenticated Users Read Claims Web-Application

Site Collection Import /Export  OR  Backup /Restore  OR Content Deployment Scenarios across Farms

Use of Termsets & Managed Metadata columns has found increased usage in Lists either directly or via a content types which provides a  Metadata column . Once a user adds a Tag to the list item the list Column is updated with Value of the TAG along with the TermID for the Taxonomy Tag.

Explained as below we see List  Metadata Columns Test11 & Test 12 & Terms in use as seen from List Items & Taxonomy Hidden list . Notice how we store this column values in SQL for List “DocLibSC2” .  The format used is TermName|IDForTerm .

metadata

metadata

 

NOTE: It is not recommended to execute SQL queries against the SharePoint databases.

Now if we Export /Import or Backup /Restore  or Do Content deployment across farms , we are  able to get the list Items Along with the Values of  Tags in Metadata columns ( due to fact that we carry the  contents of TaxonomyHiddenList along ) but they would not resolve or Match up to a Term in Termstore published by managed Metadata service on Destination farm . Even If we have the Termset/Terms  with same name created on the Target Farm  the ID’s won’t match . This would lead to  the Metadata column values being Greyed out (un-editable ) & other inconsistencies .

These are the Scenarios  where you would want to move contents from One Environment to another to ensure Term sets/Terms are also available  to target environment .  Two ways to make thing work in these scenarios are

a. Publish the Managed Metadata service Application on the Source farm or any other Services farm & ensure that both Source & Target farms consume the Managed Metadata from this same location. Please refer to articles below to Publish  & Consume  Managed Metadata services

Share service applications across farms (SharePoint Server 2010)
How to publish a Managed Metadata Service for cross-farm consumption

b.  You can use Export-SPMetadataWebServicePartitionData to export term store from source application & import the same in target MMS using Import-SPMetadataWebServicePartitionData . By using this technique the term store is available on the Target Farm. The tsid GUID does not change.  So if you have created a Managed Metadata Service and Import /Export to another farm, it will stay consistent.

matadata url

matadata url

 

Here is a sample  Cmdlet as the name is somewhat  misleading

#Export

$mms1 = “4a867ce5-d9ee-4051-8e73-c5eca4158bcd” –This sets the exporting MMS ID which can be obtained from Get-SpServiceApplication

$mms1proxy = Get-SPServiceApplicationProxy | ?{$_.TypeName -eq “Managed Metadata Service Connection”} — Assuming there is one Proxy , If you have  more , get the correct one based on ID

Export-SPMetadataWebServicePartitionData -Identity $mms1 -ServiceProxy $mms1proxy -Path \locationexportfile.bak

#Import

$mms2 = “d045d3ce-e947-4465-b039-0dfbbe24fb22”  –This sets the importing MMS ID

$mms2proxy = Get-SPServiceApplicationProxy | ?{$_.TypeName -eq “Managed Metadata Service Connection”} — Assuming there is one Proxy , If you have  more , get the correct one based on ID

Import-SPMetadataWebServicePartitionData -Identity $mms2 -ServiceProxy $mms2proxy -path \locationexportfile.bak-OverwriteExisting

Note : With the OverwriteExisting switch it maintains the name space.   Also if there were terms in the destinations that are not in the import file, then it removes them.  In other words, the only items in the term store will be the ones you import in.  Nothing more and nothing less.

Note: The Path Specified in Import-SpMetadataWebServicePartitionData has to a location on Shared Location on the SQL server of the farm  & ensure SQL  & Sharepoint Service accounts have required access . Refer to  Post Here for more details

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Pinterest (Opens in new window)

Related


‹ Improving SharePoint performance using SQL Server settings
storage related performance issues sharepoint ›

Categories: Metadata, sharepoint2010

Tags: ManagedMetadata, matadata-taxonomy, Metadata, sharepoint2010, taxonomy

My Book

  • 1 Deviprasad Panda

Follow Me

  • YouTube
  • LinkedIn
  • Facebook
  • Twitter

Category Cloud

administration Authentication Cache content databases Default Health IIS InstallationConfiguration Migration Monitoring Performance Permission powershell powershell command powershell script Search Service Application sharepoint2010 SharePoint 2013 SharePoint 2016 SharePoint 2019 sharepoint server SharePointTools Site site collection Template web application WebPart WebService

Top Posts & Pages

  • change maximum upload file size limit in sharepoint
    change maximum upload file size limit in sharepoint
  • SharePoint 2019 – TCP/IP Ports
    SharePoint 2019 – TCP/IP Ports
  • sharepoint service instance start stop stuck
    sharepoint service instance start stop stuck
  • create add a content database in sharepoint 2019
    create add a content database in sharepoint 2019
  • Backup restore site collection sharepoint
    Backup restore site collection sharepoint
  • export import list library sites in sharepoint
    export import list library sites in sharepoint
  • Managed path in sharepoint web application
    Managed path in sharepoint web application
  • Dismount Mount content database in sharepoint 2019 using powershell
    Dismount Mount content database in sharepoint 2019 using powershell

Follow Blog via Email

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 775 other subscribers

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Contact Me

Bengaluru, India
support@spmcse.com
Everyday : 8 AM - 12 AM IST