Feedback on “Create a Master Calendar in SharePoint” online workshop

The December 30th "Create a Master Calendar in SharePoint" online workshop is completed. The participants will be giving feedback here so you can get an idea of how things went. In addition to the workshop itself, they received all of the resources needed to create the solution (hierarchical Mind Map, Step-by-Step Guide for implementing a Master Calendar, two custom web parts and a LyteBox setup) and a recording of the entire workshop.

Let’s see what they have to say…

The Power of Believing

My six year old son hammered me daily for a Nintendo DS for Christmas this year. Each morning was like being inside of a live advent calendar, the days slowly ticking off until December 25th. I would get awakened with a plea and a promise… "I’ll never take it out of the house", "I’ll share it with my sister", "I’ll listen when you say turn it off!"

On Christmas Eve day, I got down on my knees, on the floor, eye-to-eye, took his face in my hands and said, "Son, I’m not going to get you a Nintendo DS. Your mother is not going to get you a Nintendo DS. And Santa Claus is not going to bring you a Nintendo DS. You are just going to be disappointed if you expect one." This was said with all sincerity, because I have absolutely no intentions of losing my son to hand-held game addiction at such an early age.

As I was standing up, hoping I got through to him, he looked me square in the eye and said, "Santa Claus listens to children’s wishes, not what grown-ups want."

I kind of shrugged it off, knowing there was going to be some hurt feelings the next day when no Nintendo DS showed up under the tree. I put my coat on to go and get some little stocking stuffers to finish off the day. As I was on my way out, my wife stuck her face through the front door and whispered, "Go get one!". I was stunned.

After all our discussions, after all of the reasoning and rational for not allowing a six year old to have a hand-held video game, Mrs. Claus had finally succumbed to a small child’s belief and persistence. "Go get one!" she whispered as I stood speechless in the doorway.

The next morning, my son woke me up, took me by the hand and pointed to a small box with the letters "DS" on the outside. "See, I told you. He listens to children." was all he said.

And so "he" does. Have a happy and safe New Year.

Mark New ideas for the coming year

I’m putting together my thoughts for the coming year and what the main focus should be for Here are a couple things getting my attention at the moment. Any input from you is appreciated.

  • Statement of Purpose: provides support for the Information Worker who is using SharePoint as one of their main productivity tools. New content is provided daily, using input from site participants who are looking for SharePoint to solve their current business problems.
  • Beginner Material
    Concentrate on providing more material for the entrance level SharePoint End User. The last few months, the focus has started to stray a bit.
  • Site Update
    Remove the article rating system and replace with a ‘Degree of Difficulty’ icon. This will help people quickly access the level of material they need.
  • Archive Page
    Create an archive page so that all content is visible, available by month. With over 400 articles available, this will be the most efficient way for people to do a quick visual search for articles of interest.
  • Study Group
    The feedback was very good on the study group idea. I’m working with one of the SharePoint book authors to lead the first sessions.
  • Live, Online Workshops
    The schedule for the workshops will begin in mid-January. Each week there will be a minimum of one workshop, with the schedule posting one month in advance.
  • Article Formatting
    For the entrance page of the site, show a short excerpt for each article instead of the entire article… much easier for people to see more information and select what they need.
  • Subscription Base
    Create a subscription area for those who are not able to attend the live workshops and would like to pay for a recording of the session along with the resources for that session.
  • Content, content, content
    There must be at least two articles a day, during workdays, going up on the site. Freshness counts!

Those are the ideas off the top of my head. Did I miss anything major?

Mark Miller
Founder and Editor

Calling all Army, Navy, Air Force, Marines… heads up

I will be presenting "Case Studies in SharePoint (WSS) Dashboards" at the Virginia Beach, VA SharePoint Saturday "get together" on January 10th.

Since I was once stationed at Fort Belvoir, VA, I started thinking about how many military installations are on the East Coast. Every branch of the military is within shouting distance of Virginia. So here’s a heads up: this is one the first big SharePoint gatherings of the year, registration is free and you are more than welcome to attend.

If you have checked out the prices for attending conferences lately, I think you’ll agree that a two to three hour drive is a small price to pay for what is going to be available that day. Let’s see what you’ll get:

Confirmed Presenters

  • Me, naturally
  • Joel Oleson
  • Susan Lennon
  • Paul Galvin
  • Becky Isserman
  • Dean Halsted
  • Dux Raymond Sy
  • Jeff Hansen
  • John Holliday
  • John Miller
  • Kevin Israel
  • Michael Lotter
  • Michelle Villalpando
  • Robin Edwards
  • Tim Yagla
  • Todd Bleeker

The agenda looks pretty amazing too:

  • 7 Ways to Leverage SharePoint for Project Management Success
  • Authenticating SharePoint Using SharePoint
  • Case Studies in SharePoint (WSS) Dashboards
  • Content Editor Web Part tricks
  • Creating and Searching Managed Properties (we aren’t talking about Real Estate either!)
  • Creating Interesting Dashboards with SharePoint Designer
  • Dazzling SharePoint with Silverlight
  • Developing and Packaging Third-Party SharePoint Solutions
  • Introducing CAML.NET 2.0
  • Is This SharePoint? Enhancing the End-User Experience
  • Mission Impossible? Help me Kill my File Servers, Notes, Front Page Servers, and Public Folder Servers and Move to SharePoint
  • Powershell and SharePoint
  • SharePoint as an Enterprise Development Platform
  • SharePoint Directory Management
  • SharePoint Fantastic 40 Applications
  • SharePoint Governance
  • SharePoint Security Management for the Business User
  • SharePoint’s Wikis and Blogs
  • Technical Best Practices
  • The Secrets of SharePoint Supportability and Custom Coding: Best Practices the Devs Don’t Want You to Know
  • The Trouble With [Today].
  • Tuning Memory Management in SharePoint
  • Use out of the box SharePoint features to create a multi-user spreadsheet without using Excel

Holy Smokes! I didn’t realize how much was being presented until I pasted that list.

I want to see a room full of uniforms when I show up, so load up the bus and plan on spending Saturday with us. Registration is free. I look forward to meeting each of you.


Create a Master Calendar in SharePoint

Just a reminder… Tuesday (December 30) at 1:00pm EST, I will redeliver the Create a Master Calendar in SharePoint, live online workshop. The workshop is for site administrators and beginning SharePoint End Users who need to manage multiple calendars.

This is a redelivery of the online workshop that was sold-out in November. If you missed that and you need to implement a master calendar, this will definitely be worth an hour and a half of your time.

View the agenda, outline and registration for more information. is closing

I worked at B&H PhotoVideo for a year, doing special projects; leading a team to coordinate and digitally organize information from 400 vendors, structuring the Payment Card Industry Processing project, setting up a metadata reader to expose the metadata structure of all of the major databases in-house, creating a plan for building a categorization system that would dynamically categorize items according to how varies business units wanted to organize the data. Most of these were projects that some would consider essential to running a business the size and breadth of B&H.

No matter how much work there was to do, however, it was against company policy to work from Friday evening, sundown, through Sunday morning. Sam, the owner of B&H, not only lives his life according to his principles, he insists that everyone in the company do the same. This not only goes for employees, it includes all external contractors. You do not work on B&H projects on Saturday… not on site, not at your office, not at your home. Saturday is family day, a time for reflection. doesn’t have the size and industry influence that B&H does, but that doesn’t mean we can’t live by the same philosophy. Christmas is a time of year for families, a time of reflection for the past year and the new one that’s right around the corner.

We will be closing down from December 24 through December 26 so that we can be with our families, friends and loved ones. We will not be publishing articles, responding to comments or participating in Stump the Panel. For me, I’m packing up the family on December 21st and headed for the mountains

In the spirit of Sam and Herschel at B&H, we all wish you a safe, healthy and happy holiday season and hope that you too, will take this time to reflect on the good that can be accomplished in the coming year.

With sincere regards and best wishes for the coming year,
Mark Miller
Founder and Editor

JQuery for Everyone: Fixing the Gantt View

This question came in from Stump The Panel:

Does anyone know how to freeze the Title column in Project Task list Gantt chart view?

Since I want to get better using jQuery, and tweaking the UI will be easier than fixing the web part, I went after it.

Instead of freezing the Title column, I decided to drop the x-axis scrollbar and add labels to the ends of each activity.

Since the header rows also disappear when you scroll down on the inner scrollbar, I froze the date header by moving it out of the chart area.

But I couldn’t stop there.  I don’t always need the Task List View below my chart and sometimes I need to see more of the chart at once. I decided to add some buttons to the toolbar that control the List View display and Gantt View height.

Check out the results of these tweaks in this screencast:

Video: SharePoint Gantt Fix

Paul Grenier

Security Trimming a List View

Here’s a question that comes up quite a bit. This time, it was on Stump the Panel:

Does anyone know how I can use one SharePoint List but have different site users only access specific views (kinda like security trimming views) The scenario is I am working with some lawyers who should only access data on the list they are responsible for and shouldn’t see the data the other lawyers are responsible for. I want to only maintain one list so that its easy for me to update just the one list.

Response from Paul Grenier, Moderator of Stump the Panel:

Perfect reason to use folders. Folders can have their own permissions. You can break inheritance and give every object in them the same permissions. This allows you to group things in a list or library by permission. Works great for things like a library of personal expense reports.

SharePoint Search in Plain English

Paul Galvin pointed me to an article, ‘Best Bets and Keywords in SharePoint and Search Server - "When it Absolutely, Positively, has to be Found" ‘ at The Sanity Point. Woody has just come on my radar screen because of a screencast he did for Mike Gannotti.

This guy’s writing style is great! Even if you don’t know anything about SharePoint, the writing makes it seem so simple you’ll want to try it out. Here’s what Paul Galvin has to say about it:

"This article is sort of admin-oriented, but it’s also the best description of best bets writing I’ve seen in a long time, perhaps ever. And, it has some great examples of how to use it in business terms that never occured to me (such as providing disclaimers when employees search for the word "financials")."

I don’t think you can get a better recommendation than that. Jump over and check out the article, ‘Best Bets and Keywords in SharePoint and Search Server ‘. Easy ideas to absorb along with a simple, no GeekSpeak writing style. My kind of guy. Thanks Woody.