Create NotFound page for 404 error in Sitecore

Create template, layout and content for Notfound page.

Changes in web.config file

<setting name="ItemNotFoundUrl" value="/Notfound.aspx"/>

<setting name="LayoutNotFoundUrl" value="/Notfound.aspx"/>

<setting name="LinkItemNotFoundUrl" value="/Notfound.aspx"/>

<setting name="NoLicenseUrl" value="/Notfound.aspx"/>

In Notfound.aspx page write below code

protected void Page_Load(object sender, EventArgs e)

{

Response.Status = "404 Not Found";

Response.StatusCode = 404;

}

XslHelper - XSL extension methods in XSLT for Sitecore

Download “XslHelper.cs” from http://svn.sitecore.net/XslHelper/ and add it to project.

Open web.config file and find, comment and add below entry in <xslExtensions> tag

<xslExtensions>

      <extension mode="on" type="Sitecore.Sharedsource.Xml.Xsl.XslHelper, WebApplicationRND" namespace="http://www.sitecore.net/sc" singleInstance="true" />

      <!--<extension mode="on" type="Sitecore.Xml.Xsl.XslHelper, Sitecore.Kernel" namespace="http://www.sitecore.net/sc" singleInstance="true" />-->

Where WebApplicationRND is project assembly name.

Image Gallery in Sitecore

Assign Placeholder in Template Standard value and set its properties – width, height, presentation, media folder [set parent folder so that all folder images will be fall under it.]

Remember that Image Gallery accepts images of the type .JPG, all others will at the moment just result in a grey screen. If you want to include all types of images then change below lines in “ImageGalleryXMLConfiguration.xslt” file

<!--<xsl:if test="./item[@template='jpeg']">-->   <xsl:if test="./item">     <album title="{@name}"            description="{sc:fld('description',.)}"            image="{sc:fld('image',.,'src')}">       <!--<xsl:for-each select="item[@template='jpeg']">-->       <xsl:for-each select="item">

Create and fill table in SQL server from XML file

<?xml version="1.0" encoding="UTF-8" ?>

<Dealers>

  <Dealer id='77'>

    <Dealer_Address>

      <Name>Action Kia</Name>

      <Address>Cnr Bruce Highway And Oak St</Address>

      <Suburb>Gympie</Suburb>

      <State>QLD</State>

      <Postcode>4570</Postcode>

      <WorkPhone>(07) 5482 2759</WorkPhone>

      <Opening_Hour>Mon-Fri: 8:00 AM-6:00 PM-br-Sat: 8:00 AM-12:00 PM-br-Sun: Closed</Opening_Hour>

      <Fax>(07) 5482 2389</Fax>

      <Url>www.actionautogroup.com.au</Url>

      <Email></Email>

      <Longitude>152.650454</Longitude>

      <Latitude>-26.179577</Latitude>

    </Dealer_Address>

    <Service_Address>

      <Name>Action Kia</Name>

      <Address>Cnr Bruce Highway And Oak St</Address>

      <Suburb>Gympie</Suburb>

      <State>QLD</State>

      <Postcode>4570</Postcode>

      <WorkPhone>(07) 5482 2759</WorkPhone>

      <Opening_Hour>Mon-Fri: 8:00 AM-6:00 PM-br-Sat: 8:00 AM-12:00 PM-br-Sun: Closed</Opening_Hour>

    </Service_Address>

  </Dealer>

  <Dealer id='7'>

    <Dealer_Address>

      <Name>Adtrans Kia</Name>

      <Address>1178 - 1184 South Road</Address>

      <Suburb>Clovelly Park</Suburb>

      <State>SA</State>

      <Postcode>5042</Postcode>

      <WorkPhone>(08) 8374 2744</WorkPhone>

      <Opening_Hour></Opening_Hour>

      <Fax>(08) 8374 2755</Fax>

      <Url>www.adtranskia.com.au</Url>

      <Email></Email>

      <Longitude>138.574837</Longitude>

      <Latitude>-34.997404</Latitude>

    </Dealer_Address>

    <Service_Address>

      <Name>Adtrans Kia</Name>

      <Address>1178 - 1184 South Road</Address>

      <Suburb>Clovelly Park</Suburb>

      <State>SA</State>

      <Postcode>5042</Postcode>

      <WorkPhone>(08) 8374 2744</WorkPhone>

      <Opening_Hour></Opening_Hour>

    </Service_Address>

  </Dealer>

</Dealers>

SELECT

      product.value('../@id', 'int') as id,

      replace(X.product.query('Name').value('.', 'VARCHAR(300)'), 'And', '&') as Name,

      X.product.query('Address').value('.', 'VARCHAR(300)')as Address,

      X.product.query('Suburb').value('.', 'VARCHAR(300)')as Suburb,

      X.product.query('State').value('.', 'VARCHAR(300)') as State,

      X.product.query('Postcode').value('.', 'VARCHAR(30)') as Postcode,

      X.product.query('WorkPhone').value('.', 'VARCHAR(20)') as WorkPhone,

      replace(X.product.query('Opening_Hour').value('.', 'VARCHAR(300)'), '-br','<br>') as Opening_Hour

INTO Service_Address

FROM

(

      SELECT CAST(x AS XML) FROM OPENROWSET(BULK 'D:\dealers_2012125 - Copy.xml', SINGLE_BLOB) AS T(x)

) AS T(x)

CROSS APPLY x.nodes('Dealers/Dealer/Service_Address') AS X(product);

Photoshop useful commands

Select – Control + Mouse click

Copy – Control + shift + C

New - Control N

Save as image size – control + shift + alt + S

Enlarge - Control + space + mouse click

Deselect all items – Control + D

Add particular child to parent in content.

Select Parent template and click on “Assign” and choose the child template. Click on Ok

Add sitecore reference in web.config file so that we can get intelligence in aspx files

<pages validateRequest="false">

      <controls>

        <add tagPrefix="sc" namespace="Sitecore.Web.UI.WebControls" assembly="Sitecore.Kernel" />

</controls>

</pages>