Export Term Store to CSV

Hii,

Below is the script that has been executed to export terms into csv of Taxonomy

Add-PSSnapin microsoft.sharepoint.powershell

$siteUrl = "siteurl"

$outputDir = "E:\TermStore"

  function Get-TermSetsCSV() {

     param($SiteUrl, $CSVOutput)

      $empty = ""

    $taxonomySite = Get-SPSite -Identity $SiteUrl

     #Connect to Term Store in the Managed Metadata Service Application

    $taxonomySession = Get-SPTaxonomySession -site $taxonomySite

  $taxonomyTermStore =  $taxonomySession.TermStores | Select Name

   $termStore = $taxonomySession.TermStores[$taxonomyTermStore.Name]

   foreach ($group in $termStore.Groups)

   {

       foreach($termSet in $group.TermSets)

         {

            $terms = @()

              #The path and file name, in this case I did C:\TermSet\TermSetName.csv

             $CSVFile = $CSVOutput + '\' + $termSet.Name + '.csv'

           #From TechNet: The first line of the file must contain 12 items separated by commas

             $firstLine = New-TermLine -TermSetName $termSet.Name -TermSetDescription $empty -LCID $empty -AvailableForTagging "TRUE" -TermDescription $empty -Level1 $empty -Level2 $empty -Level3 $empty -Level4 $empty -Level5 $empty -Level6 $empty -Level7 $empty

            $terms+=$firstLine

             #Now we start to add a line in the file for each term in the term set

             foreach ($term in $termSet.GetAllTerms())

            {

                 $tempTerm = $term

                $counter = 0

                 $tempTerms = @("","","","","","","")

               #this while loop makes sure you are using the root term then counts how many child terms there are

                while (!$tempTerm.IsRoot)

                 {

                    $tempTerm = $tempTerm.Parent

                     $counter = $counter + 1

                 }

                 $start = $counter

                #this makes sure that any columns that would need to be empty are empty

                #i.e. if the current term is 3 levels deep, then the 4th, 5th, and 6th level will be empty

                while ($counter -le 6)

                {

                     $tempTerms[$counter] = $empty

                       $counter = $counter + 1

              }

                  #start with the current term

                 $tempTerm = $term

                #fill in the parent terms of the current term (there should never be children of the current term--the child term will have its own line in the CSV)

             while ($start -ge 0)

                  {

                     $tempTerms[$start] = $tempTerm.Name

                      $tempTerm = $tempTerm.Parent

                      $start = $start - 1

               }

                #create a new line in the CSV file

                 $CSVLine = New-TermLine -TermSetName $empty -TermSetDescription $empty -LCID $empty -AvailableForTagging "TRUE" -TermDescription $empty -Level1 $tempTerms[0] -Level2 $tempTerms[1] -Level3 $tempTerms[2] -Level4 $tempTerms[3] -Level5 $tempTerms[4] -Level6 $tempTerms[5] -Level7 $tempTerms[6]

                 #add the new line

               $terms+=$CSVLine

             }

             #export all of the terms to a CSV file

            $terms | Export-Csv $CSVFile -notype

         }

   }

     $taxonomySite.dispose()

}

 #constructor

function New-TermLine() {

      param($TermSetName, $TermSetDescription, $LCID, $AvailableForTagging, $TermDescription, $Level1, $Level2, $Level3, $Level4, $Level5, $Level6, $Level7)

      $term = New-Object PSObject

     $term | Add-Member -Name "TermSetName" -MemberType NoteProperty -Value $TermSetName

     $term | Add-Member -Name "TermSetDescription" -MemberType NoteProperty -Value $TermSetDescription

    $term | Add-Member -Name "LCID" -MemberType NoteProperty -Value $LCID

     $term | Add-Member -Name "AvailableForTagging" -MemberType NoteProperty -Value $AvailableForTagging

     $term | Add-Member -Name "TermDescription" -MemberType NoteProperty -Value $TermDescription

     $term | Add-Member -Name "Level1" -MemberType NoteProperty -Value $Level1

       $term | Add-Member -Name "Level2" -MemberType NoteProperty -Value $Level2

      $term | Add-Member -Name "Level3" -MemberType NoteProperty -Value $Level3

    $term | Add-Member -Name "Level4" -MemberType NoteProperty -Value $Level4

    $term | Add-Member -Name "Level5" -MemberType NoteProperty -Value $Level5

     $term | Add-Member -Name "Level6" -MemberType NoteProperty -Value $Level6

     $term | Add-Member -Name "Level7" -MemberType NoteProperty -Value $Level7

     return $term

  }

 Get-TermSetsCSV -SiteUrl $siteUrl -CSVOutput $outputDir