Term store import file conversion

This week I was working with the term store and had to create and import a big chuck of data in the term store. We all know that we have multiple options here Just enter them one by one in the browser (great for a few entries) Use the csv import Use CSOM Use Office Dev PnP PowerShell This post will address the csv import. Getting started with the csv For the csv import we have a sample that can be downloaded from the term store (http://-admin.

How does the Custom SharePoint retention Policy work

Arjan Cornelissen
Some time ago we created a custom retention policy for a customer and last week I had to give some support. I had to dive in it again because I forgot all about it. Why did we build this? We build this custom retention policy to move a document to the record center when a specified field has a specified value. This field could be any type of field other than a data time field.

SharePoint monitoring with Microsoft Azure

After reading this blog of Matthias Einig about using Azure Analytics for your Office 365 portal. I tried this on an clients SharePoint 2013 farm. But I didn’t want to create an app to deploy the JavaScript so I created an Console app to deploy this to the specific site collection. I first wanted to create a PowerShell script, but that does not work with our farm because of the discovering of the ADFS settings.

Content Type Updates

I was triggered to write this blog because of a question on Facebook about changing the title of a content type in the content type hub. I was able to answer this question because I found the same issue a while ago when I was working with the same thing. The question was: When I create a content type in the content type hub and publish it, the content type is pushed down to all site collections and there you can use it in your lists and libraries.

Force renewal of Content Types

Arjan Cornelissen
This week we had an issue where we had some differences in the Content Types that where pushed from the Content Type hub. We wanted to make sure all Content Types where updated in the next push. After some digging around on the internet I found that there is a property in the SPWeb.Properties called “MetadataTimeStamp”. This property contains the date of the last sync with this site collection. If you clear the value of this property, the Content Type synchronization Job will update this sitecollection.

SPC14 Sessions

All the sessions of the SharePoint Conference 2014 are now available on Channel9. Like many other people I like to watch some of the sessions I missed during the conference. I also do not like to watch this from my laptop so I wanted to download the sessions I would like to see. After a few hours of trying myself I found on Yammer that there were many others trying the same thing and 1 had created and shared a really nice PowerShell script to download everything.

Undeclare In-Place records

Arjan Cornelissen
Last week I had a question to remove a document library with items that where records. Then you have an option to remove the record status of every document by hand, this is ok for a few items but in this case there were a few thousand items and only some of them had the status Record. With some searching on the internet I found a code snippet to remove the record status of a document.

Audit settings

Arjan Cornelissen
This week I was trying to make some PowerShell scripts to set the auditing in SharePoint. This can be done very easy with the GUI, but I had to set this on a few thousand sites. With the GUI you can go to the site collection and then settings. Under ‘site collection administration’ you find ‘Site collection audit settings’ Just select the options you want and you’re all set to use auditing.

Content type with Managed Metadata field

Arjan Cornelissen
This week I was asked to create some content types with Managed Metadata field in it. This of course is not hard to do if you do it from the UI, but we wanted to have a nice solution to deploy. After searching the internet I found several posts how to do this, but none had a complete solution so here it is. First of all you need to have a field that looks like this: