Skip to main content

Posts

SharePoint 2013 - Access Services

Table of Contents Overview Prerequisites Configuring SQL Server for Access Services Security mode Setting the SQL Server Enable Contained Databases, Allow Triggers to Fire Others, and Default Language properties Protocols setup IIS Application Pool Load User Profile Setting Database backup Configure Access Services Basic Configuration Steps How to complete the basic configuration steps Enabling required services Creating a site collection Setting Permissions on the site Generating Secure Store Security Service key Access Apps See Also Overview NB! This Wiki is  based on a previously released white note paper outlining Access Services 2013. Access Services in SharePoint Server 2013 allows people to host Access databases in SharePoint within the context of an Access app. Access apps for SharePoint are new in SharePoint Server 2013 and you will build them using the Access 2013 desktop client.  You c...
Post a Comment
Read more

Create and Retrieve a Social Rating

The SocialRatingManager object enables you to create a social rating for any specified URL. Because entries in Microsoft SharePoint Server lists and document libraries can be represented by URLs, you can create and retrieve social ratings for those items, and for any other SharePoint Server page. This topic demonstrates how to use the SocialRatingManager to create and retrieve social ratings and how to enable social ratings on a SharePoint Server in a custom application. The samples in this topic assume that you have added the following references to your Microsoft Visual Studio 2010 project: Microsoft.SharePoint Microsoft.Office.Server Microsoft.Office.Server.UserProfiles System.Web Creating Social Ratings The overloaded SetRating method creates a single SocialRating object for the current user on a single specified URL. A social rating consists of a URL and an integer ranging from 0 through 5. It also can optionally consist of a string title for the rating and a Feedbac...
Post a Comment
Read more

Add Rating to sharepoint list on site collecion using power shell

ShellScript: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")   $site = New-Object Microsoft.SharePoint.SPSite("http://sitecollection URL")   $web=$site.OpenWeb()   if ($web -ne $Null)   {         $AverageRating=$web.Fields[[System.Guid]"5a14d1ab-1513-48c7-97b3-657a5ba6c742"]         $RatingCount=$web.Fields[[System.Guid]"b1996002-9167-45e5-a4df-b2c41c6723c7"]         $PagesList=$web.lists["Pages"]         if ($PagesList -ne $Null)         {               Write-Host " Processing List : " $PagesList.Title               $ct=$PagesList.ContentTypes["Page"]           ...
Post a Comment
Read more

Create Rating Visual Web Part Using Visual Studio 2010,

Create Rating Visual Web Part Using Visual Studio 2010,  also Apply Rating Settings using c#   Back End Design  Register Assembly    <%@ Register Tagprefix="SharePointPortalControls" Namespace="Microsoft.SharePoint.Portal.WebControls" Assembly="Microsoft.SharePoint.Portal, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> Add Control. <div>    Average Ratting :    <SharePointPortalControls:AverageRatingFieldControl ID="PageRatingControl" runat="server"/> </div>
Post a Comment
Read more

Apply Custom Master Page To Site using Power Shell

function ApplyMasterPageToSearchSite([string] $siteURL, [string] $SiteName) {         $subsiteurl = $siteURL + "/" + $SiteName + "/default.aspx"         Enable-SPFeature -identity "94c94ca6-b32f-4da9-a9e3-1f3d343d7ecb" -url $subsiteurl         Start-SPAssignment -Global         $site = Get-SPSite $siteURL         Write-Host "Get the Site" -foregroundcolor green         $topWeb = Get-SPWeb $site.Url         Write-Host "Update Master Page to search" -foregroundcolor green         $site | Get-SPWeb -limit all | ForEach-Object { $_.MasterUrl = "/_catalogs/masterpage/LMSSearchMaster.master";$_.Update() }         Write-Host "Master Page assigned" -foregroundcolor green         Stop-SPAssignment -G...
Post a Comment
Read more

Create Search Scope and apply ruele using power shell also define Search Setting to Site Collection

[string]$searchSiteName = "Search" # Creates the search scope on site so it shows on the dropdown function CreateSearchScope([string] $siteURL){     # Variables for Site     [string]$searchServiceApplicationName = "Search Service Application"     [string]$adminServiceName = "SPAdmeinV4"     [string]$lmsContentTypeTemplateID = "STS_ListItem_10001"     [string]$searchDropDownValue= "Search Dropdown"     [string]$scopeName = "LMS Search"     # Gets the Search Service Application Object     Write-Host "Get-SPEnterPriseSearchServiceApplication" -foregroundcolor green     $ssa = Get-SPEnterPriseSearchServiceApplication -Identity $searchServiceApplicationName     # Get the root web     Write-Host "Get the root web." -foregroundcolor green     $site = New-Object Microsoft.SharePoint.SPSite($siteURL)    ...
Post a Comment
Read more

Apply C# code in Power Shell Script

  Apply C# code in Power Shell # ----------- Csharp code for variations -------------- $Assem = (     "System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"    ,     "Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" ,     "Microsoft.SharePoint.Publishing, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" ,     "Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" ,     "Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"             )     $Source = @" using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SharePoint; using Microsoft.SharePoint.Publishing; using Microsoft.SharePoint.Administration; using Syste...
Post a Comment
Read more

Custom Search Result using XSLT

 XSLT for Display search result in box format. Copy this xslt in to Search Core Results webpart's  XSL Editors Properties. <xsl:stylesheet version="1.0" xmlns:wxsl="http://www.w3schools.com/w3style.xsl" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:SharePoint="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal">   <xsl:output method="xml" indent="yes"/>   <!--this tamplate is main tamplate wich calls dvt_1 and main root template of this xslt.-->   <xsl:template match="/">     <style type="text/...
Post a Comment
Read more