Hi there, Two weeks ago I wrote a blogpost on Sitecore Rock’s Query Analyzer (http://newguidnet/sitecore/2012/sitecore-rocks-query-analyzer-handy-queries/). Tonight I have some more queries that could come in handy! Get all the items from the MASTER database that have configured an assembly name in it: use master; select * from /sitecore//*[contains(@Assembly, '')] Get all the items from the CORE database that have configured an assembly name in it: use core; select * from /sitecore//*[contains(@Assembly, '')] By using a specific database, Sitecore Rock’s Query analyzer automatically More Info »

Hi there, Tonight I was busy with Sitecore Rock’s Query Analyzer identifying a wrongly configured item. I thought I should share a couple of handy queries to quickly identify certain items. Identify which sublayouts have the Datasource Location filled: select @@name, @#Datasource Location# from /#sitecore#/#layout#/#Sublayouts#//* order by #Datasource Location# desc Identify which template fields use the ‘query:’ statement in the source: select @@name, @Source from /sitecore/templates/#User Defined#//*[contains(@Source, 'query:')]  order by Source desc Identify which template fields have configured something in the in More Info »

In my recent project I had the challenge to adjust the site context language to the location of the website visitor. That means determining the visitor’s country and related language based on its ip-adress. First of all some background information on the process of determining the context language. The process is going through the following steps: The sc_lang query string parameter The Sitecore.Data.FilePathLanguage property, containing the language as part of the url The language cookie associated with the context site The default language associated More Info »

When talking to business users (people that actually work with Sitecore on a day to day base) I created a small list of minor custom changes that would help the business users with there day to day work. One of the items on this list is the condition for User Profile fields, by default the input of this field is a manual typed String. Which is a painful process for the business user They are not sure of the fieldname and go More Info »

With the Sitecore API it’s very easy to add items to the cache. You van use Sitecore.Caching.Cache to do the necessary operations. To add something to the cache you can use several overloads. Most of the time you want to add an expiration to the cached data. You have two different overloads to do this. Add(string key, object data, long dataLength, TimeSpan slidingExpiration) Add(string key, object data, long dataLength, DateTime absoluteExpiration) First method is to add a sliding expiration. The second method More Info »

As Solution Architect a part of my job is doing product demo’s and building Proof Of Concepts. The best way for me is to build stuff based on a clean install of Sitecore with the involved modules installed (like DMS, SES or ECM). Normally you will do this with the default Sitecore installer and manually install the modules you need, but this will take to much of your precious time. With the  SitecoreInstaller you can install Sitecore with selected modules in one More Info »

We recently ran into a requirement to execute tasks in our Sitecore environment the same time every day. Sitecore doesn’t support this for two (related) reasons. The Sitecore scheduled tasks are run by the Sitecore scheduler, which is defined as an agent in the web.config. If you examine this configuration you see a certain interval defined on which bases Sitecore checks if tasks have to be executed. If a task is overdue it will run and after finishing it will write the More Info »

Did you hear of the Sitecore Log Analyzer? The Sitecore Log Analyzer is a great tool. It does what the name claims; It will help you analyze your log files! A short list of some great features: Quick analyze of all log files in a directory Date and string filter Tabs for the different categories; Messages, Audit and Health Monitor Filters for log levels; Errors, Warnings and Info’s Log entries sorted on number of occurrences Timeline overview of the (filtered) log entries Great statistics More Info »

Hi there, First of all, let me introduce myself on the Newguid.net Sitecore blog. My name is Robbert Hock and I’m a freelance and passionate Sitecore developer living in The Netherlands. I’m running my own business called Kayee Internet & Software Oplossingen and am specialized in Sitecore and Umbraco implementations. In 2011 I was awarded the Sitecore MVP award. On a regular basis I will be blogging on the Newguid.net blog on things that reflect Sitecore and I think are worth mentioning. More Info »

In Sitecore you can personalize your website with conditions and actions using the Rules Engine (so called Conditional Rendering rules).  In Sitecore 6.5 the interface for defining conditional rendering rules is integrated in to the page-editor, this way it´s easier for the marketeer to create and maintain pesonalization rules. But as a developer you want to create predefined rules and activate them on the template standard values, the same way personalisation was working in Sitecore 6.4. This is still posible with 6.5 only by default the More Info »

Tired of switching between the Master and Core database during development? Making the mistake of making changes on the wrong database? Install the Customized Startbar Module. This module will do multiple things, but the main two things that I really like are: You can add buttons to the Quicklaunch bar. Add the database name next to the database icon (bottom right) The startbar before installation The startbar after installation You can download the Customized Startbar module from trac: http://trac.sitecore.net/CustomizedStartbar/ (Thanks to Alistair More Info »

To make thinks easier for the business-users you can use Icons for templates. This is a great way to make the business-user recognize the different types of content they can create. But did you know you can also use icons for your Fieldsections? Set Icon with the webinterface You can set icons for Fieldsections the same way as you do for your templates. Just open the content editor, expand a template and underneath a template you will find all your FieldSections. Select More Info »

Today Lucas Bol gave the first Dutch Sitecore guest Webinar. The subject of this webinar was continuous integration with Sitecore based on open source products. The video is in Dutch and posted below. In the next few days Lucas will post his documentation and explanation of the webinar in English. Follow us on Twitter @new_guid or subscribe to our RSS feed if you want an update when this is posted.  

In Sitecore we know wildcards, which will give you the possibility to create dynamic urls. Basically we can use wildcards to pass variables by using the URL instead of querystring parameters. If you would like to know more on how wildcards work and what they can do for you I recommend this blogpost from Alistair Deneys. So let’s assume we have the following case. We have a multilingual website with the Dutch and English language. On this website we have a catalog section More Info »

In certain cases you want to offer the end-user a userfriendly interface to manage content, users or anything else. Thanks to Sitecore’s backend flexibility this is possible in more ways than one. In this case I will use the technique which is described in this blogpost by Adam Conn. In the example you can see that a new window is opened by the code below: public override void Execute(CommandContext context) { Assert.ArgumentNotNull(context, “context”); UrlString url = new UrlString(“/sitecore/shell/~/xaml/GridExample.GridExamplePage”); url["id"] = context.Items[0].ID.ToString(); SheerResponse.ShowModalDialog(url.ToString(), More Info »