Sharing SharePoint Knowledge

Technical Solutions for SharePoint Server 2010

Archive for June, 2010

Microsoft TechEd 2010 SharePoint Sessions

Posted by Chandrasekaran C N on June 21, 2010

Hi All,

Here is the consolidated list of all SharePoint related sessions that were held at Microsoft TechEd 2010, North America.

Microsoft TechEd 2010 – SharePoint 2010 Sessions
Session Details
Code OSP301
Title Building RIA with Silverlight and SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP301
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP301.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP301.wmv
   
Code OSP302
Title Building Solutions with Business Connectivity Services
Session http://www.msteched.com/2010/NorthAmerica/OSP302
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP302.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP302.wmv
   
Code OSP303
Title Deploying and Upgrading to Microsoft Project Server 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP303
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP303.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP303.wmv
   
Code OSP304
Title Developing and Branding with the New User Interface Features in Microsoft SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP304
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP304.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP304.wmv
   
Code OSP305
Title Developing Document Sets in Microsoft SPS 2010 Enterprise Content Management
Session http://www.msteched.com/2010/NorthAmerica/OSP305
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP305.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP305.wmv
   
Code OSP306
Title Developing Microsoft SPS 2010 Solutions with Claims Authentication
Session http://www.msteched.com/2010/NorthAmerica/OSP306
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP306.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP306.wmv
   
Code OSP307
Title Developing Office Business Applications with Microsoft Office 2010 and Microsoft SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP307
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP307.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP307.wmv
   
Code OSP308
Title Developing with Microsoft SPS 2010 Sandboxed Solutions
Session http://www.msteched.com/2010/NorthAmerica/OSP308
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP308.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP308.wmv
   
Code OSP309
Title Developing with REST and LINQ in Microsoft SharePoint 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP309
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP309.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP309.wmv
   
Code OSP310
Title Fine Tuning Your Microsoft SPS 2010 Environment
Session http://www.msteched.com/2010/NorthAmerica/OSP310
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP310.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP310.wmv
   
Code OSP311
Title From N to Z: Authentication and Authorization in Microsoft SPS 2010 
Session http://www.msteched.com/2010/NorthAmerica/OSP311
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP311.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP311.wmv
   
Code OSP312
Title Help! My Users Are Everywhere: Designing (Developing) for a Global SharePoint Audience 
Session http://www.msteched.com/2010/NorthAmerica/OSP312
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP312.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP312.wmv
   
Code OSP313
Title Microsoft Office 2010: Developing the Next Wave of Productivity Solutions
Session http://www.msteched.com/2010/NorthAmerica/OSP313
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP313.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP313.wmv
   
Code OSP314
Title Microsoft Outlook and Exchange 2010: Better Together Overview
Session http://www.msteched.com/2010/NorthAmerica/OSP314
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP314.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP314.wmv
   
Code OSP315
Title Microsoft SPS 2010 As a Social Computing Platform 
Session http://www.msteched.com/2010/NorthAmerica/OSP315
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP315.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP315.wmv
   
Code OSP316
Title Microsoft SPS 2010 for the Microsoft ASP.NET Developer
Session http://www.msteched.com/2010/NorthAmerica/OSP316
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP316.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP316.wmv
   
Code OSP317
Title Outlook Social Connector: Deployment and Development Overview
Session http://www.msteched.com/2010/NorthAmerica/OSP317
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP317.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP317.wmv
   
Code OSP318
Title SharePoint is Down: Solutions for High Availability and Disaster Recovery
Session http://www.msteched.com/2010/NorthAmerica/OSP318
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP318.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP318.wmv
   
Code OSP319
Title Upgrading and Improving MOSS WCM Sites to SOS 2010 Web Content Management
Session http://www.msteched.com/2010/NorthAmerica/OSP319
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP319.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP319.wmv
   
Code OSP320
Title Workflow Development in Microsoft SPS 2010 with Microsoft Visual Studio 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP320
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP320.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP320.wmv
   
Code OSP321
Title Microsoft IT: How MSIT Upgraded Microsoft to SharePoint 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP321
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP321.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP321.wmv
   
Code OSP401
Title Upgrading Microsoft Office SharePoint Server 2007 to SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP401
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP401.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP401.wmv
   
Code OSP402
Title Windows PowerShell Made Less Scary for the Microsoft SPS 2010 Administrator
Session http://www.msteched.com/2010/NorthAmerica/OSP402
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP402.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP402.wmv

Thanks,
Chandrasekaran C N

Posted in SharePoint, SharePoint 2010 | Tagged: , | Leave a Comment »

SharePoint MVP Experts Chat – Q & A

Posted by Chandrasekaran C N on June 20, 2010

Hi All,

Any questions on SharePoint? Join live chat with SharePoint MVP Experts online on 23rd of June 2010 between 9:00 am and 10:oo am PST  (21:30 pm and 22:30 pm IST)

So start preparing questions 🙂

Thanks,
Chandrasekaran C N

Posted in Chat, SharePoint | Tagged: , | Leave a Comment »

No Code Solution: Connecting to external systems using BCS and SharePoint Designer

Posted by Chandrasekaran C N on June 17, 2010

Hi All,   

Microsoft SharePoint is a powerful tool to interact with external system such as SQL Server, SAP, Sibel, Oracle, etc., from MOSS 2007. But there are certain limitations in MOSS 2007 like  

  • Read-only access to external systems
  • No intiutive ways to create application definition file (XML)
  • Possible error-prone due to manual creation of XML file

With the latest version of SharePoint 2010, the limitations aforesaid has been addressed and new functionalities are also included.   Microsoft SharePoint Designer 2010, the successor of SharePoint Designer 2007, is used to create no code solutions that interact with external systems with all sets of CRUD operations.  

Interactions between the SharePoint 2010 and external systems is made possible using the new feature called “External Content Types” (ECTs).  An external content type is a special content type contains all the metadata that helps to access the external systems.  External content type is something similar to “Entities” in business data catalog (BDC).  

As we know, in SharePoint 2010 there a lot of services introduced, one of them is Business Connectivity Services (BCS) which uses the external content type to interact with external systems.  

To view all the external content types available in SharePoint 2010, go to Central Admin -> Manage Service Application -> Business Connectivity Services  

Fig1: Existing External Content Types

Okay. Now we will start creating a no code solution to interact with the external systems in SharePoint Designer 2010. We will split this walkthrough into sections so that it will easy to follow Section 1: Creation of External Content Type 

  1. Open up the SharePoint Designer (SPD) 2010 and select the site you want to create external content type
  2. In the left hand navigation panel, select External Content Type option. This will show up all the existing external content types, if available
  3. On the ribbon menu, select New External Content Type as shown in the diagram below

Fig 2: External Content Type creation in SPD 2010

Once we created the external content type, it will ask to fill some basic information such as Name, display name, etc., about the content type as shown below  

Fig 3: Basic Information about External Content Type

One important option we need to fill is Office Item Type. There are five different options available namely  

  • Generic List   
  • Appointment
  • Contact
  • Task
  • Post

In this case, we select “Generic List” office item type that maps to a SharePoint custom list.  

Section 2: Connect to Datasources  

Once section 1 is finished, we need to configure the connection to the datasources. In Fig 3, click on the link (arrow marked) to configure the data connection. This will open up the screen below to configure the data connection  

Fig 4: Configure Data Source Connection

In the above diagram, click on the Add Connection button, this will popup a window asking which type of connection we want to connect to. Those are  

  • .NET Type – Use to connect to any custom .NET component
  • SQL Server – Use to connect  to existing SQL Server database
  • WCF Service – Use to connect to WCF Service

Fig 5: Data Connection Types

Select SQL Server type and click ok to continue.  

Provide the SQL Server information and select ok to continue in the SQL Server Connection window as shown below.  

Here in this window there are three different options on how to connect to SQL Server  

  • Connect with User’s Identity – Indicates to connect to SQL Server with current user identity
  • Connect with Impersonated Windows Identity – Indicated to connect to SQL Server with impersonation of other’s windows identity
  • Connect with Impersonated Custom Identity – Indicates to connect to SQL Server with impersonation of other’s custom identity (non-windows identity such as SQL Server identity or some other)

Last two options are mainly depends on the Secure Store Service configuration, which is configured in the SharePoint central administration and it is similar to Single Sign-On in MOSS 2007.  

Configuration of Secure Store Service is out of scope in this post. May be I will post later sometime on how to configure the same.  

Section 3: CRUD Operations  

After finish providing the SQL Server information, it will connect to database and shows up the provided database instance as shown in the above diagram (Fig 4). In this case it is “AdventureWorks”.  

Expand the AdventureWorks to select the database objects such as Tables, Views, etc.,  Select any table you want to show up in the external list and right click the table name to define the operations we want to perform like create,update, etc.,  

Fig 6: CRUD Operations

In the above diagram, there are several operations available to define. In this walkthrough, we select “Create All Operations” meaning we need to perform all CRUD operations on this table.  

Once we select the above operations, SPD opens a wizard like dialog to configure additional parameters on the data source such as limiting the data to pull from external data sources at a time, to provide filter conditions, etc.,  

Below screenshots show how we provide the necessary information in order to complete the wizard.  

Fig 7: Startup Wizard

   

Fig 8 : Parameter Settings

   

Above diagram shows the parameter configuration, we can set which column should be read only, required, etc., One of the  property we need to focus is “Office Property”. This property needs to set for each column, if we select the office item type in Fig 3 apart from “Generic List”.  

Fig 9: Filter Settings

Following steps describes on how to provide filter conditions

Click on “Add Filter Parameter” button

Select the data source element for which we need to provide filter condition in the above diagram

Click on Filter option (Click to Add) to open the dialog box as shown in the below diagram

Fig 10: Filter Condition

  • In the above diagram, select filter type as “Limit” and Filter Field as “WorkOrderID” and click ok.
  • Provide any default value for the limit and in this case it is 100 as shown in the above diagram.
  • Finish the wizard by clicking the finish button and save the content type in the SPD.
  • After saving the external content type, you can view the created ECT in the “Business Connectivity Services” section in the central administration

    Fig 11: Created ECT in Central Administration

    Now we can able to create the external list in SharePoint site. Below screenshot shows how to create external list in SharePoint site. It is very similar to normal custom list creation except we need to select which external content we need to use for this list.

    Fig 12: Create External List

      

    Section 4: Assigning Permissions 

    In order to view the data in the SharePoint external list, we need to provide necessary permissions to the external content type. Below steps show on how to assign permissions to the external content type

    • Go to Central Admin -> Application Management -> Manage Service Applications
    • Select Business Connectivity Service option
    • Select the external content type to which we need to provide permissions
    • Select “Set Object Permissions” option as shown in the below diagram

    Fig 13: ECT Permissions

     Select the user and assign permissions to the selected user as shown in the below diagram

    Fig 14: Assign Permissions to ECT

    Click Ok to set the permissions. Now we are able to view the external data in the  SharePoint list with no code.

    Fig 15: External List with Data

    Now, it is very easy to interact with external system using BCS and SharePoint Designer with no code.

    Thanks,
    Chandrasekaran C N

     

    Posted in BCS, SharePoint 2010 | Tagged: , | Leave a Comment »

    Events Improvements in SharePoint 2010

    Posted by Chandrasekaran C N on June 7, 2010

    Hi All,

    In MOSS 2007, there are a lot of events introduced by Microsoft such as list item events, list events, field events, etc., which are very useful to execute some tasks on the lists based on the user inputs. But there are some limitations in the event model in MOSS 2007, which are necessary for the developers. To overcome those limitations developers need to do some workarounds.

    Following are some of the limitations

    • Cannot hook the events to a particular SharePoint lists
    • Need to use standard pre-defined error page when canceling the events, which is not so intuitive for the end users
    • No javascript alert instead of redirecting to pre-defined error page
    • No events for SPWeb object

    Microsoft addressed some of the limitations and also introduced new events in SharePoint 2010. Here are the list of events introduced in SharePoint 2010

    Name of the events Description
    WebAdding Synchronous event, fired before the web is added. Some of the properties such as URL will not be visible in this event, since the web is not yet created
    WebProvisioned Either synchronous or asynchronous after-events fired after web is created. We can make this event either synchronous or asynchronous by setting the Synchronization property to either Synchronous or Asynchronous respectively. This property is in elements.xml under <Register> node
    ListAdding Synchronous event, fired before a list is created. 
    ListAdded Either synchronous or asynchronous after-events fired after list is created before it is presenting to the user.
    ListDeleting  Synchronous event, fired before a list is deleted.
    ListDeleted Either synchronous or asynchronous after-events fired after list is deleted.
    These events are created by using the same procedure as we creating events in MOSS 2007. Using Visual Studio 2010, developers are able to write,  deploy and debug these events in SharePoint server easily. Visual Studio 2010 provides a pre-defined project templates to create event receivers.
     
    Enhancements in SharePoint 2010
     Custom Error Pages: SharePoint 2010 provides developers to create/redirect to custom error pages when the events are cancelled.  This gives developers a great flexibility to provide more information on the custom error pages.  The redirection will applicable only for the pre-synchronous events and not for post-synchronous events like ListAdded, etc.,  Below shows the code snippets to redirect to custom error page
               properties.Cancel = true;
               properties.Status = SPEventReceiverStatus.CancelWithRedirectUrl;
               properties.RedirectUrl = "/_layouts/CustomErrors/error.aspx";
     
    Event Registration Feature: With new event registration enhancement, developers are able to hook the event to a particular SharePoint list in the elements.xml file using ListUrl node by passing relative url of the list.  Developers are now able to scope the events either at Site or Web levels and also set the property RootWebOnly in Receivers node, if the event receiver only works for root site.
    Impersonation Improvements:  Developers are able to elevate the privileges in the event receivers in order to perform some tasks, which current user who triggered the event does not have adequate permissions to do so using SPSecurity.RunWithElevatedPrivileges method.  In SharePoint 2010, there are new properties namely OriginatingUserToken, UserDisplayName and UserLoginName which help the developers to revert back to the original user who triggered the event very easily.
    Thanks
    Chandrasekaran C N

    Posted in Event Model, SharePoint, SharePoint 2010 | Tagged: , , | Leave a Comment »

    Microsoft SharePoint 2010 Development – Book

    Posted by Chandrasekaran C N on June 7, 2010

    Hi All,

    First book on SharePoint 2010 development has been published by Wrox. This book has been written by great authors Tom Rizzo, Reza Alirezaei, Jeff Fried, Paul Swider, Scot Hillier, Kenneth Schaefer.

    To grab this book, visit to Wrox site

    Thanks
    Chandrasekaran C N

    Posted in Book, SharePoint 2010 | Tagged: , , , | Leave a Comment »