Search This Blog

Saturday, January 29, 2011

Sharepoint Question & Answer

Sharepoint Question & Answer

• What is SharePoint?
Portal Collaboration Software.

• What is the difference between SharePoint Portal Server and Windows SharePoint Services?
SharePoint Portal Server is the global portal offering features like global navigation and searching. Windows SharePoint Services is more content management based with document libraries and lists. You apply information to certain areas within your portal from Windows SharePoint Services or directly to portal areas.

• What is a web part zone?
Web part zones are what your web parts reside in and help categorize your web parts when designing a page.

• How is security managed in SharePoint?
Security can be handled at the machine, domain, or sharepoint level.

• How are web parts developed?
Web parts are developed in Visual Studio .Net. VS.Net offers many web part and page templates and can also be downloaded from the Microsoft site.

• What is a SharePoint farm?
Multiple machines running services for SharePoint. Otherwise known as Topology.

• What is a site definition?
It’s a methods for providing prepackaged site and list content.

• What is a template?
A template is a pre-defined set of functions or settings that can be used over time. There are many templates within SharePoint, Site Templates, Document Templates, Document Library and List Templates.

• How do you install web parts?
Web Parts should be distributed as a .CAB (cabinet) file using the MSI Installer.

• What is the difference between a site and a web?
The pages in a Web site generally cover one or more topics and are interconnected through hyperlinks. Most Web sites have a home page as their starting point. While a Web is simply a blank site with SharePoint functionality built in; meaning you have to create the site from the ground up.

• What are the differences between web part page gallery, site gallery, virtual server gallery and online gallery?
Web Part Page Gallery is the default gallery that comes installed with SharePoint. Site Gallery is specific to one site. Virtual Server gallery is specific to that virtual server and online gallery are downloadable web parts from Microsoft.

• What is the GAC?
Global Assembly Cache folder on the server hosting SharePoint. You place your assemblies there for web parts and services.

• What is a DWP?
The file extension of a web part.

• What is CAML?

Stands for Collaborative Application Markup Language and is an XML-based language that is used in Microsoft Windows SharePoint Services to define sites and lists, including, for example, fields, views, or forms, but CAML is also used to define tables in the Windows SharePoint Services database during site provisioning.


• What is a document library?
A document library is where you upload your core documents. They consist of a row and column view with links to the documents. When the document is updated so is the link on your site. You can also track metadata on your documents. Metadata would consist of document properties.

• What is a meeting workspace?
A meeting workspace is a place to store information, attendees, and tasks related to a specific meeting.

• What is a document workspace?
Document workspaces consist of information surrounding a single or multiple documents.

• What is a web part?
Web parts consist of xml queries to full SharePoint lists or document libraries. You can also develop your own web parts and web part pages.


• What is the difference between a document library and a form library?
Document libraries consist of your core documents. An example would be a word document, excel, powerpoint, visio, pdf, etc… Form libraries consist of XML forms.

• What are themes?
Themes provide a quick a easy way to change the appearance of your SharePoint site

• What is presence?
Allows users to see if other users are online and can send them instant messages.

• Can web parts be connected? if so, how?
Web Parts can be connected by Modifying the Shared Part and providing the connection with the correct fields to share.

• What is a personal view and what is a shared view?
Personal views are specific to a user while Shared View is common across all users.

• What is an STP file?
The file extension that applies to site templates.

• What is an FWP file?
The file extension that applies to SharePoint sites that have been backed up.

• How does SharePoint support MS Outlook integration?
Via Web Parts available at the Microsoft Web Component Directory. Oh yeah and Active X Controls.

• How can you extend lists in SharePoint?
If you mean extend by adding columns of data and have specific data types for each column the answer is yes. You can also use Data Views in FrontPage 2003 to pull in XML data from other sites, lists or document libraries to make the information more presentable for users.

• Explain the document versioning in SharePoint document libraries
When versioning is enabled everytime the document is edited from the SharePoint site it creates a new version. You can restore or delete old versions of documents. Version numbers are incremented by the system itself.

• Where are web part resources contained?
The SharePoint file system, SQL, and the GAC folder. They are also referenced in the web.config folder.

• What are the different installation methods for deploying web parts? and what are the pros/cons?
The best way is via a CAB file using the MSI Installer.

• What is a ghosted/unghosted page?
Page that is created from a template oppsed to being created from scratch.

• How is site data stored?
Site data is stored in your content database that either resides in SQL Server 2000 or MSDE.


 • Where is metadata for a web stored?
In the content databases stored in SQL.

• What is an audience and describe the use?
Audiences are a pre-defined set of users that you can apply information to. You can apply information to their personal sites as well for dailey information or job tasks.

• What are the trust levels and what is the default trust associated with SharePoint?
SSL and the basic IIS security. SharePoint comes with Integrated Windows Authentication turned on.

• What are the two logging mechanisms for usage statistics?
By default creates log files in the \%windir%\system32\LogFiles\STS directory on the front-end Web server, although an alternate location can be specified. The STS directory contains a folder for each virtual server on the Web server, each named with a GUID that identifies the respective virtual server. Each virtual server folder contains subfolders for each day, which in turn contain the daily usage log for each virtual server. In addition to containing information per virtual server, the Windows SharePoint Services logs are also useful because they associate users with page hits and with time stamps. what functionality does owssup.dll provide for client side activities?

• What is STSAdm and what can it be used for?
STSADMIN is a tool that can do many things from a command prompt like manage users, create new sites and add files to the file system.

• Can WSS search subsites?
Not without the new CorasWorks Search Web Part.

• Can you register alerts for users?
Not unless you are logged in as that user.

• Are PDFs searchable?
Out of the box only the metadata collected in the upload form is search able. Unless you download and install the Adobe iFilter.

• Describe a large deployment
Many front-end webserver with a SQL cluster with the possibility of multiple international locations.

• How can you synchronize custom Active Directory attributes to SharePoint?
Via the Profile Importer.

• If it is anticipated that our organization would need to store 1 terrabyte of documents, what is the recommended configuration and storage requirement?
Multiple front-end web servers with content databases across the server farm. The amount of web-servers can depend on how many users you have and what the typical size of a document is.

• Explain how you would deploy SharePoint on an extranet
Usually servers that are accessible from external sources are housed in DMZ’s. Depending on the requirements and the workflow for publishing content you could go with Multiple Servers hosting the same information. One server would reside inside with the SQL Cluster while the external server resides in the DMZ simply calling data. Security would be handled by the same or different active directory domain clusters as well increasing security.

• What is the BKM for maximum number of virtual servers configured for SharePoint on a single box?
I believe its 15.

• what are the migration strategies for moving sites around?
You could use the SharePoint Portal Server backup and restore tool as well as the STSADMIN and GUI STSAMIN tools. We have migrated databased from the SQL Level and have simply reconnected the front end.

Friday, January 28, 2011

FileUpload Control

Disable pasting and typing of text in FileUpload Control
<asp:FileUpload ID="FileUpload1" runat="server"
onkeydown = "return (event.keyCode==9);"
onpaste = "return false;" />
When you add the two events to aspx page directly Visual Studio produces warning which is not an issue to worry since these are client side events and Visual Studio checks for Server Side events still if you do not want that to happen you can add the same from code behind too in the following way

FileUpload1.Attributes.Add("onkeydown", "return (event.keyCode==9);");

FileUpload1.Attributes.Add("onpaste", "return false;");


Validating RadioButtonList
<script type = "text/javascript">
function Validate()
var RB1 = document.getElementById("<%=RadioButtonList1.ClientID%>");
var radio = RB1.getElementsByTagName("input");
var isChecked=false;
for (var i=0;i<radio.length;i++)
if (radio[i].checked)

alert("Please select an item");
return isChecked;

<asp:Button ID="Button1" runat="server" Text="Validate" OnClientClick =

"return Validate()" />

Getting SelectedText and SelectedValue
<script type = "text/javascript">

function GetSelectedItem()
var RB1 = document.getElementById("<%=RadioButtonList1.ClientID%>");
var radio = RB1.getElementsByTagName("input");
var label = RB1.getElementsByTagName("label");
for (var i=0;i<radio.length;i++)
if (radio[i].checked)
alert("SelectedText = " + label[i].innerHTML);
alert("SelectedValue = " + radio[i].value);
return false;

<asp:Button ID="Button2" runat="server" Text="SelectedItem" OnClientClick

= "return GetSelectedItem()" />

Thursday, January 27, 2011

RadiobuttonList-Selected Index

<script type="text/javascript">
function getSelectedIndex() {
var radioButtons = document.getElementsByName("RadioButtonList1");
for (var x = 0; x < radioButtons.length; x ++) {
if (radioButtons[x].checked)
document.getElementById("spnmsg").innerHTML = "selected " +radioButtons[x].value;
// alert(radioButtons[x].value);

<span id="spnmsg"></span>
<asp:RadioButtonList ID="RadioButtonList1" onclick="getSelectedIndex()" runat="server">
<asp:ListItem Value="0" Text="Item0"></asp:ListItem>
<asp:ListItem Value="1" Text="Item1"></asp:ListItem>
<asp:ListItem Value="2" Text="Item2"></asp:ListItem>

Monday, January 24, 2011

Print Script

<script type="text/javascript">
function PrintContent()
{ = 'none';
var DocumentContainer = document.getElementById('divtoprint');
var WindowObject ='', 'PrintWindow',"width=750,height=750,top=50,left=50,toolbars=no,scrollbars=yes,status=no,resizable=yes");
<div id="divtoprint" style="display: none;">
calling print
<asp:ImageButton ID="imbPrint" AlternateText="Print" ImageUrl="~/print.png"
OnClientClick="PrintContent();" ToolTip="Print New Form" runat="server" />

Accordion Arrows

This is one way to have up/down or open/close arrows appear on an AJAX AccordionPane. First add a div and an img to the Header of the AccordionPane along with the title (the example uses ‘Add Widget’).

<cc1:AccordionPane ID="apTest" runat="server" >
<div id="div1" onclick="UpDownIcons('imgAcc')">
Add Widget   <img src="Images/arrow_down.ico" id="imgAcc" alt="expand" />

Note the onclick function for the div, that is where the change takes place. Here is the code for the ‘UpDownIcons’ javascript function.

function UpDownIcons(paneImg)
var clicked = document.getElementById(paneImg);
var currentIcon;
currentIcon = clicked.src.endsWith('arrow_down.png');

var others = document.getElementsByTagName('img');
for(i=0; i<others.length; i++)
others[i].src = 'App_Themes/MainTheme/Images/arrow_down.png';

The first section of the script is necessary to flip the arrow when a user clicks on the same accordion to close it rather than a different accordion. The loop runs through the other imgs to switch their src.

You would need to change the img src to your image path and you would need to change the ‘arrow_down.ico’ in the currentIcon=img.src.endsWith line to match your icon names. Also this example assumes that this pane would be closed to begin with so the default src is the down arrow icon.

Thursday, January 13, 2011



MLM (Multi Level Marketing)

The scope of this application is facilitated and track effective communication between Admin and Company Stock Pointers who have an interest in donating their time to Stock Pointer and Users. The money will be earned by the user’s basis on the tree view process.

The below described are the users and functionalities of MLM.


Ø Administrator

Ø To distribute the recharge vouchers of all the companies providing cellular/mobile services.

Ø To provide self-employment opportunities to all the levels of people.

Ø To improvise the standard of the individuals who recharge their mobiles in this medium.

Ø Stock Pointer

Ø Interested candidates can register themselves to this Company and become the distributor.


Ø Users can earn by making 5 people join in this company. There are 7 stages in which the candidates earn money.

This project has been done in ASP.NET and C# under Microsoft SQL 2005.