webTiger Blog

Add User Info To A SharePoint Connected Excel Report

When working with SharePoint list data in Microsoft Excel, it is often necessary to report based on user data (e.g. name, department, job role, etc.) and most of the time this information isn’t immediately available as User fields only store the user’s unique ID and extended metadata is not pulled in from SharePoint automatically.
Using A SharePoint User Profile PICTURE URL

SharePoint User Profiles provide a wealth of user data, but one of their most used properties is the profile picture. It can often be useful to be able to access this during custom development, and fortunately Microsoft have made it simple to access the profile picture simply via a URL.
SharePoint CAML Query Errors With “The underlying connection was closed…”

There can be many reasons for SharePoint CAML queries not working, but one of the most frustrating ones is “The underlying connection was closed: The connection was closed unexpectedly.” The connection from the client (CSOM/REST API) is just dropped. Debugging the issue can seem, at first, almost impossible as there is nearly no additional data…
Getting SharePoint Site Templates To Work On Different Environments

If you work with SharePoint custom site templates regularly, and your organisation has separated development, test, and production environments, then you’ll probably have come across the issue where a custom site template you’ve saved in one environment as a solution package (WSP) uploads and activates fine in another environment but then fails with the familiar…
How to Download Solution Packages From SharePoint

Sometimes the easiest way to resolve a missing SharePoint Solution dependency is simply to install it again. Often the solution package (WSP) is available on your development or test environment, but how do you download it from there? For sandboxed solutions, you can just go to the ‘Solutions’ section in Site Settings, but what about…
Fixing SharePoint Content Database Errors

Whenever SharePoint (SP) is patched tests are run on the farm’s content databases (CDB) to check for issues. In most cases, patching can proceed without adversely affecting the farm but it never hurts to have a perfect and functional an environment as possible before making any changes. This article guides you through how to manually…
How To View and Manage STALLED SharePoint Timer Jobs

Most of the time you shouldn’t need to get involved in anything like this, but upgrades/patches can often queue up one-time timer jobs that don’t get executed for some reason and can hold off other jobs (such as Add-in management) so they don’t run.
How to Fix SharePoint Services Stuck on Starting/Stopping

Anyone who’s done a reasonable amount of SharePoint administration will probably have come across services appearing to be stuck on a status Starting/Stopping. There can be many reasons for this, and this article aims to look at how to identify the cause and try to rectify it.
Introduction to the SharePoint Framework (SPFx)

The SharePoint Framework (SPFx) is Microsoft’s latest addition to the SharePoint development family. It is custom web-part and page extensions programming model aimed at replacing the over-used (and potentially dangerous) Script Editor Web Part (SEWP) and Content Editor Web Part (CEWP) in SharePoint Online (SPO) and recent versions of on-premise SharePoint too.
Enable the Site Collection Level App-Catalog on SharePoint Online

When developing SharePoint (SP) Add-ins, you will generally want to avoid having to deploy them to your SharePoint Online (SPO) tenancy’s public app catalogue until you are going to release them. Microsoft have catered for this and there is a way to enable a ‘developer’ app catalogue at site-collection level using some PowerShell commands.