» Joe

Publish to file system with MSBuild

Posted on by Joe in Uncategorized | Leave a comment

I’ve taken this directly from a stackoverflow question but adding it here for reference. Below shows the magic parameters to use to build either a solution of project file and and output to a directory. For a project file And for a solution

Remove nuget packages from a project in Visual Studio and restore from packages.config

Posted on by Joe in ASP.NET, C#, Visual Studio 2008 | Leave a comment

I was recently in a situation where I multiple projects in solution that needed the same nuget packages, but a lot of unnecessary packages had also been added. Firstly I wanted to quickly remove all of the nuget packages in a single project which can be done by entering the following into the Package Manager Console. Next I added just the packages I needed to that one project. The next step was to quickly update all of the other projects …

Stop Sitecore WFFM including bootstrap CSS

Posted on by Joe in Sitecore | Leave a comment

Later versions of WFFM will include a reference to the bootstrap CSS with MVC forms. This may conflict with your own styling and cause layout issues. Fortunately this can easily be disabled with a config value. The sitecore setting is called ‘WFM.EnableBootstrapCssRendering’ and can be found in App_Config\Modules\Wffm\Sitecore.MvcForms.config. Setting this to false will stop the reference.

Easy SQL duplicate row detection using Common Tables Expressions

Posted on by Joe in SQL Server | Leave a comment

Here’s a simple way to identify and/or delete duplicate records from SQL Server where you can choose which columns are using to identify the record as a duplicate. What this is doing is creating a Common Table Expression and adding a row number column where the row matches the columns defined  in the partition. In doing that each defined ‘duplicate’ record has a incremental row number. You can then delete all those where the row number isn’t 1, which removes the …

Thoughts on the Sitecore Experience Accelerator (SXA)

Posted on by Joe in Sitecore | 2 Comments

The views expressed in this post are entirely my own based on my own experiences. What is it? Previously a module and now built in to Sitecore 9, SXA is a set of layouts and components to allow drag-drop creation of a Sitecore website without developer interaction. The underlying grid system is defined by Sitecore. You can choose from Bootstrap, Foundation or Grid960, and also create your own grid system but what you are somewhat restricted to allow SXA to …

Dynamic Parameters in Jenkins

Posted on by Joe in Continuous Integration, Jenkins | Leave a comment

So I came across a problem recently where I have a Jenkins job that build multiple Nuget package and pushes them to Octopus Deploy. I spent some time looking into versioning and decided I wanted my packages to be versioned using the Microsoft versioning mechanism used by MSBuild with wildcard characters in AssemblyInfo.cs.

Sitecore Webforms for Marketers Send Email with Username and Password

Posted on by Joe in Sitecore | Leave a comment

I always forgot these parameters so writing a quick blog post for easy reference. With WFFM there are parameters you can set on the Send Email Message Save Action for sending an email through an SMTP server with a username and password. The full params are: <Login></Login><Password></Password><Host></Host><Port></Port><IsBodyHtml></IsBodyHtml>

Fix TeamCity failing to clone or pull from Git

Posted on by Joe in TeamCity | Leave a comment

I’ve had a pretty frustrating few hours today where TeamCity appeared to be very slow pulling from Git. I removed the VCS root and added it again, changed from HTTPS to SSH after which point it couldn’t even seem to pull anything from BitBucket. After a bit of searching around I finally found my answer on stack overflow here – By default TeamCity will only pull files <= 128mb. To change this you need to create an internal property …

Sitecore MVC Tutorial – Controller Renderings

Posted on by Joe in ASP.NET, C#, MVC, Sitecore | 1 Comment

In my previous Sitecore MVC post I showed how to create the menu for my sample website using a View Rendering. Now I’m going to turn that into a Controller Rendering in order to highlight the menu item for the current page.

Sitecore MVC Tutorial – View Renderings

Posted on by Joe in ASP.NET, C#, MVC, Sitecore | Leave a comment

This is my second Sitecore MVC post following on from Creating your first Sitecore MVC website. In this post I’ll extend what was built in that post to create a dynamic menu using a View Rendering.