Sample Code | Code Example | Computer Programming Tips

Screenshot using Selenium WebDriver

2014-10-09T23:06:00.003+05:30

Well many times in Automation Testing Scenario, Script and Test Case is failing due to object not found. It is handle in many testing tools in different languages. In this post, I will show you how to capture screen shot of failed test using @AfterMethod and test marked failed in report. In below example, I have handle a function with @AfterMethod annotation to capture the Screenshot using in Selenium Web Driver. To capture the Screenshot using selenium Web Driver, If you are using testNG, you can add the listener class which will further be extended with 'TestListenerAdapter' which has the implementation of taking screenshot on failures. This way we need not to make any logic change to take screenshot all the time.

Example 1:
@AfterMethod(alwaysRun = true, description = "take screenshot")
public void afterMethod_takeScreenshot(ITestResult result, Method m) throws Exception {
if (!result.isSuccess()) {
TakesScreenshot screen = (TakesScreenshot) driver;
File fileScreen = screen.getScreenshotAs(OutputType.FILE);
File fileTarget = new File("failure_" + m.getName() + ".png");
FileUtils.forceMkdir(fileTarget.getParentFile());
FileUtils.copyFile(fileScreen, fileTarget);
}

Example 2:
@AfterMethod
public void onTestFailure(ITestResult result) {

if(!result.isSuccess()){
String workingDirectory = System.getProperty("user.dir");
//specify ur path of screenshots folder here
String fileName = workingDirectory + File.separator +"screenshots"+ File.separator + result.getMethod().getMethodName() + "().png";//filename
File scrFile = ((TakesScreenshot)driver).getScreenshotAs(OutputType.FILE);
try {
FileUtils.copyFile(scrFile, new File(fileName ));
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

Delete Cookies, Browser temporary files, Browser History with QTP Script

2013-09-30T11:43:00.003+05:30

While executing the Quick Test Professional Scripts, Sometimes there can be a need to clear the Internet Explorer Temporary files. So for Delete Cookies, Browser temporary files, Browser History with Quick Test Professional Script, there are several options available.

Option 1:
Function ClearBrowserHistory
Dim temp
Set fso = CreateObject ("Scripting.FileSystemObject")
Set winsh = CreateObject ("Wscript.Shell")
Set temp = fso.GetFolder (winsh.ExpandEnvironmentStrings("%TEMP%"))
On Error Resume Next

For each ofile in temp.Files
fso.DeleteFile ofile
Next

For Each osubfldr in temp.subfolders
fso.DeleteFolder (osubfldr),true
Next
wscript.quit
End Function

Option 2:
Webutil.DeleteCookies

'To clear temporary Internet files
Set WShell = CreateObject("WScript.Shell")
WShell.run "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8"

'To Clear Browsing History
WShell.run "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 1"

Wait (10)

Option 3:
'To clear temporary Internet files
Set WshShell = CreateObject("WScript.Shell")
WshShell.run "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8"

'To clear browsing cookies
WshShell.run "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 2"

'To Clear Browsing History
WshShell.run "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 1"

HP QTP 11.5 UFT System Requirements

2013-09-06T14:20:00.002+05:30

HP has recently launched the New Version of Quick Test Pro as named HP QTP UFT 11.5. For successfully install and run HP QTP 11.5 UFT in computer, there are some minimum system requirements.

These System Requirements are given as below. But if you use a system with stronger/later setups than the minimum requirements, performance may be improved.

Minimum System Requirements and Supported Environments for HP QTP 11.5 UFT:

Computer Processor:1.6 Ghz or higher
Operating System:Windows XP Service Pack 3
Memory:Minimum of 2 GB (for no more than three add-ins are loaded simultaneously)
Color Settings:High Color (16 bit)
Graphics Card:Graphics card with 64 MB video memory
Free Hard Disk Space:2 GB of free disk space for application files and folders
Browser:Microsoft Internet Explorer 7.0 or a later supported version

Notes:

An additional 512 MB of RAM are required when using a virtual machine.
Additional memory is required when loading more add-ins and when using the Save movie to results option to capture movies during run sessions.
You must also have an additional 1 GB of free disk space on the system disk (the disk on which the operating system is installed).

HP QTP 11.5 New Features

2013-09-06T12:05:00.002+05:30

HP QTP, the best functional testing tool, is recently comes with a new version release. This HP QTP new version is hit the market with the name “HP Unified Functional Testing (UFT) 11.5”.

HP QTP 11.5 is a combination of QuickTestPro (QTP), Service Test (ST) and Mobile Testing as well. This is the major change in QTP since it is available in the market. HP QTP 11.5 creates this major change because of the end to end testing needs in the current market. So based on the requirement HP QTP 11.5 provides the testing ability as a GUI testing tool i.e. QTP, API testing tool i.e. Service Test and Mobile Testing from a single interface and that’s why now there is a no need for download separate tools.

HP UFT 11.5 Features:

QTP IDE Update:

HP UFT IDE (Integrated Development Environment) supports to work on multiple tests at the same time.
HP Unified Functional Testing IDE supports for editing more than one action at the same time.
HP QTP 11.5 IDE has improved statement completion, improved dynamic lists of values, code folding and code snippets.
Image based objects / controls identification (Insight Recording for GUI test).
QTP Recording identifies the object based on images.
Image-based testing feature can allow us to test applications on non-windows operating system as well.
Enhanced support for GUI Testing Environment.

Browsers:

HP UFT 11.5 Recording feature supports for

Internet Explorer 9
Mozilla Firefox Versions 4 to Versions 10

HP UFT 11.5 Play back supports for

Internet Explorer 9
Mozilla Firefox Versions 4 to Versions 10
Google Chrome

GUI Test support Add-ins:

Standard
Java
.NET
WPF

New and Improve Support:

Delphi
Oracle 11g, PeopleSoft 8.5 and Siebel
SAP CRM 7.0 and SAP GUI 7.2
Office (MSAA)

Improved Check points:

Checks the text in dynamically or accessed PDF file content.
Supports for including or excluding multiple areas within a bitmap.
Supports for locate a bitmap area anywhere within the run time bitmap image.
Select External bitmap file as the bitmap source.

Supports for Mobile applications testing:

Install Perfecto Mobile QTP Add-in (UFT Mobile) and automate Mobile applications.

VB Script - Close All Browser

2013-08-29T22:32:00.000+05:30

Function Details:
This Vb Script Function is for "Close browsers except QC window" using VB Script.This function will close all the Internet Explorer window and tabs except HP Quality Center. To use this function simply copy paste it in to text file and save the file with .vbs Extension. When you double click on the .vbs file, the script will be executed and you can found the result.

Function CloseIE
    On Error Resume Next

    'Variable Declaration
    dim objShell, objWindow, strTitle

    'Set Variables and Object Values
    set objShell = CreateObject("Shell.Application") 'Create Shell Application Object
    strTitle = "HP Quality Center" 'Set Window Title Search Name

    for each objWindow in objShell.Windows 'Get Window Objects
        if InStr(objWindow.FullName,"iexplore")<>0 then 'Check Object Window Full Name with iexplore
            if(objWindow.document.title<>"") then 'Check Object Window Title not Blank
                if InStr(objWindow.document.title,strTitle)=0 then 'Check Object Window is not Quality Center
                    objWindow.Quit 'Close IE
                end if
            end if
        end if
    next

    if objShell.Windows.Count>0 then 'Check Object Window Count
        For i=0 to objShell.Windows.Count
            Call CloseIE 'Recursively call Function
        next
    end if

End Function

Note :- To Use this Function write the below statement in top of the .vbs file.
Call CloseIE statement

Add Remove Object Repository Dynamically in QTP

2013-08-29T22:05:00.002+05:30

HP QTP provides a great functionality for adding or removing Object Repository at run time or dynamically. For that ObjectRepositories Utility object of QTP is used.

Find the below code for Add/Remove Object Repository dynamically in QTP during run time.

'*********************************************************
'Function Name: AddRemoveOR
'Purpose: Use for Add Or Remove Object Repository with Action Name
'Inputs:
    'repositoryPath=Repository Path for Add or Remove with Action
    'actionName=Action Name for Add for Add Or Remove Repository
    ' operationName=Operation Name to be Perform either "Add" or "Remove" Object Repository
'Return Values: -
'Created By: Krutin Gandhi
'*********************************************************

Function AddRemoveOR(repositoryPath,actionName,operationName)

    Dim qtApp,qtRepositories, actName, RepPath, rPosition'Variable Declaration

    RepPath=repositoryPath 'TRS File Path
    actName=actionName   'Get Action Name
    Set qtApp = CreateObject("QuickTest.Application")    ' Create Application Object
    Set qtRepositories = qtApp.Test.Actions(actName).ObjectRepositories    ' Get Associated repositories list

        'Adding Repository to an action
        If operationName="Add" Then
            If qtRepositories.Find(RepPath) = -1 Then
                qtRepositories.Add RepPath, 1    ' Add the Object Repository to the current action
            End If

        'Remove Repository to an action
        Else if operationName="Remove" Then
            rPosition=qtRepositories.Find(RepPath) 'Find the Position of the Repository
            If rPosition<>-1 then
                qtRepositories.Remove rPosition ' Remove Repository From the Action
            End if
        End If
    End If

    'Assign nothing
    Set qtApp= Nothing
    Set qtRepositories= Nothing
End Function

Business Process Testing Challenges

2012-07-06T22:57:00.001+05:30

What is Business Process Testing ?

•

It is an additional licensed module of Quality Center.
It is a transformation, not a technology.
It helps to create reusable business components – Manual & Automated of a test (s).
Business Component : Non-Scripted and Scripted.
It accelerates the automation in large ERP Apps – SAP & Oracle Apps.

Challenges of Business Process Testing

Required Highly Level domain knowledge to a create Business Process Testing Component.
The input data required for executing the Business Process should be reusable.
Business Process should be complete, correct and accurate.
Business Process Components should also be compatible with lower versions of Quick Test Professional and Quality Center.
Some times Subject Matter Experts require technical knowledge because:

Some initial Components might prove complete for some Business Process’s, but there will surely be a need to create new components in order to complete all the scripts.
Though UI Scanner automatically generates the required components, it might be required to manually modify the Quick Test Professional code, or even to manually create a whole component.

QTP 11 New Features

2011-11-01T17:10:00.000+05:30

HP QuickTest Professional software version 11 is now available in market. In QTP 11, There are many updates as compare to QTP 10. Following are some features of QTP 11 which are new as compare to old QTP 10.

Support for new Operating Systems

Enhanced Data Management Facility

New Object Spy Functionality

Add an object to a repository
Highlight an object in our application
Copy/paste object properties

New Smart Regular Expression list

New QTP-Service Test integration facility

New Run Results Viewer

New facility to hide the Keyword View

Facility to add Images to Our Run Results

New Log Tracking Functionality

Automatic Parameterization of Steps

New Visual relation identifiers

Visual indication of Version Control Status of Tests

Web 2.0 add-ins support

New capabilities for working with Web-Based objects

Firefox Testing
XPath, CSS, Identifiers
Event Identifiers
Embed or Run JavaScripts in our Web Pages

New methods for testing Web-based Operations

New methods for testing Web-based Operations

New LoadFunctionLibrary statement

Improved checkpoints and output value objects management

Dual Monitor Support

New QTP Asset Upgrade Tool for HP ALM and Quality Center

Test execution in minimized remote desktop protocol session

Improved Web Add-in Extensibility

Improved Business Process Testing

New Extensibility Accelerator for Functional Testing

Export QTP Result as a HTML Page

2011-10-04T12:06:00.000+05:30

The Quick Test Professional has an in built functionality to Export Test Results in PDF, Excel or HTML file but if the user want to Export the Test Result via descriptive programming and user defined function than the below code will be helpful.

This below simple code for "Export QTP Result as a HTML Page" is modifiable and developed with VB Script.

Function Declaration :
Public Function GenerateHTMLReport(ByVal inputXML, ByVal inputXSL, ByVal outputFile)
   sXMLLib = "MSXML.DOMDocument"
   Set xmlDoc = CreateObject(sXMLLib)
   Set xslDoc = CreateObject(sXMLLib)
   xmlDoc.async = False
   xslDoc.async = False

   xslDoc.load inputXSL

   xmlDoc.load inputXML

   outputText = xmlDoc.transformNode(xslDoc.documentElement)

   Set FSO = CreateObject("Scripting.FileSystemObject")
   Set outFile = FSO.CreateTextFile(outputFile,True)
   outFile.Write outputText
   outFile.Close
   Set outFile = Nothing
   Set FSO = Nothing
   Set xmlDoc = Nothing
   Set xslDoc = Nothing
   Set xmlResults = Nothing

End Function

Use of Function :
Dim sResultsXML, sDetailedXSL
sResultsXML is for define full path of the Result.xml file.
sDetailedXSL is for QTP inbuilt PDetails.xsl file for format the Result.xml file.

For Example :
sResultsXML = "C:\Temp\TempResults\Report\Results.xml"
sDetailedXSL = "C:\Program Files\HP\QuickTest Professional\dat\PDetails.xsl"

Function Call :
GenerateHTMLReport sResultsXML, sDetailedXSL, "Path for save the Exported HTML file"

Visual Studio 2011 and .NET Framework 4.5 developer

2011-10-03T17:10:00.000+05:30

There is a Fantastic news from the Microsoft for developer because microsoft recently announced the Visual Studio 2011 and .NET Framework 4.5 developer preview in Anaheim, California. There are some new features at this movement with Visual Studio 2011 and .NET Framework 4.5 developer preview are as under

1.) Visual Studio 2011 developer preview Features

- Develop Metro style Apps for Windows 8
- Enhancements for Game Development
- Code Clone Analysis
- Code Review Workflow

Download Here

2.) .NET Framework 4.5 developer preview Features

- State machine support in Windows Workflow
- Improved support for SQL Server and Windows Azure in ADO.NET
- ASP.NET has increased investments in HTML5, CSS3, device detection, page optimization, as well as new functionality with MVC4

Download Here

Javascript Confirm Message Box

2011-09-14T17:08:00.000+05:30

This is the simple and easiest way to create a JavaScript confirm message box. A JavaScript confirm message box is similar to an alert box.with the JavaScript confirm message box the user can get two choices — OK and Cancel button in the message box. One ristriction with the JavaScript confirm message box is that You can't change the names of the choices but you can determine what they do.

<html>
<head>
<script type="text/javascript">
function showConfirmBox()
{
     var r=confirm("Kindly Press a button!");
     if (r==true)
    {
         alert("You just pressed OK!");
    }
   else
   {
        alert("You just pressed Cancel!");
    }
}
</script>
</head>
<body>
<input type="button" onclick=" showConfirmBox ()" value="Click here for confirm box" />
</body>
</html>

SQL Server Report With Asp.net Application

2011-08-09T15:08:00.000+05:30

This article features integration of SQL Server Report With Asp.net Application. To call SQL Server Reports With Asp.net Application from front end can be acheived in few steps as under.

Solution 1 : Direct Load Report in Application.

Create a new website.
Add the report viewer to a form.
Change the ProcessingMode to Remote.
Also change the AsyncRendering to FALSE.
Then assign two properites to the report viewer:

ReportViewer1.ServerReport.ReportServerUrl
ReportViewer1.ServerReport.ReportPath

Report should then pop up in your page.

Solution 2 : Load the report on click of the menus on a web page.

Click the smart tag which is located on the top left corner or the ReportViewer to show the ReportViewer Tasks panel.
In the Choose Report dropdown list, select to display report on the Report Server.
Type in the Report Server Url in the Report Server Url textbox like Exe:-http://servername/reportserver.
Keep the Report Path textbox blank.
In the click event handler of the menu, type in the code below to specify the report dynamically:

ReportViewer1.ServerReport.ReportPath ="/FolderName/ReportName";
ReportViewer1.ServerReport.Refresh();

After that, the ReportViewer would not display report until click the menu.

Microsoft Report Viewer Add-On Download

When ASP.NET Application Restart?

2010-11-16T10:54:00.000+05:30

The list of situations

Adding, modifying, or deleting the application's Web.config file.
- This is very important situation here, if we are add any new section or modify existing section i web configuration file, the IIS will treat as change and then lead to restart the ASP.NET Application. And more important when Application restart all the sessions and other states will lost. so make sure before update anything in web config file, all the transaction has been completed.
Adding, modifying, or deleting assemblies from the application's Bin folder.
Adding, modifying, or deleting localization resources from the App_GlobalResources or App_LocalResources folders.
Adding, modifying, or deleting the application's Global.asax file.
Adding, modifying, or deleting source code files in the App_Code directory.
- This is very important situation here, if we are add any new section or modify existing section i web configuration file, the IIS will treat as change and then lead to restart the ASP.NET Application. And more important when Application restart all the sessions and other states will lost. so make sure before update anything in web config file, all the transaction has been completed.
Adding, modifying, or deleting Web service references in the App_WebReferences directory.

This is very smal tip, but most useful, who are working production asp.net application.

Data Access Layer Class In C#

2010-11-16T10:31:00.001+05:30

In this article, I would show to you how to create a Data Access Layer Class in C#. The data access layer always important when we are work with database and presentation layer. This class should contains all the methods which can be used to get data from database (using Stored Procedures) and also to insert and update data in database.

Data Access Layer Class contains the methods which return different objects like Data set, SqlDataReader, Integer etc at the end of the method. Data Access Layer Class also contains methods for adding.Parameter to SQL Command with different parameters and contains the method to set the parameter value.

Here is the sample code for create the Data Access Layer Class in C#.

Difference between Web Service and WCF Service

2010-11-15T09:45:00.000+05:30

Web services can be hosted in IIS as well as outside of the IIS. While WCF service can be hosted in IIS, Windows activation service,Self Hosting,WAS and on lots of proctols like Named Pipe,TCP etc.Here lots of people disagree how we can host the web service outside of the IIS but Here is the article for that.http://msdn.microsoft.com/en-us/library/aa529311.aspx.
In Web Services Web Service attribute will added on the top of class. In WCF there will be a Service Contract attributes will be there. Same way Web Method attribute are added in top of method of Web service while in WCF Service Operation Contract will added on the top method.
In Web service System.XML.Serialization is supported while in the WCF Service System.RunTime.Serialization is supported.
WCF Services can be multithreaded via ServiceBehavior class while web service can not be.
WCF Services supports different type of bindings like BasicHttpBinding, WSHttpBinding, WSDualHttpBinding etc.while Web services only used soap or xml for this.
Web services are compiled into a class library assembly. A file called the service file is provided that has the extension .asmx and contains an @ WebService directive that identifies the class that contains the code for the service and the assembly in which it is located while in WCF.WCF services can readily be hosted within IIS 5.1 or 6.0, the Windows Process Activation Service (WAS) that is provided as part of IIS 7.0, and within any .NET application. To host a service in IIS 5.1 or 6.0, the service must use HTTP as the communications transport protocol.

Share Point moving items between lists

2010-10-25T09:57:00.001+05:30

There is a very necessary thing for the Share Point developer is to move the List Item to another List. This is happening almost in every issue. So there are some simple steps for Share Point Moving Items from one List to another List.

Open your Share Point site and make sure you’re logged in at least as a Site Collection Administrator (not that you cannot do this operation with other permissions.)
Before Developer precede also make sure that publishing is enabled for the Site Collection Features and Site Features.
Navigate yourself to the Site Settings and then to Manage Content and Structure.
Select the List where you have the list item and then hover over the list item you want to move.
Drop down the menu and select Copy/Move.
It should open a dialogue box displaying a site tree structure again.
Select the List you would like to the copy/move the item to and the operation would be executed.
Now Open the destination List and you would see your List item listed there.

So now you can easily handle this massive work so simply when any developer want to do the "Share Point Moving items from one List to another List".

Share Point 2010 Change Favicon Icon

2010-10-22T12:12:00.002+05:30

To change the favicon icon in SharePoint 2010 is much easier with SharePoint 2010. SharePoint 2010 is much easier and customizable. SharePoint 2010 is latest version of Microsoft SharePoint. With SharePoint 2010 the SharePoint Designer 2010 attached which is simpler to work with and allows the SharePoint developer to change just about anything they wish to change. While customization is easier than ever, it has also changed significantly from SharePoint 2007. The addition of new SharePoint controls allows the user to change settings more easily than before. The favicon, the icon that represents the website, is an important part of any page. Specifically in SharePoint 2010, if this icon is left unchanged it leaves the default bright orange icon.

To maintain the branding of your webpage in your favicon, follow these steps.

Upload your favicon file to your images library.
Publish and Approve your icon through the SharePoint Publishing Workflows
Open your master page in SharePoint Designer 2010.
Find the tag in the HTML header.
Change the "IconUrl" tag to the relative URL of your favicon.
Save and check-in your master page.
Publish and approve your master page through the SharePoint Publishing Workflows.

Share Point group Send email

2010-10-21T10:56:00.000+05:30

For Send the email to the Share Point Group, follow the below steps. These steps are with the Active Directory settings.

First of all, create an Organization Unit (OU) in the Active Directory (AD) and delegate Full Control rights to Share Point Service Account (Central Administration Application Pool Account).
Configure Incoming Email Settings to use Share Point Directory Management Service to create Distribution Groups and Contacts to the Active Directory container (OU).
Mention the SMTP server name select all the options for Distribution Group Request Approval Settings.
On the Share Point Site create a new group with Full Control permission.
Create an Email Distribution Group (type in an email address) for this group.
In Central Administration > Operations > Approve/Reject Distribution Groups, approve the Distribution Group to be created in the OU.
Check the OU in the AD and you will find the Distribution List successfully created with the email address (Microsoft Exchange stamps this email address to this Distribution List) assigned to the Share Point Group in the Share Point Site.
Add some users to the Share Point group and you will find that they synchronized the same in the Distribution List.
Send an email to the email address assigned to the Share Point group and the emails would be sent to the individual members of the Share Point Group.

Note: Synchronization between Share Point Group and Distribution List in the AD is a one way transaction (Share Point Group to Distribution List and not the other way round). Hence, new users added to the Share Point Groups reflect automatically in the Distribution List however the vice-versa does not work.

SharePoint Foundation 2010 Features

2010-10-19T10:02:00.001+05:30

Microsoft released new technologies in 2010, and most important in between them is SharePoint Foundation 2010. Previously known by the code name SharePoint 14, SharePoint 2010 marks a significant upgrade to the SharePoint product. Here are some knowledge about what kind of great feature Sharepoint Foundation 2010 has.

New in Microsoft SharePoint Foundation 2010:

Alerts Enhancements

Alerts can now be delivered as e-mail or as a Short Messaging Service (SMS) message.
The alert system can be programmatically customized with mobile messaging service providers.

Business Connectivity Services

You can create, read, update, delete, and query external line-of-business systems and do batch and bulk operations which reduces round trips dramatically.
You can create content types for external data and services.
There are more connective options including “plug and play” custom connectors and out-of-the-box connections to databases, Web/WCF services, .NET connectivity assemblies, and custom data sources.

Client Object Model

There are three new client APIs for interacting with SharePoint 2010 site; .NET managed application (Microsoft .NET Framework 3.5 or later), Silverlight applications (Microsoft Silverlight 2.0), and ECMAScript (JavaScript, JScript).

Events Improvements

Event handlers will be available for add and delete events on lists, add events on Web sites, and after events can now be either synchronous or asynchronous.

List Improvements

You can create a SharePoint lists that reads and manipulate data from an external data sources such as a SQL Server data table.
You can easily create relational lists using lookup fields and have cascading deletion.
Lists can now have duplicate or non- duplicate list items.
Lists can have custom column validation equations using VBScript.
Lists can now have navigation hierarchies and filters based on content types meaning you can have a document library that is broken down into sub-categories based on metadata in your content types.

Microsoft Synch Framework

The new Microsoft Sync Framework will allow SharePoint developers to synchronize offline files and data from external applications, services and devices with libraries or lists in SharePoint 2010.

Mobile Device Development Enhancements

Mobile Web Part Adapters in SharePoint 2010 allows developers to create adapter controls for Web Parts that you want to make available on mobile pages.
Mobile messages can now be sent as Short Messaging Service (SMS) message or Outlook Message Service (OMS) through the SharePoint API.

Query Enhancements

A new LINQ to SharePoint provider enables your code to query SharePoint lists from server code by using LINQ syntax.
CAML queries will now supports joining multiple lists in a single query and you can specify what list fields to include in the results.
Web Services will still be a part of SharePoint 2010, but only for backwards capability support. For best performance and usability, it is recommended that you use either the client object model or the ADO.NET Data Services Framework.

Ribbon Menu

SharePoint 2010 will have use the popular ribbon menu system from Office 2007 to replace the old style of the publishing tool bar control and some administrative menus.
Central Administration screens will also use a ribbon menu system.
You can customize the ribbon with a Feature or through a user custom action.

Sandboxed Solutions

Sandboxed Solutions are partially trusted solutions that are limited to using subset of the Microsoft SharePoint namespace and can be monitored by farm administration for CPU execution time, memory consumption, database query time, abnormal terminations, critical exceptions, unhandled exceptions, and data marshalling.

Service Application Framework

The Service Application Framework replaces the Shared Services Provider in MOSS 2007
The Service Application Framework is an API that manages services and enables them to be load balanced and shared between computers on a server farm.
The Service Application Framework has over 20 built in services and can be extended by developers for their applications.

Silverlight Integration and the Fluid Application Model

Microsoft Silverlight 2.0 is now automatically installed with SharePoint 2010. Silverlight Web Parts allow Silverlight applications to be easily intergraded into your site pages.
Fluid Application Model is a new concept in SharePoint 2010 that allows non-SharePoint applications hosted on another server to be made available to all Web applications in a farm. Web site users with contributor rights can add Web Parts that host non-SharePoint applications to their page.

UI Improvements

Content and application pages now contain the same content placeholders and application pages now reference the site master page.
The CSS has been divided into multiple files to enable more targeted customization scenarios and to improve page loading performance.
More cross-browser support thanks to Silverlight.
SharePoint 2010 says it be WCAG 2.0 AA complaint.
You can choice between using the old SharePoint 2007 user interface or using new SharePoint 2010 user interface that uses Silverlight and the ribbon menu system.

Windows PowerShell for SharePoint

Windows PowerShell for SharePoint is a new command-line tool and a supporting scripting language from Microsoft that complements Cmd.exe in the Windows administration context and that supersedes the Stsadm.exe administration tool.
Although both Cmd.exe and Stsadm.exe will be maintained for backward compatibility, all current and future development of scripts and administrative files in SharePoint Foundation should use this new scripting technology.

Workflow Improvements

New workflow actions, Pluggable workflow services provide a mechanism for workflows to interact and receive data from external sources, more workflow events (WorkflowStarting, WorkflowStarted, WorkflowCompleted, WorkflowLoading, WorkflowUnloading, and WorkflowPostponed), site based workflows, high privilege workflows, and reusable declarative workflows.

InfoPath Forms Services

You can generate a simple InfoPath form that puts data into a custom list by clicking on the “List” properties in the ribbon and then the “Customize Form” menu item.
With InforPath 2010 it is easier to build rich forms declaratively with little to no code and more client-side validation.

New in Microsoft SharePoint Server 2010:

Enterprise Content Management

Site administrators can create rules in the “Content Organizer” section of SharePoint 2010 to redirect files to another folder, library, or record center based on the metadata of a file.
Document Sets applies metadata to entire collection of documents, spreadsheets, presentations, or other types of document content.
Document Sets support templates and versioning.
Document ID services adds a unique identifier to all documents throughout the site collection so you can retrieve documents by an ID no matter where it is stored.
You can create folder metadata.
In-Place Records Management incorporates record management capabilities in any site collection. You no longer have to use a Records Center site template to manage your documents.
Enterprise content types can be used in multiple site collections in the same or different farms.
Large page libraries allow more pages and folders to be store in one library than in SharePoint 2007. Libraries will scale to tens of millions and archives to hundreds of millions of documents. This mean you don’t have to break down your site into sub sites to maintain performance.

SharePoint Enterprise Search

You can define a custom ranking model to use for search queries by creating a ranking model schema.
The SharePoint Search Connector Framework enables you to create search connectors to connect and crawl custom content repositories like external web sites, file servers, Exchange, Lotus Notes, Documentum and FileNet.
SharePoint Search a new phonetic search algorithm and spell check so you don’t have to worry about spelling words or names correctly.

PerformancePoint Services

Performance Point Server will now be part of SharePoint Server 2010 and will allow business users to create dashboards, scorecards, and key performance indicators (KPIs). (Side Note: If you have enterprise edition of MOSS 2007 you can run Performance Point Server 2007. Check Microsoft website for more details.)

Excel Services

Excel services now includes richer pivoting, slicing and visualizations like heatmaps and sparklines.
Use Excel and PowerPivot, also known as “Gemini”, to quickly manipulate millions of rows of data into a single Excel workbook for ad-hoc reports without having to create or edit an OLAP cube.
You can use the REST API and the ECMAScript object model to manipulate your Excel workbooks.

Visio Services

Like Excel Services, Visio documents can now be rendered within a web browser when they are hosted in SharePoint.
Business user can create workflow outlines in Visio and export them to SharePoint designer to add the business logic and additional rules.

User Profiles and Social Data

The Microsoft.Office.Server.ActivityFeed namespace provides new functionality for programmatically publishing and gathering the activities of site users.
The Microsoft.Office.Server.SocialData namespace provides new functionality for programmatically creating and aggregating social tags, ratings, and comments.
The Microsoft.Office.Server.UserProfiles provides new functionality that enables you to create role-specific properties for any type of user profile. For example clients vs employees.

Word Automation Services

The Word Automation Services provides server-side conversion of documents into other formats including .pdf, .xps, .docx, .docm, .dotx, .dotm, .doc, .dot, .rtf, .mht, .mhtml, and .xml.

Free Download Documentation

Customize Alert Templates in SharePoint Foundation 2010

2010-10-14T18:06:00.000+05:30

SharePoint Foundation includes Pre-defined alert templates for e-mail and SMS messages
Pre-defined Alert Template Location: %ProgramFiles%\Common Files\Microsoft Shared\web server extensions\14\TEMPLATE\XML
SharePoint Foundation includes Pre-defined alert templates for e-mail and SMS messages
Pre-defined Alert Template Location: %ProgramFiles%\Common Files\Microsoft Shared\web server extensions\14\TEMPLATE\XML
Email Template: AlertTemplates.xml
SMS Template: AlertTemplates_SMS.xml
Template includes information such as the format, contents and properties for the alert email and SMS messages.

Customize alerts
(1) Create a copy of the xml template file that you need to change – AlertTemplates.xml and AlertTemplates_SMS.xml

(2) Modify the copy of the alert template file – (The original template file should not be modified)
You can make changes to the template such as add a button/link, include an image or privacy information, modify the look of the alert etc.
To customize the appearance of alerts, modify the css by using the Format element.
Resource variables listed within the template definition file, such as $Resources:Alerts_anything_filter_shortname, can be found in core.resx (in the local_drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Resources folder)
If you are modifying any element other than the Format element, both the email and the SMS templates should be modified, in parallel – the 2 templates should be in sync except for the Format element.

(3) Load the custom templates by using the command: stsadm -o updatealerttemplates. I haven’t found a direct equivalent Powershell command.

If both, the email and the SMS template are updated, the UpdateAlertTemplates command needs to be run twice, once for each of the two files.

(4) Restart IIS
(5) The SharePoint Timer service may need to be restarted.

SharePoint 2010 Installation Guide

2010-10-08T17:36:00.000+05:30

Share Point Server 2010 installation process is quite messy and taking to much time for installation. Here is the full guidance for "How to install the Share Point Server 2010". Before start the installation keep in mind the below two notes because these steps will change at RTM.
1) Install is using admin account (several of us just couldn't get ALL the features to work with separate service account in Beta)
2) We don't need loopback fix as all the sites are using specific ports instead of host headers.

SharePoint 2010 Installation guide

Start Hyper-V Manager on a 64bit server
Click “Action->New->Virtual Machine”
For Name, type “sharepoint2010”
Click “Next”
For memory, type “6144”
Click “Next”
Select a local connection, click “Next”

NOTE: you will need internet access

Select a location, ensure that the size is set to at least 127GB
Click “Next”
Click “Next”
Click “Finish”
Right click the virtual machine in Hyper-V, select “Settings”
For the IDE Controller 1, specify the “Windows Server 2008” iso

Click “Browse”
Select the iso
Click “Open”

Click “Ok”
Start the Virtual Machine
Install Windows Server 2008

Click “Next”
Click “Install Now”
Select “Windows Server 2008 Enterprise (Full Installation)”
Click “Next”
Click “I accept the license terms”
Click “Next”
Click “Custom (advanced”)
Click “Next”, windows will install
Click “Ok”
For password, type “Pa$$w0rd”
Type “Enter”
Click “Ok”

From Hyper-V Console, install “Integration Services”

Click “Action->Insert Integration Services Setup Disk”
Click “Install Hyper-V Integration Services” in the autoplay
Click “Ok” to upgrade/install
Click “Yes” to restart

Login to the server as administrator
Click “Start->All Programs->Windows Update”
Click “Turn on now”
Click “Install now” to install latest windows update software
In the “Server Manager” window that opens:

Click “Configure Remote Desktop”
Click “Allow connections from computers running any version…”
Click “OK”
Click “OK”
Click “Configure IE ESC”
Click “Off” for both administrators and users
Click “OK”
Click “Go to Windows Firewall”
Click “Windows Firewall properties”
For domain, private, public, set the firewall status to “Off”
Click “OK”
Click “Add Features”
Click “SMTP server”
Click “Add Required Role Services”
Click “Next”
Click “Next”
Click “Install”
Click “Close”

Run Windows Update, get all critical updates

Click “Install Updates”, install all updates
Click “Restart Now”

Install Microsoft Update
Run Microsoft update, install any updates

Click “Restart Now”

Install Server 2008 Service Pack 2 (if it didn’t get installed from Microsoft Update)

Restart after install

Click “Start”
Right click “Computer”, select “Properties”
Under computer name, click “Change settings”
For description, type “sharepoint2010”
Click “Change”
Set the computer name to “sharepoint2010”
Click “Ok”
Restart the virtual machine
Run Windows Update, get all critical updates

Click “Install Updates”, install all updates
Click “Restart Now”

At this point, keep your image as a Windows Server 2008 base image!

Copy the base image sharepoint2010 vhd, rename to server2008sp2base and put in a safe place!

Open a command prompt, run dcpromo, setup a domain called “contoso.corp”

Click “Next”
Click “Next”
Select “Create a new domain…”
Click “Next”
Enter contoso.corp, click “Next”
Select “Windows Server 2008”, click “Next”
Click “Next”
Click “Yes, the computer will use…”
Click “Yes”
Click “Next”
For password, type “Pa$$w0rd”
Click “Next”
Click “Next”, active directory will setup itself up

Restart the machine after AD is finished
At this point, keep your image as a Windows Server 2008 base image!

Copy the base image sharepoint2010 vhd, rename to server2008sp2_AD and put in a safe place!

Create the following domain users, set their password to “Pa$$w0rd” and that they can’t change the password and the password doesn’t expire.

Click “Start->Administrative Tools->Active Directory Users and Computers”
Expand contoso.corp
Select “Users”, right click and select “New->User”
For name and user logon, type sp_system
Click “Next”
For Password, type “Pa$$w0rd”
Uncheck “User must change…”
Check “User cannot change password”
Check “Password never expires”
Click “Next”
Click “Finish”

Install SQL Server 2008 SP1 – If you don’t have slipstreamed sp1, install the setup files for SP1, then install sql 2008, then the full SP1 (but you may need the new Installer which is in the SQL 2008 base install/non-sp1).

Insert the Server 2008 iso (with SP1)
Click “installation”
Click “New SQL Server standalone…”
On “Setup Support Roles”, click “Ok”
On “Setup Support Files”, click “Install”
Click “Next”
On product key, click “Next”
Click “I accept the license terms”
Click “Next”
Check the following:

i. Database Engine

ii. SQL Server Replication

iii. Full-Text Search

iv. Analysis Services

v. Reporting Services

vi. Business Intelligence Development Studio

vii. Client Tools Connectivity

viii. Integration Services

ix. Client Tools Backward Compatibility

x. Management Tools – Basic

xi. Management Tools - Complete

xii. Microsoft Sync Framework

Click “Next”
Click “Next”
On “Disk Space”, click “Next”
For all accounts, type “contoso\administrator” and “Pa$$w0rd” for password
Click “Next”
Click “Mixed Mode” authentication radio button
For password, type “Pa$$w0rd”
Click “Add Current User”
Click “Next”
Click “Add Current User”
Click “Next”
On report Services, click “Install, but do not configure…” radio button
Click “Next”
Click “Next”
Click “Next”
Click “Install”
Click “Next”
Click “Close”

Install the 2008 SP1 CU2

http://support.microsoft.com/kb/970315
Open SQL Management Studio, make sure your version is 10.00.2714 or later!

Open SQL Server Management Studio, this is for the initial setup process to run
Open the SQL configuration manager
Click “Start->All programs->Microsoft SQL Server 2008->Configuration Tools->Sql Server Configuration manager

Expand “SQL Server Network Configuration->Protocols for MSSQLSERVER”
Enable:

Named Pipes
TCP/IP

Restart the sql service

Install/attach the demo databases (Northwind, pubs, adventureworks2000, adventureworksDW). These can be downloaded or installed from the instructor dvd.

Northwind and Pubs (http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en)

i. Run Sql2000SampleDb.msi

ii. Open c:\sql server 2000 sample databases\instnwnd.sql

iii. Run on sharepoint2007

iv. Open c:\sql server 2000 sample databases\instpubs.sql

v. Run on sharepoint2007

vi. Delete the c:\sql server 2000 sample databases directory

AdventureWorks 2000 (http://www.microsoft.com/downloads/details.aspx?familyid=487c9c23-2356-436e-94a8-2bfb66f0abdc&displaylang=en)

i. Run AdventureWorks2000.exe

ii. Click, no at the .net 1.0/1.1 framework install

iii. Open Sql Server management studio

iv. Connect to sharepoint 2007

v. Right click databases, select attach

vi. Click Add, Browse to c:\program files\microsoft sql server\mssql\data\adventureworks2000_data.mdf

vii. Click Ok

AdventureWorksDW (http://codeplex.com/SqlServerSamples)

i. Find and download, run AdventureWorksDBScripts.msi

ii. Open c:\program files\microsoft sql server\100\tools\Samples\adventureworks data warehouse\instawdb.sql

iii. Run on sharepoint2007 (make sure you don’t get any errors, if you do fix them – likely need to copy the .csv files to a directory)

iv. Open c:\program files\microsoft sql server\100\tools\Samples\adventureworks OLTP\instawdb.sql

v. Run on sharepoint2007 (make sure you don’t get any errors, if you do fix them – likely need to copy the .csv files and rename the .mdf and .ldf to install the database)

Run Windows Update, get all critical updates

Click on all available updates
Click “Ok”
Click “Install Updates”
Click “Restart Now”

At this point, keep your image as a base image!

Copy the base image sharepoint2010 vhd, rename to server2008sp2_sql2008sp1_cu and put in a safe place!

Install “Office 2010”

Click “I accept the terms…” check box
Click “Continue”
Click “Install Now”
Click “Close”
Open “Word 2010”
Click “Use recommended settings”
Click “Ok”

Open Office Word 2010 to setup the initial settings
Install “Visio 2010”

Enter your product key
Click “Continue”
Click “I accept the terms…” check box
Click “Continue”
Click “Install Now”
Click “Close”

Install “Microsoft SharePoint Designer 2010”

Click “I accept the terms…” check box
Click “Continue”
Click “Install Now”
Click “Close”

Install “Visual Studio 2010”

Insert the iso into the image
Click “Install Visual Studio 2010”
Click “Next”
Click “I have read and accept…”
Click “Next”
Click “Full”
Click “Install”
When/if prompted, restart, the install will start up again when rebooted
When/if prompted, restart, the install will start up again when rebooted
Click “Finish”, close the intaller

Open “Visual Studio 2010”, select c# development settings

Turn off customer improvement program
Close Visual Studio 2010

Install “FireFox” browser

Download from http://www.firefox.com

Install “Google Chrome” browser

Download from http://www.google.com/chrome

Install “Apple Safari” browser

Download from http://www.apple.com/safari/

Install “Enterprise Library 4.1”

http://www.microsoft.com/downloads/details.aspx?FamilyId=1643758B-2986-47F7-B529-3E41584B6CE5&displaylang=en
Click “I accept the terms…”
Click “Next”
Click “Next”
Click “Next”
Click “Install”
Click “Launch” to install the source and working copy files
Click “Finish”

Apply WCF patch

Download and install (http://support.microsoft.com/kb/971831)

At this point, keep your image as a base image!

Copy the base image sharepoint2010 vhd, rename to server2008sp2_sql2008sp1_cu_vs2010 and put in a safe place!

Install “SharePoint 2010” Prereqs

NOTE: (BE SURE YOU ARE LOGGED IN AS CONTOSO\ADMINISTATOR)
Insert the DVD/start the install
Click “Install Prerequisites”

i. NOTE: this step will require internet access!

Click “Next”
Click “I accept the terms…”
Click “Next”

i. All pre-reqs will be downloaded and installed (this could take 45 minutes)

ii. Even on Server 2008, your setup may download SP2 for Server 2008 and install, if it does, a reboot will be required. After reboot, continue the install via the prompts

iii. Install will continue by installing application server role and the other prereqs

Install “SharePoint 2010” product

Click “Install SharePoint Server”
Enter your trial product key

i. PKXTJ-DCM9D-6MM3V-G86P8-MJ8CY

Click “Continue”
Click “I accept…”
Click “Server Farm”
Select “Complete…”
Click “Install Now”
Click “Close” (uncheck the run configuration wizard)

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} Ensure proper permissions are setup (these steps will fix the CryptographicException error):

Right click on the folder ('%CommonProgramFiles%\Microsoft Shared\Web Server Extensions\14), select “Properties”
Select “Security” tab
Click “Edit”
Click “Add”
For the user type “Network Service”
Click “OK”
Grant the user Full Control
Click “OK”
Click “OK”

At this point, keep your image as a base image!

Copy the base image sharepoint2010 vhd, rename to server2008sp2_sql2008sp1_cu_vs2010_NoConfigure and put in a safe place!

Run SharePoint Configuration Wizard

Click “Start->All Programs->Microsoft SharePoint 2010 products->SharePoint 2010 Products Configuration Wizard”
Click “Next”
In the popup, click “Yes”
Select “Create a new server farm”
Click “Next”
For database server, type “SharePoint2010”
For username, type “contoso\administrator”
For password, type “Pa$$w0rd”
Click “Next”
For passphrase, type “Pa$$w0rd”
Click “Next”
Click “Next”,
Click “Next”, SharePoint 2010 will Configure itself
Click the radio button to participate in the feedback program, we gotta make SharePoint better right?!?
Click “Walk me through the settings using this Wizard” radio button
Click “Next”
Click “Use existing managed account”
Click “Next”, all your services will be created, this will take a few minutes
Click “Skip”
Click “Finish”

Add a farm administrator

Click “Security”
Click “manage farm administrators group”
Click “New->Add Users”
Type contoso\sp_system
Click “Ok”

Open the SharePoint Central Administration site and setup Diagnostic Logging

Click “Monitoring”
Under “Reporting”, click “Configure usage and health data collection”
Ensure that “Enable usage data collection” is clicked
Ensure that “Enable health data collection” is clicked
Click “Ok”

Open the SharePoint Central Administration site and setup Outgoing Email

Click “System Settings”
Click “Configure out-going email Settings”
For outbound smtp, type “sharepoint2010”
For from address, type “sharepoint@contoso.corp”
For reply address, type sharepoint@contoso.corp
Click “Ok”

Start the “SharePoint Web Services” application pool

Open IIS Manager
Ensure that the “SharePoint Web Service” application pool is started

Start services on a server

Open “Central Administration”
Click “System Settings”
Click “Manage services on server”
Start all services, except for “Lotus Notes Connector”

i. NOTE: Install “Document Conversions Load balancer” before you start the launcher service, select “servername” when setting up the launcher service.

ii. For Foundation Search, use the following settings:

1. For Username type, “contoso\administrator”

2. For password, type “Pa$$w0rd

3. For content access account type “contoso\adminsitrator”

4. For password, type “Pa$$w0rd”

5. Click “Start”

iii. For “User Profile Synchronization Service”

1. Click “Start”

2. Select the only “User Profile Service Application”

3. Click “OK”

4. Wait for the status of the job to change to “Started”

Ensure Windows Services have started

Open the Services Applet
Ensure these two service eventually start

i. ForeFront Identity Manager Service

ii. ForeFront Identity manager Synchronization Service

Run an IISRESET
Configure the User Profile service

Click “Application Management”
Click “Manage service applications”
Click “User Profile Service Application”
Click “Manage” in the Ribbon
Click “Configure Synchronization Connections”
Click “Create new connection”
For connection name, type “Contoso.corp”
For forest name, type “contoso.corp”
For account name, type “contoso\administrator”
For password, type “Pa$$w0rd”
Click “Populate Containers”

i. NOTE: if you get an error, change the browser settings to IE7.0

Expand “Contoso”
Select “Users”
Click “Ok”

Install “Office Web Applications”

Type your key
Click “I accept the terms…”
Click “Continue”
Click “Install Now”
Click “Close”, leave the checkbox checked
Click “Next”
Click “Yes”
Click “Next”
Click “Next”
Click “Finish”

Create Office Web Applications service applications

Open Central Administration
Click “Application management”
Click “Manage service applications”
Click “New->PowerPoint Service Application”
For name, type “PowerPoint Service”
For pool name, type “PPTPool”
Click “OK”
Click New->Word Viewing Service”
For name, type “Word Viewing Service”
For application pool type “WordViewingPool”
Click “OK”
On the service applications page, click “PowerPoint Service Application”
Click “new site collection”
For title, type “PPT Broadcast”
For the url, in the dropdown select “sites”
For the url textbox, type “PPTBroadcast”
For template, click “Enterprise”, select “PowerPoint Broadcast Site”
For site collection admin, type “administrator”
Click “OK”
Click “System Settings”
Click “Manage services on server”
Click “Start” for:

i. PowerPoint Service

ii. Word Viewing Service

Open SharePoint PowerShell, run the following commands:

Click Start->Programs->Microsoft SharePoint 2010 Products->SharePoint 2010 Mangaement Shell
Run the following commands:

1. $acl = Get-Acl HKLM:\System\CurrentControlSet\Control\ComputerName

2. $person = [System.Security.Principal.NTAccount]"Users"

3. $access = [System.Security.AccessControl.RegistryRights]::FullControl

4. $inheritance = [System.Security.AccessControl.InheritanceFlags]"ContainerInherit, ObjectInherit"

5. $propagation = [System.Security.AccessControl.PropagationFlags]::None

6. $type = [System.Security.AccessControl.AccessControlType]::Allow

7. $rule = New-Object System.Security.AccessControl.RegistryAccessRule($person, $access, $inheritance, $propagation, $type)

8. $acl.AddAccessRule($rule)

9. Set-Acl HKLM:\System\CurrentControlSet\Control\ComputerName $acl

10. $e = Get-SPServiceApplication | where {$_.TypeName.Equals("Word Viewing Service Application")}

11. $e.WordServerIsSandboxed = $false

12. $e.WordServerIsSandboxed

13. $p = Get-SPServiceApplication | where {$_.TypeName.Equals("PowerPoint Service Application")}

14. $p.EnableSandboxedViewing = $false

15. $p.EnableSandboxedEditing = $false

Open c:\windows\system32\inetsrv\config\applicationHost.config file. Add the line below in the end of the dynamicTypes:

a. Run IISRESET

Download and install the Data Service 1.5 CTP

http://www.microsoft.com/downloads/details.aspx?FamilyID=a71060eb-454e-4475-81a6-e9552b1034fc&displaylang=en#filelist

Download and install Fiddler

www.fiddler2.com

Install Desktop Experience

a. Open the “Server Manager”

b. Click “Add Feature”

c. Check the following:

i. Desktop experience

d. Click “Next”

e. Click “Install”

Download and install Microsoft SilverLight

Download and install Microsoft Identity Framework

a. http://msdn.microsoft.com/en-us/evalcenter/dd440951.aspx

Download and install Microsoft Identity Framework SDK

http://www.microsoft.com/downloads/details.aspx?familyid=C148B2DF-C7AF-46BB-9162-2C9422208504&displaylang=en

Create the “Team Site”

Click “Application Management”
Click “Manage Web Applications”
In the Ribbon, click “New”
Ensure that ”Classic Mode Authentication” is enabled
For Port, type “100”
Under Application Pool, Select Create new Application Pool
For Name, type “SharePoint - ALL”
For security account, select “contoso\administrator”
For the database name, change to “wss_content_100”
Click “Ok”, your web application is being created:

i. NOTE: In Production, you should always type a meaningful name for your content databases!

Click the “Create Site Collection” Link
For Title, type “My Team Site”
For Template, Under Collaboration select Team Site
For Primary Site Collection administrator, type “Administrator”
Click “Ok”

Create the “Portal Site”

Click “Application Management”
Click “Manage Web Applications”
In the Ribbon, click “New”
Ensure that ”Classic Mode Authentication” is enabled
For Port, type “112”
Under Application Pool, Select “Use Existing Application Pool”
For Name, type “SharePoint - ALL”
For the database name, change to “wss_content_112”
Click “Ok”, your web application is being created:
Click the “Create Site Collection” Link
For Title, type “My Portal Site”
For Template, Under “Publishing” select “Publishing Site”
For Primary Site Collection administrator, type “Administrator”
Click “Ok”

Make the quicklaunch bar horizontal and add the following items to quicklaunch (you can do this by navigating to the respective program icon in the start menu, right click, Add To Quick Launch)

SharePoint Designer 2010
Visio 2010
Visual Studio 2010
SQL Server Management Studio
Visual Studio Command Prompt

i. Available under start->Microsoft Visual Studio 2010->Visual Studio Tools->Visual Studio Command Prompt

A Shortcut to the 14 hive
Enterprise library console
Services Applet

i. Available under Start->Administrative Tools->Services

IIS Manager

i. Available under Start->Administrative Tools->Internet Information Services (IIS) Manager

SharePoint Central Administration Console

i. Available under Start->Programs->Microsoft SharePoint 2010 Products->SharePoint 2010 Central Administration

SharePoint 2010 management Shell

i. Available under Start->Programs->Microsoft SharePoint 2010 Products->SharePoint 2010 Management Shell

Add C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN to the Path variable

Right click My Computer, select “Properties”
Click “Advanced system settings”
Click “Environment variables”
Under system variables section, click path, click Edit
Go to the end of the string append, “;C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN”

Uninstall bad programs

Click Start->Control Panel
Click “Programs and features”
Uninstall “Visual Studio 2010 Beta 2 Tools for SQL Server Compact ENU”
Uninstall “Microsoft SQL Server Compact *”
Restart the machine
Install SQL Server CE x86
Install SQL Server CE x64
Install SQL Server CE Server Tools x64
Reboot your machine

Download PDF File

SharePoint 2010 : Configure Outgoing e-mails on Windows Server 2008

2010-10-08T11:15:00.000+05:30

First, Configure our Server "Windows Server 2008":

Install SMTP Server
- From Administrative tools -> Server Manager

- click Add Feature and select SMTP Server

- you will need to add roles & features required for SMTP Server

- Wizard will continue the steps and finally, you will get this result

Configure IIS 7 & SMTP Email
- from Administrative tools -> Internet Information Services (IIS) Manager

- double click SMTP E-mail

Enter E-mail Address for sender e-mail address
Deliver e-mail to SMTP server: to deliver e-mail messages immediately. This requires an operational SMTP server for which the user has credentials(SMTP Server, Port and credentials)

Run SMTP Service Automatically
1.Click Start, point to Administrative Tools, and then click Services. 2.In Services, right-click Simple Mail Transfer Protocol (SMTP), and then select Properties. 3.In the Simple Mail Transfer Protocol (SMTP) Properties dialog box, on the General tab, in the Startup type list, select Automatic.

Second, Configure SharePoint 2010 from Central Administration or using STSADM
1- using STSADM:
stsadm -o email -outsmtpserver [server] -fromaddress [fromaddress] -replytoaddress [replytoaddress] -codepage [code]
2- using Central Administration:
from System Settings -> E-Mail and Text Messages (SMS) section -> Configure outgoing e-mail settings
in the Mail Settings section, type the SMTP server name, the From address mail,the Reply-to address mail, the appropriate Character set.

you can configure outgoing e-mail for specific web application using the following STSADM command:
stsadm -o email -outsmtpserver [server] -fromaddress [fromaddress] -replytoaddress [replytoaddress] -codepage [code] -url[weburl]

References:
http://technet.microsoft.com/en-us/library/cc263462.aspx#section1
http://technet.microsoft.com/en-us/library/cc772058(WS.10).aspx

Download JQuery Fundamentals Book and Examples

2010-10-07T10:35:00.000+05:30

Download JQuery Fundamentals Book and Examples

Bind Windows Default Countries to a DropDownList in ASP.NET

2010-10-07T09:59:00.000+05:30

How to get list of all countries and bind to a dropdown list in ASP.NET
Create an ASP.NET application and add a DropDownList to the page something like this.<asp:DropDownList ID="ddlCountry" runat="server"></asp:DropDownList>

Now call this GetCountryList method on your page load that will bind and display countries in the DropDownList.

public List GetCountryList()
    {
      List list = new List();
      CultureInfo[] cultures =
                  CultureInfo.GetCultures(CultureTypes.InstalledWin32Cultures |
                  CultureTypes.SpecificCultures);
      foreach (CultureInfo info in cultures)
      {
          RegionInfo info2 = new RegionInfo(info.LCID);
          if (!list.Contains(info2.EnglishName))
          {
              list.Add(info2.EnglishName);
          }
      }
      return list;
    }
ddlLocation.DataSource = GetCountryList();
ddlLocation.DataBind();
ddlLocation.Items.Insert(0, "Select");

Note: Updated attachement contains code for orderby the list using LINQ.

Solving problems with relational database

2010-10-06T11:18:00.000+05:30

Data Independence

For a large enterprise, there is a very large body of crucial information. These are the “crown jewels” of the information technology part of the company. This information lasts for the whole lifetime of the enterprise. But applications come and go, like migrating birds. The next application to come along might want access data in a different way, for important reasons. The structure of the database structure must adapt well to these new and changing demands.
With the older styles of data organization (called “network” or “CODASYL”, roughly speaking), sometimes the new application could not be done efficiently. Many times, for all practical purposes, it was impossible to write the application with acceptable performance. You can find the details of this in many books, but to give just one analogy: suppose you have a program with nested loops. In many cases (not 2D arrays), it’s pretty obvious which loop ought to be on the outside. Well, imagine if you forced to do it the other way, even if it made the program very much slower. And that’s just one example.
To solve this, we want data organization that can do two things. First, give every application a view of the database that doesn’t change over time, so that the application keeps working. Second, have a way to change the physical organization of the data without changing any of the software that uses the database system, which may be needed to make the new applications faster without hurting the old ones, or not hurting enough that it matters much. This is called “data independence.”

The Relational Model

A novel and effective solution to data independence, the “relational”, was created by E. F. Codd, in 1970. By representing data in relations, in normalized form, you can solve both of the above problems. I won’t go over all that here; I recommend “An Introduction to Database Systems” by C. J. Date.
(By the way, notice that the name of the book isn’t “… to Relational Database Systems,” even though that’s what the book is. Why bother with a superlative adjective, when “everybody knows” that all database systems, other than ancient ones, are relational?)
The relational model, as an abstract concept, is an excellent and brilliant solution to the data independence problem. Later we’ll see that that is not the only problem for which people want to store data. But in the next post, I’ll look into how well actual relational database systems implement the concept.