Enterprise AI & Cloud Architecture

SharePoint list views support a feature called  grouping  that enables you to define a grouping on a column in a list view. For example, grouping contacts by the company to which they belong is a common use of grouping. Grouping documents by the person who created them can be another good idea (see  Figure 1 ). Figure 1. A view of a document library grouping files by the Created By column Note Grouping is available only for standard and Gantt view types. To take advantage of grouping, select the column whose values you want to use as groups. If there are empty values in the selected column for some of the items or files in that view, they are placed under a group without a name (see Figure 2 ). Figure 2. A view of a contacts list, grouped by the Company column, where one contact doesn’t have a value in the Company column To define the grouping when creating a view , scroll down to the Group By section in the page and expand it by using the plus (+) sign ...

It is often a good idea to create special views that show information in a more compact way to enable mobile device users to see that information more clearly and to more comfortably navigate in it.Figure 1 Figure 1. A mobile view for an announcement list is designed to be more user friendly for mobile device users SharePoint attempts to identify whether a device is a mobile device and then switches to a default mobile view that is optimized for that purpose. Nonmobile devices see the view as if it is a regular view. Each mobile view has a special URL that the mobile device is redirected to. To specify that a view should have a mobile URL, scroll to the Mobile section in the view creation page and expand it by using the plus sign next to the section title. You can create a view and specify it to be the default mobile view for the list (see Figure 2 ), or you can just leave it as another new view in the list. Figure 2. Creating a mobile view. Additional options you can set f...

This section covers available topologies, Microsoft-approved assumptions, server roles, and a simplified scenario that provides you with an example of how you could scale out a farm.   SharePoint 2010 topologies can be broken into a limited deployment farm, small farm, medium farm, and large farm . These topologies allow SharePoint 2010 to be deployed on a single server or on many servers. SharePoint 2010 is designed to be scaled out using a three-tier system for its server roles, using server groups to build out your farm . Note: This section does not cover the large farm topology. A large farm is just a medium farm topology in which Search functionality is in a separate farm and the remaining servers are grouped by function. Topologies and scaling are closely associated: you must understand your topology to be able to scale efficiently and accommodate different scenarios and organizational requirements. The following are some best practices to use when...

Q)How to get page title and URL in SharePoint 2010 using server object model? To get the Page Title in SharePoint, you can follow the below approach. User the below namespace: using Microsoft.SharePoint; Then write the below code to get the Title String Title= SPContext.Current.Item["Title"].ToString(); Similarly you can get the URL in the below way Sting URL=System.Web.HttpContext.Current.Request.Path; Q)Generate Random password using C#.Net? public GenerateRandomPassword() { String strGuid=System.Guid.NewGuid().ToString(); strGuid=strGuid.Replace("-",string.Empty); strGuid=strGuid.Substring(0,8); //Here 8 means the password contains 8 characters. } Q)To create a list instance with SP object Model. using System; using Microsoft.SharePoint; class Program { static void Main() { using (SPSite site = new SPSite(" http://localhost ")) { using (SPWeb web = site.OpenWeb()) { string listName = "Litware News"; SPList list = nu...

A PowerPivot service application can be used by any number of SharePoint Web applications in the farm. To make a PowerPivot service application available, you add it to a service association list. Add powerPivot Services Application to Default Group A service association list is a list of shared services that provide resources to other SharePoint Web applications in the farm. There is one default group of service associations for the farm. To be on the list, a PowerPivot service application can either be added when you create the application or afterwards by using the following steps. In Central Administration, in Application Management , click Configure service application associations . In Application Proxy Group, click default . Select the checkbox next to the PowerPivot service application (indicated by type name PowerPivot Service Application Proxy ). If you have more than one PowerPivot service application, choose just one. Click OK. Add PowerPivot Services Application a...

Feature activation at the site collection level makes application pages and templates available to your sites, including configuration pages for scheduled data refresh and application pages for PowerPivot Gallery and Data Feed libraries. On a SharePoint site, click  Site Actions . By default, SharePoint web applications are accessed through port 80. This means that you can often access a SharePoint site by entering http:// to open the root site collection. Click  Site Settings . In Site Collection Administration, click  Site collection features . Scroll down the page until you find  PowerPivot Integration Site Collection Feature . Click  Activate . Repeat for additional site collections by opening each site and clicking  Site Actions . Installation of PowerPivot for existing Sharepoint Server For More Info about install powerpivot

A PowerPivot for SharePoint deployment requires that your farm include the following services: Excel Calculation Services, Secure Store Service, and Claims to Windows token service . The Claims to Windows Token Service is required for Excel Services and PowerPivot for SharePoint. It is used to establish connections to external data sources using the Windows identity of the current SharePoint user. This service must run on every SharePoint server that has Excel Services or PowerPivot for SharePoint enabled. If the service is not already started, you must start it now to enable Excel Services to forward authenticated requests to the PowerPivot System Service. In Central Administration, in System Settings, click   Manage services on server . Start the Claims to Windows Token Service. Start Excel Calculation Services . Start Secure Store Service . Verify that both SQL Server Analysis Services and SQL Server PowerPivot System Service are started. Create a PowerPivot Service Aplic...

PowerPivot refers to a collection of applications and services that provide an end-to-end solution for creating and sharing business intelligence using Excel and SharePoint. PowerPivot integrates with Excel and SharePoint. In an Excel environment, PowerPivot for Excel provides a familiar authoring and analytical experience on the workstation. In a SharePoint farm, PowerPivot for SharePoint adds server-side applications and features that support PowerPivot data access and management for workbooks that you publish to SharePoint. PowerPivot server components load the data, process queries, perform scheduled data refresh, and track server and workbook usage in the farm. Brief Intoduction about Powerpivot.. Learn Powerpivot . What is PowerPivot for Excel PowerPivot for Excel is an authoring tool that you use to create PowerPivot data in an Excel workbook. You use Excel data visualization objects such as PivotTables and PivotCharts to present the PowerPivot data that you embed or ...

There are default field types like Text, Note, Boolean, Integer, Number, Decimal, DateTime, Choice, Lookup etc. We can also make our custom field types by using visual studio 2010 The structure should look like the below figure: Steps to create custom field types:    First create a new SharePoint project using the Empty SharePoint project template. Inside the project you need to add a public class for each custom field type. You need to add a special xml file namely fldtypes_{project name}.xml, to deploy the field               type. public   class   EmployeeStartDate  :  SPFieldDateTime     {          public  EmployeeStartDate( SPFieldCollection  fields,  string fieldName)             :  base (fields, fieldName) { }          public  Emplo...