European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Programmatically Create Custom Group in SharePoint?

Sep 27th

Posted by Peter in European SharePoint 2013 Hosting

In this tutorial, i will tell you about how to Programmatically Create Custom Group in SharePoint. You can Create Custom Group in SharePoint Programmatically when the feature is activated. Sometimes we don’t have admin right on server. In this case we need to make request to install our farm solution in the site. But whats about the Group? If you need to maintain 50 groups then we need to go to the custom development where as soon feture is activated the groups are created in the site. Write the following code and will explain you how to add a group in SharePoint Programmatically.

 public override void FeatureActivated(SPFeatureReceiverProperties properties)  
            {  
                using (SPWeb spWeb = SPContext.Current.Site.RootWeb)  
                {  
      
                    try  
                    {  
                        spWeb.SiteGroups.Add("Custom Group", spWeb.CurrentUser, null, "Custom Group Test Description");  
                        
                        SPRoleAssignment spRoleAssignment = new SPRoleAssignment(spWeb.SiteGroups["Custom Group"]);  
                        SPRoleDefinition con = spWeb.RoleDefinitions["Contribute"];  
                        spRoleAssignment.RoleDefinitionBindings.Add(con);                    
                        spWeb.RoleAssignments.Add(asgn);  
                    }  
                    catch (SPException ex)  
                    {  
                        System.Diagnostics.Debug.WriteLine(ex.ToString());  
                    }  
      
                    spWeb.Update();  
                }  
            }

public override void FeatureActivated(SPFeatureReceiverProperties properties)

{

using (SPWeb spWeb = SPContext.Current.Site.RootWeb)

{

try

{

spWeb.SiteGroups.Add("Custom Group", spWeb.CurrentUser, null, "Custom Group Test Description");

SPRoleAssignment spRoleAssignment = new SPRoleAssignment(spWeb.SiteGroups["Custom Group"]);

SPRoleDefinition con = spWeb.RoleDefinitions["Contribute"];

spRoleAssignment.RoleDefinitionBindings.Add(con);

spWeb.RoleAssignments.Add(asgn);

}

catch (SPException ex)

{

System.Diagnostics.Debug.WriteLine(ex.ToString());

}

spWeb.Update();

}

SharePoint 2013 Hosting Recommendation

HostForLIFE.eu’s SharePoint 2013 Hosting solution offers a comprehensive feature set that is easy-to-use for new users, yet powerful enough for the most demanding web developer expert. Hosted SharePoint Foundation 2013 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint 2013 Foundation, you can quickly access and manage documents and information anytime, anywhere though a Web browser in a secure and user friendly way. SharePoint hosting services start at only at €9.99/mo, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint Foundation 2013 plans as well as dedicated SharePoint 2013 Foundation options.

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Check Logged in User is belong to any Type in SharePoint?

Sep 22nd

Posted by Peter in European SharePoint 2013 Hosting

No comments

In this tutorial, i will explain you how to List items where Logged In user has Created List item / Modified List Item / It belong to custom list column. In SharePoint List each column is having internal name. some time column name & its internal name is different.

Created By column – internal name -> Author.
Modified By column – Internal Name -> Editor.

ContactDetails list contains column “AllUser” type -> Person or Group (Allow Multiple Selection = true).

This following code will fetch list records where current user has created list items or modified list items or it belong to “AllUser” group.

List oList = clientContext.Web.Lists.GetByTitle("ContactDetails");  
CamlQuery camlQuery = CamlQuery.CreateAllItemsQuery();  

string UserTilte = "Rupali Shinde";  
string QueryStr = "";  
//Created By  - Internal Name -> Author  
//Modified By - Internal Name -> Editor   
//Check loggedIn User is belog to any of 3 type - Author/Editor/AllUser(user defined column).  
QueryStr = @"<View>" +  
"<Query>" +  
     "<Where>"+  
        "<Or>" +  
            "<Eq>" +  
                "<FieldRef Name='Author'/>" +  
                "<Value Type='User'>" + UserTilte + "</Value>" +  
            "</Eq>"+  
          "<Or> " +  
            "<Contains>" +  
                "<FieldRef Name='AllUser'/>" +  
                "<Value Type='UserMulti'>" + UserTilte + "</Value>" +  
            "</Contains>" +  
            "<Eq>" +  
                "<FieldRef Name='Editor'/>" +  
                "<Value Type='User'>" + UserTilte + "</Value>" +  
            "</Eq>"+  
          "</Or>" +  
       "</Or>" +  
    "</Where>" +  
"</Query>" +  
"</View>";               

camlQuery.ViewXml = string.Format(QueryStr);  

Microsoft.SharePoint.Client.ListItemCollection collListItem = oList.GetItems(camlQuery);  
clientContext.Load(collListItem);  
clientContext.ExecuteQuery();  

int itemcount = collListItem.Count;

List oList = clientContext.Web.Lists.GetByTitle("ContactDetails");

CamlQuery camlQuery = CamlQuery.CreateAllItemsQuery();

string UserTilte = "Rupali Shinde";

string QueryStr = "";

//Created By - Internal Name -> Author

//Modified By - Internal Name -> Editor

//Check loggedIn User is belog to any of 3 type - Author/Editor/AllUser(user defined column).

QueryStr = @"<View>" +

"<Query>" +

"<Where>"+

"<Or>" +

"<Eq>" +

"<FieldRef Name='Author'/>" +

"<Value Type='User'>" + UserTilte + "</Value>" +

"</Eq>"+

"<Or> " +

"<Contains>" +

"<FieldRef Name='AllUser'/>" +

"<Value Type='UserMulti'>" + UserTilte + "</Value>" +

"</Contains>" +

"<Eq>" +

"<FieldRef Name='Editor'/>" +

"<Value Type='User'>" + UserTilte + "</Value>" +

"</Eq>"+

"</Or>" +

"</Where>" +

"</Query>" +

"</View>";

camlQuery.ViewXml = string.Format(QueryStr);

Microsoft.SharePoint.Client.ListItemCollection collListItem = oList.GetItems(camlQuery);

clientContext.Load(collListItem);

clientContext.ExecuteQuery();

int itemcount = collListItem.Count;

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Add Site Columns to Site Content Type on Host Web using JSOM?

Sep 2nd

Posted by Peter in European SharePoint 2013 Hosting

No comments

This code snippet for add Site Columns to Site Content Type on Host Web using JSOM. JSOM is intended for accessing and manipulating SharePoint objects by using JavaScript (JavaScript) in an asynchronous fashion. It is very useful in situations where you want to access SharePoint data or make manipulations to the data after the page has been loaded on the client. JSOM is made up from a set of JavaScript files and can be easily used in any page or Web Part by simply referring to JSOM scripts. In some cases, you may not need to provide any references such as in the case of a page referencing the standard SharePoint 2010 master pages.

As an example, you can use an editor such as a content editor Web Part to access and manipulate SharePoint objects by using JSOM. For instance, SharePoint 2010 uses JSOM extensively for its own usage; an example of this is the new modal dialog introduced in SharePoint 2010. This modal dialog is actually a part of the client-side SP.UI namespace and leverages JSOM to perform common operations.

JSOM provides a comprehensive set of APIs that can be used to perform operations on most SharePoint objects such as Site, Web, List, ContentTypes, User Permission and so forth. The API is simple to use and allows the developer to focus on the business scenario with a minimum amount of infrastructure required. JSOM fully supports JQuery and both can be used in conjunction with the other.

'use strict';  
   
var context = SP.ClientContext.get_current();  
   
var hostWebUrl, hostWebContext;  
   
// This code runs when the DOM is ready and creates a context object which is   
  
// needed to use the SharePoint object model  
   
$(document).ready(function () {  
   
    hostWebUrl = decodeURIComponent(getQueryStringParameter("SPHostUrl"));  
   
    hostWebContext = new SP.AppContextSite(context, hostWebUrl);  
   
});  
   
   
   
// Retrieve a query string value  
   
function getQueryStringParameter(paramToRetrieve) {  
   
    var params = document.URL.split("?")[1].split("&amp;");  
   
    for (var i = 0; i &lt; params.length; i = i + 1) {  
   
        var singleParam = params[i].split("=");  
   
        if (singleParam[0] == paramToRetrieve) return singleParam[1];  
   
    }  
   
}  
   
//Add Site Columns to Content Type  
   
var hostWebContentTypes;  
   
var contentTypeName = 'Employee'; // Name of the Content Type where Colums will be added  
   
var columnsInternalName = ["EmployeeId", "EmployeeName"]; //Internal Names of the Site Columns  
   
var createdColumns = new Array();  
   
function addColumnsToContentType() {  
   
    var hostWeb = hostWebContext.get_web();  
   
    //Get the columns that need to be added to Content type and store the objects in an Array.  
   
    for (var iCreatedFieldsCounter = 0; iCreatedFieldsCounter &lt; columnsInternalName.length; iCreatedFieldsCounter++) {  
   
        createdColumns[iCreatedFieldsCounter] = hostWeb.get_fields().getByInternalNameOrTitle(columnsInternalName[iCreatedFieldsCounter]);  
   
        context.load(createdColumns[iCreatedFieldsCounter]);  
   
    }  
   
    //Get Host Web Content type Collection  
   
    hostWebContentTypes = hostWeb.get_contentTypes();  
   
    context.load(hostWebContentTypes);  
   
    context.executeQueryAsync(  
   
  function () {  
   
      //Call function to add columns to Content Type  
   
      addColumns(contentTypeName, columnsInternalName, createdColumns);  
   
  },  
   
  function onItemsRefetchedFail(sender, args) {  
   
      alert('Failed to fetch columns and Content Type. Error:' + args.get_message() + '\n' + args.get_stackTrace());  
   
  });  
   
}  
   
// Add columns  
   
function addColumns(ctypeName, fieldsInternalName, createdFields) {  
   
    //Find the Content Type and then add Fields to it  
   
    var createdContentType;  
   
    var contentTypeEnumerator = hostWebContentTypes.getEnumerator();  
   
    while (contentTypeEnumerator.moveNext()) {  
   
        var contentType = contentTypeEnumerator.get_current();  
   
        if (contentType.get_name() === ctypeName) {  
   
            createdContentType = contentType;  
   
            var fieldRef = new Array();  
   
            for (var iAddFieldsCounter = 0; iAddFieldsCounter &lt; createdFields.length; iAddFieldsCounter++) {  
   
                fieldRef[iAddFieldsCounter] = new SP.FieldLinkCreationInformation();  
   
                fieldRef[iAddFieldsCounter].set_field(createdFields[iAddFieldsCounter]);  
   
                createdContentType.get_fieldLinks().add(fieldRef[iAddFieldsCounter]);  
   
                createdContentType.update(true);  
   
            }  
   
            context.load(createdContentType);  
   
            context.executeQueryAsync(onAddFieldToContentTypeSuccess, onAddFieldToContentTypeFail);  
   
        }  
   
    }  
   
}  
   
function onAddFieldToContentTypeSuccess() {  
   
    alert('Site Columns added to Content Type.');  
   
}  
   
function onAddFieldToContentTypeFail(sender, args) {  
   
    alert('Failed to add Site Columns to Content Type. Error:' + args.get_message() + '\n' + args.get_stackTrace());  
   
}  
   
//End

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

'use strict';

var context = SP.ClientContext.get_current();

var hostWebUrl, hostWebContext;

// This code runs when the DOM is ready and creates a context object which is

// needed to use the SharePoint object model

$(document).ready(function () {

hostWebUrl = decodeURIComponent(getQueryStringParameter("SPHostUrl"));

hostWebContext = new SP.AppContextSite(context, hostWebUrl);

});

// Retrieve a query string value

function getQueryStringParameter(paramToRetrieve) {

var params = document.URL.split("?")[1].split("&");

for (var i = 0; i < params.length; i = i + 1) {

var singleParam = params[i].split("=");

if (singleParam[0] == paramToRetrieve) return singleParam[1];

}

//Add Site Columns to Content Type

var hostWebContentTypes;

var contentTypeName = 'Employee'; // Name of the Content Type where Colums will be added

var columnsInternalName = ["EmployeeId", "EmployeeName"]; //Internal Names of the Site Columns

var createdColumns = new Array();

function addColumnsToContentType() {

var hostWeb = hostWebContext.get_web();

//Get the columns that need to be added to Content type and store the objects in an Array.

for (var iCreatedFieldsCounter = 0; iCreatedFieldsCounter < columnsInternalName.length; iCreatedFieldsCounter++) {

createdColumns[iCreatedFieldsCounter] = hostWeb.get_fields().getByInternalNameOrTitle(columnsInternalName[iCreatedFieldsCounter]);

context.load(createdColumns[iCreatedFieldsCounter]);

}

//Get Host Web Content type Collection

hostWebContentTypes = hostWeb.get_contentTypes();

context.load(hostWebContentTypes);

context.executeQueryAsync(

function () {

//Call function to add columns to Content Type

addColumns(contentTypeName, columnsInternalName, createdColumns);

function onItemsRefetchedFail(sender, args) {

alert('Failed to fetch columns and Content Type. Error:' + args.get_message() + '\n' + args.get_stackTrace());

});

}

// Add columns

function addColumns(ctypeName, fieldsInternalName, createdFields) {

//Find the Content Type and then add Fields to it

var createdContentType;

var contentTypeEnumerator = hostWebContentTypes.getEnumerator();

while (contentTypeEnumerator.moveNext()) {

var contentType = contentTypeEnumerator.get_current();

if (contentType.get_name() === ctypeName) {

createdContentType = contentType;

var fieldRef = new Array();

for (var iAddFieldsCounter = 0; iAddFieldsCounter < createdFields.length; iAddFieldsCounter++) {

fieldRef[iAddFieldsCounter] = new SP.FieldLinkCreationInformation();

fieldRef[iAddFieldsCounter].set_field(createdFields[iAddFieldsCounter]);

createdContentType.get_fieldLinks().add(fieldRef[iAddFieldsCounter]);

createdContentType.update(true);

}

context.load(createdContentType);

context.executeQueryAsync(onAddFieldToContentTypeSuccess, onAddFieldToContentTypeFail);

}

function onAddFieldToContentTypeSuccess() {

alert('Site Columns added to Content Type.');

}

function onAddFieldToContentTypeFail(sender, args) {

alert('Failed to add Site Columns to Content Type. Error:' + args.get_message() + '\n' + args.get_stackTrace());

}

//End

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Display SpServices with JqGrid in Page Load SharePoint?

Aug 18th

Posted by Peter in European SharePoint 2013 Hosting

No comments

Today I will teach you how to display SPServices getlistitems in JqGrid SharePoint page load event.Here is the code. here my list name is ProjectDetails. Now write the following code:

<head runat="server">  
        <meta name="WebPartPageExpansion" content="full" />  
        <meta http-equiv="X-UA-Compatible" content="IE=10" />  
        <SharePoint:CssRegistration Name="default" runat="server"/>  
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>  
        <style type="text/css" src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/css/ui.jqgrid.css"></style>  
        <link href="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/css/ui.jqgrid.css"></link>  
        <script src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/js/i18n/grid.locale-el.js"></script>  
        <script src="https://cdnjs.cloudflare.com/ajax/libs/jqgrid/4.6.0/js/jquery.jqGrid.min.js"></script>  
        <script src="https://cdnjs.cloudflare.com/ajax/libs/json2/20140204/json2.min.js"></script>  
        <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices-2014.02.min.js"></script>  
        <script></script>  
        <script>  
    $(document).ready(function() {  
    var mydata;  
    var JqData1=[];  
    GetMyData();  
    function ForGettingUserName() {  
      var userName = $().SPServices.SPGetCurrentUser({  
          fieldName : "Title",  
          debug : false  
        });  
      return userName;  
    }  
      
    function GetMyData() {  
    ForGettingUserName();  
      
      sortIdexName = jQuery("#list").getGridParam("sortname"); //Maintaining Consitant SortName after the Sortcol event  
      sortOrderName = jQuery("#list").getGridParam("sortorder"); //Maintaining Consistant Sort Order  
      Query = "  
            <Query>  
                <Where>  
                    <Eq>  
                        <FieldRef Name='ApprovalStatus' />  
                        <Value Type='Text'>Pending</Value>  
                    </Eq>  
                </Where>  
            </Query>";  
      //Query = GetTheOrderByType(sortIdexName, sortOrderName);  
      
      var CAMLViewFields ="  
            <ViewFields>"+"   
                <FieldRef Name='ProjectId' />"+  
      "  
                <FieldRef Name='ProjectName' />  
                <FieldRef Name='DeliveryManager' />  
                <FieldRef Name='ApprovalStatus' />  
            </ViewFields>"  
      GetDataOnLoad(Query, CAMLViewFields);  
    }  
    //Function for Getting the Query Type and the particular WHERE CLAUSE TO send the Query to GetListItem function  
    /*function GetTheOrderByType(index, sortOrder, userName) {
      var OrderByType;
      if (index == "ProjectName") {
        if (sortOrder == "desc") {
          OrderByType = "
            <Query>" +
             + "
                <Where>
                    <Or>" + "
                        <Eq>" + "
                            <FieldRef Name='deliveryManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>" + "
                        </Eq>"
             + "
                        <Eq>
                            <FieldRef Name='projectManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>
                        </Eq>" + "
                    </Or>
                </Where>" +
             + "
                <OrderBy>
                    <FieldRef  Name='projectName' Ascending='FALSE' />
                </OrderBy>" +
             + "
            </Query>";
        } else {
          OrderByType = "
            <Query>" +
             + "
                <Where>
                    <Or>" + "
                        <Eq>" + "
                            <FieldRef Name='deliveryManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>" + "
                        </Eq>"
             + "
                        <Eq>
                            <FieldRef Name='projectManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>
                        </Eq>" + "
                    </Or>
                </Where>" +
             + "
                <OrderBy>
                    <FieldRef  Name='projectName' Ascending='FALSE' />
                </OrderBy>" +
             + "
            </Query>";
        }
      } else if (index == "ApprovalStatus") {
        if (sortOrder == "desc") {
          OrderByType = "
            <Query>" +
             + "
                <Where>
                    <Or>" + "
                        <Eq>" + "
                            <FieldRef Name='deliveryManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>" + "
                        </Eq>"
             + "
                        <Eq>
                            <FieldRef Name='projectManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>
                        </Eq>" + "
                    </Or>
                </Where>" +
             + "
                <OrderBy>
                    <FieldRef  Name='approvalStatus' Ascending='FALSE' />
                </OrderBy>" +
             + "
            </Query>";
        } else {
          OrderByType = "
            <Query>" +
             + "
                <Where>
                    <Or>" + "
                        <Eq>" + "
                            <FieldRef Name='deliveryManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>" + "
                        </Eq>"
             + "
                        <Eq>
                            <FieldRef Name='projectManager'/>
                            <Value Type='Text'>"
             + userName + "</Value>
                        </Eq>" + "
                    </Or>
                </Where>" +
             + "
                <OrderBy>
                    <FieldRef  Name='approvalStatus' Ascending='FALSE' />
                </OrderBy>" +
             + "
            </Query>";
        }
        return OrderByType;
      }
    }*/  
      //This function gets the data from List using SpServices  
      function GetDataOnLoad(Query, CAMLViewFields) {  
        $().SPServices({  
          operation : "GetListItems",  
          async : false,  
          listName : "ProjectDetails",  
          CAMLQuery : Query,  
          CAMLViewFields : CAMLViewFields,  
          completefunc : processResult  
        });  
      }  
      
    //Processing the XML result to formatted Json so that We can bind data to grid in Json format  
    function processResult(xData, status) {  
      var counter = 0; // Gets the total number of records retrieved from the list (We can also use xData.ItemCount method for counting the number of rows in the data )  
      var newJqData = "";  
    alert(xData.responseText);  
      $(xData.responseXML).SPFilterNode("z:row").each(function () {  
      
        var JqData={};  
        if (counter == 0) {  
         JqData.PID= $(this).attr("ows_ID");  
         JqData.PName=$(this).attr("ows_ProjectName");  
         JqData.PManager=$(this).attr("ows_DeliveryManager");  
      JqData.PStatus=$(this).attr("ows_ApprovalStatus");  
          counter = counter + 1;  
        } else {  
          JqData.PID= $(this).attr("ows_ID");  
          JqData.PName=$(this).attr("ows_ProjectName");  
          JqData.PManager=$(this).attr("ows_DeliveryManager");  
      JqData.PStatus=$(this).attr("ows_ApprovalStatus");  
      
          counter = counter + 1;    
          }  
          JqData1.push(JqData);  
      });  
    //];  
     // FinalDataForGrid(newJqData, counter);  
    }  
    /*
    function FinalDataForGrid(jqData, resultCount) {
      dataFromList = jqData;
      //var a;
      var currentValue = jQuery("#list").getGridParam('rowNum');
      var totalPages = Math.ceil(resultCount / currentValue);
      var PageNumber = jQuery("#list").getGridParam("page"); // Current page number selected in the selection box of the JqGrid  //formatting rows
     newStr = "{total:" + '"' + 1 + '"' + "," + "page:" + '"' + 1 + '"' + ","
         + "records:" + '"'
         + resultCount + '"' + ","
         + "rows:"
         + "[" + dataFromList + "]}";
         alert(newStr );
      var a = jQuery("#list")[0];
      a.addJSONData(newStr); //Binding data to the grid which is of JSON Format
     //jQuery("#list").addJSONData(newStr);
    }
    */  
    //var a = jQuery("#list")[0];  
     jQuery("#list").jqGrid({  
      data: JqData1,  
      datatype: "local",  
       height: 150,  
       width:900,  
             hidegrid: false,  
      colNames: ['PID', 'PName','PManager','PStatus'],  
             colModel: [  
                 { name: 'PID', index: 'PID', width: 100, align: "center", sorttype: 'int' },  
                 { name: 'PName', index: 'PName', width: 100, align: "left" },  
                 { name: 'PManager', index: 'PManager', width: 100, align: "left" },  
                 { name: 'PStatus', index: 'PStatus', width: 100, align: "left" }  
                       ],  
      
      pager: true,  
      pager: '#pager',  
      pageinput: true,  
      rowNum: 5,  
      rowList: [5, 10, 20, 50, 100],  
      sortname: 'ApprovalStatus',  
      sortorder: "asc",  
      viewrecords: true,  
      autowidth: true,  
      emptyrecords: "No records to view",  
      loadtext: "Loading..."  
    });  
    jQuery("#list").jqGrid('navGrid', "#pager", { edit: false, add: false, del: false, search: true, refresh: true });  
      
      
    });  
      
        </script>  
    </head>  
    <body>  
        <form id="form1" runat="server">  
            <div id='tblMain' style="float:left;width:600px">  
                <table  id="list" ></table>  
                <div id="pager" style="text-align:center;"></div>  
            </div>  
        </form>  
    </body>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

<SharePoint:CssRegistration Name="default" runat="server"/>

$(document).ready(function() {

var mydata;

var JqData1=[];

GetMyData();

function ForGettingUserName() {

var userName = $().SPServices.SPGetCurrentUser({

fieldName : "Title",

debug : false

});

return userName;

}

function GetMyData() {

ForGettingUserName();

sortIdexName = jQuery("#list").getGridParam("sortname"); //Maintaining Consitant SortName after the Sortcol event

sortOrderName = jQuery("#list").getGridParam("sortorder"); //Maintaining Consistant Sort Order

Query = "

<Query>

<Where>

<Eq>

<Value Type='Text'>Pending</Value>

</Eq>

</Where>

</Query>";

//Query = GetTheOrderByType(sortIdexName, sortOrderName);

var CAMLViewFields ="

<ViewFields>"+"

<FieldRef Name='ProjectId' />"+

</ViewFields>"

GetDataOnLoad(Query, CAMLViewFields);

}

//Function for Getting the Query Type and the particular WHERE CLAUSE TO send the Query to GetListItem function

/*function GetTheOrderByType(index, sortOrder, userName) {

var OrderByType;

if (index == "ProjectName") {

if (sortOrder == "desc") {

OrderByType = "

<Query>" +

+ "

<Where>

<Or>" + "

<Eq>" + "

<Value Type='Text'>"

+ userName + "</Value>" + "

</Eq>"

+ "

<Eq>

<Value Type='Text'>"

+ userName + "</Value>

</Eq>" + "

</Or>

</Where>" +

+ "

</OrderBy>" +

+ "

</Query>";

} else {

OrderByType = "

<Query>" +

+ "

<Where>

<Or>" + "

<Eq>" + "

<Value Type='Text'>"

+ userName + "</Value>" + "

</Eq>"

+ "

<Eq>

<Value Type='Text'>"

+ userName + "</Value>

</Eq>" + "

</Or>

</Where>" +

+ "

</OrderBy>" +

+ "

</Query>";

}

} else if (index == "ApprovalStatus") {

if (sortOrder == "desc") {

OrderByType = "

<Query>" +

+ "

<Where>

<Or>" + "

<Eq>" + "

<Value Type='Text'>"

+ userName + "</Value>" + "

</Eq>"

+ "

<Eq>

<Value Type='Text'>"

+ userName + "</Value>

</Eq>" + "

</Or>

</Where>" +

+ "

</OrderBy>" +

+ "

</Query>";

} else {

OrderByType = "

<Query>" +

+ "

<Where>

<Or>" + "

<Eq>" + "

<Value Type='Text'>"

+ userName + "</Value>" + "

</Eq>"

+ "

<Eq>

<Value Type='Text'>"

+ userName + "</Value>

</Eq>" + "

</Or>

</Where>" +

+ "

</OrderBy>" +

+ "

</Query>";

}

return OrderByType;

}

}*/

//This function gets the data from List using SpServices

function GetDataOnLoad(Query, CAMLViewFields) {

$().SPServices({

operation : "GetListItems",

async : false,

listName : "ProjectDetails",

CAMLQuery : Query,

CAMLViewFields : CAMLViewFields,

completefunc : processResult

});

}

//Processing the XML result to formatted Json so that We can bind data to grid in Json format

function processResult(xData, status) {

var counter = 0; // Gets the total number of records retrieved from the list (We can also use xData.ItemCount method for counting the number of rows in the data )

var newJqData = "";

alert(xData.responseText);

$(xData.responseXML).SPFilterNode("z:row").each(function () {

var JqData={};

if (counter == 0) {

JqData.PID= $(this).attr("ows_ID");

JqData.PName=$(this).attr("ows_ProjectName");

JqData.PManager=$(this).attr("ows_DeliveryManager");

JqData.PStatus=$(this).attr("ows_ApprovalStatus");

counter = counter + 1;

} else {

JqData.PID= $(this).attr("ows_ID");

JqData.PName=$(this).attr("ows_ProjectName");

JqData.PManager=$(this).attr("ows_DeliveryManager");

JqData.PStatus=$(this).attr("ows_ApprovalStatus");

counter = counter + 1;

}

JqData1.push(JqData);

});

//];

// FinalDataForGrid(newJqData, counter);

}

function FinalDataForGrid(jqData, resultCount) {

dataFromList = jqData;

//var a;

var currentValue = jQuery("#list").getGridParam('rowNum');

var totalPages = Math.ceil(resultCount / currentValue);

var PageNumber = jQuery("#list").getGridParam("page"); // Current page number selected in the selection box of the JqGrid //formatting rows

newStr = "{total:" + '"' + 1 + '"' + "," + "page:" + '"' + 1 + '"' + ","

+ "records:" + '"'

+ resultCount + '"' + ","

+ "rows:"

+ "[" + dataFromList + "]}";

alert(newStr );

var a = jQuery("#list")[0];

a.addJSONData(newStr); //Binding data to the grid which is of JSON Format

//jQuery("#list").addJSONData(newStr);

}

//var a = jQuery("#list")[0];

jQuery("#list").jqGrid({

data: JqData1,

datatype: "local",

height: 150,

width:900,

hidegrid: false,

colNames: ['PID', 'PName','PManager','PStatus'],

colModel: [

{ name: 'PID', index: 'PID', width: 100, align: "center", sorttype: 'int' },

{ name: 'PName', index: 'PName', width: 100, align: "left" },

{ name: 'PManager', index: 'PManager', width: 100, align: "left" },

{ name: 'PStatus', index: 'PStatus', width: 100, align: "left" }

pager: true,

pager: '#pager',

pageinput: true,

rowNum: 5,

rowList: [5, 10, 20, 50, 100],

sortname: 'ApprovalStatus',

sortorder: "asc",

viewrecords: true,

autowidth: true,

emptyrecords: "No records to view",

loadtext: "Loading..."

});

jQuery("#list").jqGrid('navGrid', "#pager", { edit: false, add: false, del: false, search: true, refresh: true });

});

</script>

</head>

<body>

</div>

</form>

</body>

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Change SharePoint Site Title Using JavaScript Code?

Aug 9th

Posted by Peter in Other Related Post

No comments

In this tutorial, i will show you how to change SharePoint Site Title Using JavaScript Code. Edit SharePoint Page and insert the script editor:

<script language="javascript" type="text/javascript">  
//Ensure the Client Object Model is ready before you use it  
ExecuteOrDelayUntilScriptLoaded(GetTitle, "sp.js");  

function btnUpdate_onclick()  
{  
    //Update the site's Title property  
    site.set_title(document.getElementById("txtbutton").value);  
    // site.update();  
    site.update();  
    // addd the site to Query queue   
    context.load(site);  
    //Run the Query on the server   
    context.executeQueryAsync(onTitleUpdate, onQueryFailed);  
}  

function onTitleUpdate()  
{  
    alert('Title has been updated');  
    //Refresh the page  
    SP.UI.ModalDialog.RefreshPage(SP.UI.DialogResult.OK);  
}  
var site;  
var context;  

function GetTitle()  
{  
    //Get the current client context  
    context = SP.ClientContext.get_current();  
    //Add the site to query queue   
    site = context.get_web();  
    context.load(site);  
    //Run the query on the server   
    context.executeQueryAsync(onQuerySucceeded, onQueryFailed);  
}  

function onQueryFailed(sender, args)  
{  
    alert('Request failed' + args.get_message() + '\n' + ar.get_stackTrace());  
}  

function onQuerySucceeded(sender, args)  
{  
    document.getElementById("txtbutton").value = site.get_title();  
}  
// ]]>  
</script>  
<p>  
<input id="txtbutton" type="text" />  
</p>  
<p>  
<input id="Button1" type="button" value="button" onclick="return btnUpdate_onclick()" />  
</p>

//Ensure the Client Object Model is ready before you use it

ExecuteOrDelayUntilScriptLoaded(GetTitle, "sp.js");

function btnUpdate_onclick()

{

//Update the site's Title property

site.set_title(document.getElementById("txtbutton").value);

// site.update();

site.update();

// addd the site to Query queue

context.load(site);

//Run the Query on the server

context.executeQueryAsync(onTitleUpdate, onQueryFailed);

}

function onTitleUpdate()

{

alert('Title has been updated');

//Refresh the page

SP.UI.ModalDialog.RefreshPage(SP.UI.DialogResult.OK);

}

var site;

var context;

function GetTitle()

{

//Get the current client context

context = SP.ClientContext.get_current();

//Add the site to query queue

site = context.get_web();

context.load(site);

//Run the query on the server

context.executeQueryAsync(onQuerySucceeded, onQueryFailed);

}

function onQueryFailed(sender, args)

{

alert('Request failed' + args.get_message() + '\n' + ar.get_stackTrace());

}

function onQuerySucceeded(sender, args)

{

document.getElementById("txtbutton").value = site.get_title();

}

// ]]>

</script>

<p>

</p>

<p>

</p>

I hope, it works for you!

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Enable Rating or Likes Settings in SharePoint 2013?

Aug 2nd

Posted by Peter in European SharePoint 2010 Hosting

No comments

In this tutorial, i will tell you about how to Enable Rating or Likes Settings in SharePoint 2013. It was a tough time to find the PowerShell or a C# API to enable or disable Rating/Likes Settings in SharePoint 2013. I found a helpful post from Nanddeep for c# equivalent. I have converted it in PowerShell, hope this will help some of SharePoint developers and admins.

Add-PSSnapin “Microsoft.SharePoint.PowerShell” -ErrorAction SilentlyContinue.

$web=Get-SPWeb "http://abc.com/test";  
$list=$web.Lists["Pages"];  
if($list -ne $null)  
{  
Write-Host $list.Title "not null";  
$assembly=[System.Reflection.Assembly]::Load("Microsoft.SharePoint.Portal, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")  
$reputationHelper =$assembly.GetType("Microsoft.SharePoint.Portal.ReputationHelper");  
 
$bindings = @("EnableReputation", "NonPublic", "Static");  
[System.Reflection.BindingFlags]$flags = [System.Reflection.BindingFlags]::Static -bor [System.Reflection.BindingFlags]::NonPublic;  
 
$methodInfo = $reputationHelper.GetMethod("EnableReputation", $flags);  
 
#For enabling Ratings  
$values = @($list, "Ratings", $false);  
 
#OR for enabling Likes  
#$values = @($list, "Likes", $false);  
 
$methodInfo.Invoke($null, @($values));  
 
#For disable Rating or Likes  
<#$methodInfo = $reputationHelper.GetMethod("DisableReputation", $flags);  
$disableValues = @($list);  
$methodInfo.Invoke($null, @($disableValues));#>  
}

$web=Get-SPWeb "http://abc.com/test";

$list=$web.Lists["Pages"];

if($list -ne $null)

{

Write-Host $list.Title "not null";

$assembly=[System.Reflection.Assembly]::Load("Microsoft.SharePoint.Portal, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")

$reputationHelper =$assembly.GetType("Microsoft.SharePoint.Portal.ReputationHelper");

$bindings = @("EnableReputation", "NonPublic", "Static");

[System.Reflection.BindingFlags]$flags = [System.Reflection.BindingFlags]::Static -bor [System.Reflection.BindingFlags]::NonPublic;

$methodInfo = $reputationHelper.GetMethod("EnableReputation", $flags);

#For enabling Ratings

$values = @($list, "Ratings", $false);

#OR for enabling Likes

#$values = @($list, "Likes", $false);

$methodInfo.Invoke($null, @($values));

#For disable Rating or Likes

<#$methodInfo = $reputationHelper.GetMethod("DisableReputation", $flags);

$disableValues = @($list);

$methodInfo.Invoke($null, @($disableValues));#>

}

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Programmatically Create Custom Group in SharePoint?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Check Logged in User is belong to any Type in SharePoint?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Add Site Columns to Site Content Type on Host Web using JSOM?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Display SpServices with JqGrid in Page Load SharePoint?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Change SharePoint Site Title Using JavaScript Code?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Enable Rating or Likes Settings in SharePoint 2013?

SharePoint 2013 Hosting Recommendation

BLOGROLL

Featured On

European Sharepoint 2013 Hosting Blog

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Programmatically Create Custom Group in SharePoint?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Check Logged in User is belong to any Type in SharePoint?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Add Site Columns to Site Content Type on Host Web using JSOM?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Display SpServices with JqGrid in Page Load SharePoint?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Change SharePoint Site Title Using JavaScript Code?

SharePoint 2013 Hosting Recommendation

SharePoint 2013 Hosting – HostForLIFE.eu :: How to Enable Rating or Likes Settings in SharePoint 2013?

SharePoint 2013 Hosting Recommendation

BLOGROLL

Featured On

Tags