Saturday, May 9, 2015

How to show multiple web parts in accordion style in a single page


Today i wanna share something related to design part in SharePoint.

I have a page and in that page i need to show multiple webparts. 

Each webpart having more number of records so when i show all the web parts in a single page then it's difficult to see the page and doesnot look good.

show now i want to show all the webparts in accordion style.

Here the steps to create accordion page with multiple webparts.

1. Download the below scripts and style sheet then upload in site assets library.

a. jquery-ui.css
b. jquery.min.js
c. jquery-ui.min.js

2. Now create or go to your page and add all your web parts on to the page and your page looks like this.

3. Now add script editor and add the below script

<link  type="text/css" rel="stylesheet" href="/SiteAssets/jquery-ui.css" />
<script type="text/javascript" src="/SiteAssets/jquery.min.js"></script>
<script type="text/javascript" src="/SiteAssets/jquery-ui.min.js"></script>
<script type="text/javascript">
     jQuery(document).ready(function($) {
         //Add the Web part titles for the webparts that should be displayed in the accordion

    function SharePointAccordian(webPartTitles)

        for(index in webPartTitles)
            var title = webPartTitles[index];
            $(" span:contains('"+title+"')").each(function(){
                if ($(this).text() == title){
                                var outerDiv = $('<div></div>');
                                var outerP = $('<p></p>');
                    var innerItem = $(this).closest("span").hide().closest


       $("#accordian").accordion({ heightStyle: "content" });

<div id="accordian"></div>

Here ["Holidays","Department","associate"] there are the my web parts' title. So, please change names as per your web parts' title and save the page.

4. Finally, your page looks like this.

Wednesday, May 6, 2015

How to download all deployed wsp solution files in SharePoint


Usually SharePoint admin guys takes backup of content DB and all physical files if they want to create replica of existing SharePoint site when actual site is down.

But that will not complete solves the solution, if there are any custom solutions already deployed.

So, admin guys needs those solution files.
To get those solution files which are deployed in SharePoint use the following power shell command to get all deployed solution files.

$pathName = "<PATH to Save files>"
foreach ($solution in Get-SPSolution)  
     $solid = $Solution.SolutionID
     $title = $Solution.Name
     $filename = $Solution.SolutionFile.Name

How to check in all checked out files in a SharePoint list using Power shell


I have a SharePoint list which has having more than 10 folder and many sub folder in side each folder.

Again each have subfolders and document. Most of the documents are checked out.

Now i need to check in all the checked out files its big task for me to going to each document and checkin and it will takes me days.

I was searching for any other alternatives, so using content structure i can check in multiple documents at a time but i can do it at folder level. Again it will takes more time to check in all the files.

Now, again started searching for another alternative and came up with powershell script.

I got the script and am sharing that script.

*****************************Start of  Script **********************************


$site = New-Object Microsoft.SharePoint.SPSite("http://uday:43662")

$root = $site.allwebs[0]

$folder = $root.GetFolder("Shared Documents")


# Function Set-CheckInFolderItems is a recursive function

# that will CheckIn all items in a list recursively


function Set-CheckInFolderItems([Microsoft.SharePoint.SPFolder]$folder)


    # Create query object

    $query = New-Object Microsoft.SharePoint.SPQuery

     $query.Folder = $folder
    # Get SPWeb object

    $web = $folder.ParentWeb
    # Get SPList

    $list = $web.Lists[$folder.ParentListId]

    # Get a collection of items in the specified $folder

    $itemCollection = $list.GetItems($query)

    # If the folder is the root of the list, display information

    if ($folder.ParentListID -ne $folder.ParentFolder.ParentListID)

         Write-Host("Recursively checking in all files in " + $folder.Name)

    # Iterate through each item in the $folder

    foreach ($item in $itemCollection)


        # If the item is a folder

        if ($item.Folder -ne $null)


            # Write the Subfolder information

            Write-Host("Folder: " + $item.Name + " Parent Folder: " + $folder.Name)

            # Call the Get-Items function recursively for the found sub-solder

            Set-CheckInFolderItems $item.Folder


        # If the item is not a folder

        if ($item.Folder -eq $null)


            if ($item.File.CheckOutType -ne "None")


                if ($item.File.Versions.Count -eq 0)


                    # Check in the file

Write-Host "Check in File: "$item.Name" Version count " $item.File.Versions.Count -foregroundcolor Green

                    $item.File.CheckIn("Bulk check in By Administrator")






    $web = $null


Set-CheckInFolderItems $folder

******************************  End of Script *************************************

Saturday, May 2, 2015

Slide library missing in SharePoint 2013

As per Microsoft's, Slide library has been deprecated in SharePoint 2013.

Here the reference link.

Even if you try to search for template in add an app, it will show the below screen.

What to do next?? can not i create slide library in SharePoint 2013???

NO, we can create slide library in SharePoint 2013 by using the below URL

http://<SITE URL>/_layouts/15/slnew.aspx?FeatureId={0be49fe9-9bc9-409d-abf9-702753bd878d}&ListTemplate=2100

It will ask for list name and description. Once you have clicked on Create, it will create and it looks like as below.