European Sharepoint 2013 Hosting Blog
Articles about European Sharepoint Hosting Service
SharePoint 2013 Hosting – HostForLIFE.eu :: How to Display SpServices with JqGrid in Page Load SharePoint?
Aug 18th
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 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 |
<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> |
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 Change SharePoint Site Title Using JavaScript Code?
Aug 9th
In this tutorial, i will show you how to change SharePoint Site Title Using JavaScript Code. Edit SharePoint Page and insert the script editor:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
<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> |
I hope, it works for you!
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 Enable Rating or Likes Settings in SharePoint 2013?
Aug 2nd
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.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
$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 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 :: Remove List Items CSOM SharePoint Online
Jul 26th
Today, we will show you how to remove all items of the list using Client Object Model with PowerShell script for Office 365 sites. When you have more items to delete, we can go for batch delete. I would like to highlight programmatically when we delete list items, those are not moved to the Recycle Bin for the site.
First, Please find the below code. Hope this will help.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
cls Add-Type-Path"E:\PSDLL\Microsoft.SharePoint.Client.dll" Add-Type-Path"E:\PSDLL\Microsoft.SharePoint.Client.Runtime.dll" $0=$MyInvocation.MyCommand.Definition $dp0=[System.IO.Path]::GetDirectoryName($0) $url="https://test.sharepoint.com/sites/test/" $username="abc@microsofttest.com" $password="*****" $securePassword=ConvertTo-SecureString$password-AsPlainText-Force #connect/authenticate to sharepoint online and get ClientContext object... $clientContext=New-ObjectMicrosoft.SharePoint.Client.ClientContext($url) $credentials=New-ObjectMicrosoft.SharePoint.Client.SharePointOnlineCredentials($username,$securePassword) $clientContext.Credentials=$credentials if(!$clientContext.ServerObjectIsNull.Value) { $web=$clientContext.Site.RootWeb $clientContext.Load($web) $clientContext.ExecuteQuery() $list=$clientContext.Web.Lists.GetByTitle('TestList') $clientContext.Load($list) $clientContext.ExecuteQuery() $query=New-ObjectMicrosoft.SharePoint.Client.CamlQuery $query.ViewXml="<View><RowLimit>1000</RowLimit></View>" $items=$list.GetItems($query) $clientContext.Load($items) $clientContext.ExecuteQuery() if ($items.Count-gt0) { for ($i=$items.Count-1; $i-ge0; $i--) { $items[$i].DeleteObject() } $clientContext.ExecuteQuery() } } |
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 Get SharePoint Local Server Admins?
Jul 13th
In this post, I will tell you about Get SharePoint Local Server Admins. Two sets of users are allowed to perform administrative functions for Microsoft : members of the administrators group for the local server computer and members of the SharePoint administration group. The SharePoint administration group is a Microsoft Windows domain group that is registered with . Members of this domain group can perform Central Administration tasks without having to be given administrator rights to the local server computer. And here is the script to list out the SharePoint local server administrators.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null ) { Add-PSSnapin Microsoft.SharePoint.Powershell } $scriptBase = split-path $SCRIPT:MyInvocation.MyCommand.Path -parent Set-Location $scriptBase $global:timerServiceName = "SharePoint 2010 Timer" $global:timerServiceInstanceName = "Microsoft SharePoint Foundation Timer" # Get the local farm instance [Microsoft.SharePoint.Administration.SPFarm]$farm = [Microsoft.SharePoint.Administration.SPFarm]::get_Local() Function GetServerAdministrators([Microsoft.SharePoint.Administration.SPFarm]$farm) { write-host "" write-host "Preparing to collect SP server administrator details" -fore magenta $output = $scriptbase + "\" + "ServerAdminDetails.csv" "ServerName" + "," + "AdminMember" | Out-File -Encoding Default -FilePath $Output; foreach($server in $farm.Servers) { foreach($instance in $server.ServiceInstances) { if($instance.TypeName -eq $timerServiceInstanceName) { [string]$serverName = $server.Name write-host "Collecting administrator details for the server " $servername -fore yellow $admins = invoke-command {net localgroup administrators | where {$_ -AND $_ -notmatch "command completed successfully"} | select -skip 4} -computer $serverName foreach($admin in $admins) { write-host $admin " is member of administrator group in server " $serverName -fore cyan $serverName + "," + $admin | Out-File -Encoding Default -Append -FilePath $Output; } write-host "Administrator details for the server " $serverName " has been collected" -fore green } } } Write-host "Administrator details collected for all the SP servers in the farm" -fore green } GetServerAdministrators |
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 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint, 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/month, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint plans as well as dedicated SharePoint options
SharePoint 2013 Hosting – HostForLIFE.eu :: How to Publish All Page Properties from a Site?
Jun 28th
In this article, I will show you how to Publish All Page Properties from a Site with PowerShell in SharePoint 2013. This following code snippet for PowerShell to get all publishing page properties from a site.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
if ($ver.Version.Major - gt 1) { $Host.Runspace.ThreadOptions = "ReuseThread" } Add - PsSnapin Microsoft.SharePoint.PowerShell - ErrorAction SilentlyContinue Set - location $home $str = "http://localhost" function ProcessSubWebs($str) { $currentWeb = Get - SPWeb $str if ([Microsoft.SharePoint.Publishing.PublishingWeb]::IsPublishingWeb($currentWeb)) { $publishingWeb = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($currentWeb) $publishingPages = $publishingWeb.GetPublishingPages() foreach($publishingPage in $publishingPages) { if ($publishingPage.ListItem['Title'] - ne $null) { select Uri, Title, @ { Name = ’€™; Expression = { $_.Layout.ServerRelativeUrl } } $publishingPage | select Uri, Title, @ { Name = ’€™; Expression = { $_.Layout.ServerRelativeUrl } } $SPvaluesforOutput = $publishingPage | Select Uri, Title, Name $SPvaluesforOutput | Out - File c: \123. csv - append $publishingPage | Out - File c: \test.csv - append } } foreach($sub in $currentWeb.Webs) { if ($sub.Webs.Count - gt 0) { ProcessSubWebs($sub.Url) } } Write - Host - ForegroundColor red "FINISHED" } else { Write - Host - Foregroundcolor Red "$str not a publishing site" } } ProcessSubWebs($str) |
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 is the premiere web-based collaboration and productivity enhancement tool on the market today. With SharePoint, 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/month, allowing you to take advantage of the robust feature set for a small business price. HostForLIFE.eu offers a variety of hosted SharePoint plans as well as dedicated SharePoint options
