SharePoint Kings

Visual Web Part in SandBox solution

noreply@blogger.com (SharePoint Kings) — Sun, 19 May 2013 10:57:00 +0000

Hi,

If you are creating a sandbox solution let's say for SharePoint online and if you wish you create a visual web part, then you have no choice for that directly.

However you can still download an extension to your Visual Studio 2010 which will allow you to create a visual web part in sandbox environment.

It is called the VS 2010 SharePoint power tool.

http://visualstudiogallery.msdn.microsoft.com/8e602a8c-6714-4549-9e95-f3700344b0d9

I hope this helps.

Save list as a template and create list from template using PowerShell

noreply@blogger.com (SharePoint Kings) — Thu, 25 Apr 2013 03:01:00 +0000

In this post we are going to see how we can save list as a template that saves it to the list template gallery and then how we can create a new list / library from the template from the saved template earlier.

Here is a simple script that we can write in PowerShell to do that

Here we are saving shared documents library as a template and then creating a library from the saved template.

[xml]$xmlfile = Get-Content ConfigFile.xml

foreach( $sitecoll in $xmlfile.Configuration.SiteCollection)
{
$site = $sitecoll.name
}

$spSite= Get-SPSite $site

$web = $spSite.OpenWeb()

Write-Host -foregroundcolor yellow 'Saving list as a template.....'

$list = $web.GetList("/sites/SharePointSite/Shared Documents/")

$list.SaveAsTemplate("SDWITHDOCSET","SD with DOCSET","Shared Doc with Doc Set",1)

Write-Host -foregroundcolor Green 'Saving list as a template successfully'

Write-Host -foregroundcolor yellow 'Creating documents library from the template...'

$listTemplates = $spSite.GetCustomListTemplates($web)

$web.Lists.Add("SDFromTemplateUsingPS", "", $listTemplates["SD with DOCSET"])

Write-Host -foregroundcolor green 'Creating documents library from the template completed successfully.'

I hope this helps.

Document Set Save as a template problem

noreply@blogger.com (SharePoint Kings) — Mon, 22 Apr 2013 15:34:00 +0000

In this post, we are going to see one problem which is not been addressed properly. I think not even from Microsoft in the form of SP1 or even in the form of CU.

Problem is, you have one document library and you have document set in that library with many other documents inside each document set.

The problem is when you save a library as a template with content and when you create a document library based on the template, you can see that the document sets have come. You can even see the icon indicating that these are the document sets. However when you click on the document set, boom!! page not found.

I did not find answer anywhere. Even if you save a web as a template including content and then try to create a web based on the template, you see a strange thing. In the document library, you will find those document set icon as folders not as a icon of the document sets.

Well only thing that I observed is you go ahead and manually edit the properties of those document sets and change the content type to the document set, that will resolve the issue and when you click , you get the welcome page and documents that were there inside the document set while saving site or list as a template.

But this is not a solution. Imaging you have more than 100 libraries and each having more than 50 document sets with each almost 100 documents inside it. !!! Not sure what Microsoft is thinking on this.

If anyone has come across to this and have found proper solution, please do let us know.

Create document set programmatically

noreply@blogger.com (SharePoint Kings) — Fri, 19 Apr 2013 13:12:00 +0000

In this post we are going to see how to create a document set in SharePoint programmatically.

To start with we need to activate the feature called document set at the site collection level.

If you would like to know more about document set, then I would recommend you reading Understand Document Set to get a fair idea on what document set is and what it offers.

I have one document library with the name Shared Document. To add document set programmatically, we first need to enable the content types on this library. So go to the library settings, advance settings and enable the allow management of content types.

Now click on add from existing content types.

On the page look for document set content type and add it to the library.

So you should have something like this

Now I am showing this with an example of feature activated event. I have one feature and on activating the feature I am creating a document set programmatically.

Here is a code that you need to write.

Now if you see what we have done here is first we have taken document set content type in to a code from current web. This will not work if you have not activated document set feature at a site collection level.

Document set has properties, so we have set one property - document set description. This needs to be done with HashTable.

Then we are creating a document set by DocumentSet.Create method. To get this done you need to add reference to one DLL and for the HashTable you need to one DLL.

These are the DLLs you need to refer.

using System.Collections;

using Microsoft.Office.DocumentManagement.DocumentSets;

After creating Document Set, the important line of code to note is the ProgId of the item to be set to SharePoint.DocumentSet.

If you do not do this, then all you get is just a folder and not actual document set. You can see the difference in the icon as well as when you click on the folder.

Finally we update the item.

So let's deploy the WSP and activate the feature and see what happens.

See the icon. Icon indicates that this is the document set and not the plain folder. Click on the title.

See the description is also set. You can also set additional properties at the time of creating document set.

I hope this helps.

Checking for validation error programatically in InfoPath

noreply@blogger.com (SharePoint Kings) — Thu, 11 Apr 2013 16:16:00 +0000

In case if you are writing a code in button click event of InfoPath page and you would like to validate the required fields input or any other validation, then here is a one liner code that you need to write.

this.errors.count

if the count is 0 that means there is no error, else there are errors.

Happy coding!!

Allocate tasks to users inside group in start approval process in SharePoint Designer

noreply@blogger.com (SharePoint Kings) — Thu, 04 Apr 2013 17:23:00 +0000

In this post we are going to see how we can assign tasks to the users inside start approval process on this item with these users action inside SharePoint designer.

To demonstrate I have one list with one title column and one group name column which has group as well as users settings done.

Let us open the SharePoint Designer and connect to the site. Click on list workflow and select list on which you want to add the workflow.

Select start approval process from the actions menu.

Click on these users.

Select workflow lookup and then from current item, select the field.

Configure this workflow on start automatically on create and on edit

Now go ahead and create one item in the list.

I have added one list item with selecting engineers as a group on which approval will start.

As you can see workflow is in progress.

Click on in progress and as you can see it is assigned to the group and not to the users inside group.

So how to actually allocate tasks to the users inside the group. Well there is a small change.

Go back to the workflow in designer. Select the step and click on advanced properties from ribbon.

And change the expand group to yes.

Publish the workflow now.

Create one more item in the list, click on the in progress status of the workflow. and there you go.

Task is now allocated to the user inside the group. As this approval is set as a serial, go ahead and approve this. You will see the next task allocated to the next user in the group.

I hope this helps.

Display list item in edit mode in InfoPath Form Web Part

noreply@blogger.com (SharePoint Kings) — Tue, 02 Apr 2013 17:56:00 +0000

In this post we are going to see how we can open a list item in edit mode in InfoPath Form Web Part. This initially seems to be an easy job. But it is not.

I really had to invest a lot of time figuring out this solution. What we want to achieve is actually a list form customized using InfoPath by using customize this form in InfoPath ribbon option and then by using the InfoPath form web part we display the form of the list.

I have a list called orders.

and I have used customized the form in InfoPath option from ribbon so that new item, edit item and view item opens up in InfoPath form and not the list form.

If you select the list item and click on edit the item, you can see item is opened in the InfoPath.

Now here comes a tough part. Assume that you want to have another web parts on the page and on the same web part page you would like to have this order list item new entry form to be displayed.

Well, this is not as tough as you think. you can simple add the InfoPath form web part and then set the list name to order and you are good to go.

Once you click on ok, you can see the form has been added on the web part.

Now comes the challenging part, how would you open any list item in the InfoPath Form Web Part. Now again this seems an easy job but it is not as I stated earlier.

I had to go through lot of blog posts and articles. Many of them mentioned that you need to have source list and then bind the connection between InfoPath Form web part and source list so that when you select the source list item, that item gets populated in the InfoPath Form Web Part.

However this is not the solution that we want. We cannot add a source list in our case, orders to the same page and connect these two web part.

There can be a scenario where you are just passing ID of the list item from another page and based on the query string you want to show the edit form in the InfoPath form web part.

So here is a solution that I came out with. But yes if you do not have code option available to you, then you have to go with the connect web part approach. But for that you will have a list also displayed on the same web part page.

All we need to do is create one simple web part (not the visual web part) . add a reference to the c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI\Microsoft.Office.Server.dll DLL.

protected override void CreateChildControls()

{

BrowserFormWebPart web = new BrowserFormWebPart();

web.FormLocation = @"{siteURL}/Lists/Orders/Item/editifs.aspx?List={list GUID}&LItemID={ITEMID}&Source={siteURL}%2FLists%2FOrders%2FAllItems%2Easpx&ContentTypeId=0x01005AFFDCC34451FF46B97FDD902EA436AF";

this.Controls.Add(web);

}

Just replace the List GUID, site URL and ID with the actual list GUID, site URL and list item ID. you can get these through query string or as per your requirement.

Deploy the web part and you are good to go. Now you have a InfoPath Form web part which shows list item in edit mode.

Add web part page using PowerShell

noreply@blogger.com (SharePoint Kings) — Thu, 28 Mar 2013 18:14:00 +0000

Imagine a scenario where you need to create 100 web part pages with different templates. You would spend a lot of time creating those pages. One of the approaches can be having a PowerShell script which can create web part pages for templates that you want.

Here is a simple script that creates web part pages in a loop.

[xml]$xmlfile = Get-Content ConfigFile.xml

foreach( $sitecoll in $xmlfile.Configuration.SiteCollection)

{ $site = $sitecoll.name }

$spSite= Get-SPSite $site

$web = $spSite.OpenWeb()

$layoutTemplate = 4 # Template code

$web = $spSite.OpenWeb()

$list = $web.GetList("/sites/SharePointSite/SitePages/")

$i = 1

while ($i -le 5)

{ Write-Host $pageTitle = "WebPartPage& + $i

$xml = "<?xml version=""1.0"" encoding=""UTF-8""?>

<Method ID=""0,NewWebPage""><SetList Scope=""Request"">" + $list.ID + "</SetList><SetVar Name=""Cmd"">NewWebPage</SetVar><SetVar Name=""ID"">New</SetVar><SetVar Name=""Type"">WebPartPage</SetVar><SetVar Name=""WebPartPageTemplate"">" + $layoutTemplate + "</SetVar><SetVar Name=""Overwrite"">true</SetVar><SetVar Name=""Title"">" + $pageTitle + "</SetVar></Method>"

$result = $web.ProcessBatchData($xml)

$i++

Write-Host -foregroundcolor Green $pageTitle 'created successfully'

}

and when you run here is the output of the script and then final result

If you observe closely here we have specified layouttemplate, we have specified 4. This related to various templates like three column, four columns, headers the template that we select while creating web part page.

Possible LayoutTemplate values are :

# 1 - Full Page, Vertical

# 2 - Header, Footer, 3 Columns

# 3 - Header, Left Column, Body

# 4 - Header, Right Column, Body

# 5 - Header, Footer, 2 Columns, 4 Rows

# 6 - Header, Footer, 4 Columns, Top Row

# 7 - Left Column, Header, Footer, Top Row, 3 Columns

# 8 - Right Column, Header, Footer, Top Row, 3 Columns

Set custom task field value in Start Approval action in SharePoint Designer

noreply@blogger.com (SharePoint Kings) — Thu, 21 Mar 2013 15:57:00 +0000

In this post we are going to see how you can set custom field that is in the task list from the designer when you use Start Approval action.

First take any list into consideration. Open SharePoint Designer 2010, connect to the site. Click on list workflow, select that list and create a workflow, give a name and description. and add start approval process action to designer.

Set it like this.

Now click on Approval. This will take you to the form where you can customize the entire approval process.

We are interested in change the behaviour of single task.

But before moving into this, observe task form fields on right. We need to create one task form field in this. Click on new. If you already have site column defined, you can click on add from site columns.

as you can see it is set to optional.

Now click on change the behavior of single task.

Before you can access task field. Go ahead and publish the workflow.

go to tasks list and list settings. Observe that designer has created a field for you.

Coming back to the designer add set task field to value action.

You will get the WF name field here select WF Name

and set the value to Order WF. Go to the workflow settings screen and select start workflow on create and on edit.

Save and publish the workflow. Go to the orders list and add an item. You can see workflow has started.

Go to task list.

Now if you click on the task title, you can see the WF Name field is shown on the form

go back to designer and go to the customizing approval process.

From the task form fields, set from optional to hidden. Now save and publish the workflow.

Again click on task list item and see that field is not visible on the form now.

I hope this helps.

Create Managed Metadata Site Column in SharePoint 2010

noreply@blogger.com (SharePoint Kings) — Tue, 19 Mar 2013 16:05:00 +0000

In this post we are going to see how we can create a site column that links with the managed meta data.

Creating a site column that holds a value from managed meta data term store is not directly available.

We first need to create a site field which is of type taxonomy and then we need to create one feature which is scoped at site level and in feature activation we access the taxonomy store and set the site column to required term set.

Go to site settings, under site administration click on term store management. I have following settings.

Now let's create one Visual studio project. Select blank project.

Now add SharePoint content type project item.

Choose item content type. This is a sample that I have.

Finally I have something like this.

Now add an event receiver to the site level feature.

What we are doing here is we are first taking reference of the field that we created. Then we take a term store in to the account and then locate the Microsoft group.

After that we take Web Technologies group and then associate this group to our site column.

public override void FeatureActivated(SPFeatureReceiverProperties properties)

{

SPSite site = properties.Feature.Parent as SPSite;

Guid fieldId = new Guid("{B87F6D98-564F-43CA-B4A6-1539A3A3E7C2}");

if (site.RootWeb.Fields.Contains(fieldId))

{

TaxonomySession session = new TaxonomySession(site);

if (session.TermStores.Count != 0)

{

var termStore = session.TermStores["Managed Metadata Service"];

foreach (Group grp in termStore.Groups)

{

if (grp.Name == "Microsoft")

{

var group = grp;

var termSet = group.TermSets["Web Technologies"];

TaxonomyField field = site.RootWeb.Fields[fieldId] as TaxonomyField;

field.SspId = termSet.TermStore.Id;

field.TermSetId = termSet.Id;

field.TargetTemplate = string.Empty;

field.AnchorId = Guid.Empty;

field.Update();

break;

}

Deploy the project.

To check this, go to a task list. go to the list settings and enable the management of content type.

Once enabled, add from existing site content type and add the SPKings content type.

and there you go

I hope this helps.

Set up and configure My Sites in SharePoint 2010

noreply@blogger.com (SharePoint Kings) — Sun, 17 Mar 2013 12:18:00 +0000

In this post, we are going to see how to set up my site in SharePoint 2010. to set up My Sites you need to follow some simple steps.

First it is recommended that you set up a dedicated web application for My site. After this you set up a dedicated site collection under the web application.

So let us go ahead and create one web application and under that create site collection to start with and then we will set up and configure My Site.

so here I have one dedicated site collection under dedicated web application. Make sure that while selecting site collection you select My Site Host as a site template under Enterprise category.

Now by keeping the central administration open, click on the application management, click on manage service application and then click on user profile service application.

Under user profile service, click on set up My Sites.

In my Sites Host URL, enter the site collection URL that we have created for the My Site Host.

In Personal site location, enter personal. You can have this name chosen by yourself. I am keeping it personal.

Now again let us go back to the web applications screen. Click on the My Site web application, and click on manage paths.

In add a new path, enter the path that you would like to append to the URL. Also select the Wildcard including. Wildcard inclusion path is the path under which a separate site collection will be created for each user when they visit for the first time.

So type personal in the path text box and click on add path.

Now we need to enable the self service site creation for our web application.

Go to application management, manage web applications, select our web application. In security group, select self service site creation. Select on.

Now we are good to go with My Sites. Login with any user and then click on My Sites and you should see site getting created.

I hope this helps.

Add managed property to advance search web part

noreply@blogger.com (SharePoint Kings) — Wed, 13 Mar 2013 17:16:00 +0000

If you are using advanced search web part and want to add your own custom property to the properties list, then you can do it very easily.

First you need to have managed property which is mapped with the crawled property. If you would like to know how to get crawled property and how to map the managed property with the crawled property, you can refer

Consider we have one advance search web part and a managed property with us. Go ahead and edit the advance search web part.

Prior adding our department property that we already have , let us see what all things that we can do with advance search web part.

If you remove all which is highlighted in above image, you can see that languages options go away from search.

We also have the document type

If you remove all which is highlighted in below image, you can see that excel and powerpoint document type option go away.

and here is what you get.

Now you should be able to get the results by specifying your custom property. I hope this helps.

Add mapped property to search refinement panel - Part 1

noreply@blogger.com (SharePoint Kings) — Tue, 12 Mar 2013 17:43:00 +0000

In this series I am going to show you how you can add custom property from document library or list to the search refinement panel.

Search refinement panel appears left hand side when you perform a search. If you observe closely, you get to see meta data associated with the result set that is returned from the search query.

First create one web part page with at least three columns by selecting proper web part template. then edit the page and add the web part. Select search category and then add search refinement panel on the left web part zone and search core results web part on center web part zone.

Let's say you have a document library and you search for some word. you find the result in the search results but you would want bifurcate the result based on few meta data properties of the document library, then you need to modify the search refinement panel.

Before diving into this let us have one document library with some meta data properties.

Make sure that you have the values in the field for which you want to create mapped property. Otherwise search will ignore the field and will not generate crawled property. The process is first crawl the content so that you get crawled property generally starts with ows_fieldname and then create mapped property and then use mapped property in the search page.

Coming back to the document library, we have something like this in our hand.

Now go to the central administration. Click on application management. then click on manage service applications and click on search service application. then click on content sources. now full crawl the content source local sites which generally has all the web applications.

Let the full crawl complete.

Now click on the metadata property from the quick launch on the same page. then click on the crawled property.

now search with department which is our column in the document library.

click on ows_department to verify that this is the property that we are looking for. once you click on the property, you actually get to know that where this property has been created from. This way we can be ensure that this is the correct property. On our case we can see that it is from our document library.

Now come back to the screen and click on metadata property and then click on new managed property. Give a name ManagedDepartment , click on add mapping.

now search department , you will get the crawled property and then select ows_department and then click on ok.

Now we need to crawl one more time. Full crawled the content one more time.

Let the crawl complete.

Now come back to the search result web part page. edit the page and then edit the search refinement panel web part.

Make sure that the Use Default configuration is not checked. By default it is checked. If you do not unchecked this then even you do any customization it will not get into the account.

Click on filter category definition. this opens up a text editor where we need to add our custom department property. Add following entry between categories. Make a note that ShowCounts is set to Counts and most importantly threashold value is set to 0. If this is not set to 0 that means in the search result if the property is returned for that many number of times then only department will appear in the search refinement panel. Another attribute to note is the mapped property. this is the name of the managed property that we created earlier.

And this is the result of it. We now have department appearing in the refinement panel and that too with count.

I hope this helps. In next post of this series we will see some more interesting topic for searh refinement panel.

Custom page not found page in SharePoint

noreply@blogger.com (SharePoint Kings) — Thu, 28 Feb 2013 17:53:00 +0000

Though SharePoint is almost very good for maintaining links but still there may be a chance where the link might be broken at any point of time in entire site hierarchy.

You may have any document link on the page and then the document is deleted or a link which points to the page and that page has been moved to some other page or deleted, then user end up navigating to the page not found.

Wouldn't that be nice if a user gets some nice message with some proper image and message.

We can do this by creating custom page for the web application which will act as a custom page not found page.

See what happens when a user tries to navigate to a page which does not exist.

Remember we can set a custom page not found at the web application level. we cannot have that at site or site collection level.

The best way to do this is copy the existing 14\TEMPLATE\LAYOUTS\1033\custom404.html and rename it to another name. Open the page in HTML complaint editor or in Visual Studio and edit the page with image or content as per your choice.

Copy the page at the same location under 1033.

Following is the script that will do this job.

$webapp = Get-SPWebApplication {web application URL}

Write-Host $webapp.Name

$webapp.FileNotFoundPage = "Custom404.html"

$webapp.update($true)

Write-Host $webapp.FileNotFoundPage

So now go ahead and try to open the page from site which does not exist.

You can also set the page not found via feature. Ideally have a web application level feature because this setting is for the web application and cannot be customized for the site collection or the web.

public override void FeatureActivated(SPFeatureReceiverProperties properties)

{

SPWebApplication webApp = properties.Feature.Parent as SPWebApplication;

if (webApp != null)

{

webApp.FileNotFoundPage = "custompagenotfound.html";

webApp.Update(true);

}

I hope this helps.

Change Search result page URL using PowerShell

noreply@blogger.com (SharePoint Kings) — Mon, 25 Feb 2013 16:17:00 +0000

You can change the search result page URL using PowerShell. You may require this depending on configuration you might do at the time of deployment.

All you have to do is use below line in PowerShell script and you are good to go

Now go to site settings page and under site collection administration click on search settings. You will find that your search result page has been changed.

Make sure that you add search refinement panel and search core results web part on the new search result page.

Adding note board web part programmatically in SharePoint 2010

noreply@blogger.com (SharePoint Kings) — Thu, 21 Feb 2013 17:00:00 +0000

If you want to add note board web part by object model, here is a simple way to add it. I have one web part page.

To demonstrate I have added this code in button click.

private void button3_Click(object sender, EventArgs e)

{

using (SPSite site =

new SPSite("{Site URL}"))

{

using (SPWeb web = site.OpenWeb())

{

SPLimitedWebPartManager webPartManager = web.GetLimitedWebPartManager("SitePages/NoteBoard.aspx", System.Web.UI.WebControls.WebParts.PersonalizationScope.Shared);

SocialCommentWebPart noteboardwp =

new SocialCommentWebPart();

webPartManager.AddWebPart(noteboardwp ,

"MiddleZone", 0);

}

and here is what you get out of it

Get choice values of choice column through PowerShell

noreply@blogger.com (SharePoint Kings) — Sat, 16 Feb 2013 16:28:00 +0000

If you have a choice site column or even a field in list , library and want to get the choices values that is present in that field , here is how you can get that.

To demonstrate, I have one site column with name US States which holds US state names.

Let's write PowerShell to get this site column reference and then take out all the choice values in it.

If you would like to know what this PowerShell initial few lines are all about, I would recommend reading Get Values From Configuration post and then continue.

Now run the script

and here is the result. you get each choice value in the choice column.

I hope this helps.

Content type hubs in SharePoint 2010

noreply@blogger.com (SharePoint Kings) — Wed, 13 Feb 2013 17:59:00 +0000

Before getting into the details of content type hub let us take a step back and think why content type hub is introduced and what was available in MOSS 2007.

Let us say you have created a content type in web application 1 and now you need to reuse that content type in web application 2.

so here you do not have any options other than recreating the same content type in another web application 2 when we worked with MOSS 2007.

But now with SharePoint 2010 we can create one specific web application which serves as a content type publisher and other web applications consumes those content types as a consumer from the main web application which is considered as a content type hub.

So content type hub is nothing but a dedicated web application which contains all the content types that want to reuse across many web applications and serves as a hub - the publisher.

Content type hub publishes and other web application consumes.

The advantage is you can make a change in content type at the hub level and you can push down those changes at all the web applications where they are consumed.

Let us see it in action how we can create content type hub and how we can consume it from the web application.

We first need to create web application and top level site which will serve as a publisher content type hub.

Now click on the manage service applications in applications management.

Locate for managed metadata service and click on properties.

Scroll down and enter the site collection URL that you have just created.

Now come back to the previous screen and this time select the managed metadata service connection. This is listed just below the option which you selected earlier and then click on properties again.

and this brings to the screen where you need to select all options.

Now let's get back to the site collection site that we have created earlier - the content type hub site collection.

Open the site in browser, go to the site settings then galleries and sites content types.

Create one content type. I have one content type called order.

Now check for an option manage publishing for this content type on content type settings page.

Publish must have selected by default, click on ok button. as you can see right now last publish date is empty.

You can go back and check the publish date. It must be set this time.

Now we need to move our eye to timer jobs. There are two times jobs of interest.

1) Content Type Hub

2) Content Type Subscribe

Go to monitoring - timer job definition

As you can see you have one content type hub timer job which is for the publisher and you have other subscriber timer jobs for all web applications which can subscribe / consume that hub.

So go ahead and click on hub, click on run now. Click on the respective subscriber for web application from where you want to consume the content type, click on run now.

Again make a note that we are doing this manually only because we want to see the immediate change.

Now let's go to a site collection of consumer web application.

Go to a site settings and then to site content type.

You will see the content types from content type hub appearing here and can be used throughout web application.

Go back to the content type hub, add one more site column. call it price. keep update all content type inheriting from this content type checked.

Now go to the content type settings page. again click on manage publish for this content type. this time you would find republish button. Click on republish.

go ahead and run those two services again.

Go back to the consumer site collection and see that new column is also appearing in the list.

I hope this helps and you now have fair understanding of content type hub.

Send list items to recycle bin

noreply@blogger.com (SharePoint Kings) — Tue, 12 Feb 2013 17:25:00 +0000

Let us see what happens when one deletes the list items. See the example below. I have few task list items.

And see the code below.

execute the code and check recycle bin of the site.

You will not find these deleted list items.

Let's add three more items and this time select three items and remove from the delete option from UI,

now go to the recycle bin and now you can see these three entries.

let's add three more items.

Let's change code a little.

run the code and the go to recycle bin. There you go, now you have the items in recycle bin which was deleted rather recycled programmatically.

Change Document Library folders title through Power Shell

noreply@blogger.com (SharePoint Kings) — Mon, 11 Feb 2013 16:30:00 +0000

In this post we will see how to change the title of the folders in document library.

Here is before running the script.

Here is the script. If you are not aware what is happening in this script, I would recommend reading get value from configuration file post.

[xml]$xmlfile = Get-Content ConfigFile.xml
$site = ''
$web = ''
$listName = 'Shared Documents'
foreach( $sitecoll in $xmlfile.Configuration.SiteCollection)
{
    $site = $sitecoll.name
}
$spSite= Get-SPSite $site
$web = $spSite.OpenWeb()
Write-Host -foregroundcolor Green 'Site URL' $site
$list=$web.Lists.TryGetList($listName)
foreach($folder in $list.Folders)
{
if($folder['Title'] -eq 'Folder1')
{
   $folder['Name'] = 'NewFolder1'
   $folder['Title'] = 'NewFolder1'
   } elseif($folder['Title'] -eq 'Folder2')
{
    $folder['Name'] = 'NewFolder2'
   $folder['Title'] = 'NewFolder2'
}
elseif($folder['Title'] -eq 'Folder3')
{
    $folder['Name'] = 'NewFolder3'
   $folder['Title'] = 'NewFolder3'
}
elseif($folder['Title'] -eq 'Folder4')
{
   $folder['Name'] = 'NewFolder4'
   $folder['Title'] = 'NewFolder4'
}
elseif($folder['Title'] -eq 'Folder5')
{
    $folder['Name'] = 'NewFolder5'
   $folder['Title'] = 'NewFolder5'
}
$folder.update()
}

we are opening the site and then taking the reference of the library and then iterate through all folders of the library and then compare the title of the folder and then change folder properties.

Once you run the script, all folders names and title will be changed.

I hope this helps.

Get template name of SPWeb

noreply@blogger.com (SharePoint Kings) — Thu, 07 Feb 2013 17:02:00 +0000

You may need to get the template type from which the SPWeb has been created. You must be thinking that to get this is really easy, there must be a property which gets us this value.

Well, it is really but there is no direct property. There is one property of SPWeb called WebTemplate. Let's try that.

and the result is

Now change it to this

1033 is for English. You may need to change it depending on the English.

and here we go

I hope this helps

Get values from configuration file in Power Shell script

noreply@blogger.com (SharePoint Kings) — Wed, 06 Feb 2013 17:28:00 +0000

When you write a Power Shell script sometimes you may require to get some parameter values from the configuration file. While deployment usually we need to passing some values from the configuration file.

You can create configuration file and take those values from it to the PowerShell script. Example we may need to create sub sites or lists / libraries or content types etc. To do this you need site URL to be passed to the script.

You may also need to pass in list name with site URL post deployment when the system is in use and later you want to make any changes.

We can create XML file which has data that can be passed to the PowerShell.

Let's create one configuration file.

here we have create one XML file which has top level element as configuration. inside that we have site collection where we have passed one site collection URL.

Let's now create one power shell script and get the value from XML file to the script.

What we have done is we took the xml file reference and then declared one variable in which we will store site URL.

After that we get the value of that specific site collection URL. We have written loop here because you can also define multiple <name> inside <site collection> tag.

As of now we are considering one single site collection.

and then we print the site URL in green color with Write-Host options.

Now open the SharePoint 2010 management shell.

and execute the script by typing ./PowerShellScript.ps1

and here is what you get.

In the same way, you can define as many tags as you like in XML file and can take those values inside the power shell script.

I hope this helps.

Get SharePoint Health Analyzer data programmatically

noreply@blogger.com (SharePoint Kings) — Tue, 05 Feb 2013 17:42:00 +0000

SharePoint health analyzer is a functionality which highlights the problems that are there with the servers in the farm.

As you can see, it highlights as a top notification with view these issues link.

It highlights the problem in different categories like availability, security, performance and configuration.

It also shows if it's the error or it is the warning. If it is the error , it highlights as a red circle with cross in it, if it is warning it shows as a yellow triangle with exclamation mark.

There are certain rules that are already written in Analyzer which can also be enabled or disabled. You can also select should it repair automatically or not. You can also see the schedule defined for that rule. We can also create our own rule and add it here.

When these rules execute, SharePoint health analyzer creates the report and writes it to the list called SPHealthReportsList. This is just a speciall type of list created for the SharePoint health related issues.

The default view for the health issues is set to not to show anything than the severity is not equal to 4 - success.

Now we will have a look on how we can access the information of health report of SharePoint programmatically.

I am showing this as a part of button click, you can write it the way you want.

private void btnHealthAnalyzer_Click(object sender, EventArgs e)

{

try

{

SPHealthReportsList lstHealth = SPHealthReportsList.Local;

if (lstHealth != null)

{

SPQuery queryHealthData = new SPQuery();

queryHealthData.Query =

"<OrderBy><FieldRef Name=\"Created\" /></OrderBy>";

SPListItemCollection healthresults

= lstHealth.GetItems(queryHealthData);

DataTable dt = new DataTable();

dt.Columns.Add(new DataColumn("Title"));

dt.Columns.Add(new DataColumn("Created"));

dt.Columns.Add(new DataColumn("Category"));

dt.Columns.Add(new DataColumn(gtfcvb 3"Remedy"));

dt.Columns.Add(new DataColumn("FailingService"));

dt.Columns.Add(new DataColumn("Severity"));

if(healthresults.Count > 0)

{

foreach (SPListItem item in healthresults)

{

DataRow dr = dt.NewRow();

dr["Title"] = item["Title"];

dr["Created"] = item["Created"];

dr["Category"] = item["Category"];

dr["Remedy"] = item["Remedy"];

dr["FailingService"] = item["Failing Services"];

dr["Severity"] = item["Severity"];

dt.Rows.Add(dr);

}

bindingSource1.DataSource = dt;

dataGridView1.DataSource = bindingSource1;

}

catch (Exception ex)

{

throw ex;

}

and here is the output that you get

I hope this helps.

Get SharePoint Web Application URL and path programmatically

noreply@blogger.com (SharePoint Kings) — Sun, 03 Feb 2013 16:49:00 +0000

Sometimes you may would like to get the URL of the SharePoint web application. Assume that you have a web application created but yet you have not created the site collection.

There may be a case to get the URL and even sometimes the port on which your web application is running programmatically.

You do not get these information directly via SPWebApplication object property. You can get this like shown below.

Hope this helps.

SPFarm returns null

noreply@blogger.com (SharePoint Kings) — Sat, 02 Feb 2013 15:10:00 +0000

Have you ever been into a situation when you have written a code which initiate a SPFarm with simple line of code and when you execute, you get SPFarm as null though you are running windows application on the server itself. What went wrong?

So go to the project properties and check for the build version. When you create a project, there are chances that the project is created in the x86 environment, so go ahead and change it to x64 because SharePoint code cannot run in x86 set up.

Problem must be solved now.