Archive for the ‘MS Office SharePoint Server’ Category

,Microsoft Office SharePoint 2013 Improved List View Paging

April 1, 2016

Full trust solution to replace the basic back/next pagination on SharePoint 2013 List Views with a proper paging pattern using JSLink on a page by page basis.

Quite simple really, the default pagination on SharePoint List View webparts is quite poor, only providing for back/next style controls. There is no means of seeing the total number of records or pages, nor being able to jump to the start or end without using sorting tricks.

Default Paging Controls

This solution takes advantage of the JSLink functionality in SP 2013 to override the standard footer template and replace the basic paging controls with more classic search style page controls.

New Paging Controls:

To use the solution:

  • Download the WSP package and deploy to your SharePoint 2013 farm.
  • Test the solution is successfully deployed and available by manually calling both the .js and .aspx files to ensure you can hit the pages successfully:
  • If all looks good, then go to your list view web part, edit the page, edit the web part properties for the List View.
  • Under the Miscellaneous section, add the path to the javascript file in the JSLink field:
    • ~site/_layouts/15/ImprovedListView/JSLink.js
  • Click OK and Stop editing the page, you should now see the replaced paging controls

Additional Important Notes

  • This solution assumes you are using jQuery already on your SharePoint site. If you’re not, then you will need to grab the source code and update the “updatePagingControls” function to use basic javascript to modify the DOM instead of jQuery. But seriously, why are you not using jQuery?!
  • The solution affects ALL list view web parts on the same page, you do not need to add the JSLink reference to each webpart.
  • If you need it to not affect some of the list views on a page, sorry you will need to download the source and customize the solution by specifying the BaseViewID and/or ListTemplateType. You could also do this with a custom version of the JS file however, and deploy the solution as is. Put a copy of the JSLink.js file into /_catalogs/masterpage using SharePoint Designer, then customize the variant file and use that in your JSLink field instead of the one I have provided (google: “SharePoint 2013 JSLink” for more details on this).
  • This solution is a full trust solution which makes use of an application page, which is deployed to the _layouts folder in the 15 hive. It is therefore not suitable for sandbox style environments where full trust deployments are not allowed. However, you could retrofit the solution to make it purely javascript based by using CSOM calls in order to replicate the server side code on the client instead. I did this to start with, but found the additional AJAX calls made the load times significantly slower (particularly for large lists), and so I chose to go with a server side solution for building the page URLs instead.


Microsoft Office SharePoint Easy User Manager

February 11, 2016

This app allows you to manage your SharePoint User/Group easily from within a single web form. OOTB SharePoint interface requires many clicking and redirecting in order for you do your task.
With this apps, you can easily access to not all but most of the important functions for you to manage your users.


  • Search for a particular users and be able to perform task to add/remove from within the selected group.
  • Check Membership – Allow you to quick glance all the SharePoint groups that a site user has been added
  • Quick Access to user profile page
  • Bulk Add users into SharePoint group.
  • Bulk Delete users from SharePoint group
  • Move/Clone multiple users from one SharePoint group to another SharePoint group
  • Search for a group via group name and,
  • See all the members in the SharePoint Group.
  • Download all Group and Members report in CSV format. NEW
  • Create SharePoint Group. New

Farm Solution – Easy.UserManager.wsp

How to Install:

  1. Open SharePoint Management Shell
  2. Run Add-SPSolution -LiteralPath Path To The WSP
  3. Run Install-SPSolution Easy.UserManager.wsp -GACDeployment
  4. Go to any Site and activate Web Feature Easy.UserManager Feature in Site Collection Feature

How to Update (if you have previously installed older version):

  1. Open SharePoint Management Shell
  2. Run Update-Solution -Identity Easy.UserManager.wsp -LiteralPath Path To The WSP -GACDeployment

How to access
In Site Action menu, you shall see Easy – User Manager shortcut. Click on this shortcut and it will bring you to the default page of Easy User Manager.

Alternatively, you can always access to the feature via http://<your sharepoint site>/_layouts/15/Easy.UserManager/home.aspx.

App for SharePoint Online –

How to install:
For some reason, SharePoint App Store does not allow apps permission with Full Control and in order to really make admin’s life easier, this apps requires this permission to perform user managing task.

The only way to install the app is through App Catalog. If you have not have one App Catalog in your SharePoint Online Farm. See article

Once you have your App Catalog setup, go to the App Catalog site

  1. Upload the to your App for SharePoint. Subsequently edit the uploaded app properties (optional)
  2. Go to any site that you want to use this app. Go to Site Content and Add App
  3. From the left menu, click “From your Organization” under Your Apps section
  4. Look for Easy User Manager, click it and Trust it.
  5. You should see the app being provisioned in your site. Once it is done, click on it and start using it

I hope the app can help you cut down some SharePoint administrative works:)

Managing Users

How to Add Member.png

Managing Groups

Group View.png


Report View.png


Microsoft Office SharePoint ListView Filter

November 4, 2015

SPListViewFilter is a SharePoint WebPart enables you to create custom filter to find information in SharePoint list or document library.

SPListViewFilter webpart

Supported field types

  • Simple text
  • AutoComplete

jQuery UI is required for using autocomplete!

  • Text with options enables select filtering type

Text with filtering options

  • Date

  • DateRange

  • Boolean

  • DropDown list represents unique values of field

  • User or Group

  • Taxonomy Term Picker

  • Multi-select CheckBoxList

Getting started

1. Activate SPListViewFilter feature on SiteCollection Features;
2. Open List (Document Library) view page in design mode;;
3. Add SPListViewFilter webpart on the page;
4. Connect SPListViewFilter webpart to ListView webpart;
5. Customize fields showing in filter using webpart setting panel;

View Step by step guideline to use it immediately.


SPFileZilla = FileZilla for SharePoint

October 9, 2015

Inspired by FileZilla, the fantastic free FTP client, SPFileZilla allows you to navigate and manage SharePoint as if it were an FTP Server. Browse site lists, document libraries, folders, and files. Download and upload files and folders, including support for nested folders hierarchies. Create new folders, rename existing files and folders, and delete files and folders. Also, you can copy paths to files and folders to your clipboard. Drag and drop folders/files into the application to upload to SharePoint.

Latest release for 2013 supports uploading large files (over 2 MB) to SPOnline.

Exclusive Features
These are the features, added recently that make this tool essential.

  • Includes a Property Bag editor and Text editor. This saves time, no need to fire up SharePoint Designer.
  • Overwrite (OVR checkbox in main window) makes it super easy to do incremental bulk uploads to a SharePoint Library when OVR is turned off (which will skip existing files).
  • Bulk operations like Move, Copy, Check-out, Check-in, etc. can be performed on entire Document Libraries (right click menu actions).
  • File system dates are preserved when uploading to SharePoint (created and modified).

SPFileZilla is compatible with SharePoint 2010 and 2013, including SharePoint Online (Office 365), and supports claims based authentication and mixed mode authentication. Uses the SharePoint Client Object Model, no magic.

SPFileZilla allows you to save your SharePoint connections using the built-in profiles feature. Name your profiles, set up once and use as often as you like. Or, use the Quick Connect feature to connect directly to a SharePoint site without saving a profile.

After connecting to a SharePoint site, all the lists that inherit from the document library content type are available to browse and manage. Open a list and you can then browse its folders and files. Refresh directories and navigate deeper or back to parent directories.

Never manage your SharePoint Documents using a browser again! Unless you like waiting for IE “open in explorer” mode. Or, if you prefer to upload multiple files using a specific browser. Or, if you prefer to upload your files (but not download!) using SharePoint Designer. I specifically built this program after developing “SharePoint Hand”, otherwise known as carpal tunnel of the mouse fingers.


Microsoft Office SharePoint Excel Services Fix – “The workbook cannot be opened”.

October 1, 2015

When opening an Excel workbook (.xlsx) in the browser the error “The workbook cannot be opened” is thrown:

This is caused by the account running Excel Services not having proper permissions to the Content Database.  When you upload an Excel workbook to a SharePoint library, the workbook is stored as blobs in the Content Database.  When you choose to open this in Excel Services, the account running Excel Services needs to retrieve and reassemble the workbook.  If the account running Excel Services lacks proper permissions, “The workbook cannot be opened”.

We have a KB on how to resolve this issue:

The Excel Services Application for SharePoint 2010 does not load or display workbooks

In this blog, I will step you through this KB; where to collect data and explain what the two below SharePoint Management Shell Commands do:

$w = Get-SPWebApplication –Identity <URL of the Web application>
$w.GrantAccessToProcessIdentity(“<insert service account>”)

You need to find the <URL of the Web application>.  To do this:

1. Browse to the report library where the failing workbook is located and make note of the URL.

2. Central Administration > Application Management > Manage web applications compare the URL to the list of Web Apps.  Find the correct Web App URL and add it to “URL of the web application”.

You now have the first command:

$w = Get-SPWebApplication –Identity http://tschauer

3. Central Administration > Security > Configure Service Accounts > from the first dropdown, select the application pool running “Excel Services Application” and add that account where is says “<insert service account>”.

You now have the second command:


So now you can run these commands by following the below steps:

1. Click Start, click All Programs.
2. Click Microsoft SharePoint 2010/2013 Products.
3. Click SharePoint 2010/2013 Management Shell.
4. At the Windows PowerShell command prompt (PS C:\>), type the following command, and then press ENTER:

$w = Get-SPWebApplication –Identity http://tschauer

When you run these commands you are:

1. Adding the account running Excel Services as a User to the Content Database (Security > Users).
2. Giving the account running Excel Services the SPDataAccess Membership (Account > Membership)
3. Giving the account running Excel Services Full Control to the Web Application (Via “Policy for Web Application”)

Original Source

Manage Ribbon tabs for Microsoft Office SharePoint 2013

July 6, 2015

The project allows to manage visibility’s tabs of the Ribbon for SharePoint 2013. It is the best way to hide/show tabs for different SharePoint groups.

  • Open web site as user who can manage web.

  • Find sharepoint group

  • Check Ribbon tabs that should be hide

  • Please check results



Documentation is here

Source code is here

Version 1.0.0:

  • Manage visiblity of Ribbon tabs (Manage, Share & Tracks, Copies and etc.) for different sharepoint groups;
  • can be activate on different webs and store settings for each other;
  • use library jQuery 2.1.1;
  • no assembly code, only Javascript;
  • support IE 10+, Chrome 30+, FF 30+;
  • simple use;
  • simple activation;
  • working platforms:
    • SharePoint Foundation 2013;
    • Sharepoint Server 2013 (Standard, Enterprise);
  • localization:
    • English;
    • Russian;


SPIEFolder.exe.config for SharePoint 2013

December 19, 2014

Use Keith Richie’s SPIEFolder SharePoint file import/export tool with SharePoint 2013 by saving this configuration file next to the 2010 version of SPIEFolder.exe.

<?xml version=”1.0″ encoding=”utf-8″?>
<supportedRuntime version=”v4.0.30319″ />
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>
<assemblyIdentity name=”Microsoft.SharePoint” publicKeyToken=”71e9bce111e9429c” culture=”neutral” />
<bindingRedirect oldVersion=”″ newVersion=”″ />

Microsoft Office Web Apps for SharePoint 2013

November 11, 2014

Deploy Office Web Apps Server

Configure Office Web Apps for SharePoint 2013

SharePoint reduce growing disk space by reducing WSS_LOGGING dbase size

November 1, 2014

WSS logging database grows very fast and it cause the storage problem most of the time in sharepoint server 2010.

To reduce the size of the logging database or to purge the old data from the logging database we can perform these steps.

Execute the following script:By Default the system retains 14 days of Usage data in this database. By following PowerShell command we can check and change the value of retention days of this database.

Add-PsSnapin Microsoft.SharePoint.PowerShellWrite-Host “Data retention policy, which is set to 14 days by default.Going to set it to 3 days.”

   1:  Add-PsSnapin Microsoft.SharePoint.PowerShell
   2:  Write-Host "Data retention policy, which is set to 14 days by default.Going to set it to 3 days."
   3:  Get-SPUsageDefinition
   4:  $defs = Get-SPUsageDefinition
   6:  Foreach($def in $defs)
   7:  {
   8:  Set-SPUsageDefinition –Identity $def.Name –DaysRetained 3
   9:  }

write-host “Now, open Central Admin and choose, Monitoring > Configure usage and health data collection > Log Collection Schedule>.”

Write-host “Execute the two Timer jobs:”
Write-host “1)Microsoft SharePoint Foundation Usage Data Import”
Write-host “2)Microsoft SharePoint Foundation Usage Data Processing”
Write-host “The SQL logging database will now contain some free space”
Write-host “which your SQL DBA can ‘free-up’ within SQL Management Studio ”
write-host “or running the ‘DBCC ShrinkFile’ T-SQL command.”
Remove-PsSnapin Microsoft.SharePoint.PowerShell

After that we need to run the two timer jobs to clean the old data ‘Microsoft SharePoint Foundation Usage Data Import’ and ‘Microsoft SharePoint Foundation Usage Data Processing’.Go to Sharepoint Central Administration -> Monitoring -> Configure Usage and health data collection-> Log Collection Schedule.

And it will take you to the timer jobs.

Now Click on both the Job Definitions one by one and hit ‘Run Now’ to run the timer jobs

Once the timer jobs is run you can check and confirm database has released the space.
You can shrink the database after this by using ‘DBCC ShrinkFile’ T-SQL command

Original Source: Binary Republik

SharePoint Designer 2013 “All Files” missing for SharePoint Foundation 2013

October 31, 2014

You can make yourself Admin by doing the following:

  1. Log into Central Administration
  2. Go to Application Management -> Manage web applications
  3. Click on the Web Application you want to become Admin
  4. From the ribbon bar click on User Policy
  5. Click on Add Users
  6. Select All Zones and click Next
  7. Add your user name and check Full control
  8. Click on Finish and you’re done.  You’ll now have admin rights and see All Files in SPD.


Get every new post delivered to your Inbox.

Join 32 other followers