Pages

Friday, January 17, 2014

Mention in the Microsoft Netherlands Business newsletter

I am very proud to receive a mention in the Microsoft Netherlands Business Newsletter for this month:

Welke tweets hebben uw aandacht?

Vanuit Microsoft retweeten wij een aantal twitteraars die waardevolle informatie delen over de Microsoft oplossingen voor het MKB. Ronald Scherpenisse stuurt tweets over het Nieuwe Werken, Office 365 en het groeibriljantje OneNote. Rogier Nijenhuis is de man voor SharePoint en Cloud oplossingen. En Jasper Oosterveld deelt nuttige artikelen en tips over Office 365.

Van wie leest u graag de tweets, die u hielpen met uw business in 2013? Laat het ons weten via
https://twitter.com/Microsoftmkb.

Wilt u bovenstaande heren volgen, klik op onderstaande links.

Ronald Scherpenisse

Rogier Nijenhuis

Jasper Oosterveld 

I always like to help the community with sharing useful articles and resources about Office 365. You can click here to read the whole newsletter.

Monday, January 13, 2014

Office 365 Saturday Europe 2013 - Recording of my session

The recording of my session for Office 365 Saturday Europe 2013 is online. You can view it in the player below:



SharePoint Online 2013 - A Guideline To Structure Your Documents Within SharePoint Online from Kinetal on Vimeo.

Hope you enjoy it. You can always drop a question or leave your feedback.

Thursday, January 2, 2014

SharePoint Document Management - Facts about versioning

Main selling point

Versioning has always been one of the main selling points for SharePoint Document Management. At least, that's what I always use as an, there are more of course, argument for storing documents in SharePoint instead of file shares. While I was preparing my presentation about Best Practices: Document Management in SharePoint 2013 for SharePoint Connections Amsterdam 2013, I started to wonder if versioning worked as well as I thought it did. Let's take a closer look.

New versions

When are new versions actually created in SharePoint? A new version is created when you:
  1. Upload a new document
  2. Upload document with the same name
  3. Change the properties of the document
  4. Open, edit or save the document

Upload a new document

The first version is created when I upload a new document into a SharePoint document library:



Upload document with the same name

What happens if I upload the same document again? The following pop-up appears:



Yes, I am sure! So I click on Replace it:


The document is now version 0.2.

Change the properties of the document

Let's change the name of document:


This also results in a new version:


Please be careful! Even without actually changing the properties but clicking on Save results in a new version.

Open, edit or save the document

This one makes sense of course so after I open the document in the browser and edit some text a new version is created:



Co-authoring

What about co-authoring? Working together with multiple people in the document, how does this impact the versioning? This is the official answer from Microsoft:

"During co-authoring of a document, when a different user begins working on the document or when a user clicks save to upload changes to the library. The default time period for creating new versions during co-authoring is 30 minutes, but an administrator can change that setting."

I actually tried this in my Microsoft Office 365 demo tenant but without success. After staying in the document, with multiple users, for over 30 minutes no new versions were created. Unfortunately I cannot test this in an on-premises SharePoint site.

Does it work?

To be honest, that really depends on your situation and business requirements. Let's take a look at my work situation:

I write project proposals together with a technical specialist, project manager and account manager. I create the proposal and for me its now version 0.1. After I am done, this can take multiple days, I create version 0.2 and hand the document over to the technical specialist. He or she writes her part of the proposal and turns it into 0.3 before handing it over to the project manager. After the project manager and the account manager are done, the proposal is at 0.5 and can be send to the customer as version 1.0.

This doesn't work with SharePoint versioning because SharePoint keeps creating versions after I continue working the next day and after I close and reopen the document. You can have more control with versions. You have to work with check-in and check-out. The only downside is that it disables co-authoring.

Please really take a look at your or your customers, or your own, requirements around versioning to see if SharePoint versioning works. 

Monday, December 30, 2013

Search crawl and SharePoint Online

I received a question to one of my blog posts:

"There seems to confusion regarding crawling in SPO , as it is very different from the crawling in the on prem environment. can you please shed some light on types of crawling in SPO"

This made me realize its very hard to find information about search crawls in SharePoint Online. I remembered a great post by Chris O'Brien not that long ago:

http://www.sharepointnutsandbolts.com/2013/10/waiting-for-search-crawl-in-office-365.html

Chris also looked into this question and found the following:

“Search crawls occur continuously to make sure that content changes are available through search results as soon as possible. Recently uploaded documents may not immediately be displayed in search results because of the time that's required to process them. SharePoint Online targets between 15 minutes and an hour for the time between upload and availability in search results (also known as index freshness). In cases of heavy environment use, this time can increase to six hours.”

This relates from the following article:

http://support.microsoft.com/kb/2008449 under the header More Information. Thanks for the post Chris :-)

Apperently continous crawl is supported in SharePoint Online:

http://technet.microsoft.com/en-us/library/sharepoint-online-search-service-description.aspx

Just take a look at the table! Although Microsoft contradicts itself at the beginning of the page:

"Not available to SharePoint Online customers. Configure crawl schedules for SharePoint Server 2013 content sources so that crawls are performed continuously. This option eliminates the need to schedule incremental crawls and automatically starts crawls as necessary to keep the search index fresh. Learn more about managing continuous crawl."

This makes everything a bit more confusing and isn't really helpful. I wish Microsoft would make their Service Description a bit more clear related to this subject. I remember the Service Description used to be a Word document, I had the feeling that was a bit more clear but that can be personal :-)

I do recommend the following trick to perhaps speed up the crawl of your documents:

  • Go to a document library
  • Click on Library and Library Settings
  • Click on Reindex Document Library
Definitely worth a shot! Hope this makes things a bit more clear for you.

Friday, December 27, 2013

SharePoint Online - Content type hub

Are you looking for the content type hub in SharePoint Online? This is the URL:

https://yourdomain.sharepoint.com/sites/contenttypehub

This URL can only be accessed by a Global Admin.

Note
This is a repost from SPCNL.

Friday, December 13, 2013

SharePoint Document Sets - A real world example

Document Sets are awesome!

During my assignment at an asset manager in the Netherlands, I really started to appreciate the power of Document Sets in SharePoint. I never really was a big fan (not sure why exactly) and never used them. One of my colleagues from the Intranet Team showed me the benefits and now I think they rock! I recently wrote an article for the DIWUG E-Magazine where I also write about Document Sets. In this post I would like to show you an example of the use of Document Sets within my own team at Macaw. Let's take a look!

Storing publications and presentations

Our department finds it really important to share SharePoint knowledge by writing internal or external publications. We store the publications in Document Sets. The following screenshot isn't an actual representation of our use of Document Sets but gives you a good perspective:


The publications are grouped by SharePoint version. Each visitor can immediately search for the SharePoint version they are looking for and also get a glimpse at the author. Let's create a new publication:


Every author has to attach metadata to the publication. This improves the Search results and every visitor gets all the details of the publication. After entering all the metadata the following screen appears:


This is what I love about Document Sets! The welcome page. You see a description and all the important metadata such as the URL of the publication. I hope you noticed a different view compared to the library, where the document sets are grouped by the SharePoint version. The content of the Document Sets has a different view and different metadata! Awesome! This is why I recommend using Document Sets instead of folders, you have a lot more flexibility and options. It really improves User Adoption of SharePoint and Document Libraries. So how do you recreate this solution? It's really easy.

Content type and site columns

We start by creating a new Content Type based at the default Document Set Content Type:


We create new site columns or attach default site columns to provide the metadata of our Document Set. Create a new document library and attach the Document Set Content Type:
  • Click on Library in the ribbon
  • Click on Library Settings
  • Click on Advanced Settings
  • Select Yes to allow the management of Content Types
  • Click on Ok.


The Document Set is now available in our library.

Document Set Settings

A Document Set has very useful settings. Let's take a closer look at these settings:

Allowed Content Types

This settings enables you to set the default Content Types within the Document Set. I don't recommend using this feature because it doesn't work properly. Let me show you. I select a Document Content Type called Fact sheet as my only allowed Content Type. This is what happens: 



The Fact sheet appears under New Document but after uploading a document the following happens:


In case the document library contains more Document Content Types the default one is selected. I recommend using the Default Content option.

Default Content

The main reason you want to use the Allowed Content Type feature is because you want your end-users to create Document Content Types with a predefined template. There is an easier way to do this. That's using the Default Content option. You can add templates here, these templates are automatically added to the Document Set after an end-user creates a Document Set. Very handy!  

Shared Columns

Again, a very cool feature. By adding Shared Columns all the document inside the Document Set inherit the Document Sets metadata. I really recommend using this feature because it improves the Search results in your SharePoint portal.

Welcome Page Columns

You probably noticed the metadata fields at the welcome page right? 



How can I display those metadata fields? By using this feature!

Welcome Page View

Also a very powerful feature to display different metadata inside the Document Sets compared to the view of the Document Sets in the Document Library. We first have to change the default All Documents view to group by the Document Sets based at SharePoint version and only show the Author field:



To set a dedicated view for the Document Set we have to create a new view:



So how do we get this view to be the default view for the Document Set? By selecting it at the Welcome Page View option.

This is how Document Sets can benefit your business. I really hope you found this post useful and you can start working with Document Sets in your business.

Wednesday, December 4, 2013

Speaking at European Office 365 Connect 2014



I am happy to be speaking at the first Office 365 Conference in the world. The event takes place in Haarlem, the Netherlands at a beautiful location. These are the details of my session:

External Collaboration with SharePoint Online
External collaboration has never been easier with SharePoint Online. Every end-user can store documents on SkyDrive Pro and share these document with external users. SharePoint Online has the Project site template that contains valuable features to collaborate in projects with customers. These features are a newsfeed, OneNote integration, a document library and a task list with a timeline to present important tasks in a clear overview. It doesn't stop here! Microsoft acquired Yammer in 2012 and Yammer is shifting as the Social tool for SharePoint. Through its integration with SharePoint Online, you can easily start discussions about the projects content. By using all of the above features, SharePoint Online proves to be the perfect solution for Extranet scenarios.

You can use my personal speaker code for a 10% discount: GB263

Really hope to see you at the event!

Monday, December 2, 2013

Office 365 Saturday Europe 2013 - Questions during my session

I was really honored and happy to be part of the very first Office 365 Saturday Europe. Awesome event organized by Matthew Hughes and Rene Modery. Great job guys :-)

Unfortunately I wasn't able to answer any questions due to the time. I copied all questions and here are my answers.

Phil Greer
"Can you move documents out of a document set or into a different document set?"

Yes, the easiest way to do this is by using the Explorer View. You can use the Sent To option in the ribbon but I don't like this option. Not really end-user friendly. The Explorer View is faster and easier.

Wim Lenaerts
"Jasper, maybe a bit of a general question but: Are you impressed by the evolution that SharePoint is making in the areas of document management? I had higher hopes for SPS 2013 (personally, mainly working in the ECM aspects of SharePoint). :)"

I have to admit to have no experience with other Document Management systems apart from SharePoint. The improvements in Document Management in SharePoint 2013 are indeed very minor but still very subtle:

  • You are now able to change managed metadata fields in the Quick Edit view
  • You can drag and drop documents in a document library
I know, no shocker here but it makes life a bit easier. I am really curious what your opinion is :-)

In case I missed any questions, please leave a comment.

Office 365 Saturday Europe 2013 - My presentation

I spoke at the Office 365 Saturday Europe about the following:

SharePoint Online 2013: A guideline to structure your documents within SharePoint Online
We all know SharePoint Online is a powerful platform with excellent Document Management features but do your end-users agree? They have been working with folders for many years and love working folder. This means it's harder to convince them about the power of SharePoint Online. During this presentation, I am going to share a guideline about structuring your documents with SharePoint Online. After this session, you can use this information to convert those stubborn end-users who have a long lasting love for folders.

You can find my presentation below:

Thursday, November 28, 2013

SharePoint Connections Amsterdam 2013 - Promo video

An amazing promo video just got released for SharePoint Connections Amsterdam 2013:


SharePoint Connections 2013 from Kinetal on Vimeo.

Really awesome job by Matthew Hughes and Jordan Saunders! You guys rock!

Tuesday, November 26, 2013

I'm Speaking at the European SharePoint Conference 2014

In case you missed it, the European SharePoint Conference 2014 programme is now available and I’m delighted to announce that I am speaking at Europe’s largest SharePoint event in Barcelona, Spain from the 5-8th May 2014.

I will be conducting a session on “External Collaboration with SharePoint Online” aimed at End Users and Business Decision Makers.

External Collaboration with SharePoint Online

During this session, I am going to talk about the SharePoint Online collaboration features that prove how easy it is to share content with external users. The session includes many demos and further valuable information to help businesses immediately start collaborating with external partners or suppliers. I am including my Surface RT tablet and Windows Phone in the demo to show attendees how you can collaborate with any device, anywhere and anytime! The session will contain up-to-date SharePoint Online features, including the new and improved integration with Yammer.



The European SharePoint Conference will be run over four days and will feature over 100 informative SharePoint sessions and 6 preconference tutorials providing you with a fantastic opportunity for learning and building your SharePoint skills. Check out the full Conference Programme to see all sessions and topics that are being covered by myself and world renowned SharePoint experts.

If you want to deepen your SharePoint expertise, to understand the trend of the SharePoint market, and to learn how to leverage Microsoft Office 365 for your business, including the revolutionary Enterprise Social wave, the European SharePoint Conference is the best place to be in 2014!

Prices start as low as €995! There is also special group discounts for bookings of 3 or more people.

Book Now and I’ll see you in Barcelona in May

Friday, November 22, 2013

SharePoint Connections Amsterdam 2013 - My presentation

I was very proud to be part of SharePoint Connections Amsterdam 2013. Its a great conference with amazing speakers and sessions. I talked about Best Practices Document Management in SharePoint (Online) 2013. You can find my presentation by clicking here or watching it here:



Don't hesitate to contact me with any questions.

From File Shares to Document Libraries

I wrote an article for the latest DIWUG E-Magazine. Click here to download the magazine in PDF format. The article connects with the webinar I did last September and my presentation at SharePoint Connections Amsterdam 2013. This is the introduction of the article:

"End-users love their files shares with folders, there I said it! There’s no denying it. They really
do; why you may ask? They have been working with folders for many, many years. It has
become a familiar face staring back from the monitor screen. End-users also find folders easy
to use; they know where to find their documents, even if this means browsing through many
layers of sub folders. Let’s be honest: it’s really easy to create new folders, pretty much child’s
play. That’s fine for them because they are used to it and have accepted this working method.
And here you show up, telling them folders are bad! Very bad! Metadata is the new cure for
finding and structuring documents by creating new columns, views, applying a taxonomy and
maybe even document sets (isn’t that a folder?). Just remember the look on your end-users
faces, when you are explaining this, because they aren’t buying it. This is a very common
scenario for every SharePoint Consultant. I have been there many times before. By writing
this article, I want to help you convince your end-users of the power of SharePoint Document
Management with useful tips and tricks."

I hope you enjoy the article and find it useful.

Monday, November 18, 2013

SharePoint 2010 - Users cannot edit managed metadata columns

I was working on a SharePoint solution for one of our customers. I created a couple term sets and connected these to corresponding managed metadata site columns. After adding the site columns to a SharePoint list I wanted to change the name of the columns. This wasn't possible because I got the SharePoint access denied screen! Very strange because I had all the correct permissions to the term store group. After searching on Google I found out that I didn't had permissions to a hidden list! This is the TaxonomyHiddenList. You can find this list by adding the following behind your site URL:

/Lists/TaxonomyHiddenList/AllItems.aspx

Check out the permissions of the list to see if the inheritance is broken. This often happens when sites are created with a custom solution. This was at least the case at our customer.


Wednesday, November 13, 2013

SharePoint - Create a link to export to Excel

For one of our customers I had to create dashboard with a few shortcuts to SharePoint actions. One of these actions is an export of a central SharePoint list to Excel. I thought it would be easier to add a link at the dashboard. Otherwise the end-users have to open the list and click two times in the ribbon. One click is always better than three ;)

This is the end result:



Pretty simple and straightforward but it doesn't always have to look fancy ;-) So how does this work?

The URL to execute the export is as follows:

{Site URL}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={List GUID}&View={View GUID}&CacheControl=1

You have to change the List GUID and View GUID corresponding to your SharePoint environment.

List GUID
Go to the List Settings and right click at Audience targetting settings and Copy shortcut. Copy the shortcut in Notepad and you find the GUID. For example:

https://contoso/_layouts/ListEnableTargeting.aspx?List={18cf5fa8-7256-4715-89f9-daa42ceef883}

View GUID
Go to the List Settings and click at the view you want to export to Excel. Copy the URL and past it in notepad. For example:

https://site_layouts/ViewEdit.aspx?List=%7B18CF5FA8%2D7256%2D4715%2D89F9%2DDAA42CEEF883%7D&View=%7BBE72746E%2D85DA%2D41AB%2DBB91%2D73941AF9DC10%7D&Source=%252Fsites%252Fsitename%252Fsitename%252F%255Flayouts%252Flistedit%252Easpx%253FList%253D18cf5fa8%252D7256%252D4715%252D89f9%252Ddaa42ceef883

A very long and confusing URL right? You can find the GUID after View=. In our case this is:

%7BBE72746E%2D85DA%2D41AB%2DBB91%2D73941AF9DC10%7D

There is an awesome site that can decode this long GUID. Go to: http://meyerweb.com/eric/tools/dencoder/

Now you can add your GUID:

<a href="https://sitename/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={18cf5fa8-7256-4715-89f9-daa42ceef883}&View={BE72746E-85DA-41AB-BB91-73941AF9DC10}&CacheControl=1&RootFolder=" onclick="GoToLinks(this) ;return false;" target="_self">Click here</a>

I hope you find this useful!

This post wouldn't have been possible without the help of  awesome SharePoint Community. I recommend checking the following sources.

Sources
http://www.formsonfire.com/office-365/create-link-to-export-library-contents-to-excel/
http://sarahlhaase.wordpress.com/2012/08/21/how-do-i-change-the-url-users-are-sent-to-after-they-fill-out-a-new-item-form/#comment-952

Thursday, November 7, 2013

SharePoint Online - My Site doesn't show profile picture

I had a strange issue within our Macaw SharePoint Online demo tenant. The profile picture of one of our users didn't show within the My Site:



I found it very strange that the picture appeared when I edited the profile picture field:


Weird right? What made it even weirder (is that a word?) was that the image was available within the webmail:


Strange right? To great thing about Office 365 is that you can ask Microsoft for support! I received the following solution:
  1. As an Admin, browse to Tenant Admin | User profiles.
  2. In the People section, click 'Manage user profiles'
  3. Search for a broken user.
  4. Edit the profile. Set 'Picture Exchange Sync State' to 0 and save the profile.
  5. Edit the profile again. This time, on the 'Picture' property, click 'Remove' to remove the picture from SharePoint.
  6. Edit the profile a third time. This time, set 'Picture Exchange Sync State' back to 1.
  7. Have the user browse to their My Site upload a new photo. (It may take some time for the cache to clear and this to reset)

This did the trick for me! Hope it helps you as well.

Wednesday, November 6, 2013

SharePoint and Yammer - The Yammer app

The Yammer App for SharePoint (Online) 2013

In this post I want to discuss the Yammer app for SharePoint (Online) 2013. The app has been available for a while (since June) but I never really got around to try it out! Since my previous two posts about the Yammer and SharePoint integration (click here and here), I am really interested in this integration and the possibilities it offers for the business. Let's take a closer look how the app works.

Installation process

I start by installing the Yammer App. I have to browse to the SharePoint Store:


The app is free and the only thing I have to do is click on Add it:


The installation process only takes a couple of minutes. After its done, I click on the Yammer tile:




The App has three feed options: Group, Home and Comment. Before we can choose a feed, I have to sign in:


I need to sign in once and approve the trust between my Yammer account and the SharePoint site:




The trust is enabled and I can choose a feed type:

Group feed


I have to select a Yammer network and an Group ID. The pop-up gives you a description how to obtain the ID. Got the ID? The feed appears:


This feed can be used when a team or department has a related Yammer group. For example, the Contoso Sales team discusses sales updates in Yammer and also have a SharePoint team site to store their documents. You can add the Yammer App in the SharePoint Sales team site. The users have the option to add new messages from Yammer:


The message appears very quickly in the Yammer SharePoint App:

Every user can also add messages, no surprise, from the app to Yammer.

Home Feed


To change the feed type an user with full control or contribute permissions can click on the wheel icon on the top right corner of the web part. This is something I will discuss further in this post but for now I will focus at the feed itself. I have to select one of the Yammer networks related to my account to view the home feed of that network:



Comment feed


The comment feed is comparable to the new Post feature. I can create a Yammer page to talk about any SharePoint object such as documents, pictures, sites or pages. For example:


After entering the link to the time-off policy document, Yammers creates a comment page:


The Post feature is really aimed, for now at least, at documents. By using the comment feed you can also discuss other interesting and valuable SharePoint objects. 

Issues

Although I really like the Yammer App and the features it offers, I have a couple issues with it.

Firefox 
My Firefox browser didn't like the Yammer web part at all! It's really unstable because it didn't show the sign in button:


Videos
I posted a link to a video in Yammer and a preview is generated. This preview disappears in the feed of the App.

Permissions to change the feed
I found it very unusual that every SharePoint user with contribute permissions is also able to change the feed of the web part. I can imagine that every site owner wants to display one feed and not letting users with contribute permissions change this themselves.

Wednesday, October 30, 2013

Yammer and SharePoint - Extend SharePoint search results with Yammer

SharePoint Search and Yammer

While I was writing my previous post about the Post feature between SharePoint and Yammer, I stumbled upon another cool new feature! Apparently, the search results are connected with Yammer:


I hadn't read about this new feature at all so I thought, let's click on Search on Yammer:


My default Yammer network opened and a search for the words SharePoint and Contracts was executed. The Yammer search results also have refiners available, these are the four tabs you probably noticed: Conversations, People, Files and Topics. Let's take a closer look at the refiners.

Conversations

I can easily follow the conversation of a particular SharePoint contract by clicking on View full conversations:


I can start a discussion, open the contract or click on one of the topics. Clicking on a topic starts a new search for discussions and documents related to the selected topic. 

People


All the users related to the two keywords are displayed. In this case only myself because of my job title SharePoint Consultant. This is a great refiner to find colleagues with a certain expertise or knowledge related to your search scope. Just click on the users name to open his or her Yammer profile:


Nice!

Files

All the files (documents) are shown with the two keywords, in my examples this is only contract. Be aware that only documents uploaded to Yammer are shown here! Not the documents you post from SharePoint to Yammer to start a discussion. I can download the document or go to the documents profile page:


I really like this profile page. You can easily browse through the document and there is even an option to leave comments in the document:



Awesome right? At least I think so! You can view the followers of the document (to connect and collaborate) or add related content. 

Topics


The final tab shows the related Yammer topics with the search results keywords. In my case the only topic available is SharePoint:


Another very nicely organized Yammer menu is presented. All the related topic conversations, files, notes, images, videos and links are available. Yammer is really a well made Enterprise Social Collaboration tool with many useful business features! This promises a bright future for the integration between SharePoint Online and Yammer. 

Integration with SharePoint

I do have one critical comment about this new integration. Yammer only shows documents uploaded to Yammer. It would be really nice to also see documents posted to Yammer from SharePoint so you can view the discussion about the document.