Content Precedes Design – thought leadership collides with learned experience to yield practical advice

Content Precedes Design

thought leadership collides with learned experience to yield practical advice

SharePoint Managed Metadata Import Files – Geographical Location

March 7, 2014

Information Architecture SharePoint
I frequently need access to standard lists in the Term Store. Here is the CSV file I use for selecting a geographical location, which I place under a group named Canonical Terms:

ImportTermSet_Canonical-Terms_Geographical-Location Download

Data Sources
- MSDN
Related Posts
- SharePoint Managed Metadata Import Files (02/27/2014)
Terms of Use

SharePoint Managed Metadata Import Files – Geographical Location by Jonathan Ralton is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
SharePoint Managed Metadata Import Files – Locale

March 7, 2014

Information Architecture SharePoint
I frequently need access to standard lists in the Term Store. Here is the CSV file I use for selecting a locale, which I place under a group named Canonical Terms:

ImportTermSet_Canonical-Terms_Locale Download

Data Sources
- MSDN
Related Posts
- SharePoint Managed Metadata Import Files (02/27/2014)
Terms of Use

SharePoint Managed Metadata Import Files – Locale by Jonathan Ralton is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
SharePoint Managed Metadata Import Files – Currency

March 7, 2014

Information Architecture SharePoint
I frequently need access to standard lists in the Term Store. Here is the CSV file I use for selecting a currency, which I place under a group named Canonical Terms:

ImportTermSet_Canonical-Terms_Currency Download

Data Sources
- XE
Related Posts
- SharePoint Managed Metadata Import Files (02/27/2014)
Terms of Use

SharePoint Managed Metadata Import Files – Currency by Jonathan Ralton is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
SharePoint Managed Metadata Import Files – Language

March 7, 2014

Information Architecture SharePoint
I frequently need access to standard lists in the Term Store. Here is the CSV file I use for selecting a language, which I place under a group named Canonical Terms:

ImportTermSet_Canonical-Terms_Language Download

Data Sources
- TechNet
Related Posts
- SharePoint Managed Metadata Import Files (02/27/2014)
Terns of Use

SharePoint Managed Metadata Import Files – Language by Jonathan Ralton is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
SharePoint Managed Metadata Import Files – Time Zone

February 28, 2014

Information Architecture SharePoint
I frequently need access to standard lists in the Term Store. Here is the CSV file I use for selecting a time zone, which I place under a group named Canonical Terms:

ImportTermSet_Canonical-Terms_Time-Zone Download

Data Sources
- MSDN
Related Links
- Time Zone Map
- Time Zone Abbreviations
Related Posts
- SharePoint Managed Metadata Import Files (02/27/2014)
Terms of Use

SharePoint Managed Metadata Import Files – Time Zone by Jonathan Ralton is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
SharePoint Managed Metadata Import Files

February 27, 2014

Information Architecture SharePoint
SharePoint allows you to import term sets using a specifically formatted CSV file. This is quite helpful to set up large quantities of terms, with inheritance, quickly. It also allows for planning of your term set in spreadsheet format.

A shortcoming of this method is the inability to specify synonyms (alternate spellings, abbreviations, etc.) for any of your terms. Those must be manually entered on each term after importing. Also, once you import a term set, you can not just replace it with a subsequent import. The term set must be deleted and re-established via a subsequent import. Deleting the term set severs all connections from any columns, so those will all need to be re-established after the replacement term set is created.

Unfortunately, SharePoint does not provide a method for you to export a term set through the user interface, which means that your managed metadata hierarchies are trapped in the farm you set them up in. Unless… you either write custom code, employ a third party tool such as MetaVis Term Store Manager or MetaVis Architect Suite, or try out a CodePlex solution such as SolidQ Managed Metadata Exporter or SharePoint Managed Metadata Navigator.

I frequently need access to standard lists in the Term Store. I’ll be publishing several import files that I use, and will periodically update this post with links to the individual posts for each file here:

Canonical Terms
1. Currency (03/07/2014)
2. Geographical Location (03/07/2014)
3. Language (03/07/2014)
4. Locale (03/07/2014)
5. Time Zone (02/28/2014)
Common Entities
1. Airlines (03/21/2014)
2. Parcel Carriers (03/17/2014)
3. Postal Carriers (03/17/2014)
4. Logistics Companies (03/19/2014)
5. Trucking Companies (03/19/2014)
Related Links
- Managed Metadata Overview
  SharePoint 2010 | SharePoint 2013
- Managed Metadata Planning
  SharePoint 2010 | SharePoint 2013
- Creating and Migrating Taxonomies Using the Term Store Management Tool
- Managed Metadata Input File Format
My Slides – Taming Your Taxonomy in SharePoint – SPSRI13

November 9, 2013

Information Architecture Presentations SharePoint SPS Events

Thanks for attending my session at SharePoint Saturday Rhode Island!

Slide Deck