Pages

Friday, November 22, 2013

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.

Wednesday, October 23, 2013

Internet Explorer 11 and SharePoint 2013 issues

After updating to Windows 8.1 you automatically get Internet Explorer 11. Sounds nice right? Its not!


The new Explorer causes serious issues with SharePoint (Online) 2013:


  • Calendar web part is extremely corrupted
  • You will click Settings > Edit Page, Pages will not enter edit mode.
  • Web Part Properties cannot be modified.

Thanks to Bojan Buhac I found the workaround to fix these issues:

  1. Click Compatibility View Settings in Settings
  2. Click Add to add the current SharePoint site to your list.
Thanks dude! This is very embarrassing for Microsoft and a massive #FAIL!

Source
http://sharepointthing.wordpress.com/2013/10/09/problem-with-sharepoint-2013-and-internet-explorer-11/

Office 365 Power BI - An overview from and end-user perspective part 3

This is already the third post in my Office 365 Power BI series. You can read the first post here and the second post here. The last part, for now, in this Power BI series focusses on the Windows 8 app. Although I am not really a massive fan of the Surface RT anymore (doesn't always respons well and the lack of important apps), I do really like the Windows 8 app Microsoft created. Nowadays employees don't only work with their laptops or desktops but also have smart phones and tablets. You can imagine that employees want to stay connected with valuable data, anywhere and anytime!

Before I show you the app, you have to realize that the app is only usable as a demo, you aren't able to configure new data. Its really meant to provide you with an idea of the possibilities for your business. Let's take a look:


The main menu shows the two Excel examples we have seen in the previous posts. The restaurant and olympic scenarios. I decide to take a look at sales results for popular mix drinks:


I am not really interested in mix drinks but in the sales results for rum. To see these results I can use the filter at the top right side of the screen:



The only thing I have to do is click on Rum and the results immediately change. Let's say I am a sales executive, I now have a clear overview of the most popular rum and can make proper business decisions based on this data:


The results of the last three years are interesting for me to make a decision on our new sales strategy. Again, this is very easy by using the filter:


I can drill down even further by clicking on a brand of rum. In my example Bacardi:



My next interest is an overview of the bartenders selling the most Bacardi. Perhaps I can promote the bartender as a rewards for his or her good work. Every chart is clickable and opens up in a "new" screen:



I can use the filter to zoom in on Jeromes results:


He sold over 9k of Bacardi and is defnitely my best bartender!

The app has a lot of potential for business employees on the road who need to make quick and informed business decisions. I can also see the app being used in business meetings. At this moment there is no information how the app generates its data and how you can provision it. Or perhaps I have missed something ;)

I hope you got a good impression of Power BI through my posts. I am definitely very excited for the BI future of Office 365 and SharePoint Online.

European Office 365 Connect 2014 (GB263 for 10% discount)
SharePoint Connections Amsterdam 2013 (SP266 for 10% discount)


I also created a post with helpful Office 365 resources. Just click here.

Wednesday, October 16, 2013

Yammer and SharePoint Online - Post documents to Yammer

Introduction
Since the release of SharePoint (Online) 2013, I have been a massive fan of the new Social features. I wrote multiple blogs and articles about Social and SharePoint. A lot has changed, and is going to change, since Microsoft decided to acquire Yammer. Yammer is going to be the Social experience for SharePoint Online 2013. Yes, SharePoint Online and not SharePoint On Premises. Microsoft cannot force companies with a local SharePoint installation, for now at least, to start working with Yammer. Companies subscribed to Office 365 and SharePoint Online have to stick with the new release cycle and innovation controlled by Microsoft. That means the SharePoint newsfeed is going to disappear and be replaced by Yammer.



The integration between Yammer and SharePoint Online is starting to take shape. The Newsfeed link in the top navigation bar can be switched to Yammer. This has to be changed within the SharePoint Administration Center and can only be done by Global Administrators:


It takes up to 30 minutes to process this change. After this, you will be directed to the Yammer group you are logged in with in the current browser! This is very important to realize. You cannot set a default Yammer network for your SharePoint Online Portal. I hope this is going to be available soon because you want have one central company Yammer network for your employees.

One of the recently launched integration features is posting a document from SharePoint Online to Yammer. Let's take a look! I open SkyDrive Pro and want to share a customer contract to Yammer:



After clicking on the Post button, you have to decide where you want to share document. This can be with all your colleagues or a specific group. After posting the document, it gets a dedicated Yammer document page:


People can start discussing the content of the document or adding related documents and links. Please teach your end-users where to add a new reply. This has to be done under the first post and not in the top discussion field. Otherwise the following happens:


This gets a bit messy and ruins the main page. This is the way to do it:


The document is only accessible for end-users with the corresponding SharePoint permissions! Not every Yammer user can open and view the document. Every user with access to the document can open and edit the document in the browser. The document opens in SharePoint Online: 



This starts the collaboration with colleagues modifying the document and discussing the changes in Yammer. The document can be shared with other groups at any time:



I really like how this integration is taking shape!

Question
What happens with the document after its posted to Yammer? Is a copy also stored in Yammer? This is an interesting question because businesses want to know where their documents are stored. I think the document isn't stored in Yammer because when you click on the document it does open in SharePoint Online. I am not sure though.

Small issue
The Yammer document page has to option to add related documents. I wasn't able to upload a new document:



Nothing happened after uploading the document. Probably a temporary glitch?

I hope you liked this post and find it useful. My goal is to keep blogging about Yammer and SharePoint when new features arrive.

Source
http://blogs.office.com/b/office365tech/archive/2013/09/12/starting-yammer-conversations-from-documents-stored-in-sharepoint-online.aspx

Monday, October 14, 2013

Office 365 Power BI - An overview from and end-user perspective part 2

In the first part of this series, I introduced you to the new and awesome Office 365 Power BI. You didn't read it? Shame on you! Click here.


In this post I want to focus on working with Excel sheets in the browser. This option is available from the home menu:


Let's skip the Olympics sample, I covered it in the previous post, and go for the Retail example:


The sales results, per category, are displayed. The right side of the screen contains an easy to use filter menu. Let's narrow the results to the year 2010:


Immediately the 2010 sales results are displayed, cool! Let's say I want to see more information about beer sales. The Excel sheet has a tab called Sales by Item:


I want to see the sales on Domestic beers, between 2010 and 2012 on Saturdays. How do I do this? Again, this is really easy by using the filter:

We are now able to see the result:


Isn't this amazing? I am so excited about Power BI because its so easy to use! Every end-user, even the not very technical ones, can use the filters (or the ask feature) to find the information they are looking for. Before I finish this post, I am curious about one more scenario:

"What is the most popular mixed drink from the last three years sold on the weekend?"

To find the answer to this question literally takes me 30 seconds:


Long Island - Free Pour is the clear winner with 2764 items. That's not to bad at all but wait a minute, who is our best bartender? Selling the most Long Island drinks? Under Item Name I select Long Island - Free Pour and the clear winner is Jerome:


Power BI enables your employees to quickly analyze data, resulting in positive business decisions and strategies to let your business strive. Next week I will release the final post where I will show you the Windows 8 Power BI app.

Do you want to learn more about Office 365 and/or Power BI? You should definitely visit the following events:

European Office 365 Connect 2014 (GB263 for 10% discount)
SharePoint Connections Amsterdam 2013 (SP266 for 10% discount)

I also created a post with helpful Office 365 resources. Just click here.