Guide to Selecting the Best LED Light Bar for your Car or Truck

Check out MaintainYourRide.  The experts at MYR have done all the research to help you select the best products for your car, truck or SUV.  From Best Car Battery, to Best Oil filter and best spark plugs, the team at MYR has you covered with easy to read guides and direct links to the products for purchase on Amazon.

Best Car Wax
Best Headlight Bulbs - Halogen
Best Aux Cable
Best Headlight Restoration Kit

MaintainYourRide.com

SSIS Package Not Appearing in Solution Explorer

The Problem:

You've created an SSIS solution in Visual Studio.  When opening the solution to edit a package, a few are missing from the Solution Explorer pane.  Every time you try to 'Add Existing Package' or 'Copy & Paste' it creates a new instance of the package.

The Solution:

Instead of right-clicking and selecting 'Add Existing Package', right-click on the Solution itself and click 'Add > Existing Item' (Shift+Alt+A).  Now you can CTRL-select all of the items missing from your Solution Explorer and click 'Add'.

The Wrong Way:

The Correct Way:

If you're interested in a little more about WHY this happens billinkc has a some good information here on StackOverflow http://stackoverflow.com/questions/15502567/ssis-package-not-visible-in-vs-2010

SharePoint 2010 Force Modal Dialog

The Problem:

You've added a Custom Action to your SharePoint 2010 list to redirect users to a specific edit form.  However, when they click on it, it takes them to a completely separate page, away from the list.  Lets take a look at how we can force SharePoint to open these links in the Modal Dialog similar to how it handles the default edit/create/display forms.

The Solution:

So, in SharePoint Designer, under Lists and Libraries, you have selected the list you're working on.  In the bottom right-hand corner of the List page, you should see a Custom Actions box.  Create your Custom Action if you haven't already.

Now that you've got your Custom Action started, we are going to work off of the default settings in the "Navigate to Form" field.  We will use a simple JavaScript function call to SP.UI.ModalDialog.showModalDialog() which is a built-in JS function included with SharePoint 2010.

Here is an example of the call:

javascript:SP.UI.ModalDialog.showModalDialog({
url: "/sites/<SiteName>/Lists/<ListName>/EditForm.aspx?ID={ItemId}",
title: "Custom Edit Form/Destination",
dialogReturnValueCallback:  function(dialogResult){
SP.UI.ModalDialog.RefreshPage(dialogResult);
location.reload();
 }
});
return false;

After editing the URL & Title, this function call can be placed right into the "Navigate to URL" textbox back on the SharePoint Designer Custom Action screen.

You might notice there is a line called dialogReturnValueCallback.  Here, we specify the behavior to send back to the original page that called the Modal (our list).  For this example, we refresh the original list to reflect any changes that may have been made on the Modal Dialog.

Copy the JavaScript (inline) right into the Custom Action "Navigate to URL" box, click "OK" and test out your custom action!

** UPDATE (6/24/15) - I noticed when using the above code snippet, that SharePoint Designer won't let you copy and paste the code as it is above.  In order to use the code sample above, you must remove all carriage returns and paste the code in as a single line:

javascript:SP.UI.ModalDialog.showModalDialog({ url: "/sites/<SiteName>/Lists/<ListName>/EditForm.aspx?ID={ItemId}", title: "Custom Edit Form/Destination", dialogReturnValueCallback:  function(dialogResult){ SP.UI.ModalDialog.RefreshPage(dialogResult); location.reload(); }});return false;

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