2/01/2013

SharePoint Workspace gone for 2013!

 

Just an FYI…

http://technet.microsoft.com/en-us/library/cc178954.aspx

SharePoint Workspace Product

SharePoint Workspace

End of life

SharePoint Workspace is being removed from the Office product base.

We will release Folder Sync with Office 2013.

N/A

The replacement feature is Folder Sync, which is included with Office 2013. This lets users take doc libraries offline for SharePoint and sync them.

N/A

For those not upgrading to Office 2013 yet, SharePoint Workspace 2010 may still work with SharePoint 2013.

You may also want to search that article for "End of life", "removed" and "removing" to see what else is gone.

 

.

1/23/2013

Cincinnati PowerShell User Group Meeting with Keith Mayer (Round 2)

 

Thursday 1/24/2013 6:00 at MAX Technical Training

Before our December meeting came to a close, Keith mentioned a follow-up presentation. I am pleased to announce he will be joining us again on Thursday January 24th! He will continue his presentation with the second half of PowerShell management and virtualization – this time with a focus on managing Windows Azure virtual machines via PowerShell.

Registration and other details here: http://www.meetup.com/TechLife-Cincinnati/events/98558502/

Registration is optional, but helps us with planning.

.

1/02/2013

January SharePoint Events in the Cincinnati Area

 

 

Cincinnati SharePoint User Group Meeting – Thursday 1/3/2013  6:00-8:00

Please register here so we know how much food to get! http://www.meetup.com/TechLife-Cincinnati/events/94158842/

Lisa Gardner will present on SharePoint and SQL Server

SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configuration options are best for a SharePoint workload? What kind of maintenance should be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help DBAs better communicate with SharePoint application teams.

This presentation is aimed at DBAs who have to manage SharePoint databases, but it definitely pertains to SharePoint administrators as well.

  • Outline:
    • SharePoint Overview
    • SharePoint Databases – what they are, best practices, sizing guidance
    • SQL Server Configuration, Setup, and Maintenance for hosting SharePoint
    • What to look out for – common

Lisa Gardner
Microsoft Premier Field Engineer
SQL Server
US PFE - Central Region

 

Dayton SharePoint User Group Meeting – Tuesday 1/8/2013 6:00-8:00

Info here: http://www.dayspug.org/SitePages/Home.aspx

Session Title: What’s New in SharePoint Server 2013 for IT Pros

Abstract:
SharePoint Server 2013 can help you achieve new levels of reliability and performance, delivering features and capabilities that simplify administration, protect communications and information, and empower users while meeting their demands for greater business mobility. In this session you will learn more about what's new for IT Professionals in SharePoint Server 2013 and how its features and capabilities can help simply administration, protect communications and information, and empower users. Sign up for a FREE Windows Azure trial before this session at http://aka.ms/AzureCloudLab to prepare for building your own SharePoint Server 2013 lab in the cloud!

Speaker:
Keith Mayer is a Technical Evangelist at Microsoft focused on Windows Infrastructure, Data Center Virtualization, Systems Management and Private Cloud.

 

SharePoint Saturday Indy – January 12th, 2013

Register here: http://www.sharepointsaturday.org/Indy/default.aspx

SharePoint Saturday is coming back to Indianapolis. SharePoint Saturday is 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!

SharePoint Saturday Indianapolis will be held January 12th, 2013 on the campus of Indiana University-Purdue University Indianapolis (IUPUI) in the heart of downtown Indianapolis. Our call for speakers is now open, to submit download the submission form at http://sdrv.ms/TpsQHX, fill it out, and submit it to spsindy@outlook.com. If you are interested in sponsoring the event, please send an email to spsindy@outlook.com for more information. Keep an eye on this page for more information about the event as it develops.

 

.

12/31/2012

SharePoint 2013 First Looks for ITPros and Developers

 

I will be presenting two FREE First Look clinics this Thursday and Friday at MAX Technical Training. You can attend these sessions in person at MAX's Mason, Ohio training center or remotely using any PC.

Just for fun, when registering add a note that "Mike sent me!" (Or maybe… "Attending in spite of Mike")

 

MS-40027 First Look: What's New for Developers in Microsoft SharePoint 2013

More info here: http://www.maxtrain.com/Classes/ClassInfo.aspx?Id=43826

This 1/2 day instructor-led developer first-look course provides an overview of the new features, functional areas, product enhancements, and application models in SharePoint 13.

At Course Completion

  • Provide an overview of the new features, functional areas, and product enhancements in SharePoint 2013.
  • Summarize the key features of the SharePoint 2013 application development platform and describe the key features of Marketplaces.
  • Explain what a SharePoint-Hosted app is, and describe how to build a SharePoint-Hosted app.
  • Explain what a Cloud-Hosted app is, and describe how to build a Cloud-Hosted app.
  • Describe how developers extend Office Application user interfaces by creating Apps for Office and publishing them in different catalogs.
  • Describe how to create and code a simple App for Office that interacts with document content.
  • Describe improvements in Manage Metadata Services, Enterprise Content Management and Web Content Management in SharePoint 2013.
  • Describe the new social networking functionality available to SharePoint 2013 App developers.
  • Describe how the new capabilities of the SharePoint Search engine can be used in SharePoint Apps.
  • Describe how to query the index from a SharePoint-Hosted app using CSOM.

MS-40028 First Look Clinic: What’s New for IT Professionals in Microsoft SharePoint Server 2013

More info here: http://www.maxtrain.com/Classes/ClassInfo.aspx?Id=44107

This 1/2 day instructor-led first-look clinic explains the new and improved product features as applicable to IT Professionals and how to install, deploy, manage, and administer SharePoint Server 2013. It also provides information on how to integrate SharePoint Server 2013 with key applications and how to maintain and troubleshoot SharePoint Server 2013.

At course completion:

  • Identify the major new features in SharePoint 2013 for IT Pros
  • Discuss the major architectural changes in SharePoint 2013
  • Describe the major changes to the BCS and the search service
  • Describe the new BI and composites features in SharePoint 2013
  • Describe the new content management and compliance features
  • Identify the new features for social computing and mobile users

 

.

12/28/2012

Fun and Games with Site Collection Administrators

 

SharePoint has three kinds of Site Collection Administrators: Primary, Secondary and "other". When you edit the list of admins in Site Actions, Site Settings there is just a list of admins with no indication of kind. So who is the Primary? What happens when the list is edited and the Primary and / or Secondary is removed? Then who's the Primary?

This article has two parts:

  • Background on Site Collection Administrators
  • Weird Fun and Games

I did my testing in SharePoint 2010, but expect similar results in both 2007 and 2013. I'll test those when I get a chance.

Background

A Site Collection Administrator is:

  • a user assigned to the SPSite.Owner property. They are displayed in Central Administration as the "Primary site collection administrator".
  • a user assigned to the SPSite.SecondaryContact property. They are displayed in Central Administration as the "Secondary site collection administrator".
  • a user added in Site Actions, Site settings as a site collection administrator. They are not displayed anywhere in Central Administration. They are added in the site using Site Actions, Site Settings, Site Collection Administrators. (Both these admins and the Primary and Secondary admins have their SPUser.IsSiteAdmin property set to true.)

What makes them special:

  • All Site Collection Administrators have full control over the entire site collection and can see all content. (unless limited by Central Administration, Applications, User Policy)
  • Only the Primary and Secondary admins receive administrative email alerts for the site collection (Quota exceeded warnings and Site Use Confirmation and Deletion notices)

Finding them with Central Administration

image

Finding them with Site Actions, Site Settings

image

Finding them with PowerShell (just the Primary and Secondary here:

$site = get-spsite http://sharepoint/sites/training
$site.Owner
$site.SecondaryContact

Or for all Site Collections in a web application:

Get-SPWebApplication http://sharepoint | Select -ExpandProperty sites | Select url, owner, secondarycontact | ft -AutoSize

Now for the Fun and Games!

I created a new site collection and assigned:

  • Primary Site Collection Administrator (Owner):  susanj
  • Secondary Site Collection Administrator (SecondaryContact):  samc

I confirmed the admins in:

Central Admin:

image

Site Actions, Site Settings:

image

PowerShell:

Get-SPSite http://sharepoint/sites/test1 | select url, owner, secondarycontact

Url                           Owner             SecondaryContact
---                           -----             ----------------
http://sharepoint/sites/test1 SHAREPOINT\susanj SHAREPOINT\samc

 

Now I add two more Site Collection Administrators from Site Actions, Site Settings:

image

No change in Central Administration as these new admins are not the Primary/Owner or Secondary/SecondaryContact and have been added as "other site collection admins". (Their IsSiteAdmin property has been set to True.)

For PowerShell we need to add one more request to get the list of "other" admins (IsSiteAdmin=true)…

$site = Get-SPSite http://sharepoint/sites/test1
$web = $site.RootWeb
$web.AllUsers | Select UserLogin, IsSiteAdmin 

UserLogin                IsSiteAdmin
---------                -----------
SHAREPOINT\samc                 True
SHAREPOINT\administrator        True
SHAREPOINT\stellas              True
SHAREPOINT\susanj               True
SHAREPOINT\system              False

So now I have:

  • Primary Site Collection Administrator (Owner): susanj
  • Secondary Site Collection Administrator (SecondaryContact): samc
  • Additional admin: stellas
  • Additional admin: administrator

 

Now for the fun…

I logged in as Stella and then using Site Actions, Site Settings I removed sam and susan (the Primary and Secondary). So who is now what?

  • Primary Site Collection Administrator (Owner): stellas
  • Secondary Site Collection Administrator (SecondaryContact): none!
  • Additional admin: administrator

Then I added susan and sam back:

  • Primary Site Collection Administrator (Owner): stellas
  • Secondary Site Collection Administrator (SecondaryContact): none!
  • Additional admin: administrator
  • Additional admin: samc
  • Additional admin: susanj

I then tried all kinds of combinations of adding and removing admins from Site Actions, Site Settings and from Central Admin.

Learnings

  • There are two kinds of Site Collection Administrators: the ones who receive site event emails, and all of the rest. Except for the emails, they all have the same permissions.
  • The order of site collection administrators in Site Actions, Site Settings does not tell us who is the Primary or the Secondary. The order is simply the order the users are found in the SPWeb.AllUsers collection, sorted by DisplayName. There is no way to find out who the Primary or Secondary is except for Central Administration and PowerShell.
  • If a Primary Site Collection Administrator is deleted from Site Actions, Site Settings, a replacement is automatically selected using the first person found in order by ID. (ID's are assigned in the order users are added to the site collection. First user is ID #1, etc..)
  • If a Secondary Site Collection Administrator is deleted from Site Actions, Site Settings, a replacement is not automatically selected. A Secondary Site Collection Administrator can only be added from Central Administration or by using PowerShell.

Obvious, right?

 

.

 

 

 

 

 

 

 

 

    a

12/23/2012

SharePoint: Use my local drafts folder

 

Update: In SharePoint 2007 the "Use my local drafts folder" checkbox was checked by default. In SharePoint 2010 and 2013 it is not checked by default. Turns out that this is an Office default and not a SharePoint default and can be changed from the Options screen of Word or Excel. See here for how to change this default: http://techtrainingnotes.blogspot.com/2013/03/sharepoint-change-default-for-my-local.html

When checking out a document SharePoint 2007 and later offers an option to automatically download a copy of the file to your local machine.

    image

Selecting this option will download the file to your computer into a SharePoint Drafts folder inside of your My Documents folder.

    image

When you later check in the document, SharePoint will automatically upload the file from the SharePoint Drafts folder. The file is also automatically deleted from the drafts folder. The file will also be deleted if you Discard the Checkout.

image

If you cancel the upload you will also cancel the check in.

So far, a very hand feature!

 

There is an unexpected side effect of the "Use my local drafts folder" option…

  • Check out a document with the Use my local drafts folder option
  • Later return to the library and download the document
  • Edit the downloaded file and then upload back to the library
  • When you later check in the file, the copy of the file downloaded to your drafts folder will be uploaded, overwriting your previously uploaded file!

 

What about Security?

Just something to think about… do your users know what's in their draft folders? Is there any content getting downloaded into laptops and forgotten about?

 

.

12/22/2012

Weird problem with SharePoint Designer workflows and Office 365

 

I wanted to add a quick little workflow to a SharePoint Online / Office 365 (2010) site using SharePoint Designer 2010. When adding the workflow all I got was a blank screen.

My steps:

  • Open SPD 2010 and open the Online (2010) site
  • Click Workflows, click new List Workflow, select my list, enter a title and description, click OK
  • and…  nothing… no workflow editor, no error message, just a blank workflow list

                           image

Note that this was a SharePoint Online 2010 site, not a 2013 site.

The fix?

Create the workflow using SharePoint Designer 2013! SPD2013 can create both 2010 and 2013 style workflows, but when used with a 2010 site it can only create 2010 style workflows.

Here's the KB:

You have problems with workflows or receive errors in SharePoint Designer 2010
http://support.microsoft.com/kb/2794961

.

12/19/2012

CincyPowershell with Microsoft IT Pro Technical Evangelist Keith Mayer

 

Reminder for Cincinnati area PowerShell nuts!

Thursday, December 20, 2012, 6:00 PM at MAX

On December 20th, we will be joined by special guest speaker Microsoft IT Pro Technical Evangelist Keith Mayer. For this event, he will be speaking on Hyper-V and PowerShell. To learn more about Keith, visit his blog at http://blogs.technet.com/b/keithmayer/. We want to give Keith a great event too, so spread the word!

.

12/08/2012

SharePoint 2010–Hiding "Sign in as Different User"

 

The "Sign in as Different User" is a bad idea for a lot of reasons, but the two biggest are:

  • Security on the computer where "User B" wants to access SharePoint. While at this computer they could perform any number of actions as "User A".
  • Mixed experiences when using software other than a browser. As an example, "User B" can "Sign in as Different User" on the "User A" computer. Everything done from the browser, such as adding list items, is logged as "User B", but many actions performed from Word, Outlook and other tools will be logged as "User A"

"Sign in as Different User" is available from the Welcome menu and from the Access Denied page:

           clip_image002[6]           clip_image002[8]

 

How a Site Owner can hide "Sign in as Different User"

You can hide the "Sign in as Different User" option by adding a small block of JavaScript code to your site's master page just before the </body> tag.

<script type="text/javascript"> 
var doc = document.getElementsByTagName('ie:menuitem');  
for (var i = 0; i < doc.length; i++)  
{
    itm = doc[i];
    if (itm.id.match('LoginAsDifferentUser') != null)
      { itm.hidden=true; }
 } 
</script> 

Note: You can still "Sign in as Different User" by navigating directly to the Access Denied page:
  http://yourserver/sites/yoursite/_layouts/AccessDenied.aspx

 

How a developer or server administrator can hide "Sign in as Different User"

As there are two ways a user can get to the "Sign in as Different User" option you will need to make two different changes, one to the Welcome menu and one to the Access Denied page.

Warning:

  • Changes to ControlTemplates and Layouts folder impact all users on all sites in the farm!
  • Changes to the pages in the ControlTemplates and Layouts folder need to be documented as farm rebuilds or service pack updates could overwrite your changes.
  • You should make a backup copy of any files you edit.
  • All changes must be made identically on all web front end servers.
Updating the Welcome menu

The Welcome menu is implemented as an ASPX user control (.ascx) and is stored in the …\14\TEMPLATE\CONTROLTEMPLATES folder. Editing this file impact all users on all sites in the farm. You may want to use the "Site Owner" solution listed earlier in this article. Another option is to create a copy of the Welcome.ascx file and modify selected master pages to point to the custom version of the file.

  1. Open the Welcome.ascx file (or your custom copy) using Notepad or Visual Studio from
        …\14\TEMPLATE\CONTROLTEMPLATES 
  2. Find the MenuItemTemplate with the ID of ID_LoginAsDifferentUser
  3. Then do one of the following
    • Delete the MenuItemTemplate control
    • Add these two options to the MenuItemTemplate control to limit the display of the menu item to only Site Owners
         PermissionsString="ManageWeb"
         PermissionMode="Any"
Updating the Access Denied page (AccessDenied.aspx)
  1. Open the AccessDenied.aspx page using Notepad or Visual Studio:
       …\14\TEMPLATE\AccessDenied.aspx
  2. Find the following code:
      <asp:HyperLink id="HLinkLoginAsAnother"
      Text="<%  $SPHtmlEncodedResources:wss,accessDenied_logInAsAnotherOne%>"
      CssClass="ms-descriptiontext" runat="server"/>
  3. Then do one of the following:
    • Delete the code
    • Wrap the code in a comment block
    • Wrap the code in a SPSecurityTrimmedControl with a permission level such as ManageWeb (see this article) so Site Owner can still see the option.

<Sharepoint:SPSecurityTrimmedControl runat="server" PermissionsString="ManageWeb">

  <asp:HyperLink id="HLinkLoginAsAnother"
  Text="<%$SPHtmlEncodedResources:wss,accessDenied_logInAsAnotherOne%>"
  CssClass="ms-descriptiontext" runat="server"/>
</SharePoint:SPSecurityTrimmedControl>

 

.

12/05/2012

Cincinnati SharePoint User Group

 

The December meeting has been canceled!

http://www.CincinnatiSPUG.org

January 2013 Meeting - SharePoint and SQL Server

Lisa Gardner will present on SharePoint and SQL Server

Lisa Gardner
Microsoft Premier Field Engineer
SQL Server
US PFE - Central Region

SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configuration options are best for a SharePoint workload? What kind of maintenance should be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help DBAs better communicate with SharePoint application teams.

This presentation is aimed at DBAs who have to manage SharePoint databases, but it definitely pertains to SharePoint administrators as well.

  • Outline:
    • SharePoint Overview
    • SharePoint Databases – what they are, best practices, sizing guidance
    • SQL Server Configuration, Setup, and Maintenance for hosting SharePoint
    • What to look out for – common

 

 

See you in January!

http://www.CincinnatiSPUG.org

Note to spammers!

Spammers, don't waste your time... all posts are moderated. If your comment includes unrelated links, is advertising, or just pure spam, it will never be seen.