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…
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
I’m putting together my thoughts for the coming year and what the main focus should be for EndUserSharePoint.com. Here are a couple things getting my attention at the moment. Any input from you is appreciated.
Those are the ideas off the top of my head. Did I miss anything major?
Mark Miller
Founder and Editor
EndUserSharePoint.com
The question of the day comes from Mick:
"Site Background: small business site hosted on a shared WSS server at FPWEB
Problem Background: "The team" uses an SP teamsite to organize tasks, share a calendar etc. One of their key tasks is to prepare excel/word/pdf reports for 40+ different clients.
It occurred to the team that it would be great if instead of sending these documents out to people they could just host them on the site and have clients access their own documents, at their own convenience and ignorant of the existence of other clients documents being there.
Query: There are many potential solutions to this problem i.e. many subsites, use of [ME] as a filter.
I’d prefer a safe option where there was no chance a document could be accidentally downloaded by somebody who shouldn’t have access to it. Equally, a real simple method of managing that would be great (who needs the upkeep of 40 subsites!)
I’m sure this is a fairly common SP scenario. What strategy would you use to resolve this issue?"
Response from Mark Miller:
Mick,
You don’t state how many documents would be applicable for each client. Is it 10? 25? 50? 100? Knowing that would help determine a solution, but here are two that should get you started on a discussion with your team and with your clients.
My initial thought would be to create a base content type that holds all of the common metadata attributes you would want for all client data. Create a library for each client, using the base content type to setup the metadata structure. Set unique permission levels on each library. As you start to get more familiar with the data, you might add ‘children’ to the base content type and refine the libraries down the road.
An alternative is to create one library and store all documents within that library. Some here at EndUserSharePoint.com, including Chris Quick and Paul Grenier, recommend the use of folders within that library to maintain a security structure.
Either way, I don’t see the necessity of creating subsites for all of your clients unless there is a large amount of collaborative data that needs to be shared with the client.
Hope that gets you started. — Mark
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:
The agenda looks pretty amazing too:
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.
Regards,
Mark
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.
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.
EndUserSharePoint.com 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 EndUserSharePoint.com 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
EndUserSharePoint.com
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js" type="text/javascript"></script> <script type="text/javascript"> $(function() { //capture variables var div=$("div[class^='ms-ganttDiv']:eq(0)"); var tlv=$("table.ms-listviewtable:eq(0)"); var w = $("#GanttTable").width(); var a = "img[src='/_layouts/images/EndNormal.gif']" var b = "img[src='/_layouts/images/MileStone.gif']" //build new html from header rows var html="<table class='ms-ganttInnerTable' cellspacing='0' cellpadding='0' style='table-layout:fixed' width='"+w+"'>"+ "<col width='222px'></col>"+ "<tbody><tr>"+ $("#GanttTable tr:eq(0)").html()+ "</tr><tr class='ms-ganttDetailTimeUnitRow'>"+ $("#GanttTable tr:eq(1)").html()+ "</tr></tbody></table>"; //build toggle buttons var bt1="<input id='tlv0' class='ms-ButtonHeightWidth' type='button' target='_self' value='Toggle List' name='togglelv'/>"; var bt2="<input id='div100' class='ms-ButtonHeightWidth' type='button' target='_self' value='Full Gantt' name='div100'/>"; var bt3="<input id='div272' class='ms-ButtonHeightWidth' type='button' target='_self' value='Min Gantt' name='div100'/>"; //DOM manipulation $("#GanttTable").prepend("<col width='222px'></col>"); $("table.ms-menutoolbar:eq(0)").after(html); //insert html $("td.ms-toolbar[width='99%']").append(bt1).append(bt2).append(bt3);//add buttons $("#tlv0").click(function() {$(tlv).toggle()}); //add toggle fn $("#div100").click(function() { $(div).height("100%"); $(div).css({"overflow-y": "visible", position: "relative"}); }); //add 100% fn $("#div272").click(function() { $(div).height("272"); $(div).css({"overflow-y": "auto"}); }); //add 272 fn $("#GanttTable tr:lt(2)").replaceWith("<th></th>"); //replace original rows $(a+", "+b).each(function(i,e) { //add labels var title = $(e).parent().siblings("th").text(); $(e).parent().next().html("<div style='position:relative;z-index:99;white-space: nowrap'>"+title+"</div>"); }); //css fixes $("#GanttTable").css({"table-layout":"fixed","word-wrap":"normal",width:w}); $("table.ms-listviewtable > tbody > tr[class='']").css("background-color","#fff"); $(div).css({"overflow-y": "auto", "overflow-x": "hidden"}); }); </script> <style type="text/css"> body {background-color:#83B0EC} .ms-main {height:97%} .ms-globalTitleArea {background-color:#fff} .ms-bodyareapagemargin {border-top:1px solid #83B0EC} .ms-bodyareaframe {background:none transparent} .ms-ganttInnerTable {background-color:#fff} .ms-bodyareacell {background-color:#83B0EC} </style> |
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.
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.
