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”

Dynamics – How to Setup Plugin Tracing in Custom Workflow Steps C#

This is likely a side-effect of me being rather new to coding in C# and coding CRM solutions however I came across an issue in that I needed to create some tracing on a plugin however I couldn’t add it as a parameter of the Execute function.

I’ll cover two ways to enable tracing within a custom plugin, the standard way which everyone suggests and a workaround which I used –

Continue reading “Dynamics – How to Setup Plugin Tracing in Custom Workflow Steps C#”

Dynamics – C# Input/Output Parameters Cheat Sheet

I’ve been doing some work on expanding Dynamics in order to create a solution capable of scheduling automatic reporting to email addresses recently (a very interesting subject) and found it difficult to find a complete list of input parameters for use in my custom workflow step.

Below I’ve included all the examples I’ve found –

Continue reading “Dynamics – C# Input/Output Parameters Cheat Sheet”

Dynamics – Can’t Modify Static Marketing List Converted from Dynamic List

I’ve been doing some work with marketing lists today and came across a confusing issue.

After converting a dynamic list to a static list so that one of our marketing users could selectively remove contacts for a marketing email, we realised we couldn’t use the ‘Manage Members’ functionality as it simply froze when processing any sort of query against members. After some head scratching we figured out why.

Continue reading “Dynamics – Can’t Modify Static Marketing List Converted from Dynamic List”

How to Create a Project Server Resource Utilization Report – #2 Setting up Pivot Table and Styling

This is a continuation of ‘How to Create a Project Server Resource Utilization Report – #1 Data Connections‘.

If you followed my last article on this you should now have an Excel file with a data connection to the Project Server which is half the battle, but now we’ve got to set up the Pivot Table to show something useful and we have to style it so that it will provide value at a glance.

This article will cover the full setup for the Pivot Table and getting it styled up to a useable format. Once done you’ll be able to easily extend this to show other useful info such as how much of your companies total resource is assigned to projects and the likes.

Continue reading “How to Create a Project Server Resource Utilization Report – #2 Setting up Pivot Table and Styling”

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”

Dynamics 365 – Business Process Flow (BPM) Not Appearing on Records

For those of you who have already done so or plan to migrate to Dynamics 365, there appears to be a bug with business process flows whereby they won’t appear on records. I’ve seen reports this is now fixed for online deployments but unfortunately there’s no such luck for those of us on-premise.

In this article I will hopefully fix the problem for you.

Continue reading “Dynamics 365 – Business Process Flow (BPM) Not Appearing on Records”

Dynamics 365 – Key not valid for use in specified state – Event 1309

This error will display in one of several ways depending on what you are trying to access, it can display as a generic “An error occurred” error to users upon login or it can display as something similar to the image below if you happen to have DevErrors enabled –

cryptographicKey1

ID1073: A CryptographicException occurred when attempting to decrypt the cookie using the ProtectedData API (see inner exception for details). If you are using IIS 7.5, this could be due to the loadUserProfile setting on the Application Pool being set to false.

 

It will also display as a Warning event with ID 1309 in the Event Viewer on the CRM server.

Continue reading “Dynamics 365 – Key not valid for use in specified state – Event 1309”

Dynamics 365 – “The instance name must be the same as computer name”

When installing Dynamics CRM on a server you may find you receive an error stating “The instance name must be the same as computer name”. This error refers to the SQL database which contains an invalid name for the server.

This normally only occurs when a machine has been renamed since SQL was installed however I’m sure there are numerous ways to cause this. It can easily be fixed however. Continue reading “Dynamics 365 – “The instance name must be the same as computer name””

4 Quick Wins to Improve Your Dynamics CRM Deployment

I thought it would be worth going over some potentially quick ways you can improve your CRM deployment. If you’re one of the many who has been working with CRM for a while now then you’ve undoubtedly developed new functionality, ‘improved’ forms and decided time and time again that you can improve the sales process in CRM, which is great, however there’s a tendency to avoid cleaning up old fields and the likes which can be a major frustration both for users and for those who have to manage CRM.

I’m going to cover some likely obvious but overlooked things that you probably need to consider doing, and then I’ll finish up by talking briefly about the built in maps functionality which can be a quick win with users and managers.

Continue reading “4 Quick Wins to Improve Your Dynamics CRM Deployment”