kwizcom banner advertisement

Hide "Recent" from SharePoint 2013 Quick Launch Navigation

5:10 PM    ,
Recent section gets added automatically through a Web Control on SharePoint pages. 'Recent' menu is individual to each user! meaning everyone gets their own recent section with links to their recent activities! If you have a requirement to remove (or hide) the "Recent" menu header from the left navigation of SharePoint 2013, Here are some solutions: In Publishing sites, You can remove "Recent" section manually by going to : Site Settings >> Look and Feel >> Navigation (or Quick launch on Non-publishing sites!) . How to hide recent in SharePoint 2013 using jQuery: Edit the page, Add a script editor web part and place this code in it (or master page html) <script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script> <script type="text/javascript"> jQuery(document).ready(function() { jQuery(".ms-core-listMenu-item:contains('Recent')").parent()
Hide "Recent" from SharePoint 2013 Quick Launch Navigation Hide "Recent" from SharePoint 2013 Quick Launch Navigation Reviewed by Salaudeen Rajack on 5:10 PM Rating: 5

Cancel Workflows in SharePoint using PowerShell

1:46 PM    , , ,
Requirement: There was a large list with workflow attached to it. SharePoint Development team came with a requirement of cancelling multiple workflows running on these list items, nearly 2000! While cancelling workflows on individual item is pretty straight forward, How about cancelling workflows on 1000's of items? Would be a daunting task, isn't it? Terminate Workflow in SharePoint using PowerShell: Well, PowerShell can help to cancel workflows in SharePoint. If you ever have to cancel multiple running workflows on all list items, use this PowerShell script: Cancel all workflows on a list: $web = Get-SPWeb "http://your-sharepoint-site-url" #List Name $list = $web.Lists["Your-List-Name"] # Iterate through all Items and all Workflows on Items foreach ($item in $list.Items) { foreach ($wf in $item.Workflows) { #Cancel Workflows [Microsoft.SharePoint.Workflow.SPWorkflowManager]::CancelWorkflow($wf) } } To cancel a
Cancel Workflows in SharePoint using PowerShell Cancel Workflows in SharePoint using PowerShell Reviewed by Salaudeen Rajack on 1:46 PM Rating: 5

Arrange Choice Field Radio Buttons Horizontally in SharePoint List Forms

2:14 PM    , , , ,
Requirement is to arrange choice fields of Radio buttons to horizontally in a SharePoint 2013 custom list form: How to arrange choice field options Horizontally? Step 1: Create new Custom list form(Say: New.aspx) using SharePoint Designer, Edit the page in SharePoint designer, Find and wrap your choice field in <Span> tag to assign it a unique ID. E.g.optRegType. <span id="optReqType"> <SharePoint:FormField runat="server" id="ff3{$Pos}" ControlMode="New" FieldName="Change_x0020_Request_x0020_Type" __designer:bind="{ddwrt:DataBind('i',concat('ff3',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@Change_x0020_Request_x0020_Type')}"/> <SharePoint:FieldDescription runat="server" id="ff3description{$Pos}" FieldName="Change_x0020_Request_x0020_Type" ControlMode="New"/> </span> Step 2:
Arrange Choice Field Radio Buttons Horizontally in SharePoint List Forms Arrange Choice Field Radio Buttons Horizontally in SharePoint List Forms Reviewed by Salaudeen Rajack on 2:14 PM Rating: 5

Branding SharePoint 2013 Top Navigation Menu bar with Custom CSS

6:24 PM    , , , , ,
Branding SharePoint top navigation is one of the frequent requirement in SharePoint implementations. Here is my quick way to apply branding to SharePoint 2013 top navigation menu.  Step 1: Create a custom CSS file with custom styles for your navigation menu (Find my CSS below!). Upload it either to site assets library/Master pages folder or to file system (/_Layouts/Styles/). Step 2: Edit the HTML master page and add reference to your custom CSS. Open the HTML master page of your site in SharePoint designer (by default: Seattle.html), Locate this chunk: <!--SPM:<SharePoint:CssRegistration Name="Themable/corev15.css" runat="server"/>--> Add this line just below it: <!--SPM:<SharePoint:CssRegistration Name="http://YOUR-SITE-COLLECTION-URL/SiteAssets/YOUR-CSS-FILE.css" runat="server" After="corev15.css" />--> Rather hard-coding the URL, upload/deploy custom CSS to Master Pages folder and set the path as:
Branding SharePoint 2013 Top Navigation Menu bar with Custom CSS Branding SharePoint 2013 Top Navigation Menu bar with Custom CSS Reviewed by Salaudeen Rajack on 6:24 PM Rating: 5

Manage Access Request Settings in SharePoint 2013

6:55 PM    , , , , ,
Access request feature allows users to request access to sites and content. Access requests feature is improved in SharePoint 2013. Now, Administrators can keep a track of access requests. Enable access request SharePoint 2013 Site owners can enable access requests in SharePoint. To configure access request settings in SharePoint 2013, navigate to: Go to Settings >> Site Settings Click the "Site permissions" link under "Users and permissions" section Now, from the ribbon, Click on “Access Request Settings” button. You'll be prompted with the access request Settings popup window. Click on "Allow access request" option to enable access request and enter the E-mail address of the user who will receive access requests from that site. This allows access request in SharePoint 2013. You can change access request email or you may want to turn off access request at later point of time by visiting the same link. Manage access request SharePoi
Manage Access Request Settings in SharePoint 2013 Manage Access Request Settings in SharePoint 2013 Reviewed by Salaudeen Rajack on 6:55 PM Rating: 5

Change Regional Settings - Time Zone, Locale in SharePoint 2013 with PowerShell

4:52 PM    , ,
Regional settings in SharePoint 2013 controls how locale-specific information, such as Date, Time, Numbers, calendar, etc. are displayed on the site. Internally, SharePoint keeps date time values in UTC format in database and presents to the end-user based on the configured regional settings. SharePoint 2013 regional settings are configured in these levels: Web Application Level Site Collection Level Site Level User Level  Web Application Level Under web application general settings, we've "Default Time Zone" settings, which sets default regional settings for site collections at the time of its creation.  Go to Central Administration Site Manage Web Applications >> Select your web application Click on "General Settings" ribbon button Now, from the general settings page, you can set "Default Time Zone" for site collection. SharePoint 2013 default regional settings However, This setting has only "Time zone" configurati
Change Regional Settings - Time Zone, Locale in SharePoint 2013 with PowerShell Change Regional Settings - Time Zone, Locale in SharePoint 2013 with PowerShell Reviewed by Salaudeen Rajack on 4:52 PM Rating: 5

How to Delete Subsite In SharePoint 2013 using PowerShell?

12:07 PM    , , , , ,
How to delete a subsite in SharePoint 2013? To delete a subsite in SharePoint 2013, Navigate to Site Settings >> Click on "Delete this Site" link under "Site Actions" group. That takes you to the "Delete this site" page. Click on "Delete" button and confirm site deletion.  So simple, huh? To restore deleted subsite in SharePoint 2010(sp1) or in SharePoint 2013, Just go to your Site collection recycle bin! Delete all subsites in SharePoint using PowerShell Why we need to use PowerShell, while deleting subsites from SharePoint 2013 web UI is relatively simpler? Well, If you try to delete a sub-site which has its own subsites, You'll end up in Error! SharePoint doesn't allow you to delete a site with its sub-sites (But You can delete a site collection and all its subsites in a single click from web UI by following above instructions!). In other words You cannot delete SharePoint Subsite with one or more child subsites. You
How to Delete Subsite In SharePoint 2013 using PowerShell? How to Delete Subsite In SharePoint 2013 using PowerShell? Reviewed by Salaudeen Rajack on 12:07 PM Rating: 5

SharePoint Knowledge Transfer Checklist

11:38 AM    ,
In a SharePoint architect/administrator's life, Its quite a common task to takeover existing SharePoint environments at the time of Job/Role switch. From my experience, Here is the check list to help easing up documentation for SharePoint: SharePoint  Infrastructure Farm(s) Topology - List of servers and roles, physical and logical architecture diagrams for production, Staging and Development Environment (if applicable) Server Infrastructure (Physical/Virtual), Storage, CPU-RAM-Network configurations List of Service Accounts (Setup account, Farm account, search crawler account, etc) and passwords. Active directory setup, DNS entries for SharePoint Maintenance windows schedule - Patching, patch Level? OS versions? Incoming/Outgoing E-mail configurations. SMTP configuration details IIS Level customizations (compression, URL rewrite, redirects, etc.) Backup, Disaster recovery in place. Tools used (SCDPM, Comvault, etc). Backup frequency. Database server details. SQL Alias?
SharePoint Knowledge Transfer Checklist SharePoint Knowledge Transfer Checklist Reviewed by Salaudeen Rajack on 11:38 AM Rating: 5

Office Web Apps Previews Not Working in SharePoint 2013?

2:19 PM    ,
During a SharePoint 2013 deployment, integrated Office Web Apps 2013 with SharePoint 2013 with my implementation guide How to Install and Configure Office Web Apps 2013 for SharePoint 2013 . Everything went well until we received all of the Office Web Apps services failing errors in SharePoint 2013. Word Web Apps gave an error:   “ Sorry, there was a problem and we can’t open this document.  If this happens again, try opening the document in Microsoft Word.” Excel and PowerPoint Web Apps also failed. "Excel Web App - Sorry, we're having a problem showing this workbook" On PowerPoint web application: "Microsoft PowerPoint Web App - Sorry, we couldn't open this presentation because we ran into a problem. please try again" Troubleshooting: Analyzed event logs of SharePoint and OWA servers and found nothing useful. Logged in to the Office Web Apps server and Analysed the latest log file from "C:\ProgramData\Microsoft\OfficeWebA
Office Web Apps Previews Not Working in SharePoint 2013? Office Web Apps Previews Not Working in SharePoint 2013? Reviewed by Salaudeen Rajack on 2:19 PM Rating: 5

Restore-SPSite Error: 0x80070003 on Backup-Restore SharePoint Site Collection Between Different Farms

12:28 PM    , , , , , ,
When I was trying to backup restore between SharePoint DEV and QA Farms got this error message: Restore-SPSite : <nativehr>0x80070003</nativehr><nativestack></nativestack> Root Cause: The source and target SharePoint Farm's build version mismatch! Solution: Upgrade either the source or destination SharePoint farm and then backup-restore. Backdoor way: What if you don't have the option of immediate upgrade and complete this backup restore operation? Here is the backdoor way to skip upgrades and backup-restore SharePoint sites or lists between farms with different versions/build numbers. One way is: Backup-restore the content database of your old SharePoint site collection to the target farm. Mount and Upgrade the content database ( Mount-SPContentDatabase followed by Upgrade-SPContentDatabase ) in the target farm. There is an another way: Binary Edit! Just open the backup file in any HEX editor tool, I've used HxD from: http://mh-nexu
Restore-SPSite Error: 0x80070003 on Backup-Restore SharePoint Site Collection Between Different Farms Restore-SPSite Error: 0x80070003 on Backup-Restore SharePoint Site Collection Between Different Farms Reviewed by Salaudeen Rajack on 12:28 PM Rating: 5

PowerShell Script to Find All Active Directory Groups in SharePoint

1:26 PM    , , , , , , ,
Requirement: Get the list of All AD Security groups used in SharePoint sites. We need to generate a report on AD groups that are being used in a SharePoint web application. PowerShell script to find AD Groups in SharePoint: Here is my PowerShell script to find and export Active Directory groups on all SharePoint sites with in the given web application. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Change to your web application $WebAppURL = "http://intranet.crescent.com" #Get Web Application $WebApp = Get-SPWebApplication $WebAppURL #variable for data collection $ADGroupCollection= @() $ReportPath ="C:\ADGroups.csv" foreach ($Site in $WebApp.Sites) { Write-host -foregroundcolor green "Processing Site Collection: "$site.RootWeb.URL #Get all AD Security Groups from the site collection $ADGroups = Get-SPUser -Web $Site.Url | Where { $_.IsDomainGroup -and $_.displayName -ne "Everyone" }
PowerShell Script to Find All Active Directory Groups in SharePoint PowerShell Script to Find All Active Directory Groups in SharePoint Reviewed by Salaudeen Rajack on 1:26 PM Rating: 5

SharePoint 2013 People Picker Browse Button Missing?

6:15 PM    ,
With massive changes from SharePoint 2010 to SharePoint 2013, People picker also has changed! In its previous versions, SharePoint 2010 and SharePoint 2007, people picker is associated with an address book and check name icons, which are missing in SharePoint 2013! While its still identical in some places of SharePoint 2013 (E.g. Setting up groups for the site: /_layouts/15/permsetup.aspx), These icons are missing in all other places. E.g In SharePoint list forms, Grant Permission pages, etc. But in SharePoint 2013 these places provides "Auto complete" feature in people picker to help us picking users. How can I show browse buttons in SharePoint 2013 People Picker? Not very sure why Microsoft removed these nifty icons. Anyway, If you need the "Browse Icon" back in SharePoint list form people picker fields, simply create new custom list form using SharePoint designer, which brings browse button in people picker by default!
SharePoint 2013 People Picker Browse Button Missing? SharePoint 2013 People Picker Browse Button Missing? Reviewed by Salaudeen Rajack on 6:15 PM Rating: 5

Create Autonumber Unique Column in SharePoint List

1:17 PM    , , , , , ,
Auto-numbering is quite a common requirement when working with SharePoint lists. Say, You may want to auto number list items in SharePoint 2010 issue tracking list! Here are some methods to achieve SharePoint list auto increment number: Add Auto number column to list with ID field: SharePoint Lists have an built-in "ID" column which auto increments. You can simply Add this column to your views! You can rename ID column if required: How to rename ID field in SharePoint list Using calculated field for Autonumber? Tried using calculated column with ID field, Entered formula such as = CONCATENATE("CR-" [ID]), But no luck - Doesn't work for new items! Because ID field is filled ONLY after the item is created! SharePoint Autonumber with Workflows: Here is my solution to set auto increment number with SharePoint designer workflow! Just follow these steps: Create a column, say: Request Number of appropriate type. Make this column hidden: How to make a
Create Autonumber Unique Column in SharePoint List Create Autonumber Unique Column in SharePoint List Reviewed by Salaudeen Rajack on 1:17 PM Rating: 5

How to Rename ID Column in SharePoint List?

11:09 AM    , , , , ,
Requirement:  Rename ID field in a SharePoint list! We had a list with ID column added to the view to provide unique auto number feature. User wants to rename ID field to "Change Request Number" as it sounds more appropriate. Solution: Hidden columns such as "ID", "Workflow Status" are not providing Edit features directly from SharePoint web UI and they don't even appear on SharePoint list settings page. So, use this simple trick to rename any hidden column such as ID: Go to List settings page  Pick any column such as "Title". You'll get Edit Column page.  In the URL, Change the Field parameter from "Title" to "ID" and Hit Enter. E.g. http://demo.crescent.com/_layouts/15/FldEdit.aspx?List=%7BB9BED485%2D889D%2D49D9%2DBDC1%2DD78EB4E06EB9%7D& Field=Title To http://demo.crescent.com/_layouts/15/FldEdit.aspx?List=%7BB9BED485%2D889D%2D49D9%2DBDC1%2DD78EB4E06EB9%7D& Field=ID Now you can rename the field as
How to Rename ID Column in SharePoint List? How to Rename ID Column in SharePoint List? Reviewed by Salaudeen Rajack on 11:09 AM Rating: 5

Design Manager Missing in SharePoint 2013?

7:05 PM    , , ,
Problem: Design Manager is a new feature introduced in SharePoint Server 2013 publishing sites to manage branding. But you are not seeing "Design Manager" in SharePoint 2013? design manager link missing? Solution: Well, to enable design manager in SharePoint 2013, You got to activate "Publishing" Feature! Go to "Site Settings" of your root site collection >> Click on "Site collection features" under site collection administration Click on "Activate" button next to "SharePoint Server Publishing Infrastructure". Activate "SharePoint Server Publishing Infrastructure" from site features via "Site Setting" >> Click on "Manage site features" and activate SharePoint Server Publishing Infrastructure. How to access design manager in SharePoint 2013 Above steps activates design manager. Now, You'll get design manager link in Site actions menu and in site settings page! De
Design Manager Missing in SharePoint 2013? Design Manager Missing in SharePoint 2013? Reviewed by Salaudeen Rajack on 7:05 PM Rating: 5

Configuration Failed - Failed to connect to the configuration database: Error during decryption. Ensure the passphrase is correct.

2:02 PM    , , , , ,
Problem: Trying a add a server to SharePoint 2013 farm, after a passphrase reset. Got this error message. Configuration Failed Failed to connect to the configuration database:  An exception of type System.ArgumentException was thrown. Additional exception information: Error during decryption. Ensure the passphrase is correct. Troubleshooting: Double-checked my pass phrase is correct. If my pass phrase is wrong, I should get this error message: "The passphrase you entered is incorrect. Please try again" - But I didn't receive any such! Verified the pass-phrase change timer job's last run time: Get-SPTimerJob -Identity job-admin-passphrase-change | Format-Table -Property DisplayName,Id,LastRunTime,Status Tried restarting SharePoint Timer job and SharePoint Administration services in CA server Made sure the account I logged in is a Farm Admin account with Security Admin, DB Creator roles in SQL Server and Local administrator in the server I'm trying t
Configuration Failed - Failed to connect to the configuration database: Error during decryption. Ensure the passphrase is correct. Configuration Failed - Failed to connect to the configuration database: Error during decryption. Ensure the passphrase is correct. Reviewed by Salaudeen Rajack on 2:02 PM Rating: 5
Powered by Blogger.