Archive for the ‘MS Office SharePoint Server’ Category

Microsoft SharePoint 2016 new and deprecated features

June 3, 2016

At the #Ignite conference in Chicago, Bill Baer from Microsoft disclosed several new (and deprecated) feature we can expect from SharePoint 2016.

Below is a highlighted listing of what we can expect, thanks to Matty Vasquez for compiling this list.

Release Information

  • Public Preview – 2015 Q4
  • SharePoint 2016 RC – 2016 Q1
  • SharePoint 2016 RTM – 2016 Q2
  • SharePoint server hardware requirements have not changed (12-16GB RAM, 1xQuad Core CPU, 80GB OS Drive)
  • Windows Server 2012 R2 with .Net Framework 4.5.2 or Windows Server 10 with .Net Framework 4.6
  • SQL Server 2014 SP1 or SQL Server 2016

Deprecated Features

  • There is no ‘standalone’ option during installation which installs SQL Express – SQL must be installed and running prior to installation
  • There are no plans to release SharePoint 2016 Foundation
  • Forefront Identity Manager is no longer included to sync user profile attributes with Active Directory (uni-directional sync using AD Import is still available and MIM can be configured separately to enable bi-direction sync)
  • SharePoint Designer will not be shipped with SharePoint 2016 – Designer 2013 will continue to be supported
  • InfoPath 2013 will continue to be supported (EOL April 2023) and InfoPath Forms Services will be included

Upgrade Considerations

  • There is no direct upgrade path from 2010 to 2016 (sites and databases must be running in 2013 mode)
  • The upgrade process is the same as 2010 to 2013 (2013 databases are attached to a new 2016 Farm and are upgraded)

User Improvements

  • Support for ODF documents
  • Files shared via “Durable Links” will reference a site ID and document ID, so renamed or moved files will not result in broken links
  • File name length and other character restrictions are being removed
  • New Knowledge Management Portal (Site Template?)
  • New User Profile page to include content from Delve and Office Graph API
  • Updated blogging experience including drag and drop feature for adding images to posts

System Improvements

  • Optimisations within the server roles to reduce latency and traffic between servers
  • Initial configuration of Farm and Server Roles has been simplified in the GUI (MinRole server configuration)
  • Fast Site creation based on copying a master template Site Collection from the database level using “SPSite.Copy” function
  • Reliability improvements to Distributed Cache (still relies on AppFabric 1.1 and will continue to be supported for SharePoint 2013 and 2016’s lifecycles)
  • MS Project Server content is now consolidated into the SharePoint Content databases and not in separate databases
  • SharePoint Logging API (SLAPI) allows easier ability to record and report on analytics and telemetry across a whole range of objects in the Farm

Security Improvements

  • SMTP connections now support TLS
  • SAML claims-based authentication is the preferred and default authentication method (NTLM and Kerberos will continue to be supported)
  • Compliance features with complex rules (51 out of the box) to support identification and protection of sensitive data

Hybrid Improvements

  • eDiscovery and Legal Hold will now traverse SharePoint Online in O365
  • Search Service can query SharePoint Online in O365 and provide a single ranked results set with integrated relevancy (no separate verticals)
  • Consolidation of Social features to ensure followed on premise and online content appears in a single social profile
  • Delve and Office Graph API can surface content from on premise services along with content in O365 (will be released for 2013 this year)
  • Item level encryption using Azure AD Rights Management Services

Patching Improvements

  • Patches will be much smaller – currently 37 MSIs and down to 4 MSIs in a single patch
  • Can be applied to servers online with zero downtime to the Farm and no disruption to the users

Scalability Improvements

  • Content DBs will scale into TBs (no specific figures on site template, workloads and actual size released yet)
  • 100,000 Site Collections per database (was 20,000)
  • List view threshold will reach >5,000 items (currently 5,000 but no specific figures released yet)
  • Maximum upload size has increased from 2GB to 10GB (BLOBs will still be stored in the content database and leverage Shredded Storage)

Performance Improvements

  • 500 million maximum items per search index partition (was 10 million)
  • BITS now replacing FSS over HTTP and Cobalt to reduce IO between servers and bandwidth to the end user
  • Traffic Management endpoint automatically routes user requests based on server health

More information can be found on Bill Baer’s blog


,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