Microsoft's PowerShell script of the week is a script to help admins manage SharePoint managed metadata terms. Check it out Manage Managed Metadata Terms in Microsoft SharePoint Server 2010

This script can manage managed metadata terms in Microsoft SharePoint Server 2010. You can use this script to get terms, add terms or remove terms.
In a real world, a lot of people ask the possibility of managing managed metadata terms by using Windows PowerShell. Since administrators need to manage lot of terms, they really need to find a script to reduce their workload.
This script contains the following advanced functions: Get-OSCSPTaxonomyTerm Add-OSCSPTaxonomyTerm Remove-OSCSPTaxonomyTerm

If you just want to export a term set and you are on Office 365 check out my post: Export and Import a Term Set on Office 365 with no code!

Inevitable product plug… If you use SharePoint Managed Metadata why not give SPTermCloud a spin…

Continue Reading

Email this · Tweet this · Share on Google+ · Share on Facebook · Post to del.icio.us · Subscribe to this feed

Last year when demoing SharePoint managed metadata features I prepared a demo that could be easily be added to existing sites (including Office 365). I've recently used the same configuration for SharePoint 2013 investigations and demos so thought I'd share both the data and the process of preparing the demo in a short series of posts...

1. Collecting data for term sets and list items
2. Creating and loading term sets
3. Preparing list items with managed terms
4. Loading the list items into SharePoint

The demo is online here.

Through the previous posts we have collected source data from the UK Government Art Collection, created and loaded term sets and prepared some SharePoint list item XML with managed term IDs. Finally we need to load the works of art into our team site by:

1. Creating a SharePoint list with the correct metadata columns,
2. Loading the individual works of art as list items and
3. Adding the required SharePoint Managed Metadata list event receivers.

It would be good to be able to do this via the browser but I haven't found a way out of the box to bulk add list items with managed metadata columns (feel free to add a comment ...

Continue Reading

Email this · Tweet this · Share on Google+ · Share on Facebook · Post to del.icio.us · Subscribe to this feed

Last year when demoing SharePoint managed metadata features I prepared a demo that could be easily be added to existing sites (including Office 365). I've recently used the same configuration for SharePoint 2013 investigations and demos so thought I'd share both the data and the process of preparing the demo in a short series of posts...

1. Collecting data for term sets and list items
2. Creating and loading term sets
3. Preparing list items with managed terms
4. Loading the list items into SharePoint

The demo is online here.

In this article i'll walk through transforming our UK Government Art Collection works of art source data into SharePoint list items with assigned managed metadata terms.

After scraping the art data from the site we have an xml file (worksofart.xml) with information about all the items in a SharePoint style import format.

    <Row>
      <Field Name="id">24141</Field>
      <Field Name="url">http://www.gac.culture.gov.uk/work.aspx?obj=24141</Field>
      <Field Name="image">/images/standard/11376.jpg</Field>
      <Field Name="artist">James Pollard</Field>
      <Field Name="engraver">Charles Hunt I</Field>
      <Field Name="title">St. Albans Grand Steeple Chase, 8 March 1832: Plate 1: Preparing to Start</Field ...

Continue Reading

Email this · Tweet this · Share on Google+ · Share on Facebook · Post to del.icio.us · Subscribe to this feed

Last year when demoing SharePoint managed metadata features I prepared a demo that could be easily be added to existing sites (including Office 365). I've recently used the same configuration for SharePoint 2013 investigations and demos so thought I'd share both the data and the process of preparing the demo in a short series of posts...

1. Collecting data for term sets and list items
2. Creating and loading term sets
3. Preparing list items with managed terms
4. Loading the list items into SharePoint

The demo is online here.

In the last post I collected the subject and place category menu data from the UK Government Art Collection web site (the site Places filter widget is shown below). This time i'll walk through creating and loading SharePoint term sets from the categories.

So after scraping the html we have 2 files (subjects.htmland places.html) with a nested HTML menu style UL/LI format:

<html>
  <body>
    <ul>
      <li id="103019">
        <a cn="27" href="#" >Africa [103]</a>
        <ul>
          <li id="136573">
            <a cn="4" href="#" >Africa: natural features</a>
            <ul>
              <li id="138257">
                <a cn="0" href="/places_results.aspx?TermId=138257" >Congo River [3]</a>
              </li>

The menu html ...

Continue Reading

Email this · Tweet this · Share on Google+ · Share on Facebook · Post to del.icio.us · Subscribe to this feed

Last year when demoing SharePoint managed metadata features I prepared a demo that could be easily be added to existing sites (including Office 365). I've recently used the same configuration for SharePoint 2013 investigations and demos so thought I'd share both the data and the process of preparing the demo in a short series of posts...

1. Collecting data for term sets and list items
2. Creating and loading term sets
3. Preparing list items with managed terms
4. Loading the list items into SharePoint

The demo is online here.

How many dry SharePoint presentations have you seen where the presenter creates doc1.docx, saves it and adds a bit of metadata to demo Managed Metadata? (one of mine in the past maybe...). Well I wanted a richer test and demo data set so I looked for some interesting data labelled with quality metadata. In this article i'll walk through collecting the term set categories and item data required for the demo.

It didn’t take too long to spot the UK Government Art Collection web site, it’s a well structured site (good for indexing...), with an interesting data set all labelled with terms from taxonomies. The web site includes ...

Continue Reading

Email this · Tweet this · Share on Google+ · Share on Facebook · Post to del.icio.us · Subscribe to this feed

Recently I was looking at some SharePoint search/managed metadata configuration and thought I'd check out some examples on the internet. Because SharePoint has some quite distinct URL patterns using a basic Google search can uncover all sorts of goodies.

SharePoint 2010 uses the owstaxIdMetadataAllTagsInfo search property to refine against any managed metadata values so we can search Google for any URLs containing owstaxIdMetadataAllTagsInfo using the allinurl search operator like this:

https://www.google.com/search?hl=en&biw=1920&bih=979&output=search&sclient=psy-ab&q=allinurl%3A+owstaxIdMetadataAllTagsInfo&btnK=

This reveals some of the SharePoint examples below from energizer.com, sappi.com, presidio.gov, arcweb.com, trustdots.com and mynevadacounty.com.

To check out the SharePoint site click on an image below and it will execute the SharePoint search and display the page.

Continue Reading

Email this · Tweet this · Share on Google+ · Share on Facebook · Post to del.icio.us · Subscribe to this feed