Nov 11
SharePoint and 365 Tools

A collection of tools and projects that I have found very useful in managing SharePoint

AutoSPInstaller

The Swiss army knife of automated farm installation.

http://autospinstaller.codeplex.com/

SharePoint Search Query Tool

Build search queries with hints for parameters and view raw results. Great tool for troubleshooting display templates and Content by Search web part

http://sp2013searchtool.codeplex.com/

Search Topology UI for PowerShell

Simple UI to help understand the current search topology and update it.

https://blogs.technet.microsoft.com/scottstewart/2015/04/29/powershell-ui-to-modify-sharepoint-search-topology/

Graph Explorer

Graph explorer is a web application for exploring Microsoft Graph Rest API with autocomplete.

https://graph.microsoft.io/en-us/graph-explorer

Nov 30
Enterprise apps, what a joke

Trying to add an OOTB list to my site but cats are getting in the way

The only filter for all the apps available is by Newest and Name. You would think "Built-in apps" would be helpful when IT have decided to make 240 apps globally available

Oct 05
Search Ranking Model ID’s in SharePoint 2013

If you are using a tool like the SharePoint 2013 Search Query Tool it is useful to know the ranking model GUID's so you can see the effect of using different models.

Unfortunately the field example used in this tool uses the GUID for O14 Default Search Model so the results will not match what you see in the OOTB search results.

Below is the list of GUID's extracted using the PowerShell command Get-SPEnterpriseSearchRankingModel -SearchApplication $ssa -Owner $owner

Ranking Model type

Model Name

ID

General Purpose

Default Search Model

8f6fd0bc-06f9-43cf-bbab-08c377e083f4

General Purpose

Search Ranking Model with Two Linear Stages

5e9ee87d-4a68-420a-9d58-8913beeaa6f2

General Purpose

O15 MainResultsDefaultRankingModel

9b911c3e-78e1-4b99-9b1f-a69d3691bdd1

General Purpose

O14 Default Search Model

9399df62-f089-4033-bdc5-a7ea22936e8e

General Purpose

Search Model With Boosted Minspan

97cbcebd-037c-4346-9bc4-582d8c560204

General Purpose

Search Model Without Minspan

df3c3c51-b41f-4cbc-9b1a-c3b0ed40d4f0

People Search

People Search application ranking model

d9bfb1a1-9036-4627-83b2-bbd9983ac8a1

People Search

People Search expertise ranking model

c8bdd081-7379-4c71-aac8-61b6aa6e25a6

People Search

People Search expertise social distance ranking model

02b657fe-924f-4b2b-bb91-4a12baf9929a

People Search

People Search name ranking model

0bba4d7d-4f2c-4086-975a-8f9d2b6c6d53

People Search

People Search name social distance ranking model

5df7ba10-55d6-4da1-b55f-896f7bcb486b

People Search

People Search social distance model

4790b250-e2af-4e4a-8136-600739ee3163

Special Purpose

Catalog ranking model

ca2a10ff-6f63-4913-a125-34b5894495f4

Special Purpose

Popularity ranking model

d4ac6500-d1d0-48aa-86d4-8fe9a57a74af

Special Purpose

Recommender ranking model

b63ad0fd-3ab4-490d-b556-379dc4a52422

Special Purpose

Site suggestion ranking model

9e09f192-e036-422f-ad3b-534574e8f894

 

More detail on each of the ranking models can be found on the Microsoft Technet site https://technet.microsoft.com/en-us/library/dn169065.aspx

Aug 28
SharePoint Office Integration in Chrome no longer works
Apr 16
The Top 20 SharePoint Powershell Commands

According to Bing, the following 20 are the top SharePoint commands search for:

Get-SPWeb

163000

Get-SPSite

90200

Get-SPWebApplication

43900

Add-SPSolution

31000

Get-SPFarm

26200

Enable-SPFeature

22400

Export-SPWeb

19700

Get-SPServiceApplication

18000

Get-SPEnterpriseSearchServiceApplica...

15800

Backup-SPSite

14800

Add-SPShellAdmin

14400

Get-SPUser

14400

Get-SPServiceInstance

13700

Backup-SPFarm

11400

Get-SPDatabase

11100

Get-SPContentDatabase

11000

Get-SPFeature

10200

Get-SPManagedAccount

10000

Disable-SPFeature

8720

Add-SPProfileSyncConnection

8240


No surprises really. See the full list of 819 commands here…

Sep 24
Embed code workaround for Excel Web App

In SharePoint (on-premises or 365), you can get the embed code from a word or PowerPoint file and insert that in another page with the </> Embed Code ribbon command.

Unfortunately Excel Web App doesn't provide the option to generate this embed code. Fortunately you can create this very easily yourself.

Just get the URL for the Excel file and add ?web=1 to the end of it. This will give you the code that you place in a "</> Embed Code" by creating an iFrame from the Insert Ribbon of a publishing page, wiki page, blog article, discussion item, etc.

The embed code will look like this…

<iframe src="http://yoursite/Priorities.xlsx?web=1" width="100%" height="400px"></iframe>

It is possible that Excel Web app is not available if Excel Services is the default for viewing Excel files (A farm wide setting), in which case there is a Web Part called Excel Web Access which can be added to a page (Enterprise Site Features must be enabled).

Jun 13
SharePoint 2013 default permission levels may shock you

To save time, SharePoint pre-defines different combinations of permissions. These pre-defined permission levels are known as the "default permission levels".

SharePoint 2010 provided a default SharePoint Group called "Members" which was assigned the "Contribute" permission level. This is the group would would assign most users to who would be creating and editing documents in predefined libraries.

This level includes all permissions in Read , plus:

  • View, add, update and delete Items
  • Delete Versions
  • Browse Directories
  • Edit Personal User Information
  • Manage Personal Views
  • Add/Remove Personal Web Parts
  • Update Personal Web Parts

In 2013 the "Members Group" permission level has change to "Edit".

This level includes all permissions in Read, plus:

  • View, add, update and delete Items
  • Add, Edit and Delete Lists
  • Delete Versions
  • Browse Directories
  • Edit Personal User Information
  • Manage Personal Views
  • Add, Update, or Remove Personal Web Parts

So now the users who we intended to just manage files in predefined libraries can also delete and create new libraries! In a well-controlled SharePoint environment where libraries have been created with default metadata based on a taxonomy, the ability to create new "rogue" libraries is undesirable.

1 - 10Next

 Image Viewer

About this blog

I've been working with SharePoint since Team Services v1 and Portal Server 2001. After 10 years working for Microsoft NZ I joined Information Leadership, a leading SharePoint implementer of IM, KM and records management solutions.
Information Leadership