SharePoint Saturday Toronto Presentation

The first ever SharePoint Saturday Toronto conference organized by SharePoint Delivery was held on July 11th, 2009. For full coverage of the event see the article on sharepointdelivery.com.

I presented a session on "Content Query Web Part In The Wild" along with my colleague Tahir Nasir. The session was on how to customize the CQWP and build applications using it. As promised in the session, I am posting my PowerPoint presentation and demo script. The demo shows how to create an employee directory using the CQWP.

If you have any feedback about my presentation, please feel free to contact me. If your organization is looking for help with SharePoint please give me a call at 917-655-4948.

The presentation is at: http://sharepointdelivery.com/Documents/SharePoint%20Saturday%20Toronto/SharePoint%20Delivery%20-%20SharePoint%20Saturday%20Toronto%20-CQWP.pptx

Employee Directory Demo

Here are the steps to build an employee directory in MOSS.

1. Create a site for SharePoint Saturday Toronto using the team site template. Use its own top navigation. In the navigation settings check of show sub sites.

2. Create sites for IT, Sales, Employee Directory. Use the team site template.

3. In the site collection settings, create content type "SST Employee" that inherits from List -> Item.

4. In the SST Employee content type add the following existing fields:
Email, Business Phone

5. Create a new field called "SST Department".
values: IT, HR, Sales

6. In the Employee Directory site, create a custom list called Employees. In the list settings, add the SST Employee content type.

7. Create a new view called Employees and add the columns SST Department, Email, Business Phone. Reorder if necessary.

8. Populate the Employees List with the following data:
Hasan Shahid Sales hasan_pub*sharepointdelivery.com 917-655-4948
Tahir Nasir IT tahir_pub*sharepointdelivery.com 425-985-1549
Kanwal Khipple Sales kanwal_pub*sharepointdelivery.com 416-873-7799
Muhsin Shahid IT muhsin_pub*sharepointdelivery.com 416-629-4948
Amjad Ashraf IT amjad_pub*sharepointdelivery.com 248-890-4968


9. Go to the Employee Directory site main page and add the Employees web part. Set the view to the view that was created.

10. Go to the IT site and add the content query web part. Point it to the Employees list. Use the SST Employee content type. Enter condition for SST department field to contain "IT".

11. Export the Content Query Web Part. Edit the file. Search for the property "CommonViewFields". Edit the line to add the Work Phone and Email columns. Use the internal SharePoint column names. To find out the internal names, go to the Employees list settings and copy the URL from the link on the column name.

http://win2003/SST/ed/_layouts/FldEdit.aspx?List=%7B5C2A48F4%2DCEB0%2D4BAC%2D9B53%2D0E35A11F275B%7D&Field=WorkPhone
http://win2003/SST/ed/_layouts/FldEdit.aspx?List=%7B5C2A48F4%2DCEB0%2D4BAC%2D9B53%2D0E35A11F275B%7D&Field=EMail

So the internal names are WorkPhone, EMail.

Change the CommonViewFields property to the following:

<property name="CommonViewFields" type="string">WorkPhone,Text;EMail,Text</property>

Save the file and Import the web part file to the IT sales site.

12. In this step we need to create the XSLT to display the fields. In SharePoint Designer open up the site collection. Go to Style Library -> XSL Stylesheets. Check out the file ItemStyle.xsl.

Find the section xsl:template name="TitleOnly". Copy this and paste it at the end of the file before .
Edit this section and add this line before the final tag.

- <xsl:value-of select="@WorkPhone" /> - <xsl:value-of select="@EMail" />

Change the name to: SSTEmployees.

13. Now go back to the CQWP and change the web part settings. Under Presentation -> Item Styles select "SSTEmployees".

13. Repeat for the Sales site.

SharePoint Saturday Boston Was A Hit

I just got back from Boston after presenting at SharePoint Saturday Boston. The event went very well and we received a great response. For coverage of the event see the news article on the sharepointdelivery.com website.

As I promised in my session "Content Query Web Part It The Wild" that I presented along with my colleague Amjad Ashraf, I am posting my presentation for your reference.
sharepointdelivery.com/Lists/News/Attachments/6/SharePoint%20Delivery%20-%20SharePoint%20Saturday%20Boston%20-CQWP.pptx

We did two demos during our session. The first was on creating an Employee Directory and the second was on creating a Project Management system. I will post the content of those demos as soon as I get a chance to make it presentable.

If you have any feedback about my session, it would be very much appreciated. I look forward to speaking at other upcoming events in the SharePoint community.

For more information about SharePoint Saturday visit the site www.sharepointsaturday.org.

SharePoint Saturday Boston

I will be doing a presentation at SharePoint Saturday Boston this Saturday, March 14, 2009. It will be on SharePoint's Content Query Web Part and will delve into custom development in MOSS. I will be posting the presentation material on my blog after the event. Attendance is free.

The offical blurb: Join SharePoint architects, developers, and other professionals that work with Microsoft Office SharePoint Server 2007 for ‘SharePoint Saturday’, on Saturday, March 14th, 2009 at the Microsoft Office on Jones Road in Waltham, MA. SharePoint Saturday will be an educational, informative & lively day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint-orientated topics. SharePoint Saturday is FREE, open to the public and is your local chance to immerse yourself in SharePoint!

To register or for more information go to: http://www.sharepointsaturday.org/boston/default.aspx

Welcome To Hasan Shahid's SharePoint Blog!

I am starting a new blog to talk about all things SharePoint. Come back here over the next couple of months to read my posts.

If you are trying to contact me for a SharePoint project, you can give me a call at 917-655-4948.

Thanks!