Skip to content
  • Home
  • About
Search
Close

Piyush K Singh

unfolding the journey

Tag: Custom Sort

Import SharePoint MetaData from CSV along with their Guids, Deprecate-State and Custom Ordering

September 23, 2015December 11, 2016 Piyush K Singh2 Comments

This is the final of the two-series blog. Before proceeding further, here’s the link to the 1st part, https://realmpksharepoint.wordpress.com/2015/06/19/export-sharepoint-metadata-to-csv-along-with-their-guids/. The objectivity of the entire series has been already defined there so I won’t be re-iterating the same. However, I must re-visit some of the items relevant to the current context. So following are the objectives of this script:

  • Import Terms to SharePoint only when they don’t already exist. The search will be done using the Term Name only.
  • Can create a Term with the given Guid i.e., Guids can be retained across the servers. This is optional. If you don’t want to use this option, then keep this column blank and the TermSet will be created using a brand new Guid assigned by the SP.
  • Deprecate/Un-Deprecate an existing or a new Term. If you want to change this option on a number of pre-existing TermSets or you even want to create the TermSets with the deprecate value on, then simply update the corresponding column in the exported CSV and then run the import script.
  • Modify the availability for Tagging option. If you have to change this option on a number of pre-existing or new TermSets then simply update the given CSV accordingly and then run the import script.
  • Most importantly, it applies custom sorting to the TermSets. So the TermSet and their child terms will exactly appear in the same order as has been listed in the processing CSV file.

Input

There are three parameters that needs to be set before executing the script. They are:

  • $fileName: Full path of the csv file to be imported.
  • $termStoreGroupName: Term group name. Please note that the script does not create a term group. Hence do ensure first that the group already exist at SharePoint even if its blank.
  • $MMSStore: Name of the managed metadata service.

Read More »

Export SharePoint MetaData to CSV along with their Guids

June 19, 2015December 11, 2016 Piyush K Singh4 Comments

This is a two series blog in which I will try to cover lots of SharePoint TermSet Metadata operations. The idea is to achieve the following:

Export Terms to CSV

  • Existing Terms along with their child Terms,
  • Current Guid,
  • Available for Tagging option, &
  • Deprecate state.

Import Terms from CSV

  • Import Terms which will create Terms only when they don’t already exist. The search will be done using the Term Name.
  • Can create the Term with the given Guid. This is optional. If you don’t want to use this option, then keep this column blank and the Term will be created using a brand new Guid.
  • Deprecate/Un-Deprecate an existing or a new Term. If you have to change this option on a number of pre-existing TermSets then simply update the exported CSV accordingly and then run the import script.
  • Modify the availability for Tagging option. If you have to change this option on a number of pre-existing TermSets then simply update the given CSV accordingly and then run the import script.
  • Most importantly, it also applies custom sorting. So the Terms and their child terms will exactly appear in the same order as has been mentioned in the processing CSV.

In this post, I’ll only be showing the export operation. The import operation has been defined here, https://realmpksharepoint.wordpress.com/2015/09/23/import-sharepoint-metadata-from-csv-along-with-their-guids-deprecate-state-and-custom-ordering/. Please note that since the generated output will be in CSV format, we’re converting any comma (,) that might be included in the Term name to “,” otherwise the format will get distorted.

Input

The script expects two parameters that needs to be set before executing it. They are:

  • $termGrpNm: The name of the TermGroup whose all TermSets will be exported to CSV files respectively.
  • $svLoc: File System location where all the CSVs will be dumped.

Here’s the script preview. Download link for the same has been provided in the later segment.

Read More »

Piyush K Singh

Piyush K Singh

Cloud consultant. Microsoft 365

View Full Profile →

Top Posts

  • PowerApps: Edit and Submit Form
  • Power Automate: Read Excel File
  • PowerApps: Pass argument to another screen
  • PowerApps: Select Current User by Default
  • Call Microsoft Flow from PowerApps

Recent Posts

  • Fatal: no email was given and auto-detection is disabled
  • Power Automate: Copy SharePoint List Attachments
  • Power Automate: Read Excel File
  • PowerApps Drop Down: Show Values from multiple Data Sources
  • Set Bing Maps API Key in SharePoint

Categories

Microsoft Flow Microsoft PowerApps SharePoint SharePoint Apps SharePoint Online SharePoint Online List SharePoint Online List Field SharePoint Online ListItem SharePoint Online View SharePoint WebPart

#Twitter

My Tweets
Create a website or blog at WordPress.com
Back to top
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: Our Cookie Policy