Friday, February 14, 2014

Glossary/Index of products based on SharePoint Out Of Box Features


I need a very simple Glossary or Index of all the Product Items along with Images based on SharePoint out of box features. So I followed the below steps.


1. Create Image Library
1.1. Create a Glossary Image Library ( I Choose this as I can upload an image directly to this library where as if I choose a document library I cannot have preview, it just show an icon as Type, and with List, I have to upload the image to an image library and take the path of the image and add it as an image..)

1.2. Add the required columns like category, description, Intendedtouse, ProductType etc or use the existing columns if it suits for your requirement.

1.3. Create a View to show it on the page (with Preview or Thumbnail Preview).

1.4. Add this Image library to the page as List/Library webpart and change the View by editing the webpart.

2. Add Query String Filter Webpart to the page.
2.1 Edit the webpart, Query String Parameter Name = <a column from the list which should indexed>
then OK.
2.2. Query Sting Filter webpart --> dropdown @ right side of the webpart --> Connections --> Send Filter Values to --> Glossary (name of the web part that you already placed for the Image Library)
then (on popup) Coose Connection tab Connection Type: Get Filter Values From. On Configure Connection tab Consume Field Name: <choose the column which is used for index>
--> Finish

3. Now we need to add the alphabet list for indexes
3.1 Add a Content Editor Webpart and add the below content in HTML Editor and change the URL Paths and other content based on your requirement.
3.2. Save the page and refresh the page & test.

It should work perfectly...
Note: Make sure the query filter works correctly and html urls configured correctly for the alphabets.

==================== Content Editor HTML code
<!--DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"--><!--DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"--><style type="text/css" media="screen">
H3 {
FONT-SIZE: 130%
}
.container {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; BACKGROUND: #fff; PADDING-TOP: 0px
}
#minitabs {
BORDER-BOTTOM: #660099 1px solid; PADDING-BOTTOM: 20px; MARGIN: 0px; PADDING-LEFT: 10px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
#minitabs LI {
PADDING-BOTTOM: 0px; LIST-STYLE-TYPE: none; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; DISPLAY: inline; PADDING-TOP: 0px
}
#minitabs A:link {
PADDING-BOTTOM: 2px; LINE-HEIGHT: 14px; MARGIN: 0px 10px 4px; FLOAT: left; COLOR: #660099; FONT-SIZE: 10px; FONT-WEIGHT: bold; TEXT-DECORATION: underline
}
#minitabs A:visited {
PADDING-BOTTOM: 2px; LINE-HEIGHT: 14px; MARGIN: 0px 10px 4px; FLOAT: left; COLOR: #660099; FONT-SIZE: 10px; FONT-WEIGHT: bold; TEXT-DECORATION: underline
}
#minitabs A.active:link {
BORDER-BOTTOM: #696 4px solid; BORDER-LEFT: #696 4px solid; PADDING-BOTTOM: 2px; BACKGROUND: #fff; COLOR: #363; BORDER-TOP: #696 4px solid; BORDER-RIGHT: #696 4px solid
}
#minitabs A.active:visited {
BORDER-BOTTOM: #696 4px solid; BORDER-LEFT: #696 4px solid; PADDING-BOTTOM: 2px; BACKGROUND: #fff; COLOR: #363; BORDER-TOP: #696 4px solid; BORDER-RIGHT: #696 4px solid
}
#minitabs A:hover {
BORDER-BOTTOM: #696 4px solid; BORDER-LEFT: #696 4px solid; PADDING-BOTTOM: 2px; BACKGROUND: #fff; COLOR: #363; BORDER-TOP: #696 4px solid; BORDER-RIGHT: #696 4px solid
}
#miniflex {
BORDER-BOTTOM: #333 1px solid; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 10px; WIDTH: 75%; PADDING-RIGHT: 10px; FLOAT: left; FONT-SIZE: small; PADDING-TOP: 0px
}
#miniflex LI {
PADDING-BOTTOM: 0px; LIST-STYLE-TYPE: none; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; DISPLAY: inline; FLOAT: left; LIST-STYLE-IMAGE: none; PADDING-TOP: 0px
}
#miniflex A:link {
LINE-HEIGHT: 20px; MARGIN: 0px 10px; FLOAT: left; COLOR: #333; FONT-SIZE: 85%; FONT-WEIGHT: bold; TEXT-DECORATION: none
}
#miniflex A:visited {
LINE-HEIGHT: 20px; MARGIN: 0px 10px; FLOAT: left; COLOR: #333; FONT-SIZE: 85%; FONT-WEIGHT: bold; TEXT-DECORATION: none
}
#miniflex A.active:link {
BORDER-BOTTOM: #333 4px solid; PADDING-BOTTOM: 2px; COLOR: #333
}
#miniflex A.active:visited {
BORDER-BOTTOM: #333 4px solid; PADDING-BOTTOM: 2px; COLOR: #333
}
#miniflex A:hover {
BORDER-BOTTOM: #333 4px solid; PADDING-BOTTOM: 2px; COLOR: #333
}</style><div><table width="100%" class="s4-wpTopTable" border="0" cellspacing="0" cellpadding="0"><tbody><tr><td valign="top"><div class="ms-WPBody noindex" webpartid="1f55372c-2b0b-4221-9d71-281e85b4e99c"><a href="/sites/abc/blogs/EFBlog/default.aspx" target="_blank"><table width="100%" class="ms-rteTable-6 ms-rteFontSize-2 ms-rteThemeForeColor-2-0 ms-rteBackColor-10" cellspacing="0" style="font-size: 1em"><tbody><tr class="ms-rteTableHeaderRow-6 ms-rteFontSize-2 ms-rteThemeForeColor-2-0 ms-rteBackColor-10"><th style="background-color: #60c; color: #ffffff"><span>Glossary</span> </th></tr></tbody></table></a></div></td></tr></tbody></table></div>
<div class="container"><table><tbody><tr><td style="width: 739px"><font color="#660099"></font></td></tr></tbody></table>
<ul id="minitabs" style="width: 1038px; height: 50px"><li><a href="/sites/abc/Pages/Glossary1.aspx">All</a> </li>
<li><a href="/sites/abc/Pages/Glossary1.aspx?Category=a">A</a> </li>
<li><a href="/sites/abc/Pages/Glossary1.aspx?Category=b">B</a> </li>
<li><a href="/sites/abc/Pages/Glossary1.aspx?Category=c">C</a> </li>
<li><a href="/sites/abc/Pages/Glossary1.aspx?Category=d">D</a> </li>
.... <li><a href="/sites/abc/Pages/Glossary1.aspx?Category=m">M</a> </li>
<li><a href="/sites/abc/Pages/Glossary1.aspx?Category=p">P</a> </li>
<li><a href="/sites/abc/Pages/Glossary1.aspx?Category=r">R</a> </li>
<li><a href="/sites/abc/Pages/Glossary1.aspx?Category=S">S</a> </li></ul>
</div>
=============================