powershell script to add a managed metadata column

Question

$webURL = "http://xxx/sites/wingtipcalculator"
$spSite = New-Object Microsoft.SharePoint.SPSite($webURL)
$spWeb = $spSite.OpenWeb()

$listTemplate = $spWeb.ListTemplates["Custom List"];

$spweb.Lists.Add("List4","Data information DTU",$listTemplate)

write-host "List added in the Web : " $spweb -foregroundcolor Yellow

$spList = $spWeb.Lists["List4"]
$spList.Fields.Add("Publication Date","DateTime",1)
$spList.Fields.Add("Headline","Text",1)
$spList.Fields.Add("LeadParagraph","Text",1)
$spList.Fields.Add("FullText","Text",1)
$spList.Fields.Add("ContactName","Text",1)
$spList.Fields.Add("ModifiedTest","DateTime",1)
$taxonomySite = Get-SPSite http://XXX:2010
$taxonomySession = Get-SPTaxonomySession -site $taxonomySite
$termStore = $taxonomySession.TermStores["Managed Metadata Service"]
write-host "Connection made with term store -"$termStore.Name
$taxonomySession = $spWeb.site;

$termStoreGroup = $termStore.Groups["XX"];
$termSet = $termStoreGroup.TermSets["General Business Taxonomy (v1.0)"];
$TaxonomyField = $spList.Fields.Add("TaxonomyFieldType", "Test1"); 
$taxonomyField.SspId = $termStore.Id;
    $taxonomyField.TermSetId = $termSet.Id;
$spWeb.Dispose()

trying to use the above script but unable to cretae the required metadata column in list

possible duplicate of powershell script add a managed metadata column — Eric Alexander
– Eric Alexander, Commented Jan 27, 2012 at 19:25

Ashish Patel · Accepted Answer · 2012-01-27 20:09:28Z

2

You should get the taxonomy session of the site in which you are adding field.

$taxonomySite = Get-SPSite http://XXX:2010 
$taxonomySession = Get-SPTaxonomySession -site $taxonomySite

Also try calling Update() method after you set the SSPId and TermSetID

answered Jan 27, 2012 at 20:09

Ashish Patel

11.4k3 gold badges24 silver badges29 bronze badges

Hi asish patel i tried doing that im getting the field but its not pointing to the term store its giving termstore is null..please help me out..

vikram06
– vikram06

2012-01-27 20:28:43 +00:00
Commented Jan 27, 2012 at 20:28
what is taxonomySession.TermStores.Count?

Ashish Patel
– Ashish Patel

2012-01-27 20:36:56 +00:00
Commented Jan 27, 2012 at 20:36
Thank You very much Asish Patel I have resolved with it...:-)

vikram06
– vikram06

2012-01-30 15:05:14 +00:00
Commented Jan 30, 2012 at 15:05
1

Please accept this as the answer, if it solved the problem, rather than leave a comment.

SPDoctor
– SPDoctor

2012-03-27 14:33:41 +00:00
Commented Mar 27, 2012 at 14:33
If it did not solve the problem, please post what you did to correct it as an answer. If Ashish's answer did help but was not complete, consider accepting his answer but adding the additional steps as a comment. The helps the community by increasing the value of your question.

Robert Kaucher
– Robert Kaucher

2013-08-17 15:11:37 +00:00
Commented Aug 17, 2013 at 15:11

Add a comment |

Stack Exchange Network

powershell script to add a managed metadata column

1 Answer 1

Your Answer

Hot Network Questions

powershell script to add a managed metadata column

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions