Sharepoint

A few weeks ago it was the time of the year that the signing certificate of ADFS was expiring. Last year it took us by surprise because the ADFS team did not notify us and we did not put it in our agenda’s that the certificate would expire. So last year we had a lot of people complaining that SharePoint 2013 was not available anymore.

This year we had it in our agenda’s that the certificate would roll over, so we were prepared for a roll over and had contact with the ADFS team and made an arrangement to roll over the certificate. I also found a nice script that can be ran to prepare for the roll over. This script will download the new certificate and when the secondary certificate becomes the primary the script will update SharePoint.

As a follow up on my post from last week I wanted to add some extra data in the terms. This is not possible with the default CSV import that SharePoint has. I mentioned in my previous post that Office Dev PnP has also an option to import terms. And with that option we can add a lot more than only the term itself.

What commands do we have?

We have a 2 options here to add term to Office 365.

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)

This week I had a customer that has some data in their on-premises Active directory that we needed to use for a custom application in SharePoint Online. This data was placed in the ExtensionAttribute field of the user. With the latest version of Azure AD Connect we have the option to select attributes to sync to Azure Active Directory and that is what the customer did. https://learn.microsoft.com/en-us/entra/identity/hybrid/connect/how-to-connect-sync-feature-directory-extensions

This screenshot has selected division and employeeID, but in the complete list of available attributes there are also the ExtensionAttributes. When you do not select them here, the extension attributes will be in the synchronization.

Two weeks after my visit to SharePoint Saturday Paris I visited SharePoint Saturday Netherlands. The schedule for today was a bit more relaxed than in Paris. We had 4 session slots of 75 minutes with great sessions and more time in between the sessions to have a chat with sponsors, trying out the HoloLens and playing some games. The HoloLens is a very cool device and I tried it here for the first time.

On May 28th 2016 I visited SharePoint Saturday in Paris (http://www.spsevents.org/city/Paris/Paris2016/). The event was held in the Montparnasse Tower in the center of Paris on the 40th floor. We had an amazing view from that height.

This article contains my notes of the day.

Start of the day

We had some trouble getting in the building because of some regulations of the building owner, but when we were all registered we could go all the way up to the 40th floor. Here we started with a small breakfast, I did not eat in the hotel so I could use this. I came in just after 8 and all sponsors where getting settled because they also had trouble getting into the building. After breakfast and a delay of 15 minutes the first session started at 9:15

From the beginning of SharePoint Online we have the option to share a site or document with an external user. When you use this feature the recipient need to have a Microsoft Account to login your SharePoint environment. Because this can be very confusion for the user, Microsoft is working on a Business 2 Business connection within Azure AD. With this connection you can share that same site or document with a user from another Azure AD tenant.

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()