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

.