Reminder! Cincinnati and Dayton SPUG March Meetings

---

Cincinnati SharePoint User Group
Next meeting: TONIGHT 3/7/2013 - 6:30 PM (Pizza and networking at 6:00 PM!)  (details below)

 

Dayton SPUG
Next Meeting - Tuesday, March 12, 2013 starts at 6:00 p.m. (details below)

---

Update!

If we get at least 30 people to the March meeting MAX Technical Training will donate a free pass to SharePoint Cincy 2013! And... everyone will get a MAX T-shirt. And... I think I've still got a radio controlled helicopter around... And there's still a book or two...

So... drag your friends and coworkers to the meeting! (And please click the I'm attending button on the TechLife Cincinnati Site so we know how much food to order!)

---

Cincinnati SharePoint User Group
Next meeting: 3/7/2013

Tony Maddin will present:

SharePoint 2013 Real Estate – Do you buy, rent, or both?

Tony Maddin will be presenting on the SharePoint 2013 hosting models for on-premise, Office365, and the Hybrid (both on-premise and Office365 tied together) to share insight on features should be reviewed in order to help an organization to choose the right model that fits.

Past Meetings...

---

Dayton SPUG: @DAYSPUG

Next Meeting - Tuesday, March 12, 2013 starts at 6:00 p.m.
Event: DAYSPUG Annual Social Gathering. A great way to celebrate the upcoming SharePoint 2013 launch, SharePoint 2010 Service Pack 2, Office365, spring season, and surviving the Mayan calendar prediction.

PLEASE RSVP HERE

Location: Fox and the Hound. Beavercreek, Ohio
Event Details: DAYSPUG will be hosting a social gathering this month in lieu of our normal monthly meeting. Appetizers and soft drinks will be provided. All draft beers are $2 all night! Come on out, meet some new SharePoint friends, and support the community! Applied Information Sciences will be our gracious sponsor for the night.
Time: 6:00 p.m. to 8:00 p.m.

---

Interested in HTML5 and CSS3?

The user group gets points if you sign up! (Points = free books!)

Free HTML 5 online training here:

---

And don't forget… SharePoint Cincy 2013 is coming soon! April 19th

Third Annual SharePoint Cincy Event!

http://www.sharepointcincy.com/

Choose From Multiple Tracks:

This conference promises to have something for every level of your organization and every IT professional who has an interest in SharePoint.

• Driving Business Value with SharePoint
• Application Development in SharePoint
• SharePoint Implementation and Administration
• Business Intelligence and Data Management
• Site Owners, Content Managers & Power Users

Who should attend?

• Application/Software Developers
• Information Architects
• SharePoint Administrators
• IT Business Leaders
• Knowledge Workers
• IT Professionals

New SharePoint 2013 content in TechNet

 

Microsoft released a lot of new content on SharePoint 2013 in TechNet in February. After a quick count, it looks like around 40 new articles and number of updated articles. Lots of good stuff here…

Here's the link to a list of the articles:  http://technet.microsoft.com/en-us/library/cc262043.aspx

A little light reading for the weekend…

.

SharePoint 2013 First Looks for ITPros and Developers–Classroom and Webinar

 

I will be presenting two FREE SharePoint 2013 First Look clinics this March 8th at MAX Technical Training. You can attend these sessions in person at MAX's Cincinnati area Mason, Ohio training center or remotely using any PC.

• MS-40027 First Look: What's New for Developers in Microsoft SharePoint 2013
  March 8th, 2013 1:00 PM - 4:00 PM EST
  Click here to register: http://www.maxtrain.com/Classes/ClassInfo.aspx?Id=43826
  
• MS-40028 First Look Clinic: What’s New for IT Professionals in Microsoft SharePoint Server 2013
  March 8th, 2013 9:00 PM - 12:00 AM EST
  Click here to register: http://www.maxtrain.com/Classes/ClassInfo.aspx?Id=44107

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

.

And if you can't get enough of SharePoint 2013…

Tony Maddin will present the night before, March 7th, at the Cincinnati SharePoint User Group on:

SharePoint 2013 Real Estate – Do you buy, rent, or both?

Tony Maddin will be presenting on the SharePoint 2013 hosting models for on-premise, Office365, and the Hybrid (both on-premise and Office365 tied together) to share insight on features should be reviewed in order to help an organization to choose the right model that fits.

Cincinnati and Dayton SPUG March Meetings

---

Cincinnati SharePoint User Group
Next meeting: 3/7/2013 - 6:30 PM (Pizza and networking at 6:00 PM!)

---

Update!

If we get at least 30 people to the March meeting MAX Technical Training will donate a free pass to SharePoint Cincy 2013! And... everyone will get a MAX T-shirt. And... I think I've still got a radio controlled helicopter around... And there's still a book or two...

So... drag your friends and coworkers to the meeting! (And please click the I'm attending button on the TechLife Cincinnati Site so we know how much food to order!)

---

Tony Maddin will present:

SharePoint 2013 Real Estate – Do you buy, rent, or both?

Tony Maddin will be presenting on the SharePoint 2013 hosting models for on-premise, Office365, and the Hybrid (both on-premise and Office365 tied together) to share insight on features should be reviewed in order to help an organization to choose the right model that fits.

Past Meetings...

---

Dayton SPUG: @DAYSPUG

Next Meeting - Tuesday, March 12, 2013 starts at 6:00 p.m.
Event: DAYSPUG Annual Social Gathering. A great way to celebrate the upcoming SharePoint 2013 launch, SharePoint 2010 Service Pack 2, Office365, spring season, and surviving the Mayan calendar prediction.

PLEASE RSVP HERE

Location: Fox and the Hound. Beavercreek, Ohio
Event Details: DAYSPUG will be hosting a social gathering this month in lieu of our normal monthly meeting. Appetizers and soft drinks will be provided. All draft beers are $2 all night! Come on out, meet some new SharePoint friends, and support the community! Applied Information Sciences will be our gracious sponsor for the night.
Time: 6:00 p.m. to 8:00 p.m.

---

Interested in HTML5 and CSS3?

The user group gets points if you sign up! (Points = free books!)

Free HTML 5 online training here:

---

And don't forget… SharePoint Cincy 2013 is coming soon! April 19th

Third Annual SharePoint Cincy Event!

http://www.sharepointcincy.com/

Choose From Multiple Tracks:

This conference promises to have something for every level of your organization and every IT professional who has an interest in SharePoint.

• Driving Business Value with SharePoint
• Application Development in SharePoint
• SharePoint Implementation and Administration
• Business Intelligence and Data Management
• Site Owners, Content Managers & Power Users

Who should attend?

• Application/Software Developers
• Information Architects
• SharePoint Administrators
• IT Business Leaders
• Knowledge Workers
• IT Professionals

SharePoint 2013 Site Members Can Create and Delete Lists!

 

Have you noticed that when you create a new site collection or subsite with unique permissions that your team members can:

• Create new lists and libraries (now called Apps)
• Customize lists and libraries
• DELETE LISTS AND LIBRARIES!
• The Help button on a site also says "With the proper permissions – Full Control, Design, or Edit – you can activate or deactivate specific features for your site", but my testing shows that users with Edit cannot enable/disable features. (Now that would be scary!)

In SharePoint 2007 and 2010 the default members group was assigned the Contribute permission level. Contribute permitted them to add, edit and delete content, but not lists and libraries. In SharePoint 2013 the members group is now assigned the new Edit permission level, which adds the "Manage Lists" permission.

What can you, or should you, do?

If you don't like team members deleting lists then consider one or more of the following:

• Ask your team members to please not add, edit or delete "Apps" (Lists and Libraries)   :-)
• In each Site Collection edit the Edit permission level an remove the "Manage Lists" permission
• Update your governance plan to deal with this interesting little issue
• Enable Auditing at the site collection level so you at least know who did the damage

 

.

Cincinnati SPUG Meeting this Thursday

 

We meet at MAX at 6:00 for food and networking and start the meeting at 6:30.  Details here.

I'll be presenting…

The Mystical SharePoint Super User and Auditor

A look into SharePoint User Policies, the creation of “super users” and how to take away powers from everyone else!

In this session we will explore SharePoint Permission Policies and User Policies to grant application wide permissions to selected users to create the often mentioned but rarely documented “Auditor” and “Super User” roles. We will also see how to use SharePoint’s only option to deny permissions to restrict even Full Control users from things like creating subsites.

Mike Smith is a SharePoint MVP, a Senior Instructor at MAX Technical Training, author and an official SharePoint nut.

Add a Content Editor Web Part (CEWP) to a Survey

 

Had an interesting question… how do I add a Content Editor Web Part to a SharePoint survey. Turns out this is pretty easy, with one trick, one bug and one caveat.

• SharePoint 2007 will need a web part trick.
• SharePoint 2013 has a "bug" that requires you to edit the page in SharePoint Designer. The steps below include 2013 just in case they fix the bug! Be forewarned, adding a CEWP in Designer 2013 is not trivial as they left out the Design View. You have to hand edit your HTML for the web part!
• The caveat has to do with how multipage surveys are displayed. There are only two web pages, no matter how many Page Separator columns you added; one web page for page 1 (Newform.aspx) and one web page for all other "pages" (Editform.aspx). What this means is that you cannot add a different page level (or web part) customization on "page 3" than on "page 4".
• Trivia: Both SharePoint 2010 and 2013 surveys still use the old 2007 user interface! No ribbon!

When you respond to a multipage survey the following happens:

1. NewForm.aspx is displayed. (this is the first "page" of your survey) When you click Next SharePoint creates a new list item in the Survey list and then loads EditPage.aspx for the rest of the questions. The URL for the first page looks like this:
     http://sharepoint/sites/Training/Lists/Survey/NewForm.aspx?IsDlg=1
       (2007 and 2013 do not add the "?IsDlg=1".)
2. EditForm.aspx is displayed for "page 2" starting with the next question in the survey. In my example the question is named "Comments":
     http://sharepoint/sites/Training/Lists/Survey/EditForm.aspx?ID=7&FirstField=Comments&IsDlg=1
       (2007 and 2013 do not add the "?IsDlg=1".  ID is the item ID of this survey response.)
3. EditForm.aspx is displayed for "page 3" starting with the next question in the survey. In my example the question is named "How many days?":
     http://sharepoint/sites/Training/Lists/Survey/EditForm.aspx
     ?ID=7&FirstField=How%5Fx0020%5Fmany%5Fx0020%5Fdays%5Fx003f%5F&IsDlg=1

Note that after page one the same web page (and web part) is used to display all remaining questions. They only difference is the FirstField parameter in the URL. So… an edit made to NewForm.aspx is displayed on the first page of the survey while an edit made to EditForm.aspx is displayed on all survey pages after page 1.

 

Here's the steps for SharePoint 2007, 2010 (or Office 365 2010) and 2013:

1. Create the survey as usual
2. Go to the survey and click "Respond to this Survey". (you will be on NewForm.aspx) If it is a multi page survey and you want to edit everything after page 1 then click Next. (You will be on EditForm.aspx)
3. For SP 2010, right-click in a blank area in the dialog box and click Properties. Copy the URL (make sure you get it all as only two lines are displayed) Paste the URL into the browser's address bar. If you are working with 2010 then remove the "?IsDlg=1" from the URL. Press Enter to display the form.
4. For 2007 add "&ToolPaneView=2" to the end of the URL Press Enter to display the form.
5. For SP 2010 and 2013 click Site Actions (The "gear" for 2013) and Edit Page. (2007 is already in edit mode due to the ToolPaneView=2.)
6. Click Add A Web Part and add your Content Editor Web Part. This is where SP 2013 fails. The panel to add a web part is displayed behind the web page. You can see it but not click it. Go to SharePoint Designer, open the site, open the survey list and edit NewForm.aspx or EditForm.aspx and add the web part there.
7. Click the dropdown menu on the web part and click Edit Web Part. For SP 2007 click the Rich Text button. For SP 2010 click in the web part and start typing. For SP 2010 the text editor ribbon will not be displayed. You may want to create the text in another CEWP and copy and paste it into this CEWP.
8. Click the OK in the web part's Properties panel to save your changes.
9. Test your survey.

Tip: When you create your survey checkmark "Allow multiple responses". If you forgot to do this then go to the Survey and click Settings, Survey Settings, Title Description and Navigation.

 

For more survey customization options see Chapter 12 of my book SharePoint Customization for the Site Owner. 

What's in this chapter?

• A list of survey tips, including how to create custom views
• A better Yes/No field for surveys and lists
• Adding a Welcome or Instructions message to the Overview page
• Adding a Welcome, Instructions or Thank You message to the survey
• Adding Color, Fonts and HTML to Surveys

.

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.

 

.

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.

.

January SharePoint Events in the Cincinnati Area

 

• Cincinnati SharePoint User Group Meeting – Thursday 1/3/2013
• Dayton SharePoint User Group Meeting – Tuesday 1/8/13
• SharePoint Saturday Indy – Saturday 1/12/2013

 

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.

 

.