kwizcom banner advertisement

How to make Dataview Web Part Portable?

9:05 PM    , ,
When working with SharePoint DataView Customizations, by default you can not just copy paste the data view pages into new environment or even restore them from backup. This is because: The Data View Web Part uses List ID instead of List Name. So, How to make the Dataview Portable from one environment to another? Simple! Replace the ListID to ListName and provide the List name in the place of GUID. Important: Please note, These changes must be done once you complete all the customizations to the dataview webpart. You will not be able to make changes using Design view in SharePoint designer after making these changes, because SharePoint designer uses ListID parameter, which we are going to replace!   As always, Take a Backup! Detailed steps:     1. Open the site & Web part page in SharePoint Designer.     2. Search and Replace ListID with ListName    3. Replace the DefaultValue="GUID" with  DefaultValue="Your List Name" That's All!
How to make Dataview Web Part Portable? How to make Dataview Web Part Portable? Reviewed by Salaudeen Rajack on 9:05 PM Rating: 5

Building Branding Solution with Feature Stapler for SharePoint 2007

6:21 PM    , , ,
Feature Staplers are the best way to build branding solutions in SharePoint. Once deployed branding will be automatically applied based on Site definition. Overall Steps: Create a WSP Project and add 2 features in it. One for actual Branding with Feature handler code - Applies Branding on activated and another one for Stapling the feature - Binds the feature with site with Site definitions.  Lets get started. 1. Create a WSP Project in Visual Studio: 2. Right click the Project and choose "Add > New Item" to the Project 3. Under "WSPBuilder" choose "Feature with Receiver", Enter the Name for the feature. 4. Set the scope for the Feature as "Web" meaning sub-site. 5. Now, add the feature for FeatureStaple: Add New Item, and this time choose "Blank Feature" 6. Set the scope for FeatureStapler as "WebApplication" 7.Add your own Master Page,  CSS, Site Map files, Custom Navigation Provider, etc. t
Building Branding Solution with Feature Stapler for SharePoint 2007 Building Branding Solution with Feature Stapler for SharePoint 2007 Reviewed by Salaudeen Rajack on 6:21 PM Rating: 5

Workflows Inventory Report for SharePoint

3:19 PM    , , , ,
Requirement from my CIO: Salaudeen, Get me a SharePoint Workflows Report with Total No. of workflows wherever its running, for our intranet SharePoint site with Site Name, List Name, Workflow Name, and No. of Instances, etc. Solution: As usual dive into the object model code (This can be achieved with PowerShell as well). Here it is. using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using Microsoft.SharePoint.Workflow; using System.IO; namespace GetWorkflowReport { class GetWorkflowsReport { static void Main(string[] args) { string site; try { if (args.Length == 0) { Console.WriteLine("Enter the Web Application URL:"); site = Console.ReadLine(); } else { site = args[
Workflows Inventory Report for SharePoint Workflows Inventory Report for SharePoint Reviewed by Salaudeen Rajack on 3:19 PM Rating: 5

What is my SQL Server Version, Service Pack, Edition

2:53 PM    ,
Requirement: Wanted to check the installed SQL Server version service pack level. SELECT @@version ? It didn't give me the Service pack information. Query to Check SQL Server version, Service pack and Edition: SELECT SERVERPROPERTY('productversion') [Product Version], SERVERPROPERTY ('productlevel') [Service Pack], SERVERPROPERTY ('edition') [Edition] KB Article: http://support.microsoft.com/kb/321185
What is my SQL Server Version, Service Pack, Edition What is my SQL Server Version, Service Pack, Edition Reviewed by Salaudeen Rajack on 2:53 PM Rating: 5

Install PowerShell in Windows 2003

4:19 PM    ,
Need PowerShell in Windows 2003?  Install "Windows Management Framework core" which includes Windows PowerShell 2.0. You need to have SP2 or later in Windows 2003. Go the KB: http://support.microsoft.com/kb/968929 , download and install the appropriate KB for your environment (such as x64, x86) Once installed, you can access PowerShell  from Start > All Programs > Accessories > Windows PowerShell Your browser does not support iframes.
Install PowerShell in Windows 2003 Install PowerShell in Windows 2003 Reviewed by Salaudeen Rajack on 4:19 PM Rating: 5

Version History Size Report for Entire SharePoint Web Application

8:02 PM    , , , , ,
Ever wanted to get a report on versioning sizes on SharePoint? Unlimited No. of versions enabled in various document library across web application. As part of regular auditing, wanted to generate report for the entire web application ,with Number of versions, Amount of storage consumed by versions. Of course there are some third-party products like Axceler Control Point with additional capabilities. But How about wring my own code? Sounds good. Here is my code: Tested in SharePoint 2010 and MOSS 2007. using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Administration; using System.IO; namespace SharePointReporting { class GetVersioningReport { static void Main(string[] args) { string site; StreamWriter SW; try { if (args.Length == 0) { Console.WriteLine("Enter the
Version History Size Report for Entire SharePoint Web Application Version History Size Report for Entire SharePoint Web Application Reviewed by Salaudeen Rajack on 8:02 PM Rating: 5

Using owssvr.dll to retrieve List data in XML format

6:26 PM    , ,
Owssvr.dll is a traditional Remote Procedure Call method to remotely invoke functions in SharePoint. It can be used to retrieve data from SharePoint list as well. syntax: http://sharepoint.com/_vti_bin/owssvr.dll?Cmd=Display&List=<<LIST-GUID>>&XMLDATA=TRUE E.g. https://intranet.sharepoint.com/_vti_bin/owssvr.dll?Cmd=Display&List={6685db48-013f-4934-8147-b7a6014eccc9}&XMLDATA=TRUE Other options: Filter &   View Append -  FilterField1=<<Field-Internal-Name>>&FilterValue1=<<Value-of-the-field>> e.g: FilterField1=Domain&FilterValue1=Sales View={ViewGuid} How to get the List GUID? Go to List settings >> right click "Audience targeting settings" Say "Copy Shortcut". Now you will get something like: https://sharepoint.com/sites/Test/_layouts/ListEnableTargeting.aspx?List= {6685db48-013f-4934-8147-b7a6014eccc9} Highlighted is the GUID. Output: Once you get the XML you can use it wh
Using owssvr.dll to retrieve List data in XML format Using owssvr.dll to retrieve List data in XML format Reviewed by Salaudeen Rajack on 6:26 PM Rating: 5

How to Deploy and Activate Sandboxed Solutions in SharePoint 2010

5:20 PM    , , ,
Sandboxed solutions brings the benefit of deploying solutions to SharePoint Server without affecting any other process outside the sandbox. SharePoint 2010 Sandboxed solution can be deployed by Site collection administrators. Here is the guide on How to Deploy and activate sandboxed solution in SharePoint 2010. Go to Site Actions >> Site Settings >> Solutions under the Galleries In Solutions tab, click Upload Solution button  Browse and select the WSP File from your sandboxed solution, click on "OK" to complete. The solution package is now in the site collection's solution gallery, but it is not yet deployed. In the Activate Solution dialog box, click Activate to activate the solution  You will see the solution's activation status in the solution Gallery page.   Depending on the solution, will see the sandboxed solution in action. From the solution gallery page, we can deactivate, delete the solution further. Using PowerShell to Deplo
How to Deploy and Activate Sandboxed Solutions in SharePoint 2010 How to Deploy and Activate Sandboxed Solutions in SharePoint 2010 Reviewed by Salaudeen Rajack on 5:20 PM Rating: 5

Fix "The site collection containing this sandboxed solution has exceeded its daily resource usage quota."

3:27 PM    , , , ,
When trying to activate a sandboxed solution, Got below error message: "The site collection containing this sandboxed solution has exceeded its daily resource usage quota." Solution:  This is because of the Sandbox solution resource limit. To fix this issue, just increase the site collection Sandbox solution resource quota in site collection quotas and locks. Go to: Central Administration >> Application Management >> Configure quotas and locks >> Pick the target site collection. Increased the Sandbox solution resource quota under "Limit maximum usage per day to:   0 points" to 100 points, Problem solved! In an another case, whey trying to deploy a sandbox solution from visual studio, it reported the same error "Error occurred in deployment step 'Add Solution': The site collection containing this sandboxed solution has exceeded its daily resource usage quota" and the fix is same! Same thing applies to office 365!
Fix "The site collection containing this sandboxed solution has exceeded its daily resource usage quota." Fix "The site collection containing this sandboxed solution has exceeded its daily resource usage quota." Reviewed by Salaudeen Rajack on 3:27 PM Rating: 5

Create List Instance Feature for SharePoint 2010 in Visual Studio

1:15 PM    , ,
Requirement:  Create a new Link list with pre-populated list items as a feature based solution. Steps: 1. Lets create a SharePoint 2010 list instance feature with Visual Studio. Create a New Empty SharePoint Project , Give it a name, I've named it as Crescent.Portal.DashboardLinks 2. In the next dialog box, Select either Farm solution or Sandboxed solution whichever applicable to your requirements. I've selected "Deploy as a Farm Solution" 3. Right click the Project in visual studio solution explorer >> Add >> New Item >> List Instance to  create new SharePoint 2010 list using visual studio   4. Enter the List Instance settings: Link List Name, List to Instantiate, URL. Click Finish. 5. Now our project will look like the below screen. Look at the "FeatureId" attribute. This is the Feature ID of the Link List feature. In case, If you want to create a List instance for your own List definition, You can use the Feature ID of
Create List Instance Feature for SharePoint 2010 in Visual Studio Create List Instance Feature for SharePoint 2010 in Visual Studio Reviewed by Salaudeen Rajack on 1:15 PM Rating: 5

Get the List Settings Page of any List

9:53 PM    ,
Problem: There was a List in a site collection without any tool bars (They were removed purposefully). Had to change some columns in the list. Since the toolbar is disabled, could not get into : List settings from SharePoint Interface. Solution: For user created lists, the simplest way is, navigate to: Site actions >> Site Settings >> click on Site libraries and lists under "Site Administration". That will lead to a page from where we can pick a list to get its settings page. How about SharePoint Server's lists/hidden lists? e.g. User Information List? Lets dig little more. Take a look at a typical list settings URL: http://sharepoint.com/_layouts/listedit.aspx?List={List-GUID} . Why don't we try the same with our List? We know the List Name and its location. But how to get the GUID of the list? Well, There are many ways: Object Model, PowerShell, or Database Query. Here, I'm using PowerShell: Say our List name is: "User Information
Get the List Settings Page of any List Get the List Settings Page of any List Reviewed by Salaudeen Rajack on 9:53 PM Rating: 5

Find Large Lists & Generate Report in SharePoint

6:47 PM    , , , , , ,
Requirement: SharePoint was running with serious performance issues and wanted to get the report, where more than 2000 items stored in List/Library for the entire web application. When users store large number of items in List or Library, SharePoint will definitely run into serious performance issues. This script will generate the report on List items count for the entire web application. This code generates the CSV file, with details : List name, Site collection, Site URL, Item count. By this way, we can make sure we control the users activities by generating reports on our site content periodically. we can use this piece of code to generate the report on scheduled basis to get the List item count insights on our environment. It basically loops through all the site collections, Lists and libraries of the given web application, checks whether the items count > 2000, If yes, it logs the details to the CSV file. Here is the C# code to Find Large Lists & Generate Report in S
Find Large Lists & Generate Report in SharePoint Find Large Lists & Generate Report in SharePoint Reviewed by Salaudeen Rajack on 6:47 PM Rating: 5

Copy Webpart Pages between SharePoint Site Collections

7:31 PM    , ,
Had a requirement to copy web part pages from one site collection to other. These options failed, I got the page with out any web parts placed: Explorer view copy paste Download a copy and upload SharePoint Designer copy-paste The worked trick is: Using SharePoint Designer - "New from Existing Page". Steps in Detail:   1. Open Both the Source and Target sites in SharePoint Designer  2. Right click the source web part page and then choose "New From Existing Page"      3. This will create a new page with existing page's content. Click on Save button 4. Now, Enter the target site's location in Save dialog box, and then Save the file! So Simple trick isn't it? Another approach if you have server access: You can use SharePoint Deployment Wizard utility to achieve the same. You can use SharePoint Designer workflow's Copy Item action also!
Copy Webpart Pages between SharePoint Site Collections Copy Webpart Pages between SharePoint Site Collections Reviewed by Salaudeen Rajack on 7:31 PM Rating: 5
Assembly microsoft.sharepoint.intl.dll security permission grant set is incompatible between appdomains Assembly microsoft.sharepoint.intl.dll security permission grant set is incompatible between appdomains Reviewed by Salaudeen Rajack on 8:02 PM Rating: 5

Playing Videos in SharePoint using JWPlayer

3:19 PM    , , ,
Requirement :  To play a .MOV video file in SharePoint site. Solution: Used the JWPlayer in SharePoint. Here are the detailed steps. Step 1:  Download the JWPlayer files from http://www.longtailvideo.com/jw/upload/mediaplayer-viral.zip Extract and open the jwplayer.js file, Search for  /jwplayer/player.swf and then replace this with the location where you are going to upload the files. E.g. change it to: https://SharePoint.yourcompany.com/sites/Marketing/brandcenter/Player/player.swf Step 2: Create a Document Library and upload the files along with your video file and modified preview.png. Step 3: Create a HTM file with the name of "Jwplayer.htm", paste the below code in it, change the File locations accordingly,  and then upload it to the document library you created earlier. <html> <head> <title></title> </head> <body> <!-- START OF THE PLAYER EMBEDDING TO COPY-PASTE --> <div id="mediaplayer">Lo
Playing Videos in SharePoint using JWPlayer Playing Videos in SharePoint using JWPlayer Reviewed by Salaudeen Rajack on 3:19 PM Rating: 5

"Alert me" Missing in SharePoint 2010?

9:35 PM    , , ,
In an odd case, received complaints from users "SharePoint alert me missing!". Usually "Alert me" link will be there under documents tab of the SharePoint 2010 Ribbon. End-Users were unable to get "Alert me" link. W hen I checked, Yes, alert me button missing in SharePoint 2010 site!! and some more complaints for getting error messages when trying to setup alerts. "Alerts have been turned off for this virtual server. For assistance, contact your server administrator." Fix:   Check whether the Outgoing E-Mail settings are configured in Central Admin.  Go to: Central Administration >> System Settings >>  Outgoing E-Mail Settings >> specify the outbound SMTP server & E-Mail settings. If already enabled, Then alerts might be disabled. Enable Alert by:  stsadm -o setproperty -pn alerts-enabled -pv true -url "http://your-web-app-url.com"  That would fix the issue: alert me is missing in SharePoint 2010! Go
"Alert me" Missing in SharePoint 2010? "Alert me" Missing in SharePoint 2010? Reviewed by Salaudeen Rajack on 9:35 PM Rating: 5

SharePoint Search Scope Force Update

6:36 PM    , ,
After updating SharePoint Search Scope, it said: wait 14 Minutes to update. How to instantly update the scopes? Do we have to wait for 14 Minutes? Is there a  way to force SharePoint search scope update on-demand? Definitely, Yes! We can force update SharePoint 2010 search scope. Just go back to "Search Administration" There you will find a link "Start Update Now" Click on the link to update Search Scopes on demand! Want to update search scope in SharePoint using powershell? Sure, Why not! Here you go: SharePoint powershell update search scope $SearchServiceApp = Get-SPenterpriseSearchServiceApplication $SearchServiceApp.StartScopesCompilation() This will do SharePoint 2010 force search scope update!
SharePoint Search Scope Force Update SharePoint Search Scope Force Update Reviewed by Salaudeen Rajack on 6:36 PM Rating: 5

SharePoint Alert Notifications Not Working - Checklist for Troubleshooting

7:46 PM    , , , , , ,
Before proceeding with the checklist, analyze and isolate the issue: Whether E-mail Infrastructure is working on your environment Whether in all SharePoint web applications alerts are not working? SharePoint alerts not working for one site? SharePoint alerts not working after upgrade or migration  Alerts not working after restore or Service pack? Alerts not working all the time? or Stopped working Recently? SharePoint alerts not being sent to All the user? or some users? or distribution groups, ad group members? Whether SharePoint alerts not working for document library? list alerts not working? calendar alerts not working ? or everywhere? Only SharePoint daily alerts not working? etc.  This will help you to troubleshoot the SharePoint email alerts not working issue, quickly. Here is the checklist for troubleshooting: 1. Check alerts are enabled for your web application: How to check? execute this stsadm in your SharePoint Server: Stsadm.exe -o getproperty -url http:/
SharePoint Alert Notifications Not Working - Checklist for Troubleshooting SharePoint Alert Notifications Not Working - Checklist for Troubleshooting Reviewed by Salaudeen Rajack on 7:46 PM Rating: 5

SharePoint Topology for 5000 users - Virtual

4:23 PM    , , ,
Had a requirement to provide SharePoint 2010 Topology for 5000 intranet users. End-users will be using SharePoint 2010's collaboration features, Nintex workflows with SQL Server Reporting services and the Management wants to go for Visualization as it reduces the Cost! Here goes my recommendation: Hardware/Software specifications: Technet article on Topology planning in virtual environment: http://technet.microsoft.com/en-us/library/ff607811.aspx
SharePoint Topology for 5000 users - Virtual SharePoint Topology for 5000 users - Virtual Reviewed by Salaudeen Rajack on 4:23 PM Rating: 5

"Unable to complete this operation. Please contact your administrator" Error when trying to upload a file in SharePoint

5:47 PM    , , , ,
I was troubleshooting an issue with uploading files to SharePoint Site. When I tried uploading a file to the document library, I got this error: "Unable to complete this operation. Please contact your administrator" Enabled Stack Trace and Disabled Custom error tags in web.config to reveal the actual error: Unable to complete this operation.  Please contact your administrator.   at Microsoft.SharePoint.Library.SPRequestInternalClass.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage)    at Microsoft.SharePoint.Library.SPRequest.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int3
"Unable to complete this operation. Please contact your administrator" Error when trying to upload a file in SharePoint "Unable to complete this operation. Please contact your administrator" Error when trying to upload a file in SharePoint Reviewed by Salaudeen Rajack on 5:47 PM Rating: 5

Find Remaining of Days in XSL

3:00 PM    ,
Scenario: I have a List for keeping track of my Outsourced resources with fields: Resource Name, Skills, Contract Start Date, End Date, etc. What I want is: Display the No.of remaining days in a page. So Added a calculated field , applied the formula : =IF(Today>=[End Date],0,INT([To Date]-Today)) , So simple, isn't it? hmm, The problem here is: since its a calculated field, it wont get update until you update the record! All I wanted is just to display the remaining days. Tried the formula: <xsl:variable name="DaysDiff" select="ddwrt:FormatDateTime(string(ddwrt:Today()), 1033, 'yyyyMMdd') - ddwrt:FormatDateTime(string(@EndDate), 1033, 'yyyyMMdd')"/> Nope! didn't work, gave me wrong values in some cases. After Googling some time, found in Technet forums something works: Custom XSL Template! Insert this code in Dataview XSL <xsl:template name="DateDiff">     <xsl:param name="StartDate">&l
Find Remaining of Days in XSL Find Remaining of Days in XSL Reviewed by Salaudeen Rajack on 3:00 PM Rating: 5

Unable to upload files or add users. Receiving HTTP 403 Forbidden error

4:16 PM    ,
Users were unable to upload files or add users to SharePoint sites. Moreover they received  HTTP 403 Forbidden error message when trying to upload or add users. Fix: This is a known issue and needs the hot fix http://support.microsoft.com/kb/934793/ applied on the server! In some cases, another possible case is: anonymous access might removed from READ permissions of IIS virtual directories.  Fire IIS console and fix it.
Unable to upload files or add users. Receiving HTTP 403 Forbidden error Unable to upload files or add users. Receiving HTTP 403 Forbidden error Reviewed by Salaudeen Rajack on 4:16 PM Rating: 5

"New" Icon Indicator in SharePoint - Disable, Replace, Set Duration

3:32 PM    , , ,
Lot of folks asking me on SharePoint " ! New " Indicator. By default SharePoint 2007/2010 shows " ! New" Indicator for 2 days from the creation of an List item/document. It simply indicates it's newly added content such as document or list item! How to Replace New tag in SharePoint 2010? As part of branding, we can replace the New Indicator. Its just an image, new.gif , located at: /_layouts/1033/images/new.gif (\14\template\layouts\1033\IMAGES\new.gif). Behind the scenes ddwrt:IfNew Function determines whether to display this image or not. How to change New tag duration in SharePoint? You can query the current value of !New indicator by:   stsadm -o getproperty -pn days-to-show-new-icon -url <URL-of-web-app> If you want to change the days: stsadm -o setproperty -pn days-to-show-new-icon -pv <days-to-show> -url <web-app-URL> How To Remove/Disable New Tag in SharePoint? Want to disable the !New tag indicator? execute the STSADM:
"New" Icon Indicator in SharePoint - Disable, Replace, Set Duration "New" Icon Indicator in SharePoint - Disable, Replace, Set Duration Reviewed by Salaudeen Rajack on 3:32 PM Rating: 5
Powered by Blogger.