Office Professional Plus – via Office 365

November 6th, 2011

Well, either I missed something earlier or they changed the offering.  Either way, this is pretty cool.  I was under the impression that you had to be a Plan E (Enterprise) customer of Office 365 to be able to purchase a subscription to the Office client applications.  That is NOT the case.  You can also purchase a subscription as a Plan P user. 

There is a few dollars per user per month difference, but the key difference is that Plan E users need to purchase an annual subscription while the Plan B (Small Business) users can do a monthly subscription.  Pretty cool. 

  • Plan E will pay $12/user/month – annual subscription
  • Plan P will pay $15/user/month – monthly subscription

These services also enable access to the Office Web Apps as well, so they can access the web versions of the applications without needing to load the client app, or if they are on another machine view and edit documents without the client apps at all. 

For more information, check out this page:
http://www.microsoft.com/en-us/office365/buy-office-professional-plus.aspx#fbid=qv4rqlTfnei

More good news for small business owners if you ask me. 

Post to Twitter Post to Facebook

SharePoint Conference 2011 (SPC11) Notes

October 21st, 2011

A few weeks ago Microsoft held the official SharePoint Conference in Anaheim, CA.  If you are involved with the SharePoint community, you’ve likely seen and heard a lot about it already.  This conference wasn’t filled with sessions on features as much as the last conference, but had a lot of practical info on how organizations have been using and been successful with SharePoint in their organizations. 

The two items I was most excited about during the keynote were:

  1. There will be a SharePoint Conference 2012
    This one will likely coincide with content about SharePoint vNext.  Odds are good that we’ll be going back to the 2009 type of content that is more features, features, features about the new platform. 
    Set your calendar: November 12-15, 2012 in Las Vegas, NV
  2. BDC is coming to Office 365 and SharePoint Online – soon. 
    By soon they mean by the end of the year.  Those of us that have Office 365 accounts have already been notified that there will be system updates happening between Oct 20th and the end of November. 
    This is one of the really exciting things about Office 365, that we can (hopefully) expect more frequent updates to features…
    Now we need to see what the details of this are and how we can extend our SharePoint Online capabilities. 

So, a lot to look forward to. 

If you’re interested in following more SharePoint people on Twitter, Raymond put together a list of all SPC11 speakers, their web sites and Twitter handles if they were available.  

If I can find the time, I’ll do some follow-up on the three sessions I enjoyed:

  • SPC289  Visio Services – Creating No-code Visio Services Dashboards using Office 365 by Christopher Hopkins and Krishna Mamidipaka
  • SPC290 The City of SharePoint: What SharePoint Planners Can Learn From City Planning by Craig Roth (Gartner)
  • SPC393 Step-by-Step: Building Search-Driven Applications that Matter by Scot Hillier

Post to Twitter Post to Facebook

SharePoint Saturday Twin Cities–October 29th, 2011

October 21st, 2011

The next SharePoint Saturday event in the Twin Cities will be taking place in just over a week on Saturday, October 29th at Normandale College in Bloomington, MN.  If you haven’t already registered – do it now.  We’ve already got over 400 people registered to attend a day of fun with the SharePoint Community in Minnesota and surrounding areas.  Come and learn about SharePoint and Office 365 in sessions for for users, developers, administrators and people new to SharePoint and SharePoint Online. 

We’ve got 25 speakers giving 27 sessions in 7 tracks through out the day.  This includes two new tracks that we’re excited about.  We have a SharePoint 101 track featuring several national speakers as well as a Hands-on Lab track being managed by Mindsharp.  Be sure to come and visit all of the sponsors that make the event possible. 

I’ll be kicking off the SharePoint 101 track with a “What is this thing called ‘SharePoint’” session that’s been described as a SharePoint session you could send your mom to.  Smile   (and one attendee did)

Check out the schedule and tell us which track you’re likely to attend most of the day. 

Also, check out GuideBook as an app for your iPhone or Android device or m.guidebookapp.com on other devices as we’ll soon have our event information available there as a tool to use during the event. 

Register Now!

Post to Twitter Post to Facebook

Minnesota SharePoint User Group (MNSPUG) Location Change

October 21st, 2011

With Microsoft’s Bloomington Minnesota office moving to Edina, the Minnesota SharePoint User Group meetings will be moving as well.  The next meeting on November 9th and all meetings after that (I believe) will be held at the Microsoft Technology Center (MTC) location in Edina. 

Hopefully they’ll get information about the new location, parking, etc. on the MNSPUG site soon. 

Post to Twitter Post to Facebook

SharePoint Saturday – Columbus, OH

September 18th, 2011

(FINALLY posted…)

SharePoint Saturday Columbus (OH) was held a few weeks back on August 20th.  The organizers did a wonderful job organizing the event and pulling everything together at a nice venue and pulled together about  130 or so attendees. 

I presented my Lists: Used, Abused and Underappreciated session in the first time slot of the day, had decent attendance (25 or so) and fantastic participation throughout the session.

If you weren’t able to stick around until the last timeslot of the day, Jennifer Mason did a session on simple dashboards which was an excellent follow-up to the content introduced in my session.  Check her slides out – HERE.  

My apologies for the delay in getting the slides out there – I had a slight detour on my way home and was off the grid for 5 days or so – only now getting back up to speed.  My slides can be found on SlideShare – HERE

Please let me know if you have any questions!

Post to Twitter Post to Facebook

Office 365 – SharePoint Online ‘Sharer’ Beware

September 12th, 2011

The short story:

Beware of using the ‘Share Site’ or ‘Share this site’ links in Office 365 – SharePoint Online without knowing exactly what it is doing: you are potentially granting users access to more content than you intend to. 

The longer explanation:

In my opinion, security is one of the most confusing things in SharePoint for users to manage.  This is both because the flexibility of its design leads to a confusing implementation and because most users aren’t properly trained on how SharePoint security works (yes, this should be handled through a governance policy). 

Because of this, a number of issues usually arise: users don’t have enough access or users have too much access.  Just this weekend I was chatting with someone that uses SharePoint in their organization and she described a conversation with their SharePoint contact who was giving her access to a site – or so she thought.  Typical, irritating to users and something that needs to be handled better in order to successfully accomplish user adoption.  

The flip side of that problem is giving users too much access – more access than you are intending them to have.  Sometimes this isn’t that big of a deal, but many times it can be a serious issue with competing clients seeing each other’s content, etc. There are many examples of how this could turn out badly.    

Well, in SharePoint Online, as part of Office 365, Microsoft has added a nice and easy way to grant users access to SharePoint by way of the ‘Share this site’ link.   Unfortunately, while this is a very easy way to grant users access, it will in many cases grant too much access unintentionally – not because it doesn’t work properly, but because it isn’t doing what most users will expect it to do.

First, a quick primer on SharePoint security:

  • SharePoint has a number of containers and entities, all of which can have security attached to them:  Site collections, sub sites, lists or libraries, folders (I’m not touching this topic in this article) and items.   
  • Security can be assigned directly to these containers and items by adding a user and defining the permissions they have.  Users can also be granted access through an Active Directory security group or a SharePoint security group. 
  • By default, security in SharePoint is inherited.  When you have security on a site collection and create a sub site, you can tell SharePoint to have the sub site inherit the permissions of the parent site collection.  People and groups will have the same permissions to view, add and update on the sub site content as they did on the site collection. 

There are lots of details to work through if you want to dig in, but those are the basics.  Now to the specific problem scenario. 

I have a SharePoint Online site collection and I want to create an area where I can collaborate with people outside my organization on a project.  To me, this translates into a sub site (or even better a site collection if possible) because I can isolate security at a whole site level, I can have a landing page for users, I can add additional lists later without having to change security, etc. So, I create my sub site. 

By default, my site has a document library which is all I really need for starters.  Now, I want to grant my external users access to the site – here comes the potential issue.  SharePoint Online has the ‘Share this site’ link right on the default page.  You can get to the same functionality by going through the Site Actions menu and selecting ‘Share Site’.  Both are shown below.

image

image

Either of these links will open up the following form:

image

Herein lies the potential for a security issue.  Now, the form does some nice things.  It allows you to add users to groups and then send them an email that will alert the user to the fact that they now have access and provides them a link to the site, list, etc. that you’ve just given them access to.  Where this form causes issues is by only allowing you to add them to the pre-existing ‘Visitors’ or ‘Members’ SharePoint security groups.  By adding users to the ‘Visitors’ or ‘Members’ groups, you are very likely granting them access to more than just the sub site. 

The Members and Visitors groups are default groups added to most SharePoint sites and many site administrators allow the groups to be inherited in sub sites and lists as they are created.  Members are generally able to read most everything and contribute to most lists and content.  Visitors can read, but not contribute.  If I were to add my external users that I want to collaborate with on one specific sub site to either of these groups, they’d have access to much of the rest of my site as well unless I had specifically gone and locked down my other content by breaking inheritance and/or removing the Member and Visitor groups from my other sites and content – which most administrators or users do not do. 

Suggested Approach:

The suggested approach to granting users access to only the sub site (or list) is to do it directly/explicitly rather than using the shortcut.

  • On the sub site, select Site Actions –> Site Settings

    image

  • Select Site permissions

    image

  • In the ribbon, select ‘Stop Inheriting Permissions’

    image

  • Now, there are plenty of variations here, but we’re going to add a new group.  Even if I’m only adding a single person right now, it’s better to have a group in place in case you want to add others later with the same permissions.  The group will be visible throughout the site collection (trivia, but might actually be relevant if you have groups for partners, clients, etc. in the same site collection).  So select Create Group from the ribbon.

    image

  • For simplicity’s sake in this example, give the group a name and select the permission level you’d like for the group.  I’m using ‘Contribute’.  Click Create.
  • From the Permissions page (where you land after creating or adding a group), click the name of your group.
  • You are listed as a member by default, but now you can also add other users who will all take on the permissions of the group.  More importantly, they will only have permissions in the sub site, rather than in other areas of your site collection that you might not want them to have access to.  Click New –> Add Users

    image

SharePoint security and permissions have many options.  Be aware of what you are doing when adding users, groups and managing their permissions in order to maintain the security you need and want. 

Post to Twitter Post to Facebook

SharePoint Online (O365) and Windows Phone

September 10th, 2011

I LOVE the ability to view my SharePoint calendars in Outlook right with my Exchange calendars.  This is one of the greatest features ever in my opinion.  The problem now is that I expect to be able to do the same thing on my smartphone devices – but cannot.

Playing with the Windows Phone (pre-Mango) tonight and was hoping to be able to display a SharePoint calendar in my phone’s calendar view.  You’d think if anyone could do it, it should be the MS device but no go. 

Here’s the official post/statement:  http://community.office365.com/en-us/w/sharepoint/527.aspx

Ok.  It’s lame, but Mango isn’t that far out, so we’ll just wait and see. 

Sad smile

To be fair, I haven’t found a way to get this to work on the iPhone/iPad either, though there are a number of 3rd party apps available to assist with access to SharePoint sites.  On the iPad, the screen is big enough to actually navigate to the calendar site itself, which is better than nothing, but I still would like the one-stop-shop available with Outlook. 

Bamboo got close at one point – it looks like a product called MashPoint actually allowed some functionality for ‘real’ SharePoint servers for 2007, but nothing is available for 2010 or the Office 365 solution (sandbox solution).    

If Mango can pull this off – major points to them.  It still won’t solve the problem of my wife wanting to access our family SharePoint calendar on O365 though… Her employer doesn’t allow browser access to O365 – #FAIL. 

Post to Twitter Post to Facebook

SharePoint Designer 2010 Error

August 12th, 2011

I was working on a project where I need to create additional forms for a SharePoint 2010 list. 

The list is a custom list with a number of fields added – nothing fancy (yet). 

I open up SharePoint Designer from the list ribbon and select New form, enter a name and hit OK, only to receive the following error:

image

“Could not save the list changes to the server.”  This translates into “something happened and we don’t have any more details for you.  Virtually useless. 

image

There are a lot of posts and forum entries out there for this, many of which were resolved with things like cleaning out the recycle bin.  Not so in my case. 

Just for kicks, I wanted to see if the problem was on my end.  I opened up an Office 365 site I had easy access to and repeated the same process of opening a list, then jumping into SPD from there to add a new form and it worked flawlessly.  So, pointers back to something on the server-side. 

Back to the server.  Next, I tried editing the existing forms.  Normally I like to leave the existing stuff alone, but I was early enough in the process where it wouldn’t make a big difference for me to delete everything and start over if I messed anything up.  Anyhoo – I got another error message:

image

And clicked “Details”, which gave me the following:

“soap:ServerServer was unable to process request. —> Value does not fall within the expected range.”

This error was more helpful and turned up some better information.  I found the following forum post related to the latest error:
http://social.technet.microsoft.com/Forums/en/sharepoint2010customization/thread/aa093ec9-e491-4fdf-b233-a1ba3eba0f75

The URL for my web application was listed as:  “http://servername/”

The URL that I have been using to access the environment looks more like “http://servername.domain.company.com”.  Per the suggestion in the forum post, I added an alternate access mapping of the long name for an intranet zone, refreshed my browser, opened the list in SPD and was able to create a new form. 

Hopefully this post will help someone with the same issue find the resolution more quickly… 

Post to Twitter Post to Facebook

SharePoint ShopTalk – SharePoint Online (Office 365)

June 27th, 2011

At last week’s SharePoint ShopTalk, the organizer asked me to do a quick overview of SharePoint Online and Office 365 – nothing too formal, just enough to start the conversation.  So, I jotted down some notes, which I threw in to PowerPoint for my own purposes… which evolved into uploading them to the ShopTalk Live Meeting and was then asked to make them available – so I dropped them on SlideShare. 

Now, a few days later they’ve had over 350 views.  I even got a note from Slideshare on Friday that it was ‘trending’ on LinkedIn, so they put a link on the SlideShare homepage.  Neat. 

Kind of cool, though not as crazy as Spence’s Pod Show that had over 500 viewings in the first HOUR.

The recording of the ShopTalk session is now available HERE.  Keep in mind, this isn’t something we did a lot of preparation for, so I’m kind of rambling.  Hopefully someone might find it useful.  Smile 

If you’re interested in SharePoint Online and Office 365, check back as I should have a case study for small business posted soon. 

Enjoy the launch tomorrow! 

Post to Twitter Post to Facebook

Random Links – 6/22

June 22nd, 2011

And another set of interesting links to check out…

First, the latest and greatest from Microsoft on SharePoint:
http://www.iusesharepoint.com

Why are Small Businesses Choosing Office 365 Over Google Apps?
http://blogs.technet.com/b/whymicrosoft/archive/2011/06/21/why-are-small-businesses-choosing-office-365-over-google-apps_3f00_.aspx

Remember Microsoft Tag?  Maybe?  Maybe Not?  It came out years ago, but seems to be making a surge.  I’ve even seen them on plants at Home Depot… 
http://tag.microsoft.com/consumer/index.aspx

I particularly enjoyed this quote:  “If you are implementing a SharePoint initiative with the idea that you will begin with customization, your org will never realize the full benefits of SharePoint”
https://www.nothingbutsharepoint.com/sites/eusp/Pages/SharePoint-for-Nonprofits-Part-III.aspx

Have you visited the SharePoint Pod Show?
http://www.sharepointpodshow.com/

Love this example of Crawl, Walk, Run solutions for BI.  I’d put this in the ‘walk’ category. 
http://sympmarc.com/2011/06/20/one-of-the-most-impressive-web-pages-i-have-ever-seen-in-sharepoint/

Some getting started with Office 365 references:
http://blogs.msdn.com/b/devschool/archive/2011/06/05/free-training-kit-for-sharepoint-and-office365.aspx

Very cool wire-framing tool.  There’s also an iPad app that will export to Balsamiq format (From @ruveng)
http://balsamiq.com/products/mockups

Microsoft calls them “Information Workers”.  Interesting article from 1.5 yrs ago…
http://www.gartner.com/it/page.jsp?id=1212813

Application Template from MS for Absence Requests and Vacation Schedules:
http://www.microsoft.com/download/en/details.aspx?id=26212

Nice overview of Office 365
http://www.zimmergren.net/archive/2011/06/12/office-365-part-1-what-is-office-365-and-how-can-my-organization-benefit-from-using-it.aspx

July 6th Webinar coming up… Using SharePoint 2010to create a highly developed Learning Gateway for education:
http://sharepointineducation.com/using-sharepoint-2010-to-create-a-highly-developed-learning-gateway-for-education-free-webinar

List comparisions: Lists, Excel, InfoPath and Access
http://www.sharepointsharon.com/2011/06/managing-data/

Post to Twitter Post to Facebook