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://-admin.
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://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnectsync-feature-directory-extensions/
This screenshot has selected division and employeeID, but in the complete list of available attributes there are also the ExtensionAttributes.
In the trend of my recent blog post I create a new addition to my automation of Office 365 tasks. This time creating a report with the license consumption per month with PowerShell automation, Azure table storage and Power BI. In this post I will take you with me thru the steps to set this up.
What do we need? Before we can get started coding we need to do some plumbing first.
Last week I was getting complaints by users in our Office 365 environment that the address book in Exchange was not up to date. The issues was that users where getting email addresses with the .onmicrosoft.com as the default email address. The users with these onmicrosoft.com mail addresses where users that are in our on-premises Exchange environment.
The situation At this customer we have a select group of users in Office 365 and all other users are in an on-premises Exchange environment.
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.
In Office 365 we have the option to give some of our users an administrative role, but what role(s) can we give them?
This post will be an overview of the available roles within the portal and PowerShell.
What roles do we have in the portal? Within the portal we have the following roles available
Global administrator Billing administrator Exchange administrator Password administrator Skype for Business administrator Service administrator SharePoint administrator User management administrator Microsoft did a great job outlining what each of these roles can do.
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.
In Office 365 you have the option to add a partner to your Office 365 tenant. In this article I explain what the partner sees and what can they do.
What is this option about? In your Office 365 portal you see ‘Partner relationships’, here you will find a list of Microsoft Partners that have delegated access to your tenant. The Microsoft partner can ask for delegated access to your tenant, you cannot invite the partner yourself.
We are rolling out Office 365 at my current assignment. Within this project we want to automate as much as possible to avoid human error and reoccurring tasks. We already used a lot of PowerShell for our current SharePoint farm, so the most obvious thing was to look at PowerShell for automating those tasks. In this article I will take you with me on the journey that we took.
Why Azure Automation We choose Azure Automation for a few reasons.