kwizcom banner advertisement

SharePoint Alerts Report for a List or Library

March 31, 2012    , , ,
End-User's Requirement: I want to see all people who subscribed for my Project site's "Lessons Learn" List. Solution: Wrote object model code to retrieve all alerts created on a specific list. C# Object Model Code to Get All Alerts Created on a SharePoint List or Library & Generate Report: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using System.IO; namespace SharePoint.AdminReports { class GetAlertsForList { static void Main(string[] args) { string site; string web; string list; long alertCounter=0; StreamWriter SW; try { //Get the site collection , Sub-site, Lists if (args.Length != 3) { //Site collection Console.WriteLine("Enter the Site collec
SharePoint Alerts Report for a List or Library SharePoint Alerts Report for a List or Library Reviewed by Salaudeen Rajack on March 31, 2012 Rating: 5

"Navigation to the webpage was canceled" Error in .CHM File

March 30, 2012    , ,
Just downloaded a PowerShell Help file (.chm) from Microsoft site. When I open the CHM file, It just displayed an error message "Navigation to the webpage was canceled" Whatz wrong? Well, Since the file was downloaded from internet, by default it was blocked. Solution: Go to the properties of the file (Right click on the file, and choose Properties) and then click on Unblock button. That's it.
"Navigation to the webpage was canceled" Error in .CHM File "Navigation to the webpage was canceled" Error in .CHM File Reviewed by Salaudeen Rajack on March 30, 2012 Rating: 5

Security Trimmed Top Navigation Menu Using Custom Sitemap Provider for SharePoint

March 28, 2012    , , ,
Some time back shared my experience on creating consistent top navigation in SharePoint . Now, added with that, there is a requirement to make the Top navigation Security Trimmed! Alright, to fulfill this requirement all we need to do is: Create our own sitemap provider which does the job of security trimming. Lets get started! Brief: Create a Class project in Visual studio, Add references to SharePoint, System.web, System.Configuration. Place the following code in the .CS file, Strong Name it, Compile, Place the DLL to GAC, Update the web.config file. Place your own .sitemap file, Change your master page to link with the custom site map. SharePoint Security Trimmed Navigation Provider - Source Code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Utilities; using Microsoft.SharePoint.Navigation; using System.Web; using System.Xml; namespace BpCustomNavProvider { public class Cus
Security Trimmed Top Navigation Menu Using Custom Sitemap Provider for SharePoint Security Trimmed Top Navigation Menu Using Custom Sitemap Provider for SharePoint Reviewed by Salaudeen Rajack on March 28, 2012 Rating: 5

Configuring SSL Certificates in SharePoint 2010 - Step by Step

March 27, 2012    , , ,
Introduction SSL certificates provides secure connectivity between client-server. Setting up HTTPS in SharePoint 2010 sites is an security addition. Generally its a best practice to secure SharePoint Central Administration and External web applications with SSL (HTTPS access). This article covers : How to configure SSL certificates in SharePoint 2010 for HTTPS access. There are different types of SSL certificates available. We can pick one among them whichever applicable to our environment.     Steps overview Get the SSL Certificate Obtain from Trusted Certificate authority or Create a Self-signed SSL certificate Edit the Binding of the web application in IIS Change the alternate access mapping(AAM) Important: Certificates should be imported and Bindings to be updated in All the WFEs in the environment.   1.     Get the SSL Certificate To start with SSL certificates either we have to obtain the certificates from any trusted certificate provider like   Ve
Configuring SSL Certificates in SharePoint 2010 - Step by Step Configuring SSL Certificates in SharePoint 2010 - Step by Step Reviewed by Salaudeen Rajack on March 27, 2012 Rating: 5

Create Pie Chart from SharePoint Task list using Fusion Charts

March 26, 2012    , , ,
Two years back, I posted an article on Creating Fusion Charts in SharePoint .(Refer this article for step by step instructions to create Fusion charts, Just replace the below given XSL)  There is a similar request today, But this time, I had to create a Pie Chart from SharePoint Task List. Requirement is just to display the Chart based on the Task Status counts. Here is my XSL <xsl:template name="dvt_1.body"> <xsl:param name="Rows"/> <xsl:variable name="varNotStarted" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'Not Started'])" /> <xsl:variable name="varInProgress" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'In Progress'])" /> <xsl:variable name="varCompleted" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status) = 'Completed'])" /> <xsl:variable name="varDatase
Create Pie Chart from SharePoint Task list using Fusion Charts Create Pie Chart from SharePoint Task list using Fusion Charts Reviewed by Salaudeen Rajack on March 26, 2012 Rating: 5

SharePoint Database Consistency Check and Repair

March 25, 2012    , ,
Another fine evening, SCOM reported an IO issue in SQL Server box where SharePoint DBs residing. At the same time, End-users started getting errors: "Cannot complete this action. Please Try again." SCOM Alert: Alert: Logical consistency error after performing I/O on page Source: MSSQLSERVER Path: DBserver.domain.org Last modified by: System Last modified time: 3/21/2012 7:20:55 PM Alert description: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x4c2c50d1; actual: 0x4c6650b5). It occurred during a read of page (1:2505989) in database ID 25 at offset 0x000004c7a0a000 in file 'S:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WSS_Content.mdf'.   Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused b
SharePoint Database Consistency Check and Repair SharePoint Database Consistency Check and Repair Reviewed by Salaudeen Rajack on March 25, 2012 Rating: 5

Find Most Active SharePoint Sites of a Web Application

March 25, 2012    , , ,
Requirement is fairly straightforward. Get me the list of SharePoint sites which are most active (Where updates made quite often) PowerShell? Yes. Lets get the SPWeb's Last Item Modified Date and log it to a CSV file to generate the most active sites report. #Set-ExecutionPolicy RemoteSigned [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") $url="http://sharePoint.company.com" $site = New-Object Microsoft.SharePoint.SPSite($url) $spWebApp = $site.WebApplication $OutputFN = "c:\ActiveSitesReport.csv" "Site Name `t URL `t Last Modified" > $OutputFN # Iterate through all sites: foreach ( $spSite in $spWebApp.Sites ) { foreach ($spWeb in $spSite.AllWebs) { if ($spWeb.IsRootWeb) { $siteName = $spWeb.Title +" - Root"; } else { $siteName = $spSite.RootWeb.Title
Find Most Active SharePoint Sites of a Web Application Find Most Active SharePoint Sites of a Web Application Reviewed by Salaudeen Rajack on March 25, 2012 Rating: 5

Create Event Handler to Force Unique in MOSS 2007 with WSP Builder

March 20, 2012    , , , , ,
Long back, I did an Event handler to prevent duplicates in a SharePoint list. There is a another requirement of same kind now. This time, Let me do it with WSP builder. Requirement is simple - Prevent duplicate titles from a List. Hmm.., But in SharePoint 2010 this is an instinct feature, we don't need to do any event handlers. Lets get started. Create an Event handler for SharePoint 2007 with WSP Builder - Step by step : Step 1:   Open the Visual studio, Create a New Project, Choose WSP Builder Project type Step 2: Add a new item to the Project Step 3: Choose Event Handler under WSP Builder node, Name it and click "Add" Step 4: In the Event Handler code, place this code: using System; using System.Collections.Generic; using System.Text; using Microsoft.SharePoint; namespace PreventDuplicateEventHandler { class PreventDuplicates : SPItemEventReceiver { public override void ItemAdding(SPItemEventProperties properties) {
Create Event Handler to Force Unique in MOSS 2007 with WSP Builder Create Event Handler to Force Unique in MOSS 2007 with WSP Builder Reviewed by Salaudeen Rajack on March 20, 2012 Rating: 5

Workflow Actions are Empty in Nintex Workflow Designer

March 19, 2012    
Problem: Workflow actions are missing in Nintex workflow designer 2010. Troubleshooting: Tried de-activating and re-activating the Nintex Workflow 2010 feature at site collection and site level. Tried adding user to Full permission/Tried Re-adding the user to the site. Solution: Follow these steps to get workflow actions in Nintex workflow designer:  Open SharePoint Central Administration site as a Farm Administrator. Click on Manage allowed actions link under Nintex Workflow Management. Tick All activities you need and Click on OK to save your changes. Now, Navigate to your SharePoint site, you'll see Workflow Actions available. Also make sure, the allowed workflow actions settings are set at the site collection and site levels.
Workflow Actions are Empty in Nintex Workflow Designer Workflow Actions are Empty in Nintex Workflow Designer Reviewed by Salaudeen Rajack on March 19, 2012 Rating: 5

'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher

March 18, 2012    , , ,
When trying to edit documents in SharePoint from the context menu item "Edit in Microsoft Office Excel" , users received error message: "'Edit Document' Requires a Windows SharePoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher" Error: Troubleshooting: 1. This functionality works only on 32 bit version of IE and not with IE 64 bit version. So use IE 32 bit version. You can access it from: C:\Program Files (x86)\Internet Explorer\iexplore.exe   even though you installed 64 bit version. More info: http://technet.microsoft.com/en-us/library/cc263526.aspx refer ActiveX controls section 2. Make sure all the SharePoint add-ons are enabled in IE. Refer this screenshot. Go to Internet explorer >> Tools >> Manage Add-ons to enable the add-ons. 3. This functionality doesn't work in Firefox (Found it works with Google Chrome!) 4. Try adding SharePoint site to the trusted sites list in IE. 5.
'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher 'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher Reviewed by Salaudeen Rajack on March 18, 2012 Rating: 5

Configuring My Sites & User Profile Synchronization in SharePoint 2010 - Step by Step

March 15, 2012    , , , , , ,
Introduction : This article provides step by step instruction on Configuring My Sites and user profile synchronization for SharePoint 2010. Overview Create My Site Host web application Create User Profile Service Application Configure Synchronizations connections with AD-Domains Configure Synchronization Schedules Before we begin:   Create/Obtain the domain account that will be used for profile synchronization. This account should have the “Replicate Directory Changes” permission on a domain. (This rights for query changes in the directory. This permission does not allow an account to make any changes in the directory.) Refer: http://technet.microsoft.com/en-us/library/hh296982.aspx#RDCdomain for more info and steps. This domain account must be a Farm Admin account and should have Administrator rights on the All the SharePoint servers. Make sure you have all the SharePoint 2010 updates at-least till August 2011 CU is installed. Get the updates from URL: http://techne
Configuring My Sites & User Profile Synchronization in SharePoint 2010 - Step by Step Configuring My Sites & User Profile Synchronization in SharePoint 2010 - Step by Step Reviewed by Salaudeen Rajack on March 15, 2012 Rating: 5
Powered by Blogger.