kwizcom banner advertisement

SharePoint 2016 IT Preview Released

August 30, 2015    
SharePoint 2016 IT preview has been released! Cloud first infrastructure, Large file support (10GB!), Durable links, Zero downtime on patching, App launcher, Cloud hybrid search are some new exciting features!! You can download the SharePoint 2016 IT Preview at: http://www.microsoft.com/en-us/download/details.aspx?id=48712 As per Microsoft, SharePoint Server 2016 will become available in Q2 2016, with a public beta planned for Q4 2015: http://blogs.office.com/2015/04/16/sharepoint-server-2016-update/
SharePoint 2016 IT Preview Released SharePoint 2016 IT Preview Released Reviewed by Salaudeen Rajack on August 30, 2015 Rating: 5

Fix "The Standard View of your list is being displayed because your browser does not support running ActiveX controls."

August 28, 2015    
Problem: Datasheet view in SharePoint 2010 did not work with a message "The Standard View of your list is being displayed because your browser does not support running ActiveX controls." in IE11 browser! Solution: Add SharePoint site to compatibility view settings in your IE-11 browser. Also, check the "Display intranet sites in Compatibility view" checkbox (My SharePoint site is under Intranet zone, BTW) Download and install the Access database engine: http://download.microsoft.com/download/f/d/8/fd8c20d8-e38a-48b6-8691-542403b91da1/AccessDatabaseEngine.exe
Fix "The Standard View of your list is being displayed because your browser does not support running ActiveX controls." Fix "The Standard View of your list is being displayed because your browser does not support running ActiveX controls." Reviewed by Salaudeen Rajack on August 28, 2015 Rating: 5

Update Calculated Column Formula in SharePoint List using PowerShell

August 27, 2015    , , , ,
Requirement: Update a Calculated Field's formula for a specific column of a list across entire site collection. PowerShell to update calculated field formula in SharePoint: This updates the site column's formula for all subsites in the site collection. Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue #Variables $SiteURL = "http://intranet.crescent.com" $ColumnName="Productivity" #Iterate through each web in given site collection $Webs = Get-SPSite $SiteURL | Get-SPWeb -Limit All | ForEach-Object { #Check if the column exists if($_.Fields.ContainsField($ColumnName)) { $column = $web.Fields[$ColumnName] #Update calculated field formula $Column.Formula = "=(([PlannedEffort]/5)/ActualEffort)*8" $Column.update($true) write-host "Updated Calculated Field formula at $($_.URL)" } } Same code can be used for List level formulas as well. PowerShell to U
Update Calculated Column Formula in SharePoint List using PowerShell Update Calculated Column Formula in SharePoint List using PowerShell Reviewed by Salaudeen Rajack on August 27, 2015 Rating: 5

Find All Web Parts in Use in a SharePoint Site using PowerShell

August 27, 2015    , , , , , , ,
Requirement: Generate a report to get the Inventory of all web parts in use in a SharePoint site collection. PowerShell script to generate web parts in use in a site collection: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration parameters $SiteURL = "http://intranet.crescent.com" $ReportOutput="C:\Webparts-in-use.csv" $ResultCollection = @() #Get All Subsites in a site collection and iterate through each $Site = Get-SPSite $SiteURL ForEach($Web in $Site.AllWebs) { write-host Processing $Web.URL # If the Current Web is Publishing Web if ([Microsoft.SharePoint.Publishing.PublishingWeb]::IsPublishingWeb($Web)) { #Get the Publishing Web $PubWeb = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($Web) #Get the Pages Library $PagesLib = $PubWeb.PagesList } else { $PagesLib = $Web.Lists["Site Pages"] }
Find All Web Parts in Use in a SharePoint Site using PowerShell Find All Web Parts in Use in a SharePoint Site using PowerShell Reviewed by Salaudeen Rajack on August 27, 2015 Rating: 5

How to Create a Self-Signed SSL Certificate in IIS for SharePoint?

August 27, 2015    , , , , ,
Self-Signed certificates provides encryption between the two ends. Technically, self-signed certificate are signed with its own private key. Often they are used in ADFS configuration. We may also have to use self-signed certificates in DEV-Test environments and for evaluations purposes. Lets see how to create a self-signed certificate using IIS. Never use self-signed certificate on production sites! How to create self-signed certificate for SharePoint 2013? Let's see, how to create a self-signed certificate in IIS step by step: Open IIS Manager, Click on Server name in the Left navigation Tree, Open "Server Certificates" widget From the Right pane, Click on "Create Self-Signed Certificate" link Enter the details for your self-signed certificate. Click on "OK" to create self-signed certificate from IIS. That’s all. You'll find the new self-signed certificate generated and listed in Server Certificates. By default, its validity is fo
How to Create a Self-Signed SSL Certificate in IIS for SharePoint? How to Create a Self-Signed SSL Certificate in IIS for SharePoint? Reviewed by Salaudeen Rajack on August 27, 2015 Rating: 5

SharePoint 2013 Design Manager - Cannot Map Network Drive in Windows Server 2008/2012?

August 26, 2015    , , , ,
Problem:  I was trying to map Master Page Gallery as network drive from Windows Server 2008 R2, but got this error message: "Network Error: Windows cannot access <URL>. Check the spelling of the name. Otherwise, there might be a problem with your network. To try to identify and resolve network problems, click Diagnose. Error code: 0x80070043. The network name cannot be found. Solution: This is due to: "Desktop  Experience" feature not enabled on Windows Servers by default. To resolve this error, follow these steps: Open Server Manager in Windows Server  Click on "Features" node and then Click on "Add Feature" link. Select "Desktop Experience" and click Next >> Next >>Install to complete the wizard. Once rebooted, I was able to map my SharePoint 2013 master pages gallery to network drive successfully!
SharePoint 2013 Design Manager - Cannot Map Network Drive in Windows Server 2008/2012? SharePoint 2013 Design Manager - Cannot Map Network Drive in Windows Server 2008/2012? Reviewed by Salaudeen Rajack on August 26, 2015 Rating: 5

Get Current User Account Name, E-Mail using Javascript Client Object Model in SharePoint 2013

August 24, 2015    , , ,
Get Current User Account Name, E-Mail in JavaScript Client Object Model You can use this code in Content Editor/Script editor or anywhere in SharePoint artifacts like Pages, Page Layouts, Master pages or external Javascript files. <script type="text/javascript"> ExecuteOrDelayUntilScriptLoaded(getCurrentUser, "sp.js"); var currentUser; function getCurrentUser(){ var ctx= new SP.ClientContext.get_current(); var web = ctx.get_web(); currentUser = web.get_currentUser(); ctx.load(currentUser); ctx.executeQueryAsync(onSuccess, onFailure); } function onSuccess() { alert(currentUser.get_title()); // Domain\Account alert(currentUser.get_email()); document.getElementById('userLogin').innerHTML = currentUser.get_loginName(); } function onFailure() { alert('request failed' + args.get_message() + '\n' + args.get_stackTrace()); } </script> <div>Currently Logged User: <span id="userLogin"></span> <
Get Current User Account Name, E-Mail using Javascript Client Object Model in SharePoint 2013 Get Current User Account Name, E-Mail using Javascript Client Object Model in SharePoint 2013 Reviewed by Salaudeen Rajack on August 24, 2015 Rating: 5

SharePoint Online: Get All Lists and Libraries using PowerShell CSOM

August 22, 2015    , , ,
While working with SharePoint online, you may have to iterate through all lists in a site. Here is the PowerShell script to get all lists from SharePoint online site. SharePoint Online: PowerShell to Get All Lists   Here is the PowerShell script to get all lists and libraries from given SharePoint online site #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Variables for Processing $SiteUrl = "https://crescent.sharepoint.com/sites/sales" $UserName="salaudeen@crescent.com" $Password ="Password goes here" #Setup Credentials to connect $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,(ConvertTo-SecureString $Password -AsPlainText -Force)) Try {
SharePoint Online: Get All Lists and Libraries using PowerShell CSOM SharePoint Online: Get All Lists and Libraries using PowerShell CSOM Reviewed by Salaudeen Rajack on August 22, 2015 Rating: 5

How to Use ULS Log Viewer to Analyse SharePoint Errors?

August 21, 2015    , , , , ,
ULS logs are unavoidable in SharePoint administration and support. This post describes the basic usage of ULS log viewer to reveal actual error message in SharePoint 2013 environment. Scenario: You got an E-mail from end-user saying: They received a typical "An unexpected error has occurred." page with some GUID, time stamp, etc. User forward the error screenshot to SharePoint support team. How to get the detailed error message using ULS Viewer ? Every request SharePoint receives, it assigns a correlation ID in the form of a GUID. Whenever SharePoint presents an error to an end user, it includes the correlation ID as part of the error message. It could be challenging to find the detail that you need from an unformatted text file. However, The ULS Viewer tool lets us to open and analyze ULS log files in a user-friendly format. Here is how to use SharePoint ULS viewer. To start with, Download the ULS Viewer tool to your SharePoint Web front end server. Its a tiny Cli
How to Use ULS Log Viewer to Analyse SharePoint Errors? How to Use ULS Log Viewer to Analyse SharePoint Errors? Reviewed by Salaudeen Rajack on August 21, 2015 Rating: 5

Display List from Top Level Site to SubSite in SharePoint

August 21, 2015    , , , ,
Requirement: We have a announcement list in Top level site of a SharePoint 2013 site collection and wanted it to appear on each subsite! Solution: Requirements to show Lists/Libraries from Root site to Sub-site or Sub-site to Root site is quite common. In short, the solution idea is: Export the List view web part to web part gallery (so that its stored on root site's web part gallery) and insert the web part to subsite pages wherever required. Here comes the detailed steps. Tips: You can also use SharePoint Content Query web part (or Content Search Web Part) if you have publishing feature turned ON! Step 1: Export the Source List View Web Part using SharePoint Designer 2013 Open your Site in SharePoint Designer, Navigate to Lists and Libraries node in the left navigation tree view. Click on the All Items view to open it in SharePoint designer. Go to Insert Tab, Click on Dataview and choose your Source List from the dropdown. Now click on Web Parts tab, Click on To
Display List from Top Level Site to SubSite in SharePoint Display List from Top Level Site to SubSite in SharePoint Reviewed by Salaudeen Rajack on August 21, 2015 Rating: 5

Query-Import SharePoint List to Excel using Data Source Connections

August 14, 2015    
Have you ever had to query and import SharePoint list to Excel? or ever required to use SharePoint list as excel data source? Well, just follow these steps to excel data connection to use SharePoint list as excel data source: Step 1: Create a SharePoint list view with desired columns and order: Go to your SharePoint list, Create a new view matching your requirement by adding necessary columns to it. Step 2: Use Export to Excel to generate Data Source Connection Navigate to your SharePoint list view created in Step-1, Use "Export to Excel" button under "List" tab. This imports SharePoint list to Excel and establishes data source connection in Excel as below.  Make sure you set the below properties to skip column width and preserve sort/filter/layout/formats. You can also set the data refresh when opening the file. How to Refresh the Data? All you have to do is, either right click on any data imported and click "Refresh" in the context menu
Query-Import SharePoint List to Excel using Data Source Connections Query-Import SharePoint List to Excel using Data Source Connections Reviewed by Salaudeen Rajack on August 14, 2015 Rating: 5

Clear Maintenance Mode to Unlock a Site Collection in SharePoint 2013

August 13, 2015    , , ,
Problem: Another fine morning, SharePoint 2013 sites started displaying a message: "We apologize for any inconvenience, but we've made the site read only while we're making some improvements.". Same time, noticed a backup failure E-mail from the backup software! Root Cause: Since the Backup failure occurred, SharePoint placed the site to read-only mode. However, all options under "Site Collection Quotas and Locks" were disabled in SharePoint 2013 Central Administration site! Solution: Clear maintenance mode using PowerShell This is because, SharePoint site collection is set under maintenance mode. To clear maintenance mode in SharePoint, use this PowerShell script: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Site Collection URL $SiteURL = "http://intranet.crescent.com/" #Clear Maintenance mode $Admin = new-object Microsoft.SharePoint.Administration.SPSiteAdministration($SiteURL) $Admin.ClearMaintenance
Clear Maintenance Mode to Unlock a Site Collection in SharePoint 2013 Clear Maintenance Mode to Unlock a Site Collection in SharePoint 2013 Reviewed by Salaudeen Rajack on August 13, 2015 Rating: 5

How to Delete a Document Library in SharePoint using PowerShell?

August 13, 2015    , , , , ,
Task: Delete document library in SharePoint with PowerShell Solution: To delete a document library in SharePoint, follow these steps: Browse to your SharePoint Site Click on Site Settings gear >> Site Contents Click on "Remove" link from the context menu of the library. Alternatively, You can go to Library Settings >> Click on "Delete this document library" to remove a document library in SharePoint. Now, there are scenarios where you want to utilize PowerShell to remove a document library in SharePoint, such as: SharePoint UI doesn't provide delete option, You want to delete libraries in bulk, etc. Here is the PowerShell to delete document library in SharePoint 2013. Delete document library in SharePoint using PowerShell: $WebURL="http://intranet.crescent.com/" $LibraryName="Documents" #Get Web and List objects $web = Get-SPWeb $WebURL $list = $web.Lists[$LibraryName] #delete sharepoint document library using pow
How to Delete a Document Library in SharePoint using PowerShell? How to Delete a Document Library in SharePoint using PowerShell? Reviewed by Salaudeen Rajack on August 13, 2015 Rating: 5

Create AD Security Group/Distribution List from All SharePoint Users of the Farm

August 08, 2015    , ,
Have you ever had to send out an E-mail to all SharePoint users of your SharePoint Farm? Ever wanted to create a global AD security group which comprises of all SharePoint users? Well, I'm sure, You will at some point of time. E.g. during scheduled maintenance, Grant access to a global site, etc. Your SharePoint farm may have multiple web applications with lot of users accessing it. We can't keep a AD group or distribution list in sync up to date with all SharePoint users, isn't it? But we can create a AD security group or distribution list on-demand which includes all users from the entire SharePoint farm. By this way, it will be more accurate and update. The idea is: Loop through each web application-site-collection-site in SharePoint farm to retrieve and add members to a security group or distribution list in AD. PowerShell script to Add All SharePoint Users to an AD Security Group: Add-PSSnapin Microsoft.SharePoint.PowerShell –ErrorAction SilentlyContinue Import-Mo
Create AD Security Group/Distribution List from All SharePoint Users of the Farm Create AD Security Group/Distribution List from All SharePoint Users of the Farm Reviewed by Salaudeen Rajack on August 08, 2015 Rating: 5

How to Delete a Permission Level in SharePoint using PowerShell?

August 07, 2015    , , , , ,
Requirement: PowerShell to remove a permission level in SharePoint How to remove a permission level in SharePoint? To delete a permission level in SharePoint, follow these steps: Login to your SharePoint site as Farm/Site collection administrator.  Navigate to Site Settings >> Site Permissions  Click on "Permission Level" button from the ribbon.  Select the permission level to remove and click on "Delete Selected Permission Levels" link. Confirm the prompt to delete permission level. Now, lets see SharePoint PowerShell to remove permission level. SharePoint: PowerShell script to delete permission level Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration parameters $WebURL="https://portal.crescent.com/sites/Sales/" $PermissionLevelName="Contribute without Delete" #Get the Web $Web = Get-SPWeb $WebURL if($Web.RoleDefinitions[$PermissionLevelName] -ne $null) { $Web.RoleDefinitions.D
How to Delete a Permission Level in SharePoint using PowerShell? How to Delete a Permission Level in SharePoint using PowerShell? Reviewed by Salaudeen Rajack on August 07, 2015 Rating: 5

How to Save List as a Template using PowerShell in SharePoint?

August 07, 2015    , , , , , , ,
Requirement: Save SharePoint list as a template using PowerShell How to Save List as template in SharePoint? List templates in SharePoint provides great re-usability without having to recreate every single columns. Say for e.g. you may created a custom list (say: Projects) in a SharePoint site collection  with all relevant columns, Now you might want this list structure in other site collections, without recreating the list on every single site. To save a list or library as template: Go to your SharePoint list >> Navigate to list settings by going to List tab on the ribbon and then List Settings. Click on "Save list as Template" under Permissions and Management group. Provide the name for template File and Template name Choose the appropriate option for "include content" and Click OK. You will see "Operation Successful" page and your template will be uploaded to "List Template Gallery". Generally, its a good idea to create l
How to Save List as a Template using PowerShell in SharePoint? How to Save List as a Template using PowerShell in SharePoint? Reviewed by Salaudeen Rajack on August 07, 2015 Rating: 5

Custom 404 Page Not Found Error page for SharePoint 2013 Site Collection

August 07, 2015    , , ,
SharePoint 2013 is shipped with a default "Page not found" Error page in "Pages" library in publishing Sites (http://intranet.crescent.com/Pages/PageNotFoundError.aspx) which works automatically when a user hits a non-existent URLs. We can either customize this page or create our own page and set as a page not found error page. Here are the steps to create a custom 404 page not found error page: Go to Site Contents, Pages Library and Create New Error Page Customize the error page with your own styles and images Use PowerShell script to set the new page as default page not found error page. $site = Get-SPSite "http://your-sharepoint-site-coll-url" $site.filenotfoundurl = "/Pages/PageNotFound.aspx" #Relative path Using SharePoint Designer to set Custom Page not found error page: You can also use SharePoint designer to set the custom page not found error page: Here is how: Open your SharePoint 2013 Site in SharePoint Designer 2013 S
Custom 404 Page Not Found Error page for SharePoint 2013 Site Collection Custom 404 Page Not Found Error page for SharePoint 2013 Site Collection Reviewed by Salaudeen Rajack on August 07, 2015 Rating: 5

SharePoint Online: Add Site Collection Administrator using PowerShell

August 01, 2015    , , , , ,
SharePoint site collection administrators have Full access rights to manage all sites under a site collection. When creating a site collection, Global Administrator or SharePoint Online Administrator will automatically become the primary site collection admin. A SharePoint online site collection can have several administrators, but only one primary administrator, unlike SharePoint on-premises. Its possible to add multiple site collection admins for any SharePoint site collection. To add additional site collection administrator in SharePoint online, you must be either Global Administrator or SharePoint online Site Collection Administrator of the particular site collection. SharePoint online add site collection administrator Navigate to your SharePoint Online administration center (E.g. https://crescent-admin.sharepoint.com/_layouts/15/online/SiteCollections.aspx ) Select the site collection, Click on "Owners" button from the ribbon and then click on "Manage Admini
SharePoint Online: Add Site Collection Administrator using PowerShell SharePoint Online: Add Site Collection Administrator using PowerShell Reviewed by Salaudeen Rajack on August 01, 2015 Rating: 5
Powered by Blogger.