Monday, November 21, 2011

The Importance of SharePoint Workflows

SharePoint Workflow strongly supports the workflow process with the edges and keeps tab of events and gives us information about what is happening. It also helps consumers focus their attention on the slopes, not the smallest details of the procedure. It is vital to understand the process of SharePoint workflow, and basic information about Windows SharePoint Services and Office SharePoint Server.

SharePoint workflow is useful for workers who find it almost impossible to agree with the exact process, not complicate it. SharePoint workflow, it's easier to keep an eye on the many tasks and events, and finally gives an overview for employees on what is less, to be precise, it helps to strengthen these processes. SharePoint development is a must in every growing organization, because it reduces confusion about serious official work time and keeps it without any problems while outsourcing SharePoint development is a prerequisite.

Best of SharePoint Workflow:

SharePoint workflow is best for what it is, because it is a task-based and focuses on focuses on human interface, and not just focused on automated programmatic steps. SharePoint is the best because he shares and documents. So rather than blend in with all possible workflows, employees only need to focus on document-based workflows, as they have been reviewed and amended and approved for publication. So you have to do is to put together a process and manage documents directly to SharePoint.

SharePoint Server 2007 so that it is constructed so that public workflows and to start the approval workflow. Simple steps that require manual force is built into SharePoint Server 2007, which is also useful for non-IT people:

Authorization and Gather Opinion:

It sends a document to "say-so", which can approve or reject or approve, move the approval task, or request changes to the document. It sends the feedback document, which can give their approval views, after which the document was assembled and sent to the owner of the document.

Accumulates Signatures and Disposition Approval

It gathers signatures to complete an Office document that must be performed by an Office client. Moreover, it is at the end of document retention and providing a space for participants to settle on whether to continue to kill the document.

Group Approval:

This is accomplished in the same way that Acceptance work-flow is accomplished but it makes use of a certain file selection which shows in aspect the approval procedure of which a customer is engaging. This work-flow allows the grants to use the press management instead of a signature; this remedy was engineered for the Eastern Oriental Areas which has also anxious its symbol in the delegate SharePoint Progression Indian.

These are one of the processes that are highly useful whilst the SharePoint workflows can also be fashioned with SharePoint Designer, a web design and customization tool which lets you form workflows without having to write any code.

Add icons to document types

When you add a document of unknown type for SharePoint, a neutral document icon appears in the document librairie near the file. Here is the example for a PDF File:

To display a PDF icon as on Windows, the first step is to download the wished picture fromGoogle image for example with a size of 16 x 16 pixels. Store this picture in the folderC:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES on the server.

To reference the picture with the PDF extension, open the file DOCICON.XML located in the folder C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML. Into the section ByExtension, add a line like below:
pdf16.gif should be replaced by the name of your picture previously downloaded.

Restart IIS with the command iisreset.

When reloading the document librairie, the new icon appears:

produce your own features in JQuery

This message is part of the learning jQuery. When I was new to learn jQuery, I was faced with a lot of problems by creating its own jQuery functions. Because I want to create a function in one place and use it throughout the call directly to JqueryObject.function (). When we got the experience, then I started to write your own functions and use jQuery in my projects.

Syntax of how we can create a new function is as below.
jQuery.fn.myownfunction = function() {
var currentObject = $(this) ; //currentObject holds the current object.

Example function for centering an element is shown below. = function () {
this.css("top", ( $(window).height() - this.height() ) / $(window).scrollTop() + "px");
this.css("left", ( $(window).width() - this.width() ) / $(window).scrollLeft() + "px");
return this;

How to call it?

Saturday, November 12, 2011

How to make an actual node around your Xml output

Looking at the example below, I want to create an output that looks like this:

<name>John Smithname>
<name>Steve Hindname>
<name>Da Vinciname>
The FOR XML AUTO just gives me the bit. To wrap it in the element, we have to UNION the root section with the detail row using a FOR XML EXPLICIT clause. The example below is self-explanatory and has been tested on Sql Server 2000.
create table #temp(
field1 int identity(1,1), 
field2 varchar(50), 
field3 varchar(50))
insert into #temp(field2, field3)
select 'Customer', 'John Smith'
insert into #temp(field2, field3)
select 'Customer', 'Steve Hind'
insert into #temp(field2, field3)
select 'Customer', 'Da Vinci'
SELECT 1             as Tag, 
NULL          as Parent,
NULL      as [Customers!1!cid],
NULL       as [Customers!1!name],
NULL          as [Customer!2!id!Element],
NULL          as [Customer!2!type!Element],
NULL          as [Customer!2!name!Element]
SELECT 2 as Tag, 
1 as Parent,
FROM  #temp t

DTC Error in SQL Server

Error Message

Server: Msg 7391, Level 16, State 1, Procedure p_SP1, Line XThe operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].


Here is an excellent explanation from David Adamson’s blog (

reference:   Shailen Sukul

get localeid in SharePoint How?

reference(Shailen Sukul )
Objective: Get the locale id out of the current context.
public int HarvestCurrentLCID(System.Web.HttpContext context)
return (int)Microsoft.SharePoint.WebControls.SPControl.GetContextWeb(context).Language;
int localeID = HarvestCurrentLCID(System.Web.HttpContext.Current);
Keywords: Locale id Localization Termstore Term Termset Label

Sunday, November 6, 2011

Different tips on how to recognize what design is used for the website for SharePoint sites

Hello all, Hope all are doing fine. I believe this is very rarely needed post that we need to know what site template [Publishing site, workspace, meeting workspace, team portal etc..] was used for a particular SharePoint site. From the UI [means by navigating to SharePoint site through browser] we can't identify this. So, we need to follow either of the steps given below to identify the template used for a specific site.
  1. First option is, this is my recommended choice and very easy too. By using SharePoint Manager tool [available for both 2010 9 2007.] Download it for free from Codeplex and install it. Now, open the SharePoint Manager and connect to the SharePoint site collection. When you click on a specific SharePoint site, on the right side it will show you all the properties available in the SP object model for that site. In it find for TemplateID and check the value showing there. That's it. What is TemplateID and how to know template name from it? Navigate to end of this post for TemplateID to Name mapping.
  2. Second option is, if there is no way to install SharePoint manager or if any other problems, then save the current site as site template[.STP extension]. Now, save it to disk somewhere. Now, navigate to that location and rename the file to .CAB extension. Extract the CAB file and find the manifest.xml file. Now, in the file check for the TemplateID string and get the value. Navigate to end of this post for the TemplateID to Name mapping.
  3. From the SP Object Model: Through managed code we can identify this very easily with below code.
    1. using (SPWeb web = site.OpenWeb("/"))  
    2. {     
    3.    string templateID = web.WebTemplateId.ToString();  
    4. }   
  4. Using STSADM.EXE: It needs high level permissions. Means the user should be an administrator on the server. Below is the command we need to use for knowing the site template.
    stsadm.exe -o enumallwebs -database [content database name]
  5. From Sql Server: Sql server has all the information about SharePoint. So, if you have access to database then login to the sql server management studio and execute below query on the content database of the application.
    SELECT Title, WebTemplate FROM dbo.Webs WHERE Title='Test Publishing Site'
Choose one option which is useful or easy for you and identify the correct template.

Site template ID to Name mapping:
0 - GLOBAL (SetupPath=global) - "Global template"
1 - STS - "windows SharePoint Services Site", "Team Site", "Blank Site", "Document Workspace"
2 - MPS - "Basic Meeting Workspace", "Blank Meeting Workspace", "Decision Meeting Workspace", "Social Meeting Workspace", "Multipage Meeting Workspace"
3 - CENTRALADMIN - "Central Admin Site"
4 - WIKI - "Wiki Site"
7 - BDR - "Document Center"
9 - BLOG - "Blog"
20 - SPS (OBSOLETE) - "SharePoint Portal Server Site"
21 - SPSPERS - "SharePoint Portal Server Personal Space"
22 - SPSMSITE - "Personalization Site"
30 - SPSTOC (OBSOLETE) - "Contents area Template"
31 - SPSTOPIC (OBSOLETE) - "Topic area template"
32 - SPSNEWS (OBSOLETE) - "News area template"
33 - SPSNHOME (SubWebOnly) - "News Home template"
34 - SPSSITES - "Site Directory area template"
36 - SPSCOMMU (OBSOLETE) - "Community area template"
38 - SPSREPORTCENTER - "Report Center Site"
39 - CMSPUBLISHING (SetupPath=SiteTemplates\PUBLISHING) - "Publishing and Team Collaboration Site"
40 - OSRV (SetupPath=SiteTemplates\OSRV) - "Shared Services Administration Site"
47 - SPSPORTAL - "Corporate Intranet Site"
50 - SRCHCEN - "Search Center"
51 - PROFILES - "Profiles"
52 - BLANKINTERNETCONTAINER - "Internet Presence Web Site"
53 - BLANKINTERNET - "Publishing Site", "Press Releases Site", "Publishing Site"
54 - SPSMSITEHOST - "My Site Host"
90 - SRCHCENTERLITE (SetupPath=SiteTemplates\SRCHCENTERLITE) - "Search Center Lite"
6221 - PWA (SetupPath=SiteTemplates\PWA) - "Project Web Access Site"
6215 - PWS (SetupPath=SiteTemplates\PWS) - "Project Workspace"
14483 - OFFILE - "Records Repository", "Records Repository"

Thursday, November 3, 2011

Windows PowerShell Command Builder for SharePoint 2010 and Office 365

A very handy Silverlight application has been released on Microsoft TechNet to provide a visual interface for assembling PowerShell commands to be used in SharePoint 2010 products and Office 365.

It uses a drag-and-drop interface to add the verbs and nouns of each cmdlet, and will automatically filter available options depending on which are selected. Once the cmdlet has been chosen, it will display the required and optional parameters associated with it so that you can complete the command.  The example below shows how it can be used to design a Move-SPSite command.

Using the drop-down options available at the top left corner of the interface, cmdlets can be filtered by selecting products SharePoint Foundation 2010, SharePoint Server 2010 or Office 365 and there are also a few scenarios that can be chosen in the “I need to” drop-down – e.g., “Add a user to a domain group”.

You can access the command builder here:  For more information from Microsoft on PowerShell and SharePoint in general, check out the Resource Center here:

How to Start the File Information Section in Ms Expression 2010

 One of the most effortless tips on how to get into or change the meta-data for an Expression file is to use the Document Details Section (DIP). It’s also very possible for a person to unintentionally (or sometimes on purpose) to cover the Document Details Section. To shut the Papers Details Section, simply press on the “X” to shut it as found here.

Ms SharePoint Discussion 2011 Review

We are contemporary off the final result of the Ms SharePoint Discussion 2011 in Anaheim, CA and it was fantastic! The conference presented us with several information, but most popular that SharePoint is increasing, and increasing rapidly! You could see this everywhere, in the quantity of person in attendance produce (~7,500), the variety of creates and periods, the around the world variety of people, and the quantity of sociable events every day time. We recognized going into it that because it was a mid-production period conference that no key announcement would probably be declared and that was quickly obvious in the keynote reviews regarding how this season's style was efficiency. This was included in many of the period issues, whether it was enterprise automated using blend remedies, FAST, or being more successful with the reasoning.

I’ve highlighted what I think were the biggest takeaways from the event. However, I’m sure I am missing some as I was obviously able to neither attend every session nor keep up with the roughly 3 tweets per second for #SPC11.

SQL “Denali” and AlwaysOn, Microsoft’s new solution for SQL Server regarding high availability and disaster recovery for mission critical applications.
Forrester Research Results
Versions Installed
65% now have SharePoint 2010 installed
57% still have SharePoint 2007 installed
11% still on SPS2003 (this number surprised me)
SharePoint Deployment Timeframe
59% able to deploy SharePoint at the pace they expected
Of the other 41%, 59% said it was delayed due internal technical issues, 41% lack of governance, 28% users adopted more slowly

SharePoint Network Topology Diagram Add-In for Visio( released which adds a Visio add-in and timer job to SharePoint to pull farm topology details.

SharePoint 2010 Podcasting Hands On Lab ( – learn how to build your own podcasting site!

A new elite certification called Microsoft Certified Architect (MCA) – ( requires a pre-requisite of Microsoft Certified Master (MCM)

A new elite certification called Microsoft Certified Architect (MCA) – which requires a pre-requisite of Microsoft Certified Master (MCM)

4 times the amount of employees for User Experience currently working on the new version of SharePoint

Updates coming to Office 365, including BCS for remote web services.

Next conference is scheduled for Nov 12-15 in Las Vegas where speculation is that Microsoft will announce the next version of SharePoint

If you have not gone to a discussion in the last, I advocate you go to the next one. This is one of the best options to community with top specialists and obtain information straight from Ms, MCMs, and MVPs. I think next season will be the season for government, blend remedies, and the extended press to the reasoning. Even with SPC11 in the last, we have a lot to look send to!

Number All SharePoint 2010 PowerShell Commands

As a way to expert SharePoint 2010, you will have to get comfy using PowerShell (aka SharePoint 2010 Administration Shell). There are so many requires (or command-lets as they are called) that work together with SharePoint that it creates it nearly extremely hard to consider them all. Use this PowerShell control to result a number of all cmdlets that are discovered within the SharePoint 2010  namespace: