SQL Dropdown List for a Document Type

This is just a simple tip of how to create a dropdown list for your document type with a little SQL fanciness.

For my implementation, I needed a dropdown list of States for my custom document Type. One solution was to create a text column called state and enter as the Options:

OO;Select State
AK;Alaska
AK;Alaska
AZ;Arizona
AR;Arkansas
CA;California

0
Comments
2
Votes

Gettin' Freaky with Transformations!

I wouldn't recommend writing large amounts of code within transformations; usually, I try to keep them as simple as possible so that front-end developers find them easy to work with.  However, when you need to, this tip may be helpful.

It's important to remember Asp.net's Page Lifecycle when implementing code within a transformation.  If you pick an event that's too early within the life cycle, you'll probably end up getting a null exception.  When scripting within a transformation, you need to be familiar with which tags to use.

1
Comments
5
Votes

Many-to-Many relationships in the Kentico CMS Content Tree

For a few of my Kentico implementations, I've encountered the need for a Many-to-Many relationship for documents that exist in the content tree. Documents within the content tree are stored in a hierarchy and have a parent-child relationship.  There are a few different ways to achieve a many-to-many relationship while storing documents in the tree, but this tip will just describe a quick work-around using a bit of sql and Kentico's query repeater.  I'll first discuss an example of where the issue emerges and then the work-around.

1
Comments
3
Votes

Multiple Websites and Robots.txt, no problem!

Well, I should have included a disclaimer that this developer tip requires the use of IIS 7 and the rewrite module. If you're unfamiliar with the rewrite module, you can find a brief introduction here.

I run into this problem when creating multiple websites within a single Kentico installation.  I had a tough time finding the right solution for my application. I did find a solution in the Kentico forums that suggested adding a robots.txt file as a file type in the CMS Desk and using custom url extensions. More details of this solution can be found here. But, I also found that if your website isn't running under Integrated Mode, using the custom url extensions gets a bit messy. Therefore, I decided to look further into using the rewrite module.

0
Comments
2
Votes

Navigation Menu and Universal Viewer Webpart

Recently, I was tasked to help create multi-level main navigation within the master page of a website.  After a little investigation and finding that the CSS List Menu would not work for my implementation, I concluded that it would be the perfect opportunity to use either a Universal Viewer or a Universal Viewer with custom query; both of which I implemented with Hierarchical Transformations.

I. Universal Viewer

Add the Universal Viewer web part to your master page, set the appropriate content and content filtering properties (just as you would for a CMS Repeater) and then check the boxes for Load hierarchical data, Use default hierarchical order and make sure that the Hierarchical display mode is set to: Inner.  Select the 'OK' button and navigate to the Site Manager to define a new Hierarchical Transformation.

0
Comments
2
Votes