What I want to achieve with this post is give the editors the possibility of inserting related content from other pages into their current Rich Text Editor. They could insert related content from some selected fields in another pages or render some spots so that they would present a page somewhat like this : I am still working on […]
A quick tip on upgrading Sitecore fast and easy
Today my colleague @alinulms and I had the “fun” task of updating an old Sitecore 6.5 to version 7.2. Actually we really want to upgrade the solution to Sitecore 7.5 but we are still waiting for Sitecore. I really hope 7.5 will be officially released any time real soon. I’ve upgraded Sitecore installations at least a trillion […]
Azure API Management and output cache policies
I am writing this post because I was one day confronted with the situation when I had to move a whole bunch of HTTP Services to be called via Azure API Management. These services were serving mobile calls from both iOS and Android devices. All nice and well but the problem I got was that some of […]
An involuntary lossless image compression by Sitecore
This is a small bonus post following my post series about responsive images in Sitecore. When you load a JPEG image in .NET into a Bitmap and then draw it on another Bitmap then you will notice that the original image is sometimes bigger than the new one. How can that be.. This is because .NET does […]
Make Sitecore deliver images which fits the screen, part 2
This is the second part of a mini-series where I show how you can make Sitecore deliver images that fully support a responsive web design. See the first post here if you haven’t read it already. In this part I will show how to make Sitecore center-crop images through the media handler using query string […]
Make Sitecore deliver images which fits the screen
When implementing a responsive design the size of images is almost always an issue. You want the images to be resized server-side so they fit the screen. Primarily for performance but also to please Google Page Speed. Sitecore enables us to set the width and height dynamically by sending query parameters to the media handler. My […]
How to gzip svg files in ASP.NET
My previous post showed how to gzip svg files served by the Sitecore media library. This is fine if all svg files reside in the media library but this is typical not the case. In this post I will show how to gzip compress any svg files served by your ASP.NET solution. As I explained in my […]
How to compress SVG images from the Sitecore media library
This blog post is long overdue. The code was written some time last year when I started my still on-going fight with Google Page Speed. When Sitecore deliver svg files from the media library there is no out-of-the-box approach for gzipping the media content and setting the Content-encoding response header to gzip. Gzipping the svg media content First […]
How to use a subset of markdown in Sitecore text fields
This is my first blog post for some months now so I’ll start somewhat easy. I attended a design presentation meeting this Friday where the customer presented a nice and simple design based on bootstrap for their new website. All was great about the design but then I noticed something funny about the spot headlines used […]
Sitecore Analytics rules with custom user properties
This post will show how to create an Engagement plan rule that uses custom fields. The idea is that the users have custom fields on their profile related to newsletter distribution groups. The goal is to create an engagement plan where we have a rule condition saying something like this : The engagement plan using this condition has […]
3 reasons why TypeScript is brilliant
I had the pleasure of attending a talk with Anders Hejlsberg from Microsoft today at the Copenhagen University department of computer science. The talk was an introduction master class to TypeScript and even though I played a bit around with TypeScript before it was so cool and beneficial to hear about it from the mind […]
Sitecore DMS visits from specific IP addresses
Sitecore DMS stores IP addresses as a varbinary(16) in the Visits table in the analytics database. This is just perfect but it is impossible to read the IP addresses as a normal human being. To help out with this I found the following SQL function which can convert an IPv4 address to a binary.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
CREATE FUNCTION dbo.fnBinaryIPv4(@ip AS VARCHAR(15)) RETURNS BINARY(4) AS BEGIN DECLARE @bin AS BINARY(4) SELECT @bin = CAST( CAST( PARSENAME( @ip, 4 ) AS INTEGER) AS BINARY(1)) + CAST( CAST( PARSENAME( @ip, 3 ) AS INTEGER) AS BINARY(1)) + CAST( CAST( PARSENAME( @ip, 2 ) AS INTEGER) AS BINARY(1)) + CAST( CAST( PARSENAME( @ip, 1 ) AS INTEGER) AS BINARY(1)) RETURN @bin END |
[…]