Navish Rampal

SharePoint 2013 App – Accessing SharePoint List

Navish Rampal — Tue, 26 Mar 2013 10:15:08 GMT

If you have created a list inside your SharePoint 2013 App project. Right now there is no direct navigation to the list. Only option available is to navigate directly through url of the list. ie. http://Site Url/App Name/Lists/List Name

Other way to give user access to your list for CRUD operation is by adding XSLT List View Web Part to your page.

In the Defaut.aspx of you App add the below code inside ContentPlaceHolderID="PlaceHolderMain".

<WebPartPages:WebPartZone runat="server" FrameType="TitleBarOnly" ID="dictionaryWebPartZone">

        <WebPartPages:XsltListViewWebPart ID="companyListView"

            runat="server" ListUrl="Lists/AHI-AcronymsStore"

            NoDefaultStyle="TRUE" Title="Company Dictionary"

            Default="False"  PageSize="30"

            ViewContentTypeId="0x">

        </WebPartPages:XsltListViewWebPart>

    </WebPartPages:WebPartZone>

SharePoint 2013 Customizing Suite Bar

Navish Rampal — Thu, 07 Feb 2013 10:43:59 GMT

Before we start customizing the top bar lets get familiar with controls.

The top bar shows:

1. The Branding Title or Logo

2. Suite Bar with Links i.e Newsfeed, SkyDrive, Site

3. Welcome Control

Suite bar is designed as an out-of-the-box delegate control.

Now I will explain adding my own link called Search to the Suite Bar.

1. Create a new SharePoint 2013 empty project named ProjectSuteBarCustomisation. Provide the site url.

2. Add reference to Microsoft.SharePoint.Portal dll

3. Add Feature with scope Farm

4. Add User Control named CustomSuiteBarLinks.ascx.

In the code behind add reference to Microsoft.SharePoint.Portal.WebControls dll.

Change the partial class to inherit from MySuiteLinksUserControl instead of UserControl.

Add the below code in the cs file which override the Render method to add the custom link.

public partial class CustomSuiteBarLinks : MySuiteLinksUserControl
    {
        readonly string linkText = "Search";
        readonly string linkNavigation = "http://bing.com";
        readonly string linkId = "lnkSearchLink";

        protected void Page_Load(object sender, EventArgs e)
        {
        }

        protected override void Render(HtmlTextWriter writer)
        {
            writer.RenderBeginTag(HtmlTextWriterTag.Style);
            writer.Write(".ms-core-suiteLinkList {display: inline-block;}");
            writer.RenderEndTag();
            writer.AddAttribute(HtmlTextWriterAttribute.Class, "ms-core-suiteLinkList");
            writer.RenderBeginTag(HtmlTextWriterTag.Ul);
            RenderSuiteLink(writer, linkNavigation, linkText, linkId, false);
            writer.RenderEndTag();
            base.Render(writer);
        }
    }

5. Add an Empty Element File and name it CustomSuiteLinkDelegate

6. Add the below code to the CustomSuiteLinkDelegate xml file

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
  <Control Id="CustomSuiteLinkDelegate"
  Sequence="90"  ControlSrc="~/_ControlTemplates/15/ProjectSuteBarCustomisation/CustomSuiteBarLinks.ascx" />
</Elements>

7. Deploy the solution.

Processing Xml Data in SQL Server

Navish Rampal — Mon, 16 Jul 2012 11:28:00 GMT

Processing Xml Data in SQL Server.

The below code demonstrates the use of xml data as input and converting xml data into temporary table.

Declare @xmlData xml = '<Root><ParentElement GuidanceKitId="4ffbfee7-0878-4c67-9003-89e0b29b4684" LocaleId="920"></ParentElement><ParentElement GuidanceKitId="d65ddd7d-cb99-e111-96e5-00155d16e526" LocaleId="123"></ParentElement></Root>'

DECLARE @handle INT;

EXEC sp_xml_preparedocument @handle OUTPUT, @xmlData;

        SELECT 

                cast(GuidanceKitId as uniqueidentifier) GuidanceKitId,                                                 

                cast(LocaleId as int) LocaleId,

                5 GuidanceKitRowId -- Constant Column

        INTO #TmpTable

        FROM 

        OPENXML (    @handle    ,'/Root/ParentElement'    ,1    )

        WITH 

        (

                GuidanceKitId uniqueidentifier,                

                LocaleId int

        )R

select * from #TmpTable

Result:

JavaScript Basics

Navish Rampal — Thu, 12 Jul 2012 06:07:39 GMT

Getting Id of the Checkbox in JavaScript

The below code snippet demonstrates toggling : On selecting one checkbox the other checkbox if selected gets unselected and vice-versa.

        1: <script type="text/javascript" language=javascript>

       2:  

       3:     function fn() {

       4:         var checkbox = document.getElementById('<%= cbx1.ClientID %>');

       5:         if (checkbox != null && checkbox.checked == true) {

       6:             var checkbox2 = document.getElementById('<%= cbx2.ClientID %>');

       7:             if (checkbox2 != null && checkbox.checked == true) {

       8:                 checkbox2.checked = false;

       9:             }

      10:         }

      11:     }

      12:  

      13:     function fn2() {

      14:         var checkbox = document.getElementById('<%= cbx2.ClientID %>');

      15:         if (checkbox != null && checkbox.checked == true) {

      16:             var checkbox2 = document.getElementById('<%= cbx1.ClientID %>');

      17:             if (checkbox2 != null && checkbox.checked == true) {

      18:                 checkbox2.checked = false;

      19:             }

      20:         }

      21:     }

      22:  

      23: </script>

      24:  

      25: <asp:CheckBox ID="cbx1" onclick="fn()" runat="server" />

      26: <asp:CheckBox ID="cbx2" onclick="fn2()" runat="server" />

Enabling Win 7 Desktop Experience on Windows Server 2008

Navish Rampal — Thu, 31 May 2012 18:34:13 GMT

The below steps explain enabling Win 7 look and feel on Windows Server 2008.

Step 1:

Go to Start Button –> Right click on Computer –> Click on Properties –> Click on Advanced System Settings on right side.

System Properties window will open. On Advanced Tab click on Settings button for Performance category.

Select the radio button for the Option “Adjust for best appearance” and click Ok.

Step 2:

Go to Server Manager –> Select Feature –> Click on Add Features

Enable the Desktop Experience Option by Selecting the check box. After selecting click next and then the install button.

Step 3:

Open the run window and type Services.msc. This opens the services window. Navigate to Themes service. Double click on it. Set the Start Type Option to Automatic and Start the Service.

Step 4:

You are ready to use Windows 7 Themes. Right Click on Desktop and click Personalize.

Select Aero Themes. More themes can be downloaded from http://windows.microsoft.com/en-us/windows/downloads/personalize/themes.

del.icio.us Tags: Destop Experience

SharePoint Site Provisioning with SharePoint Object Model

Navish Rampal — Wed, 16 May 2012 15:58:00 GMT

The below code can be re-used as is for creating any number of Site Collections and Sub sites.

The code is provided for two of the scenarios:

Case 1: Creating Site Collection and Sub Sites Inside It

Case 2: Adding Sub Site to already existing Site Collection/Sub Site

Step 1: Microsoft.SharePoint DLL should be added in the References Folder

Step 2:

Add the reference of below Classes:

using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

Step 3:

Case 1: Code to Create Site Collection and Sub Sites inside it.

Any number of Site Collection and Sub sites can be created on putting the below code in a loop.

The below sample code will create one site collection and one sub site inside it.

try 
 { 
 
 SPSecurity.RunWithElevatedPrivileges( 
 delegate 
 { 
 // Provide the Web Application URL under which all site collection and sub sites needs to be provisioned 
 string webApplicationUrl = "http://hpsweb:3030/"; 
 
 /* --------------------------------------------------------------------------------------- */ 
 // For Creating HR Site Collection 
 
 string relativeUrl = "/sites/hr"; 
 string siteTitle = "HR Site"; 
 string siteDescription = "WElcome to HR Site Collection"; 
 uint languageCode = 1033; // 1033 is the code for english 
 string siteTemplate = "BLANKINTERNET#0"; 
 string primaryAdmin = @"Hpsintegration\Administrator"; // Domain followed by Network Id/Alias 
 string secondaryAdmin = @"Hpsintegration\Administrator2"; //Domain followed by Network Id/Alias. If Secondary Admin is not required then assign Null 
 
 /* --------------------------------------------------------------------------------------- */ 
 
 
 SPWebApplication objWebApplication = SPWebApplication.Lookup(new Uri(webApplicationUrl)); 
 
 using (SPSite mySiteCollection = objWebApplication.Sites.Add(relativeUrl, siteTitle, siteDescription, languageCode, siteTemplate, primaryAdmin, string.Empty, string.Empty, secondaryAdmin, string.Empty, string.Empty)) 
 { 
 /* --------------------------------------------------------------------------------------- */ 
 // For Creating Benifits Sub Site inside HR Site Collection 
 
 string subSiteTitle = "Benifits"; 
 string subSiteDescription = "Employee Benifits"; 
 string subSiteRelativeUrl = "/sites/hr/benifits"; // Benifits Sub Site will get added to the HR site collection 
 
 /* --------------------------------------------------------------------------------------- */ 
 
 using (SPWeb web = mySiteCollection.AllWebs.Add(subSiteRelativeUrl, subSiteTitle, subSiteDescription, languageCode, siteTemplate, false, false)) ; 
 
 } 
 }); 
 } 
 catch (Exception ex) 
 { 
 }

Step 3:

Case 2: Code to Create a Site inside a Site Collection

Any number of Sub sites can be added by putting the below code in a loop.

The below sample code will create one sub site inside a site collection. Pre requisite: Site Collection should exist under which sub site needs to be added.

 try 
 { 
 
 SPSecurity.RunWithElevatedPrivileges( 
 delegate 
 { 
 string webApplicationUrl = "http://hpsweb:3030/"; // Web Application URL 
 string parentSiteUrl = "/sites/hr"; // URL under which to create sub site 
 
 string requestSiteUrl = "/sites/hr/compensation"; // New sub site to add 
 string siteTitle = "Compensation"; 
 string siteDescription = "Compensation Details"; 
 uint languageCode = 1033; // 1033 is the code for english 
 string siteTemplate = "BLANKINTERNET#0"; 
 
 parentSiteUrl = parentSiteUrl.TrimStart('/'); 
 string requestUrl = String.Concat(webApplicationUrl, parentSiteUrl); 
 
 using (SPSite objSiteCollection = new SPSite(requestUrl)) 
 { 
 using (SPWeb web = objSiteCollection.AllWebs.Add(requestSiteUrl, siteTitle, siteDescription, languageCode, siteTemplate, false, false)); 
 } 
 }); 
 } 
 catch 
 { 
 throw; 
 }

Information Rights Management (IRM): There was a problem when trying to find the enterprise Rights Management Services (RMS) server

Navish Rampal — Tue, 07 Feb 2012 14:31:00 GMT

We had a data migration project where we had to migrate the data from Documentum to SharePoint. During content uploading (documents) to the Document Library an error used to get logged in ULS logs with the below details:

"Information Rights Management (IRM): There was a problem when trying to find the enterprise Rights Management Services (RMS) server. There was no enterprise server registered. Additional Data Service Type: 1 Error value: 0x509fd0"

On analysis I found that whenever we try to upload a document which is rights-protected this exception gets raised in spite of document getting uploaded successfully. On uploading Windows SharePoint Services 3.0 tries to access the Rights Management Server and if it is not able to connect to the Server the exception gets logged into the ULS log file.

To check IRM settings in Central Administration

In Central Administration, on the top navigation bar, click Operations.
On the Operations page, in the Security Configuration section, click Information Rights Management.
On the Information Rights Management page, perform one of the following steps:
- If the RMS server in Active Directory, verify that Use the default RMS server specified in Active Directory is selected.
- If you are manually specifying the location of the RMS server, verify that Use this RMS server is selected and that the URL specified for the RMS server that you want to use is correct.

Once the IRM configuration is done this error gets resolved.

To enable "Show Tool Bar" option in Document Web Part through Code

Navish Rampal — Thu, 15 Dec 2011 17:38:00 GMT

I am going to explain a scenario where I had an OOB Document Web Part in one of my page and from code i had to enable the "Show Tool Bar" for that Web Part.

The scenario can be achieved through reflection. The code is given below.

splist -> The Document Library List

webpartID -> Id of the Document Web Part added to the page

private static void SetToolbar(SPList splist, string webpartID) 
{ 
 SPWeb web = splist.ParentWeb; 
 SPLimitedWebPartManager manager = web.GetLimitedWebPartManager("default.aspx", System.Web.UI.WebControls.WebParts.PersonalizationScope.Shared); 
 SPLimitedWebPartCollection webPartColl = manager.WebParts; 
 XsltListViewWebPart wp = webPartColl[webpartID] as XsltListViewWebPart; 
 
 if (wp != null) 
 { 
 MethodInfo ensureViewMethod = wp.GetType().GetMethod("EnsureView", BindingFlags.Instance | BindingFlags.NonPublic); 
 object[] ensureViewParams = { }; 
 ensureViewMethod.Invoke(wp, ensureViewParams); 
 FieldInfo viewFieldInfo = wp.GetType().GetField("view", BindingFlags.NonPublic | BindingFlags.Instance); 
 SPView view = viewFieldInfo.GetValue(wp) as SPView; 
 Type[] toolbarMethodParamTypes = { Type.GetType("System.String") }; 
 MethodInfo setToolbarTypeMethod = view.GetType().GetMethod("SetToolbarType", BindingFlags.Instance | BindingFlags.NonPublic, null, toolbarMethodParamTypes, null); 
 object[] setToolbarParam = { "ShowToolbar" }; 
 setToolbarTypeMethod.Invoke(view, setToolbarParam); 
 view.Update(); 
 } 
 }

Folders ending with “_files” not getting created in SharePoint, Thicket

Navish Rampal — Tue, 15 Nov 2011 18:34:00 GMT

I came across a problem few days back where I was not able to create Folders ending with _files and with the name Forms.

i.e image_files, Research_files

This is by design in SharePoint due to thicket. A thicket is what you get when you save a file as an HTM that contains content such as graphics. To store the additional content, which can not exist in the HTM file, the application creates a linked folder. It names the linked folder, filename_files. When a thicket is created in SharePoint site it is always hidden.

To avoid the confusion of thicket getting mixed with the user created folder SharePoint does not allow the folder to get created and instead replace an underscore after the folder name when creating manually i.e image_files_ . While creating the folder with Object Model it throws an exception

Forms is also a hidden folder in Sharepoint so does not allow to create it at the root level.

Regular expression to get all the link tags and there value from a string

Navish Rampal — Thu, 29 Sep 2011 11:16:52 GMT

hrefLink = "This text will have html + text + a link attribute "; \\ The below code will get you the content from <a> till </a>.

MatchCollection m = Regex.Matches(hrefLink, @"(<a.*?>.*?</a>)",RegexOptions.Singleline);

foreach(Match m1 in m){string value = m1.Groups[1].Value;}