• Our Office
  • 12 Alpine Close Lakefield Benoni 1501

Blog

Unable to obtain master key

Experienced this on SharePoint 2016 when managing the Secure Store Service. Service also show error when viewing Service Application list in Central Admin. To resolve just manage Service Application and REFRESH key using your original Secure Store passphrase [...]

Read More

Useful Chrome Extensions

New Identity – https://chrome.google.com/webstore/detail/openmultilogin/plaahcaagklllbcjognjgcnldgjnjhpb?utm_source=chrome-app-launcher-info-dialog Page Load Time – https://chrome.google.com/webstore/detail/page-load-time/fploionmjgeclbkemipmkogoaohcdbig?utm_source=chrome-app-launcher-info-dialog ColorZilla – https://chrome.google.com/webstore/detail/colorzilla/bhlhnicpbhignbdhedgjhgdocnmhomnp?utm_source=chrome-app-launcher-info-dialog Page Ruler – https://chrome.google.com/webstore/detail/page-ruler/jlpkojjdgbllmedoapgfodplfhcbnbpn?utm_source=chrome-app-launcher-info-dialog Image Size Info – https://chrome.google.com/webstore/detail/image-size-info/oihdhfbfoagfkpcncinlbhfdgpegcigf?utm_source=chrome-app-launcher-info-dialog [...]

Read More

Lists.UpdateListItems and Person Field

The Lists.asmx web service enables you to CRUD items on a SharePoint list (https://msdn.microsoft.com/en-us/library/lists.lists.updatelistitems(v=office.12).aspx) The default options for the person field however does not work e.g: i:0#.w|domain\username Display Name domain\username Email To make it work pass one of the following: Single user = [ID];#[Person] Multi user = [ID];#[Person];#[ID];#[Person];#[ID];#[Person];# -1;#Display Name [...]

Read More

SharePoint App Disappearing

We have been developing a SharePoint 2016 on-premise which we deployed quite a few times to work through some bugs and issues. Every time you publish a new version you need to delete the App from the sites and re-add it to the page where you want to use it. [...]

Read More

SharePoint REST API

Had some issues before using the SharePoint REST API, well, actually using the jquery implementations. Been struggling with the basics to get user profile properties. Some methods and examples suggest you get the PeopleManager class, pass the user (which then differs from onsite to O365). If you are just after [...]

Read More

Find something in a SQL Database

Previously posted about finding content in a SQL Stored Procedure. Here is a nice script that creates a new Stored Procedure called SearchAllTables that will scan all tables and columns for a string input: CREATE PROC SearchAllTables ( @SearchStr nvarchar(100) ) AS BEGIN DECLARE @Results TABLE(ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET NOCOUNT [...]

Read More