Find All InfoPath Form Libraries in SharePoint using PowerShell

September 27, 2012    , , , , ,
During a Corporate Re-branding project, implemented new logo, color themes all over the SharePoint sites and now, the new Logo must be changed in All the InfoPath Form Libraries! It was really challenging to manually find InfoPath form libraries in a Large environment with 1500+ site collections. Automation? PowerShell! Here goes the PowerShell script to find all InfoPath Form Libraries of the All Site collections. PowerShell to Find All InfoPath Form Libraries in SharePoint: [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") > $null #For SharePoint 2007 function global:Get-SPSite($url){ return new-Object Microsoft.SharePoint.SPSite($url) } #Get the web application Write-Host "Enter the Web Application URL:" $WebAppURL= Read-Host $SiteColletion = Get-SPSite($WebAppURL) $WebApp = $SiteColletion.WebApplication #Write the CSV header "Site Collection `t Site `t List Name `t List Url `t Docs Count `t Last Modified `t WF Count `t
Read More
Find All InfoPath Form Libraries in SharePoint using PowerShell Find All InfoPath Form Libraries in SharePoint using PowerShell Reviewed by Salaudeen Rajack on September 27, 2012 Rating: 5

Integrating SMS Alert Configuration in SharePoint 2010

September 24, 2012    , , , , , ,
Introduction: SMS Alerting is a new feature introduced in SharePoint 2010. Business requirements like, user should get a SMS whenever new announcement published or stock level decreased can be fulfilled with SMS integration. In some cases, SMS is preferred than Email message as SMS is fast and Email may get filtered by SPAM filters. Perform the following procedure step by step to configure SMS integration with SharePoint to establish SMS notification system. Enable SMS Alerts in SharePoint 2010 - Steps Overview: Obtain the SMS Gateway by registering to any of the SMS gateway providers or Setup your own SMS Gateway. Import the root certificate of the service provider’s Root certificate and create a trusted root authority. Configure Mobile account settings in SharePoint 2010 central Administration. Create Alerts/Use third-party applications (like Nintex Workflows) to use the SMS alerts! Step 1: Obtain the SMS Provider Gateway SharePoint SMS providers There are many SMS
Read More
Integrating SMS Alert Configuration in SharePoint 2010 Integrating SMS Alert Configuration in SharePoint 2010 Reviewed by Salaudeen Rajack on September 24, 2012 Rating: 5

SharePoint Developer Dashboard - FAQs

September 23, 2012    , , , , ,
This article is to answer some of the Frequently asked questions on SharePoint developer dashboard. What is Developer Dashboard in SharePoint? The developer dashboard is a new feature introduced in SharePoint 2010 to monitor and debug the performance on page by page basis. Remember the old days, when it was too difficult in MOSS 2007 on troubleshooting page delays? Developer dashboard is the answer to them! What Information it gives to debug and troubleshoot? Lot! All operations and its start-end time, Controls and their load time, total execution time, current user, SPRequests, URL, Current page checkout level, current operations being performed,  Call Stacks, Web Server, Critical Events, Database Queries and their execution time, Service Calls, execution time, Events fired during the page rendering, Order of the page lifecycle and time during each stage, etc. How to Activate SharePoint developer dashboard? The dashboard is turned off by default. It can be enabled via: Sts
Read More
SharePoint Developer Dashboard - FAQs SharePoint Developer Dashboard - FAQs Reviewed by Unknown on September 23, 2012 Rating: 5

Find All Documents Created or Modified by a Particular User in Specific Date Time

September 19, 2012    , , , ,
Requirement is to find all documents which are uploaded to the SharePoint environment during the past one Month. PowerShell can do the reporting well. Lets see the code: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue # Set the date Filter $dateFilter = (Get-Date).AddMonths(-1) #Past Month "File, Created Time, File Size" | out-file NewDocuments.csv # Get all Webs $webs = Get-SPWebApplication "http://sharepoint.crescent.com" | Get-SPSite -Limit All | Get-SPWeb -Limit All #Iterate through webs ForEach ($web in $webs) { #Iterate through All Lists ForEach ($list in $web.Lists) { #Check for Document Libraries If ($list.BaseType -eq "DocumentLibrary") { #Iterate through All documents ForEach ($item in $list.Items) { If ($item.URL.StartsWith("_")) {Break} #Skip _catalogs, etc If ($item.URL.EndsWith(".aspx")) {Break} #Skip For
Read More
Find All Documents Created or Modified by a Particular User in Specific Date Time Find All Documents Created or Modified by a Particular User in Specific Date Time Reviewed by Unknown on September 19, 2012 Rating: 5

Hide SharePoint 2007 List Toolbar buttons and Menu Items

September 16, 2012    , , , ,
Got a requirement to Hide SharePoint toolbar buttons (E.g. "New", "Upload"), Menu Items (E.g. "Upload Multiple Files", "Alert Me") from all document libraries of a SharePoint 2007 site collection. If its is for just a single document library, this can be achieved by wring Javascript-CSS, place it in Content Editor web part to hide the "New" button. If its for the entire Farm, this can be achieved by Override the ToolbarActionsMenu template: http://blogs.msdn.com/b/dipper/archive/2006/10/05/how-to-remove-or-hiding-items-in-list-toolbar-in-sharepoint-server-2007.aspx HideCustomAction? Nope, ListViewWebPart menu items are rendered as a web control from the Microsoft.SharePoint.dll, So they can't be hidden through the "HideCustomAction" feature. Solution: jQuery or JavaScript with Delegate Control. How? The overall idea is, plug the jQuery to hide "New" button into "AdditionalPageHead" delegate c
Read More
Hide SharePoint 2007 List Toolbar buttons and Menu Items Hide SharePoint 2007 List Toolbar buttons and Menu Items Reviewed by Salaudeen Rajack on September 16, 2012 Rating: 5

SharePoint Migration Tools Comparison

September 15, 2012    , , , ,
Disclaimer : By writing this article I'm not promoting or demoting any SharePoint migration product. This analysis was done during early 2012. Product features may get improved meanwhile. Products are compared in the perspective of the features required for my business scenarios. I've conducted these tests by migrating from our live SPS-2003 and SharePoint 2007 into SharePoint 2010 with all of the tools. We have compared the features/issues/license cost SharePoint Migration Products Compared I've evaluated below products and methods for my SharePoint migration tools comparison. Metalogix - Migration Manager for SharePoint http://www.metalogix.com/Products/Migration-Manager-for-SharePoint/SharePoint-Upgrade.aspx Quest - DELL - Migration Manager for SharePoint   http://software.dell.com/products/migration-suite-for-sharepoint/ MetaVis - Migrator http://www.metavistech.com/product/sharepoint-migration Avepoint - DocAve Migrator http://www.avepoint.com/sharepoint-to-
Read More
SharePoint Migration Tools Comparison SharePoint Migration Tools Comparison Reviewed by Salaudeen Rajack on September 15, 2012 Rating: 5

User Profile Synchronization Service Stuck at "Starting" - Solution

September 12, 2012    , , ,
While configuring User Profile Synchronization in SharePoint 2010 , User Profile Synchronization service got stuck at "Starting" state. User profile synchronization service was in starting state for long time! I've been banging my head for couple of Hours. Made sure SharePoint web services in IIS is up and running  Verified the environment has latest service pack - SP1 installed.  Verified LoopbackCheck is disabled Verified TCP chimney is disabled (TO check, in cmd: netsh int tcp show global .To Disable: netsh int tcp set global chimney=disabled ) While configuring SharePoint, I used SQL Alias. As UPS doesn't like SQL Server FQDN or IP addresses!  I made sure the Farm Account has "DB Creator" and "Security Admin" Roles. Verified Forefront Identity Manager Synchronization Service and the Forefront Identity Manager Service are running in the identity of the account which as Farm Administrator access rights. The account in which I logged on
Read More
User Profile Synchronization Service Stuck at "Starting" - Solution User Profile Synchronization Service Stuck at "Starting" - Solution Reviewed by Salaudeen Rajack on September 12, 2012 Rating: 5

Find and Delete Orphaned Users in SharePoint

September 11, 2012    , , , , , ,
Orphaned User? Who are they? Orphaned users are those who have been disabled/removed from Active Directory, but still have permissions to sites, lists and items. Internally, SharePoint keeps them in " UserInfo " table of the content database for meta-data such as created/modified by fields. Its unavoidable in any organization where employees constantly on-boarding and off-boarding. Its really difficult to manage, when it comes to thousands of sub-sites, sites, libraries and lists with their own sets of permissions. SharePoint doesn't automatically remove users when they are deleted or disabled in Active directory! Why we care about Orphaned users? It is a best practice to delete orphaned users to keep the farm clean & organized. Also this will solve the problem of deleted active directory users still appearing on the people picker which was discussed here  People Picker not showing users from Active Directory? . If you know the user base or criteria then y
Read More
Find and Delete Orphaned Users in SharePoint Find and Delete Orphaned Users in SharePoint Reviewed by Salaudeen Rajack on September 11, 2012 Rating: 5

Attach Event Receiver to Specific List Programmatically in SharePoint 2010

September 06, 2012    , , ,
Recently, developed a Event Receiver to set Item Level permissions based on the list field "Visible to Visitors". Event receiver binds with all document libraries using ListTemplateId element in Elements.xml.  Event Receiver to Set Item Level Permissions based on List Column Value How to Associate Event Receiver with a List Programmatically in SharePoint 2010: SharePoint 2010 offers ListURL to be specified in Elements.xml file to attach the Event Handler to the particular list. MOSS 2007 doesn't! So you have to write code to Register, May be Console application/Feature Receiver, etc. Code to Register Event Receiver with a Particular List: using System; using System.Collections.Generic; using System.Text; using Microsoft.SharePoint; namespace SetItemLevelPermission { //Class to Register Event Receiver to particular List class BindEventHandlerToLists : SPFeatureReceiver { public override void FeatureActivated(SPFeatureReceiverProperties prop
Read More
Attach Event Receiver to Specific List Programmatically in SharePoint 2010 Attach Event Receiver to Specific List Programmatically in SharePoint 2010 Reviewed by Unknown on September 06, 2012 Rating: 5

Event Receiver to Set Item Level Permissions based on List Column Value

September 04, 2012    , , ,
Requirement is to Set Item Level Permission on Document Library Items based on the field in the document library "Visible to Visitors". Field "Visible to Visitors" is a Check box. Technically, When this column set to True, We'll have to do nothing. When this column set to False, we'll have to break the inheritance and remove the visitors group from the Item's permissions. Lets build a Event Receiver to set Item level permissions based on the field in the Library. using System; using System.Collections.Generic; using System.Text; using Microsoft.SharePoint; namespace SetItemLevelPermission { class SetPermissions : SPItemEventReceiver { public override void ItemAdded(SPItemEventProperties properties) { // base.ItemAdded(properties); SPListItem item = properties.ListItem; //Check whether the List Item has the "Visible to Visitors" column if (item.Fields.ContainsField(&q
Read More
Event Receiver to Set Item Level Permissions based on List Column Value Event Receiver to Set Item Level Permissions based on List Column Value Reviewed by Unknown on September 04, 2012 Rating: 5

Workflow Runs on New Document Upload Before Metadata is Set?

September 03, 2012    , ,
That's the expected behavior! When Workflows configured to start on Item creation, They'll start as soon as you upload a new document and will not wait until you enter Meta-data. In fact, Metadata page is a Edit form! Alright, How to Mitigate?  Change the workflow trigger from "Item Creation" to "Item Change" if possible. If you want to check whether the document is newly created, Just compare the Created & Modified fields. They'll be same when you upload a document for the first time. In beginning of Your workflows, Include the logic to check whether the metadata values are present. If not, Just wait for the metadata to set or end up the workflow.  Alternatively, you can set the default values for your metadata fields, so that they will not be empty. You can set "Require content to be checked out" option, so that workflow will not run until you enter the mandatory fields and check-in. Using a Pause action may work (e.g. pause
Read More
Workflow Runs on New Document Upload Before Metadata is Set? Workflow Runs on New Document Upload Before Metadata is Set? Reviewed by Salaudeen Rajack on September 03, 2012 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.