Enable Custom Master Pages on SharePoint 2010

The Problem:

You have created a custom master page.  It looks great.

Now, how do you apply it to the Site Collection and all of the Subsites?

*** If you already have a Site Collection with the custom Master Page enabled, and have added a new Subsite that isn't inheriting, please skip to Subsite.

Site Collection:

We need to verify that the master page you wish to enable, is published and approved by visiting:

http://[SharePoint2010SiteCollection]/_catalogs/MasterPage/Forms/AllItems.aspx

Here, you should see a list of all of the master pages and branding pages that are available on the Site Collection, including the out-of-the-box master pages included with SharePoint 2010.

To verify this file is published and approved, make sure it is present in this list, and shows an 'Approval Status' of Approved.  If you need to publish a master page, simply check the page in.

Once we have verified the master page, we need to visit the Change Site Master Page form here:

http://[SharePoint2010SiteCollection]/_layouts/ChangeSiteMasterPage.aspx

Here, you will find the Site Master Page Settings, which includes the Site Master Page and System Master Page selections.  After selecting the option to 'Specify a master page to be used by this site and all sites that inherit from it', you should be able to find your custom master page in the dropdown.  After changing both the System and Site master pages, click 'OK' to apply the changes.

Subsite:

Now that your custom master page is activated on your Site Collection, you may have some issues when creating new subsites.  The master page seems to revert back to the default SharePoint 2010 master page.

In order to fix this, we will visit the Change Site Master Page again, this time on the subsite level:

http://[SharePoint2010SiteCollection]/[subsite]/_layouts/ChangeSiteMasterPage.aspx

Here you will find the same options as you saw on the Site Collection change page.  We will follow the same steps again:

• Select the option to 'Specify a master page to be used by this site and all sites that inherit from it' 
• Your custom master page should be available in the dropdown.  
• After changing both the System and Site master pages, click 'OK' to apply the changes.

linkback: http://stackoverflow.com/questions/3532367/sharepoint-2010-how-to-apply-custom-master-page-and-theme-to-all-subsites

Export User Groups to Excel - SharePoint 2010

EDIT 04/25/17: Updated Export Technique

Here's a topic that came up today with a user:

"I have a SharePoint Permissions Group with a few hundred people in it.  Is there a way I can export the list of people in the group to Excel?"

After a bit of digging around in the Permissions, I found that SharePoint doesn't have this functionality built-in.

Google to the rescue.

*** I was able to find 2 solutions, neither one of which can pull user groups individually.  Both solutions will pull all users in all groups.  The only way to pull users by the group is using SQL Server queries against your database or by having access to the SharePoint servers to run PowerShell scripts. ***

Anyhow, you should be able to work with a complete dump of all users in all groups.

SOLUTION 1

1.  Navigate to the People and Groups tab under Site Settings [Site Settings > People and Groups]

2.  Copy the URL of the People and Groups page.

3.  Open up your Excel workbook, and click on the Data tab.

4. Click "From Web" and paste the URL from the People and Groups page into the Address Bar.

5.  After the page loads, you will see an arrow pointing to the list of group members.  Upon hovering over this arrow, the list of group members will be highlighted.  Click this arrow, then click Import, then OK.

After a few seconds, you will have a workbook full of users!
_________________________________________________________________________________

I was also able to uncover a little hack that allows the user to export a User Group to excel.

SOLUTION 2

1.  Go into Site Permission [Site Settings > Site Permissions]

2.  Click on the User Group that you would like to export, and go into List Settings [Settings > List Settings]

3.  Down at the bottom of the List Settings page, you'll see a couple of views.  Here, we will click on the Detail View.

4.  In the URL of the Detail View page, you will see that there is a List ID and a View ID.  We want to copy both of these, making sure not to include the ? before List ID, and the & after View ID.

5.  SharePoint contains built-in functionality for exporting other types of lists.  It is accessible through URL manipulation.

http://<sitename>/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=<ListID>&View=<ViewID>&CacheControl=1

Here, you will see where the List ID and View ID come in to play.  Simply enter your append the query string to your site URL with the appropriate List and View ID, press "Enter" and you should see a dialog box asking you to save file.

Save the file, and open it with Microsoft Excel.
___________________________________________________________________________________

Please post any comments or questions to below!

Check out MaintainYourRide.com if you need advice on DIY Automotive maintenance.


linkback: http://sharepoint-works.blogspot.com/2012/03/export-sharepoint-user-groups-in-excel.html#.UWRiTFewUfc