Thursday, 5 July 2012

How to Configure Excel Services in SharePoint 2010

In this post, I will show how to configure excel Services in SharePoint 2010.
Following are the steps to configure excel services

  1. Click Application Management
  2. Click Manage Service Applications
  3. Click Secure Store Services Applications
  4. Click on new and fill the necessary details as shown below

a. Target Application ID: SP2010ExcelServices

b. Display Name: SP2010ExcelServices

c. Contact Email:

d. Target Application Type: Group

e. Target Application URL: None and then click next.





5. Keep the default settings and click next




6. Fill the below details

a. Target Application Administrators: Domain\Administrator

b. Members: Domain\Domain Users and click ok.






7. Once the target application ID is created, Checked the checkbox next to SP2010ExcelServices and click on generate new key in the ribbon.


8. Enter the Pass Phrase


9. Once again checked the checkbox next to SP2010ExcelServices and click on set credentials in the ribbon.







10. Once again click Application Management, Manage Service Applications and then Excel Services Applications.

11. Click Global Settings, Scroll to the bottom of the page and in the Application ID field under external data, enter SP2010ExcelServices then click OK.

How to use SharePoint 2010 Chart web part with Excel Services

In this post, I will show how to use SharePoint 2010 chart web part with excel services to display various charts. Firstly we need to configure excel services on the SharePoint server.
To use excel services with chart web part, we need URL of the excel document and range of spreadsheet. Once we have these things, edit the page and insert chart web part to it. Click on Data & Appearance and then Connect Chart to Data.
Choose Excel services then screen with display and fill the excel workbook path and range of spreadsheet.
Excel web service URL should be already filled.
Excel workbook path: SiteURL/Shared%20Documents/Sales.xlsx
Range: Sheet1!$A$1:$B$6
Then click next.
Keep the default setting for remaining pages and then click finish.
Final output will be

How to use SPSecurity.Runwithelevatedprivileges Method in Sharepoint 2010

In this post, I will explain in which scenario we need to use SPSecurity.Runwithelevatedprivileges method in sharepoint customisation.
There are many times when we need our code to perform certain functions that current logged In user does not have permission to perform. The SPSecurity class contains Runwithelevatedprivileges method that allow to run code under full control prilvileges.
SPSecurity.RunWithElevatedPrivileges(delegate()
{
// Code
});
This delegate method run with elevated rights under the Application Pool identity which has site collection administrator privileges on all site collections.

Wednesday, 4 July 2012

History of SharePoint

Development of SharePoint has a long history and many pre products were created before actual product came to existence.

Pre-SharePoint
Before SharePoint 2003 arrived, in 1996 Microsoft launched a product called Microsoft Site Server for managing websites and the user's authentication/authorization. In 1998, Microsoft launched Site Server v 3.0 with following features:
• Indexing and Search
• Content Management
• Product Management
• Order Processing
• Site Personalization
• Ad Server

Site server was a low-cost product with good content management abilities but it lacked document management and taxonomical abilities.
In 1997, Microsoft came with Microsoft Office FrontPage, which had a HTML WYSIWYG editor, used to create and administrate websites. Microsoft launched the last version of FrontPage in 2003 and was having abilities to view code and design by supporting asp. NET.

Neither Site Server nor FrontPage provides the ability to integrate & collaborate different information such as videos, files, applications, and documents.
Earliest Versions of SharePoint
Two versions of SharePoint came out in 2001.
1. SharePoint Team Services (STS)
2. SharePoint Portal Server (SPS)

The SharePoint Team Services (STS) developed from the Microsoft FrontPage was considered a bottom’s-up technology that means creating websites were still left to end users. The websites created using STS supported a maximum of 75 users. STS was also known as Office webserver. SharePoint Team Services (STS) was intended as a departmental Intranet and used SQL Server as its backing store.

The SharePoint Portal Server (SPS) was developed from the Site Server, for site administrators. SPS is used to index and search files stored on STS.
There was still a clear disconnect between the STS and SPS. The move to integrate their functionality drove the development of SharePoint.
SharePoint 2003
Microsoft launched WSS 2.0 and SharePoint Server in 2003 separately.

Windows SharePoint service 2.0 was made freely available as a component with Microsoft windows server 2003. WSS 2.0 enables organizations to create websites and portals easily for information sharing and document collaboration.

SharePoint 2003 was considered the first integrated and comprehensive solution for sharing information, files, applications, and websites. It integrates the capabilities of the STS and SPS. It allows website & dashboard creation using easy user interface. SharePoint 2003 server is a licensed product. It provides all the features of WSS 2.0 and many additional features.

SharePoint 2003, stores the entire top-level site configuration and data in a single database. This limits the effective size that a site collection could grow; even backups and restores were time- consuming. The web parts (web parts are reusable components that display content on web pages) available were more compatible but they were very complex to create. Permissions were clumsy and difficult to maintain.

SharePoint 2007
Microsoft upgraded WSS 2.0 to WSS 3.0 by still keeping it as freely available.
Until now, end users started enjoying the experience of SharePoint and providing feedback with the demand of more and more new features. In 2007, Microsoft came up with the new product termed as “SharePoint 2007”. This product was in integration with the Microsoft base office user product called “Microsoft office,” so Microsoft termed this product as “MOSS 2007 [Microsoft Office SharePoint Portal Server 2007]. Moss 2007 integrates with windows server, SQL Server and the .Net Framework.
In the earlier versions of SharePoint, the primary site-editing tool was FrontPage that at least in theory could be used for other web creation projects as well. With SharePoint 2007, FrontPage was extensively updated and rebranded as Office SharePoint Designer. SharePoint Designer allowed easy customization of sites without needing to write any code. Microsoft Office SharePoint Designer 2007 is a new product for creating and customizing Microsoft SharePoint Web sites and building workflow-enabled applications. It provides the professional quality design tools that you need to create great-looking SharePoint pages that are compatible with a wide range of browsers.

SharePoint 2010
The hunger and desire to add more and more user-friendly features according to user needs continued and in April 2010, Microsoft came up with the latest version called “SharePoint 2010”. The technology WSS 3.0 is upgraded to “SharePoint Foundation Server”. Like WSS 3.0 Microsoft continued its practice to keep the technology SharePoint foundation server as free version. SharePoint latest versions 2010 centers its focus on the Sites, Communities, Content, Search, Insight, and Composite.

Office SharePoint Designer 2007 was upgraded to SharePoint Designer 2010. Microsoft designed SharePoint 2010 as a 64 bit Product. The two main reasons behind this are:
1. Improving the performance
2. Flexibility

Feel free to ping at yusuf.talk786@gmail.com, in case of any queries.

Why this Kolavari Di

"Why this SharePoint SharePoint SharePoint di"

ALL Developers, Architects, Administrators and SharePoint Users
I am appraising SharePoint –u-Web Application Platform-u
Future collaboration Platform-u

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

Rhythm correct……
Why this SharePoint SharePoint SharePoint di
maintain please
Why this SharePoint..di

Microsoft la-u- solution for –u-creating Internet Site-u
Easy UI-u-Ribbon Toolbar-u-u-Publishing feature-u
Instant Mobile-u-Expand Reach-u- Customer retention-u
And Drive Revenue
For Any Domain

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

Microsoft la-u- solution for –u-creating Intranet Site-u
Communities-u-Content-u-Insight-Search-u-and-u-Composite-u-Sites-u
DMS, CMS-u-RMS-u-Team Site, Template-u
Large Storage, Faster Search-u
With
Future bright

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

Pa pa pa ppaan, pa pa pa ppaan, pa pa pa ppaan pa pa ppan
Ok NOW

Developers ready--Ready 1 2 3

.Net Customization

Wat what a coding in .Net

Only SharePoint...

Ok developers now tune change-u

SharePoint 2010 -u- Object Model-u
With SOA Architecture
Site Collection –u-Sub Site-u-Templates-u-MySite-u
List Library, Document Library, -u-web parts –u- solution, Features-u
O-Work-u-flow-u-u-with Dashboards, KPI`s-u
lovvu lovvu
Oh my lovvu
SharePoint showed Future-u

God, .net developers-u-losing control now-u
Tempted to learn SharePoint anyhow-u

This song is for .Net developers -u
Don’t have choice now-u

Why this SharePoint SharePoint SharePoint di
Why this SharePoint SharePoint SharePoint di

*Objective is to create more awareness about SharePoint.

Download SharePoint 2010 Interview Capsule

This book is free for Download for our dear users. Download a Free copy of SharePoint 2010 Interview Capsule ebook from

SharePoint2010 Interview capsule-wp