Sharepoint-2010

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://“tenant”-admin.sharepoint.com/_layouts/15/1033/ImportTermSet.csv)

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. The specification of the field and his value was in a list on the root site of the Site collection that the customer can maintain.

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. I created an issue for this on GitHub (https://github.com/OfficeDev/PnP/issues/1118). So for the console app I used the OfficeDevPnP core Nuget package (https://www.nuget.org/profiles/officedevpnp).

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. Now if we change the content type’s title or description and republish it, the changes are pushed down to the level of site collection but not to the content types associated to a list. When we create a new list the changes are visible for that new list.

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.

Today I did a presentation at Portiva’s SharePoint & Sushi about PowerShell for IT Pro. In this presentation I told the public about PowerShell en how the IT Pro can use this in his daily work. The presentation is in Dutch.

20140429 - PowerShell for IT Pro—Arjan Cornelissen

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. This script can be downloaded and used from here. For me the script did not work so I have updated this to use ‘Start-BitsTransfer -Source $url -Destination $dest -TransferType Download’ instead of the WebClient.DownloadFile()

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.

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.

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: