Learn sharepoint in easy way

Web Analytic Reports in SharePoint 2013

2013-06-05T14:29:00.003-07:00

In SharePoint 2010 we could get Web Analytic reports from the site settings menu, as shown in the screenshot below:

These reports provides statistics about resources used by the site collection that can be useful for Site Administrators and Operators as in the following:

In SharePoint 2013 Microsoft has chosen to remove this from the Site Settings menu. And this feature has been deprecated from everywhere it existed. Instead of Analytics Reports we now have Popularity Trends as in the following:

I have made a note of the URL of the SharePoint 2010 analytics report and simply pasted the "/_layouts/usage.aspx" part in after the SharePoint 2013 site in the URL field. And voila, it works.

One thing you need to do is to enable usage of the logging service in your SharePoint farm. Here is a link to do that: http://technet.microsoft.com/en-us/library/ee663480.aspx#section1.

PowerView Report Increase font size and change the font

2013-04-30T13:41:00.004-07:00

I spent a whole lot of time changing the font inside power view report and was not able to change it.

After googling about Power View Report I came to know that I can not change the font inside a powerview but I can use a theme which has the same font that I wish to change it to. So I changed the theme and able to Modify the font.

After that I tried to increase the text size from 100% to 125% , save the report and close the report. When I reopened it the text size is still 100%. So basically text size isn't getting saved :(. After hit and trial I went to the design tab instead of powerview tab and I found increase text size and decrease font size icon. I increased the font size and saved the report. When I reopened it the change in font size got reflected in the report.

So basically

You should change the theme to get desired font.
You increase the text size from the design tab.

Exploring Sharepoint 2013

2013-04-29T08:11:00.002-07:00

Now a days I am spending a lot of time on learning sharepoint 2013.

I have enrolled myself in pluralsight and it was really a worth decision made by me. I sincerely advise other fellows to please have a look into it as this is the best training site to learn easy way. All the speakers are very much highly excelled in their respective field and they almost update the contents every week so you always be updated with latest technology.

Anyways I am on my way to learning SP2013 and I personally found it really interesting. I will try to post new things here that i am learning each day.

creating custom code snippets in sharepoint designer 2007

2011-04-04T05:05:00.000-07:00

This video describes creating custom code snippets in sharepoint designer 2007 and also give some shortcuts that can be used in designer while creating page layouts from an existing master page.

Intranet developed in sharepoint

2011-04-04T04:45:00.001-07:00

I like this video a lot.Here they explain the hudson intranet in details and also it will be useful for u when u r going design a website for ur client giving them the ways to achieve a great design.

Here is another one video infact part-2 of the video series.

Hope u ll enjoy watching the videos.....:)

Workflow in Moss 2007-Sending email tips

2010-12-29T07:32:00.000-08:00

This is what i learned today about Work flow in Moss 2007.In our project we have a requirement of sending email after a particular step in the work flow.

I tried writing down simple texts and look up in the email body.

To my surprise when the work flow executes and email is send to the assigned person,the mail goes to the junk folder of the mailbox.

But when i use HTML format in the mail body,the mail goes to the desired person mailbox instead of junk folder.So the conclusion is always use HTML format in the body of the email while working with Custom work flow in sharepoint designer 2007.

How to set Item Level Permission for SharePoint 2007 (MOSS/WSS) List/Document Library Programmatically

2010-12-25T08:06:00.000-08:00

Here is a piece of code (a function) to set Item Level Permission. You can use it as a Web Method in a custom Web Service. This method can be used from Applications outside of SharePoint, provided the user using this application has sufficient privilege to update lists/libraries etc.

public string ItemPermission(string SitePath)

{

string ReturnVal = "";

try

{

SPSite WebApp = new SPSite(SitePath);

SPWeb Site = WebApp.OpenWeb();

SPList list = Site.Lists["TestDocLib"];

SPListItem item = list.Items[0];

SPRoleDefinition RoleDefinition = Site.RoleDefinitions.GetByType(SPRoleType.Contributor);

SPRoleAssignment RoleAssignment = new SPRoleAssignment("<domain>\\<user>", "email", "name", "notes");

RoleAssignment.RoleDefinitionBindings.Add(RoleDefinition);

if(!item.HasUniqueRoleAssignments)

{

item.BreakRoleInheritance(true);

}

item.RoleAssignments.Add(RoleAssignment);

item.Update();

}

catch (Exception ex)

{

ReturnVal += "Permission not set, reason: " + ex.Message;

}

return ReturnVal;

}

Requirement:

I have a list and have made settings wherein the user can edit only the items created by them and read others data. Now if a person leaves the company all the data created by he/she will become read only to others. There is no apparent OOB way to give permission to any other user to those items at one go. But we can use custom coding and special ability of SharePoint 2007 to set Item level permission for this requirement.

I have created a Custom Web Service to do the trick (From here you will get information about how to implement this web service in SharePoint). And there is a console application to pass the parameters to the Web Service’s web method. You can replace this console app with Windows/Web Form, Web Part etc. Or you can create a custom workflow which will get activated when any user is removed and will call the web service.

Here is the code for the web service:

===================================================

using System;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using Microsoft.SharePoint;

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class Service : System.Web.Services.WebService

{

public Service () {

//Uncomment the following line if using designed components

//InitializeComponent();

}

[WebMethod]

public string ItemPermission(string SitePath, string LibName, string OldUser, string NewUser,string email, string name)

{

string ReturnVal = "";

try

{

SPSite WebApp = new SPSite(SitePath);

SPWeb Site = WebApp.OpenWeb();

SPList list = Site.Lists[LibName];

SPQuery newSPQuery = new SPQuery();

newSPQuery.Query = "<Where><Eq><FieldRef Name=\"Author\"/><Value Type=\"User\">" + OldUser + "</Value></Eq></Where>";

SPListItemCollection listItemCol = list.GetItems(newSPQuery);

if (listItemCol.Count > 0)

{

foreach (SPListItem item in listItemCol)

{

SPRoleDefinition RoleDefinition = Site.RoleDefinitions.GetByType(SPRoleType.Contributor);

SPRoleAssignment RoleAssignment = new SPRoleAssignment(NewUser, email, name, "notes");

RoleAssignment.RoleDefinitionBindings.Add(RoleDefinition);

if (!item.HasUniqueRoleAssignments)

{

item.BreakRoleInheritance(true);

}

item.RoleAssignments.Add(RoleAssignment);

item.Update();

}

catch (Exception ex)

{

ReturnVal += "Permission not set, reason: " + ex.Message;

}

return ReturnVal;

}

===================================================

Here is the code for console application:

Replace the following things:

<sitepath> with the Full URL of the site

<libname> with the list/library name

<domain> with the domain name

<olduser> with the userid who left the company

<newuser> with the userid to whom you want to give permission

<email of new user> self explaning

<name of new user> self explaning

If "<domain>\\<olduser>" does not work try to use the old user’s full name such as “John Smith”.

=====================================================

using System;

using System.Collections.Generic;

using System.Text;

namespace ConsoleApplication1

{

class Program

{

//localhost.Service newService;

static void Main(string[] args)

{

localhost.Service newService = new localhost.Service();

newService.UseDefaultCredentials = true; //I am assuming an administrator/power user is running this app or use a specific credential here

string output = newService.ItemPermission("<sitepath>", "<libname>", "<domain>\\<olduser>", "<domain>\\<newuser>", "<email of new user>", "<name of new user>");

Console.WriteLine(output);

Console.ReadLine();

}

Source:msdn

Most Common Terms in SharePoint

2010-12-04T23:17:00.001-08:00

Farm – collection of servers that act together to provide a set of Web applications. The farm is most easily defined by the configuration database which defines the server member and roles of the farm as well as database servers used for storage.

Web application – In a SharePoint deployment contains IIS Web Sites previously known as IIS Virtual Servers that have been extended with SharePoint Server and have been set up to use the .NET assemblies to provide the SharePoint Application. There are content Web applications, and administration Web applications for both the central admin and the SSP admin. Web applications are known for their ability to isolate content in separate memory space with application pools which contain worker processes. In a collaboration service the Web application provides the container for the site collections in the farm.

Site Collection – A site collection is the most scalable unit in a SharePoint deployment and is a container for sites. The special properties of the site collection are the ability to have a quota, contain a global navigation, masterpage, and various galleries provided across the sites below it, and the ability to contain ownership. Considered the most scalable object in a deployment and the easiest to manage for its ability to be backed up and moved full fidelity across databases.

Site – a container of multiple lists which can inherit security, and leverage the galleries of the site collection above it. Primarily usage in a collaboration environment is for delegation of projects or to divide up content for easy navigation.

Portal – A special site template designed to host many sites below it. Common properties include special page galleries for Internet, or site directory on an Intranet portal. Another term might be hub based on navigation and a common place to go where you don’t know where to look for something. It’s the top of the breadcrumb navigation.

Splitting of content database

2010-12-02T10:03:00.000-08:00

FYI The recommended size for a Content Database in SharePoint 2007 is: 100 GB

case study:
The Size of content Database of intranet site is 450 GB, with this content database size XYZ is facing issues in managing such a huge database.So in this case we have to split the content database.

One solution may be like this :

If there is only one Site Collection in the Content DB which consumes 450 GB then it's not possible to split the content Database but we have to tweak with subsites.

If SiteCollection count >1 then we can move the Data of some selected site collections to another Content DB.

Add new content database (demo_content_2) from Central Administration àApplication Management à Content Databases to the existing Webapplication as shown below:

From the above screenshot the delta for demo_content_1 is (500 – 3 = 497) and the delta for demo_content_2 is (500 – 0 = 500). The larger the delta is determines where your site goes. So the next site collection created will go into demo_content_2.

To perform the move of SiteCollections use the following 3 commands:

stsadm -o backup -url http://demo/sites/test2 -filename e:\test2.bak

stsadm -o deletesite -url http://demo/sites/test2

stsadm -o restore -url http://demo/sites/test2 -filename e:\test2.bak

If we refresh the content database page we can see that sitecollection has been moved to demo_content_2.

To perform the move of subsites use the following 3 Commands:

stsadm -o export -url http://<path_to_site> -filename c:\<exportedSite>.cmp -overwrite -nofilecompression -includeusersecurity -cabsize 1024

Delete the subsite via SharePoint UI or stsadm command

stsadm -o import –url http://<path_to_site> -filename c:\<location_of_your_exorted_package>.cmp -nofilecompression -haltonfatalerror –includeusersecurity”

Now the sub-site would be created in new content database demo_content_2.

Note: A subsite has to be restored to a subsite only but not to a sitecollection.

First things first

2010-12-02T09:06:00.000-08:00

There are 3 things which are most important for a sharepoint developer and those are

1)Site Columns
2)Content types
3)Workflow

With increased demand of sharepoint everybody should have a basic idea about sharepoint.
SPS 2003 was the first portal server,then comes MOSS 2007 with office integration and now SP 2010 most improved product of its type.