Knowledge Management from support tickets

KMTickets-headerNow that we have launched our intranet we constantly receive questions and support tickets from our users. That is not exactly a surprise, as we know that our current intranet is vastly different from our old one. We have SharePoint Online versus SharePoint 2007 and a completely new governance.
We learn a great deal about our users and our environment from these tickets and the discussions in our dedicated Yammer group.

Of course my team knows that I am into KM, so I am currently in a small “Virtual Expert” group on knowledge sharing. Our goals is to “translate experiences into knowledge”.

That sounds pretty formal, but it is quite simple really. And you know, I like simple, especially when it is about KM.

How it works

KMTickets-process

Whenever we receive an incident, we assign it according to the type of incident. This allows every one of our team to learn about a specific topic or process, and to improve the process or generate knowledge about this topic.
For instance, for a time all incidents dealing with permissions were assigned to me.
When I had gained sufficient knowledge of common permission issues, either by searching online or by doing experiments, I wrote work instructions for the rest of the team. Permissions issues (provided we recognize them when the tickets come in 🙂 ) can now also be assigned to others as we have a common procedure.
Yammer questions that can not be answered by the community receive similar treatment: we do online search and experiments where needed. (Although we ask people to submit a ticket when it looks like something in their site is broken)

We have a regular call to discuss any new and interesting issues.

When we run into a problem that we can not solve by searching online or doing an experiment,  we ask our very knowledgeable tenant admins. They show or tell us when they know the answer. My colleague and myself then turn this knowledge into documentation – be it a work instruction for the support team, a manual or a tip for end users, or sometimes a suggestion for extra communication or even a change to the system settings.

Most materials are stored on SharePoint: in our own team site or in the site we have created for end users.

Love all around!

KMTickets-LoveI love this structured approach. Our manger, who is very much into service delivery, formal processes and stuff like ITIL, appreciates the process we are going through.
Our tenant admins like to share their knowledge, knowing this will free them up to do tenant admin stuff.
My colleague and I have great pleasure in capturing knowledge and turning it into something tangible that helps us do our work faster.
The rest of the team is happy to have good work instructions.

SharePoint Holmes

It may be a small process, but it works for us and we enjoy the benefits.  And you…you see the SharePoint Holmes cases! 🙂

Header image courtesy of Kimberley Farmer on Unsplash.com

Advertisements

SharePoint Holmes and the Pesky Permissions

SH-Pesky-ByOllieArteThe case

“This user is losing her access all the time”, the site owner said. “She keeps getting an access denied and then asking me for access”.
Now I know that SharePoint permissions can be a bit of a nightmare, but I have not come across situations where people who have access, suddenly lose that without any actions on the side of the site owner or manager of the permissions group.

The site owner told me he had added her to a group in his site. This group needs Edit permissions to the Commercial documents, a document library with confidential information.

“When she gets that access denied message, do you find she has disappeared from that group?” I asked him, but he did not know that.  Not very helpful, but a site owner should not have to be a detective, of course; things should just work.

So…time to get my Detective paraphernalia out of the closet and set out on a hunt for clues.

The investigation

    1. First step: site permissions.
      The group was called L1-CommercialTeam, with Read permissions.

      SH-Pesky-Site permissions
      I still have not figured out why permission levels are mentioned in Dutch, but trust me: The L1-CommercialTeam has Read access on this site.

      That looked OK, knowing she would have Edit permissions on one library. And indeed, when I looked at the “Users with Limited Access” I saw this:

      SH-Pesky-LimitedAccess
      Limited access because this group has Edit permissions on one document library.
    2. I checked the settings of the group. The user was a group member. The owner of the group was the site owner group, so there were no other parties who might have been messing about.
    3. I checked the permissions of the group: Read + Limited Access on the site, Edit on the document library. OK.
    4.  I checked the permissions for the library with confidential information. Indeed, the group had Edit permissions there.

      SH-Pesky-LibraryPermissions
      Enter a caption
    5. So, everything looked OK. What could have gone wrong? It is extremely hard to solve things that “occasionally happen” so I needed some time to think about next steps.
    6. I decided to have a look at all the permissions in the site, knowing that things can be more complicated than you might think at first sight.
      That was interesting: all 3 document libraries in the site had unique permissions, but the L1-CommercialTeam only had access to the Commercial Documents.

      SH-Pesky-Uniquepermissions
      All document libraries in this site have unique permissions
    7. I contacted the user and she confirmed that the she got the access denied when she wanted to go to the other document libraries.
    8. I contacted the site owner and asked him when he had created the Commercial Documents library and the group  – this had been done recently.

The solution

As the unique permissions in the other document libraries had been created before the L1-CommercialTeam group had been created and added to the site, the L1-CommercialTeam did not automatically get access to those libraries.

I informed the site owner about the permissions in his site – that all libraries had different permissions and that the user had requested access to the two libraries that she did not have access to.
He had inherited the site from a predecessor and was not aware of the unique permissions.
Besides, as the group appeared to have Read permissions at site level, he thought the group had access to everything. I can not blame him, really.

He gave the L1-CommercialTeam access to one library, and re-inherited permissions to the other. No access denieds have been reported since.

So, dear site owner, please check the unique permissions in your site on a regular basis. SharePoint Online has a very useful link on the site permissions page, which has turned into my new BFF:

SH-Pesky-Showtheseitems
This link allows you to see all libraries and lists with unique permissions, as well as libraries and lists that contain items with unique permissions.

 

About SharePoint Holmes:
Part of my role is solving user issues. Sometimes they are so common that I have a standard response, but sometimes I need to do some sleuthing to understand and solve it.

As many of my readers are in a similar position, I thought I’d introduce SharePoint Holmes, SharePoint investigator, who will go through a few cases while working out loud.

Image courtesy of Ollie Olarte.

Dear user of our intranet

DearUserbyStuartMilesThis morning I received your support ticket.

Many thanks for enclosing the complete email chain with all your colleagues. Apart from a good permissions puzzle, there is nothing I like more than going through a 40-message email chain, and find the hidden clues between the “FYI” and “Can you help” forwards. I am really pleased that you have tried to get help from so many people before logging a call in our incident system, and it is heartwarming to see your colleagues’ empathy and desire to help.

From this wonderful meandering narrative I understand that “editing the Monthly Forecast in the Marketing site does not work”. That narrows down the possibilities, because only 938 of our approximately 15.000 sites have Marketing in the title, so it will save me going through 14.062 sites which are definitely not called Marketing.

Now of course I assume the Marketing site has “Marketing” in its title 🙂

From the company address book I see that you work in the Dairy division, which has 297 Marketing sites, so I can increase the odds even further.

Then it is only a matter of finding a Monthly Forecast document in one of these sites and checking which one does not work. That should not be too difficult: I did a Search and found 6274 hits on Monthly Forecast – it is matter of checking URL’s against the Marketing sites to see which are eligible.

I assume you wanted to edit a recent document so will start from the most recent.

In conclusion, I will check the cross of Dairy Marketing sites and Monthly Forecast docs from the last 2 months, and see which one of them “does not work”. Now of course there are many ways of “does not work”, but do not worry, I will check them all, from permissions to document library opening behavior, checkout, and workflows to corrupted documents.

I have planned about two weeks to go through this and I am quite looking forward to this challenging quest!

However, should you be in a sort of hurry, or have a deadline, please let me know. After all it is the 21st already and I can imagine you will need to update this document before the end of the month. Sending me the URL of the site, the name of the document and the document library/folder it lives in, as well as a description of what you were trying to do and what happened, possibly even with a screenshot of the error message, will reduce the quest to an hour or so. Of course this will rob me of the fun of exploring this all by myself, but I know that this is business-critical content so I can not be selfish.

Looking forward to your information,

Best regards,

The Helpdesk.

Image courtesy of Stuart Miles at FreeDigitalPhotos.net

SharePoint Holmes and the Embedding Enigma

SH-ObjectDetectiveSmallMy SharePoint Holmes cases are not extremely technical or complicated. Most of the solutions to the issues that I encounter have been amply described in blogs and Microsoft support. So why do I sometimes feel at a loss when I have a new issue to solve?

  • I am still learning about SharePoint Online
  • Users generally do not know what the issue is and they do not use the most precise language. Nobody likes an issue that stops you doing your job and calls for submitting a support ticket, so I can imagine you want to spend as little time as possible on that ticket.
  • As a result, things may have a different cause and solution than I expect from the description. I may think that it is permissions-related (I often do), while it may be PC, browser or document library settings. Or vice versa.

For instance “I can not manage my site” (to me, this sounds like a permissions issue) has meant different things in different circumstances:

  1. “I can not edit my site’s homepage” (because the page has been checked out to someone else – this is a document management issue, not a permission issue)
  2. “I can not manage permissions” (because I am not the owner of the group I want to manage – a permissions issue)
  3. “I can not manage this content in my site” (because this content has unique permissions and for one reason or another I am not in the site owner’s role here  – a permissions issue)
  4. “I do not know how to manage my site” is a training issue

With this SharePoint Holmes series I try to start with the issue as described by the user. As that is not always clear or correct, I sometimes start off on the wrong foot.

The case

“Hyperlinks in a document on SharePoint are not working” the title of the incident read.

Well, “not working” or “is broken” are always great and accurate descriptions that any support person loves to see 🙂 . So I called the owner and asked him to demonstrate the situation.

The issue was with a manual (in Word) that lived in a document library.  The document had some embedded documents as well as some hyperlinks to a company system.

The real problem was: “In this document, the embedded documents as well as some specific links can not be opened – they appear unclickable”

The investigation

    1. I opened the manual – I noticed that the document opened in Online format.
    2. I clicked on a number of links – all links to pages worked OK but I could not open the embedded docs. There was no “hotspot” or “zone” where the cursor showed something clickable.

      SH-Object Online
      The embedded Word document was not clickable
    3. The special links (to a certain system) looked properly configured, but they gave an error message.
    4. I could not find anything strange in versioning settings (no mandatory check out) or advanced settings. The opening behavior was set to “use the server default (open in the browser)” which is standard practice.
    5. I determined to take a better look at the document, because only that document caused the issue. I did not want to make changes to the content, so I downloaded it.
    6. I opened it in Word. The embedded documents could be opened – they had an active window. And I could open the special links too!

The solution

OK, this was easy. I changed the library’s opening behavior to “open in the Client application” and opened the document again. Yes, the embedded documents and the links were now clickable and opened without problems.

SH-Object Client
An active zone appears around the embedded document when opening the document in Word

I can not explain what was happening with the links but they could be opened in the Client software.

This is yet another illustration of the fact that the Online versions of the Office programmes are limited in functionality.

The owner of the manual was happy, but I suggested to upload all embedded documents into the document library and making links to them from the “Master Document”, instead of embedding. If they are in a document library, you can manage and update them online when needed, and the link in the Master document will always lead to an up-to-date document. If you embed the document, it will live on its own and there will be no history of changes or anything.

Which issues with the opening behaviour of document libraries have you encountered? (Apart from my earlier password-protected document case)

Image courtesy of Craig Whitehead on Unsplash.com

The Intranet Treasure Hunt

Treasure Hunt - PongWhen we launched our new intranet at the beginning of 2017, we also set up a Treasure Hunt to make people familiar with the new look and feel and setup. After all, moving to SharePoint Online has been quite a large step from our old SharePoint 2007 environment.

Many intranet folks have talked about doing treasure hunts, but as far as I know nobody has ever explained what they have done in detail, so let me share our recipe.

The ingredients and preparation

  1. A News article to introduce the Treasure Hunt
  2. A News article with clues and a direction to the next place of the hunt
  3. More News articles or intranet pages with clues and directions – as many as you need
  4. Emailaccount of our Founding Father
  5. Autoreply message from Founding Father
  6. Yammer message
  7. A page where people are instructed how to enter their solution
  8. A survey to collect the solutions
  9. The solution: in our case a sentence that people had to create with the clue words
  10. A thank-you page with information about the next steps
  11. Prizes

 The mechanics

A few days after launch, a News article (1) appeared on the new intranet homepage. It explained the treasure hunt and the mechanics. You were to look for clues to the next place and for words that were written in a certain way, e.g. <word>.
The words you would find during your search would form a sentence.

Treasure Hunt Announcement
The first announcement about the Treasure Hunt

The first clue was to find the oldest News post on the intranet. As we had not migrated older News articles that was not so hard to find. The oldest post (2) turned out to be a post written by our Founding Father.  It was full of hope for the future and predicted with remarkable accuracy some inventions we would do later 🙂

Treasure Hunt - all news
It was easy to find the oldest News item!

Of course there was another <word> in his post. At the end he asked to send him an email asking for guidance. As his contact details were on the page (as is the case for all News items) (3) it could be done with the click of a button.

Treasure Hunt Oldest News
This is SharePoint News, slightly different than our own custom News setup, so I can not show you the Author button + email link (but I trust you will get it)

When you sent him the email you received an autoreply (5). He sent you to the “modern watering hole Yammer”, where we were to look for a post from one of our senior management about a certain topic.

Treasure Hunt Email
The email message – I quite liked the “Eternity Leave” that our Comms people came up with 🙂

On Yammer, it was easy to look for that certain person (once you knew how to search) and the message (6) in question. Once again, it contained a <word> or two and a link to the next clue.

Treasure Hunt - Yammer
This Yammer message sent people to the new Policies & Procedures site, where you were asked to follow the IM page for later reference. (When will Yammer have a proper text editor?)

After sending you to a few other important new sites (with <words>) and asking you to follow those pages, the last link led to a page (7) which welcomed you to the Treasure hunt and asked you to

  1. Set your News preferences
  2. Make sure you had uploaded your profile picture
  3. Click on a link
Treasure Hunt- entry page
The last part of the journey

The link led to a survey (8) with two questions:

  • Create a sentence (9) with the <words> you have found. The sentence was one of the company values, so not too hard to compose once you had the words.
  • Describe why you should get the prize. (That was an easy one for me: I said this treasure hunt would not have been possible without me – as I created the pages & survey).
Treasure Hunt Survey
The survey

After clicking Finish you would go to a thank-you page (10) with more information about the publication of the winners.

Treasure Hunt-Thank you page
The Thank-you page – I like to use this with surveys

All in all, by doing the treasure hunt people have been exposed to:

  • Finding News
  • Setting their News preferences
  • Going to Yammer and finding a person’s conversations
  • A number of new sites with important company-wide information
  • Following sites
  • Adding a picture to your profile

This was a very simple setup, but of course you can extend it as you like.

(Disclaimer: I have replicated this on my own tenant in a schematic way. Our real Treasure Hunt looked much better and the texts were created by communication professionals)

BTW, Sadly I did not win any prize as I was part of the organizing committee 😦

The <words>  in my screenshots form a sentence as well…please add it to the comments if you have found it! (again, exclude <word>)

Image courtesy of Pong at FreeDigitalPhotos.net

SharePoint Holmes and the Missing Metadata

SH-MissingMetadata

After all the recent permissions issues it was nice to get a Document Management case for a change.

The case

The issue was: “Every time I edit a document and save it, it is checked out and we need to check it in again and add the metadata. We have not set mandatory check-out in this library – what is going wrong?”.

I put on my SharePoint Holmes paraphernalia and set out to solve yet another case. Or so I hoped 🙂

The investigation

  1. I looked at the recently edited document. Indeed, the document was checked out with the yellow box where the metadata should have been.

    SH-MissingMetadata-ClientLibrary
    The document was checked-out and missed required metadata.
  2. I checked the Library Settings. Set to modern view, to open documents in the Client application, indeed no check out required. The “Topic” field needed a value.
  3. I uploaded another document and edited it without any issues – the document stayed checked in and retained the metadata. I edited the properties, no problem.
    Hm.
  4. I selected the checked-out document to view the properties. I quickly scrolled down the details pane to see the metadata. Yes, no topic selected, as expected.
  5. I Googled on the check-out issue as I had no clue what happened here.
    The solutions all pointed to something with “metadata” so I selected the document again to have a closer look at the metadata, and hoped that permissions and edit history would provide some extra clues.
  6. Someone called me on Skype so I left the details pane open without scrolling down.
  7. When I came back from my call, the answer stared me in the face.

    SH-MissingMetadata-NoPreview
    No preview available – aha!

The solution

I had seen this “No preview” message before on a password-protected Excel file. The owner confirmed this.
After some searching I came across several posts describing this behaviour. Apparently, SharePoint does not only respect the content of a password-protected document, but also the metadata. Hence, you have to re-add the metadata after each edit.

A request to change this behaviour has been submitted to Office 365 User Voice.

I discussed with the owner whether password protection was really needed as SharePoint has its own protection. As it turned out, the people who had the password were the same people who had access to the document and the document library, so she decided to remove the password.

I also checked what happens if this would have been a document library that opens documents in the Online version.
First, you get a warning message:

SH-MissingMetadata-Online

 

After editing in the client, you have the same result in the document library: the document is checked out and has missing metadata.

Another reason not to use password-protected documents in SharePoint!

Image courtesy of Simon Howden at FreeDigitalPhotos.net

Not intranet promotion videos

Video-funselectionRecently I have come across some videos which do not entirely qualify as intranet launch or promotion videos, but which are still nice or interesting enough to share.

Intranet product promotion

This agency has created a number of humorous clips, to promote their Office365-based intranet product. I like their series of clips which look based on the work of Roy Liechtenstein and appear to use the hyperbolic text and voice-over of the videos from Velux and Argos.

The Intranet Manager of course:

 

But they also feature some other intranet stakeholders:

Communications Director

HR Director

Finance Director

CIO/Director

Naming contests

Jeremy and Bill from Rain City Housing are running a naming contest for their new intranet. You can no longer enter or win the prize, but fortunately you can still enjoy their cheerful video:

Doherty Enterprise, a restaurant chain, is also working on their new intranet. And from the video this appears to be really long-needed! You can vote for a name:

 

Halloween

This video of the ‘spookiest SharePoint intranet you’ve ever seen” was uploaded at Halloween. Don’t do that, folks, this can only end in a bad way!

 

This one is a tad longer (36 minutes) and will take you through internal comms mishaps of which a Document Graveyard is only one!

Office365 Use Case

Interesting comparison between various collaboration tools compared to the Office365 suite, where two agencies pitch for work. Can you predict who will win? 🙂

 

Intranet is child’s play…

And this is an older one explaining the benefits of a social intranet over email. It was quite widely shared 5 years ago but for all newbies: isn’t this cute?

There are some more in this series:

Repetitive questions? Time for a social intranet!

Adopting Interact Intranet – It’s Child’s play!

I hope you enjoyed these! And remember, my collection of intranet promotion videos can be found on http://ellenvanaken.video

(And please upload your own intranet promotion video to YouTube or Vimeo and let me know the link – or let me know when you have a nice candidate for my collection)

Camera image by Alvimann on Morguefile.com