SharePoint – How to Modify SharePoint Lists and Libraries Using PowerShell

I had a request to rename roughly 100 libraries in our SharePoint deployment recently and thought it would be a good time to dig into a bit of PowerShell.

In this post I’ll demonstrate how to loop through site collections, subsites, lists and finally how to filter and change a name of a list and I’ll also attempt to show a few interesting properties we can change.

Continue reading “SharePoint – How to Modify SharePoint Lists and Libraries Using PowerShell”

How to Create a Project Server Resource Utilization Report – #1 Data Connections

I’ve recently been doing some work on creating a Resource utilization report based on data taken from Project Server 2013. The requirement was that it should stay up-to-date with project Server and should be able to show at a glance when resources were overbooked.

In this article and potentially a few others I plan to cover every required step from creating the data connection to formatting it all in a useable format, what you will end up with will be a report similar to the report in the image above or below using an OData Query –

Continue reading “How to Create a Project Server Resource Utilization Report – #1 Data Connections”

Why you should avoid folders like the plague in SharePoint

In this article I hope to cover a few reasons why you should avoid using folders in SharePoint. In a perfect world there would never be a need for folders in SharePoint as every user would correctly tag up every document and the system would perfectly sort the documents into the correct area then display it to every user perfectly, however this is the real world and there are quite a few reasons you may want to or be forced to create folders.

My aim is to make you pause and consider if you really need to create that folder before you do though.

Continue reading “Why you should avoid folders like the plague in SharePoint”

Firefox no longer compatible with SharePoint 2013 after latest update (52)

A quick note for those who use Firefox as their default browser of choice, Firefox’s latest release (52.00) is no longer compatible with SharePoint. This is due to Firefox removing any support for addons not coded in Flash, the effect of this is that the Office plugins used primarily to create new documents in SharePoint is no longer able to run meaning you’ll run into errors if you try to create new documents using Firefox.

Continue reading “Firefox no longer compatible with SharePoint 2013 after latest update (52)”

SharePoint Calculated Column and Nested IF’s Limitation Cheat Sheet

I thought I would gather some information on the limitations of calculated columns and nested if statements in different SharePoint versions. This is just meant to act as a really basic limitations cheat sheet which I’ll update if I find out anything new.

Continue reading “SharePoint Calculated Column and Nested IF’s Limitation Cheat Sheet”

Fixing Broken Links in SharePoint – QIPoint Broken Link Manager Review & Guide

I recently had the fortune of QIPoints founder coming across my blog and commenting that his company offered a piece of software called the “SharePoint Essential Toolkit Broken Link Manager” which is an enterprise equivalent to Microsoft’s own free tool “Search Engine Optimization Toolkit” which I’ve covered before.

Although the plan originally was to review the trial version which as far as I could tell came with a few limitations based on the quantity of documents and sites searched, I was very kindly offered an enterprise copy to give an accurate review of the software’s features and with their new 2016 edition out I couldn’t pass up the chance.

This post will be both a quick review of the newest version for those of you looking for that and also a basic guide to using the software for those of you who have already purchased this product if there is anything I don’t cover in this post that you would be interested to see don’t hesitate to comment below.

Continue reading “Fixing Broken Links in SharePoint – QIPoint Broken Link Manager Review & Guide”

How to Stop CRM Adding the GUID to SharePoint Folder Names (Documents)

CRM has a very useful feature called Documents which allows you to link a CRM and SharePoint deployment in order to store customers documents in SharePoint however with the update to 2013 Microsoft decided that all folders will include not just the records name but that records GUID.

I had a request recently to stop CRM adding the GUID of account records to newly created SharePoint folders and it was surprisingly difficult to find any useful advice. Below I will cover the basic steps required to disable this ‘feature’.

Continue reading “How to Stop CRM Adding the GUID to SharePoint Folder Names (Documents)”