Mike Smith's Tech Training Notes

SharePoint Saturday Dayton! June 30th, 2012

2012-02-20T21:35:00.001-05:00

We’ve had SharePoint Saturdays in Columbus, last year we had our first in Cincinnati, and now we have one coming up in Dayton! There’s not much to report yet… but save the date! June 30th, 2012. Check here for updates: http://www.sharepointsaturday.org/dayton/default.aspx and follow #SPSDAYTON on Twitter. .

SharePoint: Group by Year or Month in a View

2012-02-20T16:27:00.001-05:00

The following is for SharePoint 2007, SharePoint 2010 and SharePoint Online. Grouping by Year Grouping by year is pretty straight forward, just add a calculated column to your list to display the year and then group on that column in a view. Steps: Add a new column to your list or library 2007: Click Settings and then Create Column 2010: In the ribbon click

SharePoint Customization for the Site Owner – The Class!

2012-02-20T11:02:00.001-05:00

This Wednesday I will be offering a class and hands-on lab based on my book, SharePoint 2007 and 2010 Customization for the Site Owner, at MAX Technical Training. In the morning we will see how these customizations are done, what you can and cannot do, and do a few hands-on walk troughs. In the afternoon you can use our lab computers, or if you have remote access to your SharePoint site you

PowerShell Saturday! -- Interested in a PowerShell user group in Cincinnati?

2012-02-18T14:34:00.001-05:00

PowerShell Saturday in Columbus The first ever PowerShell Saturday will be held in Columbus, OH on March 10th. If you have not already registered, then it’s too late! It’s a sell out! But you might want to check the link below to see if they open up any more tickets. Tickets: http://www.eventbrite.com/event/2860436643/eorg I got my ticket! PowerShell in Cincinnati? So… would

SharePoint: Finding the Site GUID

2012-02-13T21:09:00.001-05:00

Had a nice quite evening planned, and then someone sends me in search of a wild goose... Because of a security issue they could not use my little GUID getter tool on their site and they were looking for some other way of getting a site GUID. The wild goose hunt paid off as I found two… For those who have bought my book, you may want add a note on page 307 to see this article.

SharePoint Error: This item is no longer available. It may have been deleted by another user

2012-02-09T16:49:00.001-05:00

Error: “This item is no longer available. It may have been deleted by another user. Click 'OK' to refresh the page.” A Missing Permission This error is caused by either out of date pages that need to be refreshed, as you would expect from the message, or from a missing permission. If the user does not have the “View Application pages” then they cannot get to “forms, views and

SharePoint: How to add JavaScript to a Content Editor Web Part

2012-02-09T00:01:00.001-05:00

The following may be a bit redundant as it has been part of many of my “JavaScript hacks” posts, but I’m asked so often I thought I would put it in a article by itself. The Content Editor Web Part (CEWP) SharePoint 2007 gave us a nice little web part to insert HTML, CSS, JavaScript, and even just some text, in any web part page. SharePoint 2010 “broke” this web part a bit by trying to “

What do you call that? How do you capitalize this? The Microsoft Manual of Style

2012-02-01T14:07:00.001-05:00

How do you… If you write in the world of technology, whether blogs, books, training manuals, or even PowerPoint slides for your local user group, then you are often asking things like: Is it “sub-folder” or “subfolder”? What is that thing at the bottom of the screen called? Is it an “Application Menu” or an “App Menu”? Is it a “Status Bar” or a “status bar” In the old days

Cincinnati SharePoint User Group Lightning Round this Thursday Evening!

2012-01-30T17:24:00.001-05:00

Below is my post from last week about the “Lightning Rounds” presentations for this Thursday’s Cincinnati SharePoint User Group meeting. (and yes… I did mistype it as “Lighting Rounds”… oh well…) So far we have presentations lined up for these topics: (exact titles TBD) Do you need a File Upload Web Part to allow uploading of files without giving access to the Document Library? Tricks

A New SharePoint Designer 2010 Class

2012-01-30T17:10:00.001-05:00

SharePoint Designer 2010 Class This week I will deliver a new SharePoint Designer 2010 class at MAX Technical Training. We reviewed all of the existing classes we could find, and none met our requirements. The problem with most SharePoint Designer classes is that they focus on SharePoint Designer the program rather than what you can do with SharePoint Designer to customize your SharePoint

SharePoint 2010: Cannot find ContentPlaceHolder 'PlaceHolderLeftActions' in the master page '~masterurl/default.master' #sharepoint #sp2010

2012-01-29T17:24:00.001-05:00

A simple error caused by a minimal problem ;-) The odds are you or someone on your team was playing with master pages and set the minimal.master as the default master page. As the minimal master is not a complete master page, some of the place holders needed by many pages are missing. SharePoint Designer To fix, just go to SharePoint Designer and reapply the v4.master (or which

Cincinnati SharePoint User Group Lightning Round in February!

2012-01-22T15:15:00.001-05:00

The Cincinnati SharePoint User Group meets the first Thursday of every month at 6:00 PM at MAX Technical Training in Mason, Ohio (directions). The next meeting is 2/2/2012. Lighting Round! February is our "Lighting Round" meeting where everyone is welcome to submit a proposal to speak for anywhere from 5 to 15 minutes. These have been a lot of fun in the past and no matter your

What Time is it in SharePoint Land? (I missed your meeting because of the time listed in the calendar!)

2012-01-19T23:15:00.001-05:00

Luis is SharePoint user working on a SharePoint installation installed in the corporate headquarters in Los Angles. The server there is setup on Pacific Time (UTC-08:00). Sam is a team member based in the Atlanta office who has changed his Regional Settings to Eastern Time (UTC-05:00). Sam schedules a Team Meeting for 10:00 AM. Luis checks the team calendar as sees: Luis is in

SharePoint Cincy 2012 Early Bird Discounted Registration Now Available

2012-01-17T17:11:00.001-05:00

Need I say more! Go here http://www.sharepointcincy.com/ and click Register Now before 2/29/12. .

Adding JavaScript to a SharePoint 2010 Wiki, and other Wiki Tips and Tricks

2012-01-17T14:01:00.001-05:00

The SharePoint 2010 Wiki has a few interesting changes… some I personally think are oversights, some are SharePoint trying to keep you “out of trouble”. Some of things I will look at here: Why can’t I see a list of all of the Wiki pages? The Rename Page button in the Ribbon is grayed out! How can I insert JavaScript and other content not supported by the Ribbon? Why can’t I

SharePoint: Hide List and Library Column Headings

2012-01-13T15:39:00.001-05:00

I have updated the “Hide List and Library Column Headings” article to add notes for SharePoint 2010 and Office 365! Go here for the details: http://techtrainingnotes.blogspot.com/2009/06/sharepoint-hide-list-and-library-column.html Before (2007): After (2007): Before (2010): After (2010): Note: after this customization the checkbox column disappears, at least until

SharePoint: Move the “Add New” Link to the Top of the Web Part

2012-01-07T23:26:00.001-05:00

When you display a long list in a web part you will find that the “Add new” link is often out of sight at the bottom of the page. Your users will have to scroll to the find the link. This article takes a look at some JavaScript to change the order things are displayed in a web part. The before and after: Note: This has been tested on only one SharePoint 2010 installation, so use at

My Blog’s Year in Review…

2012-01-07T17:54:00.001-05:00

I’ve seen that a number of bloggers have posted a “year in review” article, and someone asked where mine was, so… 2011? 79 blog posts Spoke at 7 events including user groups, SharePoint Saturdays and SharePoint Cincy Volunteered at TechEd in Atlanta Wrote a book! Wrote a magazine article Taught way too many classes (my day job!) Updated two courses we have in the Microsoft

Cincinnati SharePoint User Group Meeting Tonight!

2012-01-05T14:10:00.001-05:00

Last minute reminder… Meeting agenda Date: January 5, 2012, Thursday Time: 6:00 – 8:00 pm. Where: Max Technical Training, 4900 Parkway Dr. #160 Mason, OH. Click on the link for directions http://www.maxtrain.com/directions/ Schedule: 6:00 – 6:25 - Socials and Networking - No Registration required 6:25 – 6:30 - Introduction of Agenda

SharePoint: Not all column types can be used in Calculated or Lookup columns (plus a trick to add back four of them!)

2012-01-02T23:24:00.001-05:00

A recent question in the MSDN forums got me to looking again at the limitations on the use of certain column types in calculations or lookups. The list of column types that can be used in lookups is quite limited, but with a trick using a calculated column we can add four more to the list. For my test I added all of the following columns to a custom list. These include the basic columns

SharePoint Exams 70-667 and 70-667 Being Updated for Office 365

2011-12-29T17:38:00.001-05:00

If you have been preparing for the SharePoint administrator exams, you are about to get a surprise! The exam’s web page has this little tidbit… 70-667 and 70-668 will be updated for SharePoint 2010 SP1 and Office 365 in January, 2012. http://www.microsoft.com/learning/en/us/exam.aspx?id=70-667 They don’t list a date, so assuming January 1st…take the exam tomorrow or Saturday, or

SharePoint: Displaying PDFs from a Dropdown Menu

2011-12-24T23:15:00.001-05:00

Browsing the MSDN SharePoint forums can really bring up some interesting ideas. Recently there was a question about how to display collections of PDF files in a web page. The question included a link to an article on embedding PDFs in SharePoint 2007 by Sharon Richardson. Sharon’s approach used an <embed> tag. The <embed> tag’s SRC attribute is not updateable by JavaScript and I did not want a

December 2011 CU for SharePoint 2007 and 2010 has been released

2011-12-19T21:50:00.001-05:00

December 2011 CU for SharePoint 2010 has been released Go here and see the links to the details for what’s included: http://blogs.technet.com/b/stefan_gossner/archive/2011/12/14/december-2011-cu-for-sharepoint-2010-has-been-released.aspx December 2011 CU for SharePoint 2007 has been released http://blogs.technet.com/b/stefan_gossner/archive/2011/12/17/december-2011-cu-for-sharepoint-

SharePoint: Change the color of a web part column

2011-12-18T19:16:00.001-05:00

Over in my article on color coding lists I got this question: “Can you post a snippet of code that shows how to apply color to a particular column - the entire column (i.e., column 7)” Well, here’s two possible solutions. And you can change anything about the column by changing the CSS. Set the text to bold, change the font family or font size, or add borders. Change the color of a

Review: Amazon Fire

2011-12-17T22:51:00.001-05:00

So what does this have to do with SharePoint, .NET or other technologies I cover in this blog? Three things I guess… I read SharePoint books using an older Kindle, I wrote a book that cannot be ported to the old Kindle (at least not without starting over), and I’m starting to play with portable devices to access SharePoint sites. (If you are in a hurry, scroll down to the SharePoint section or