The 500 Internal Server Error is a very general HTTP status code that means something has gone wrong on the web site’s server, but the server could not be more specific on what the exact problem is. Here are several common ways that you might see the HTTP 500 error: How You Might See a 500 Error “500 Internal Server Error” “HTTP 500 – Internal Server Error” “Temporary Error (500)” In this article, I will show you how to fix…
In this article i will be able to make a case for how to get a year only from the date time column using calculation field in SharePoint 2013 list. First Open your SharePoint list. Here I have a Year from DOB column. Click create Column from the top ribbon. The following popup will appear. Enter column name (Year) and select calculated column. Now, you should create Column. Paste the following code to Formula field. =CONCATENATE(YEAR(DOB)) Here, I have an…
In this post, let me explain you about search in App Web using REST API in SharePoint. You can use Search REST service : <Site URL>/_api/search/query?querytext=”<SearchTerm>”. To Process the returned JSON result. Add required Search Service Permission to App.Manifest. Add ‘Search’ in Scope and set permission to ‘QueryAsUserIgnoreAppPrincipal’. Now, write the following code on Default.aspx
|
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 |
<%-- The following 4 lines are ASP.NET directives needed when using SharePoint components --%> <%@ Page Inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" MasterPageFile="~masterurl/default.master" Language="C#" %> <%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%-- The markup and script in the following Content element will be placed in the <head> of the page --%> <asp:Content ContentPlaceHolderID="PlaceHolderAdditionalPageHead" runat="server"> <script type="text/javascript" src="../Scripts/jquery-1.9.1.min.js"></script> <script type="text/javascript" src="/_layouts/15/sp.runtime.js"></script> <script type="text/javascript" src="/_layouts/15/sp.js"></script> <meta name="WebPartPageExpansion" content="full" /> <!-- Add your CSS styles to the following file --> <link rel="Stylesheet" type="text/css" href="../Content/App.css" /> <!-- Add your JavaScript to the following file --> <script type="text/javascript" src="../Scripts/App.js"></script> </asp:Content> <%-- The markup in the following Content element will be placed in the TitleArea of the page --%> <asp:Content ContentPlaceHolderID="PlaceHolderPageTitleInTitleArea" runat="server"> Page Title </asp:Content> <%-- The markup and script in the following Content element will be placed in the <body> of the page --%> <asp:Content ContentPlaceHolderID="PlaceHolderMain" runat="server"> <div> <p id="message"> <!-- The following content will be replaced with the user name when you run the app - see App.js --> initializing... </p> </div> <!-- App Web Search--> <div id="searchDiv"> <b>Search For</b> <input type="text" id="txtSearchTerm" /> <input type="button" id="btnSearch" value="Search" onclick="searchAppWeb()" /> </div> <div id="SearchResultsDiv"></div> <!--Search Ends--> </asp:Content> |
App.js
|
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 |
'use strict'; var context = SP.ClientContext.get_current(); var user = context.get_web().get_currentUser(); // 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() { getUserName(); }); // This function prepares, loads, and then executes a SharePoint query to get the current users information function getUserName() { context.load(user); context.executeQueryAsync(onGetUserNameSuccess, onGetUserNameFail); } // This function is executed if the above call is successful // It replaces the contents of the 'message' element with the user name function onGetUserNameSuccess() { $('#message').text('Hello ' + user.get_title()); } // This function is executed if the above call fails function onGetUserNameFail(sender, args) { alert('Failed to get user name. Error:' + args.get_message()); } //Search Implemenatation in App Web using Search REST API //Do not forget to provide Search Permission in AppManifest file var html; function searchAppWeb() { //Get the Search Term from textbox var searchTerm = $("#txtSearchTerm").val(); //REST API query URL var queryUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/search/query?querytext='" + searchTerm + "'";; //Empty the string html = ""; //Make the ajax call $.ajax({ url: queryUrl, method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: onSearchSuccess, error: onSearchError }); } function onSearchSuccess(data) { // JSON object contains two elements which have search results //1. PrimaryQueryResult //2. SecondaryQueryResults (When documents are grouped on Host Web) //Get PrimaryQueryResult and Render it in HTML Table format html = "<table>"; var primaryQueryResult = data.d.query.PrimaryQueryResult.RelevantResults.Table.Rows.results; if (primaryQueryResult != null && primaryQueryResult != undefined) { for (var iPrimaryResultCounter = 0; iPrimaryResultCounter < primaryQueryResult.length; iPrimaryResultCounter++) { html += "<tr><td>"; html += primaryQueryResult[iPrimaryResultCounter].Cells.results[3].Value; html += "</td><td><a href=\"" html += primaryQueryResult[iPrimaryResultCounter].Cells.results[6].Value; html += "\">" + primaryQueryResult[iPrimaryResultCounter].Cells.results[6].Value + "</a></td><tr>"; } } //Get SecondaryQueryResults and continue rendering it in HTML Table format var secondaryResult = data.d.query.SecondaryQueryResults; if (data.d.query.SecondaryQueryResults != null && data.d.query.SecondaryQueryResults != undefined) { for (var iSecondaryResultCounter = 0; iSecondaryResultCounter < data.d.query.SecondaryQueryResults.results.length; iSecondaryResultCounter++) { var resultBlock = data.d.query.SecondaryQueryResults.results[iSecondaryResultCounter].RelevantResults.Table.Rows.results; for (var iResults = 0; iResults < resultBlock.length; iResults++) { html += "<tr><td>"; html += resultBlock[iResults].Cells.results[3].Value; html += "</td><td><a href=\"" html += resultBlock[iResults].Cells.results[6].Value; html += "\">" + resultBlock[iResults].Cells.results[6].Value + "</a></td><tr>"; } } } html += "</table>"; $("#SearchResultsDiv").append(html); } function onSearchError(err) { alert(JSON.stringify(err)); } |
Best SharePoint 2013 Hosting Recommendation HostForLIFE.eu HostForLIFE.eu offer the Best, Cheap and Recommended SharePoint 2013 hosting start from €9.99/month. They can load…
In this post, I will tell you about Script to Stop SharePoint Timer Service in all Servers. As a single unified logical entity, a SharePoint farm requires a mechanism to run tasks necessary to provide its services. These tasks include updating components of the farm such as servers and services, and updating data and configuration in farm databases. To run these tasks, SharePoint provides its own scheduled tasks management service, manifested as Timer Service instances installed on every SharePoint server…
Today, let me show you How to Develope a List in SharePoint 2013 Online Using REST API. First, open new project and then replace the contents of Default.aspx with the following:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
<%-- The markup and script in the following Content element will be placed in the <head>of the page --%> <asp:content contentplaceholderid="PlaceHolderAdditionalPageHead" runat="server"> <script type="text/javascript" src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.9.1.min.js"></script> <script type="text/javascript" src="/_layouts/15/sp.runtime.js"></script> <script type="text/javascript" src="/_layouts/15/sp.js"></script> <!-- Add your CSS styles to the following file --> <link rel="Stylesheet" type="text/css" href="../Content/App.css" /> <!-- Add your JavaScript to the following file --> <script type="text/javascript" src="../Scripts/App.js"></script> </asp:content> <%-- The markup in the following Content element will be placed in the TitleArea of the page --%> <asp:content contentplaceholderid="PlaceHolderPageTitleInTitleArea" runat="server">Page Title</asp:content> <%-- The markup and script in the following Content element will be placed in the <body>of the page --%> <asp:content contentplaceholderid="PlaceHolderPageTitleInTitleArea" runat="server"> |
REST API Examples
|
1 2 3 4 5 6 7 8 9 10 11 12 |
</asp:content> <%-- The markup and script in the following Content element will be placed in the <body>of the page --%> <asp:content contentplaceholderid="PlaceHolderMain" runat="server"> <div> <p> <b>Create List</b> <br /> <input type="text" value="List Name Here" id="createlistname" /> <button id="createlistbutton">Create List</button> </p> </div> </asp:content> |
App.js Replace the contents of App.js with the following:
|
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 |
use strict '; var hostweburl; var appweburl; // Load the required SharePoint libraries. $(document).ready(function() { //Get the URI decoded URLs. hostweburl = decodeURIComponent( getQueryStringParameter("SPHostUrl")); appweburl = decodeURIComponent( getQueryStringParameter("SPAppWebUrl")); //Assign events to buttons $("#createlistbutton").click(function(event) { createList(); event.preventDefault(); }); // Resources are in URLs in the form: // web_url/_layouts/15/resource var scriptbase = hostweburl + "/_layouts/15/"; // Load the js file and continue to load the page with information about the list top level folders. // SP.RequestExecutor.js to make cross-domain requests $.getScript(scriptbase + "SP.RequestExecutor.js"); }); // Utilities // Retrieve a query string value. // For production purposes you may want to use a library to handle the query string. 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]; } } // Create a new custom list function createList() { var listName = document.getElementById("createlistname").value; var executor; // Initialize the RequestExecutor with the app web URL. // Content Type Header is used to tell server what format data in the body contains. executor = new SP.RequestExecutor(appweburl); executor.executeAsync({ url: appweburl + "/_api/SP.AppContextSite(@target)/web/Lists?@target='" + hostweburl + "'", method: "POST", body: "{ '__metadata': { 'type': 'SP.List' }, 'BaseTemplate': 100,'Description': '" + listName + "', 'Title':'" + listName + "'}", headers: { "content-type": "application/json; odata=verbose" }, success: createListSuccessHandler, error: createListErrorHandler }); } // Success Handler function createListSuccessHandler(data) { alert("List Created successfully") } // Error Handler function createListErrorHandler(data, errorCode, errorMessage) { alert("Could not create a new list: " + errorMessage); } |
Best SharePoint 2013 Hosting Recommendation HostForLIFE.eu HostForLIFE.eu offer the Best, Cheap and Recommended SharePoint 2013 hosting start from €9.99/month. They can load your site against anticipated traffic and recommend the best option for you.…
Today, We will learn about Clear SharePoint Config Cache files with powershell scripts. 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 |
$LogTime = Get-Date -Format yyyy-MM-dd_hh-mm $LogFile = ".\ClearSPConfigCachePatch-$LogTime.rtf" # Add SharePoint PowerShell Snapin 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 #Deleting any .rtf files in the scriptbase location $FindRTFFile = Get-ChildItem $scriptBase\*.* -include *.rtf if($FindRTFFile) { foreach($file in $FindRTFFile) { remove-item $file } } start-transcript $logfile Write-host "##############Following steps will be involved################" -fore green write-host "Step 1 - Stop the timerservice" -fore cyan write-host "Step 2 - Take the backup of config cache file" -fore cyan write-host "Step 3 - Delete the XML files" -fore cyan write-host "Step 4 - Reset the cache.ini file" -fore cyan write-host "Step 5 - Start the SP timerservice" -fore cyan Write-host "##############Above steps will be involved##################" -fore green $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 StopSPTimerServicesInFarm([Microsoft.SharePoint.Administration.SPFarm]$farm) { Write-Host "" foreach($server in $farm.Servers) { foreach($instance in $server.ServiceInstances) { # If the server has the timer service then stop the service if($instance.TypeName -eq $timerServiceInstanceName) { [string]$serverName = $server.Name Write-Host "Stop " $timerServiceName " service on server: " $serverName -fore yellow $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'" $serviceInternalName = $service.Name sc.exe \\$serverName stop $serviceInternalName > $null # Wait until this service has actually stopped write-host "Waiting for '$timerServiceName' service on server: " $serverName " to be stopped" -fore yellow do { Start-Sleep 1 Write-Host -foregroundcolor DarkGray -NoNewLine "." $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'" } while ($service.State -ne "Stopped") write-host " '$timerServiceName' service on server: " $serverName " stopped successfully" -fore green break; } } } Write-Host "" } Function BackupSPConfigFiles([Microsoft.SharePoint.Administration.SPFarm]$farm) { write-host "" write-host "Backup SP config cache files" -fore yellow foreach($server in $farm.servers) { foreach($instance in $server.ServiceInstances) { if($instance.TypeName -eq $timerServiceInstanceName) { $ServerName = $server.name $FolderName = $servername + "SPConfigCacheBackup" write-host "Creating a folder to hold the backup files" -fore magenta write-host "Checking whether the folder aleady exist" if(Test-path $scriptbase\$FolderName) { write-host "Folder already exists and the script is deleting it......" remove-item $scriptbase\$FolderName -recurse -confirm:$false write-host "Existing folder deleted" -fore green } else { write-host "Folder does not exist" } New-Item $scriptbase\$FolderName -type directory write-host "New folder created to hold the backup files" -fore magenta write-host "Backup of SP config files for the server " $serverName " started ...... " -fore yellow $path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config" Copy-Item $path -Destination $scriptbase\$FolderName -recurse write-host "SP config cache files backed up for the server " $serverName " Sucessfully..." -fore green } } } write-host "SP config caches files are backed up" -fore green write-host "" } Function DeletingXMLFiles([Microsoft.SharePoint.Administration.SPFarm]$farm) { Write-host "" write-host "Deleting SP config cache XML files from each server in the farm" -fore yellow $path = "" foreach($server in $farm.servers) { foreach($instance in $server.ServiceInstances) { if($instance.TypeName -eq $timerServiceInstanceName) { $serverName = $server.Name write-host "Deleting SP config cache files from the server " $servername -fore magenta $path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config\*-*\*.xml" remove-item -path $path -force write-host "SP config cache files deleted on the server " $servername -fore magenta break } } } write-host "SP config cache XML files from each server in the farm is deleted successfully......" -fore green write-host "" } Function ResetTimerCache([Microsoft.SharePoint.Administration.SPFarm]$farm) { write-host "" write-host "Reseting the value of timer cache to 1" -fore yellow $path = "" foreach($server in $farm.servers) { foreach($instance in $server.ServiceInstances) { if($instance.TypeName -eq $timerServiceInstanceName) { $serverName = $server.Name write-host "Reseting the value of timer cache file in server " $serverName -fore magenta $path = "\\" + $serverName + "\c$\ProgramData\Microsoft\SharePoint\Config\*-*\cache.ini" Set-Content -path $path -Value "1" write-host "Value of timer cache file in server " $serverName " is resetted to 1" -fore magenta break } } } write-host "The value of timer cache is resetted to 1 in all the SP servers in the farm" -fore green write-host "" } Function StartSPTimerServicesInFarm([Microsoft.SharePoint.Administration.SPFarm]$farm) { Write-Host "" foreach($server in $farm.Servers) { foreach($instance in $server.ServiceInstances) { # If the server has the timer service then stop the service if($instance.TypeName -eq $timerServiceInstanceName) { [string]$serverName = $server.Name Write-Host "Start " $timerServiceName " service on server: " $serverName -fore yellow $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'" $serviceInternalName = $service.Name sc.exe \\$serverName start $serviceInternalName > $null # Wait until this service starts running write-host "Waiting for " $timerServiceName " service on server: " $serverName " to be started" -fore yellow do { Start-Sleep 1 Write-Host -foregroundcolor DarkGray -NoNewLine "." $service = Get-WmiObject -ComputerName $serverName Win32_Service -Filter "DisplayName='$timerServiceName'" } while ($service.State -ne "Running") write-host $timerServiceName " service on server: " $serverName " started successfully" -fore green break; } } } Write-Host "" } #############Calling functions################ StopSPTimerServicesInFarm $farm BackupSPConfigFiles $farm DeletingXMLFiles $farm ResetTimerCache $farm StartSPTimerServicesInFarm $farm ########################################## write-host "SCRIPT COMPLETED" -fore cyan stop-transcript |
Best SharePoint 2013 Hosting Recommendation HostForLIFE.eu HostForLIFE.eu offer the Best, Cheap and Recommended SharePoint 2013 hosting start from €9.99/month. They can load your site against anticipated traffic and recommend the best option for you. HostForLIFE.eu is Microsoft No #1 Recommended Windows and ASP.NET Hosting in European Continent. Their service is ranked the highest top #1 spot in several European countries,…
When I tried to use the News Feed Feature in SharePoint 2013, it thrown exception:
|
1 |
microsoft.office.server.microfeed.microfeedexception |
As you can see on the below picture: Solution: News feeds are related to User Profile Service. Hence, we’ve got to visualize 2 things that which associated with User Profile Service in SharePoint 2013. – Check whether AppFabric Caching service is running with the service account which has elevated permissions. Next, check the account that is running the User Profile Service application: Open Central…