Monday, June 1, 2009

SharePoint public facing web sites discovered in February

Site Industry
Marktvergleich Financial
Microsoft Office Labs Technology
DakStats Technology
Community Reinvestment Fund Financial
Inetium, LLC MS Certified Partners
Evonic Eastern Europe Industrial
Financial Regulator Ireland Financial
XBRL US Charity/Club/Community
Department of Social and Family Affairs Ireland Government
Western Australia’s Golden Outback Entertainment
West Coast TAFE Education
Halton District School Board Education
CMS Legal Services Professional Services
Votorantim Group Charity/Club/Community
Sacred Heart Hospital Health
Etihad Airways Transportation
CCH Wolters Kluwer Professional Services
Group Scotiabank Financial
Confagricoltura Other
American Association of Community Colleges Education
Clovis Government
Inland Empire Consortium Charity/Club/Community
Eveleth-Gilbert Public School District Education
Haugh Performing Arts Center Entertainment
Prontaprint Retail
Indiana Institute of Technology Education
Cable ONE Entertainment
LaSalle Investment Management Financial
Jones Lang LaSalle Financial
Los Alamos County Government
National American University (NAU) Education
Datapolis MS Certified Partners
If you know of any others, please let me know by using this form http://www.wssdemo.com/pages/comments.aspx
Please check the full list of sites first http://www.wssdemo.com/Pages/websites.aspx

Refrence..

Ian's SharePoint Blog

Custom SharePoint display item pages per content type

[Updated with more detail] My list of over 1,800 SharePoint resources uses content types to distinguish the metadata that is relevant to each type of resource (article, blog, download etc.)

If the content type is KB Article, I wanted the default display item page to be customised to render the Microsoft KB Article page in an iFrame within the list item page.
A list with content type management enabled has a folder per content in which you can place views. This helps organize all the content type specific forms (Display item, New item and Edit item) into folders.

Views created in the content type folders are not shown in the default list views drop-down

You can then specify the default item view per content type by right-clicking on the list folder in SharePoint Designer and select properties to set the supporting files value for the Display item form

Even though a url might link to the default page e.g. http://www.wssdemo.com/Lists/Resources/DispForm.aspx?ID=1534
it will redirect to the custom page automatically (try it...)

My custom view page uses a Data Form web part to display a single item.

To create this in SPD, just right click on the List name and select New/List View Page.

Edit the new view, delete the List View web part and insert a Data Form as a "Single Item View" of the list
Insert Data View

Select the list item for which you are creating the view and select "Show Data" from the drop down
Data View Single Item

The web part is filtered by the ID Parameter that will be included on the URL.

Create the Parameter from the Data View properties
Data View Parameter

Then create a filter for the Data View
Data View Filter

and substituted the row view template code withing the DAta View web part for this...

You can include this CSS style in the page to resize the iFrame height to match the current browser height (- sharepoint chrome height).



Refrence::http://www.wssdemo.com/Blog/default.aspx

The My Links Web Part – It’s Not Just for My Sites #sharepoint

If you aren’t familiar with My Links, it’s a great place to store those things you might normally store in your Internet Explorer Favorites or Firefox Bookmarks. The advantage to using My Links is that they are always available to you anywhere you are logged into SharePoint. So, if you log in on a different computer, your links are there. And the links can go anywhere; they don’t have to be links to SharePoint locations. Here is a screenshot of how My Links is usually accessed in SharePoint.
image

Yesterday, just for fun, I decided to try an experiment; and my experiment worked! I added a My LInks web part to my My Site. Then I exported it and saved it to my desktop.
image

Next I went to the home page of my portal, made the page editable, and clicked on Add a Web Part for one of the web part zones. I closed the Add Web Parts dialog by clicking on the link at the bottom for the Advanced Web Part gallery and options. This opened the Add Web Parts Tool Pane in the right-hand side of my browser. At the top I clicked on the down arrow beside Browse and selected Import.
image

I browsed to and selected the My_Links.dwp web part I had saved to my desktop and clicked the Upload button.

1

To finish, I just drug the My Links web part where I wanted it on the page and published the page. All my links were then showing up on the page and as I logged in as different test users, their links showed up as well, as expected.

image


refrence::http://sharepointsolutions.blogspot.com/

Calling the SharePoint Web Services with jQuery

If you read this blog you probably know that besides the web user interface, SharePoint also exposes some interfaces which you can use from code: the SharePoint object model and the SharePoint web services. The object model of SharePoint can only be used by code/applications that are running on a SharePoint server in your Server Farm, so you can’t use the object model on client machines. The SharePoint web services can be used of course across a network boundary, that’s what they are built for! In this post I’m going to show you how you can access the out-of-the-box SharePoint web services by making use of the jQuery Javascript library. First let’s see what you can do with this technique: download this zip file that contains an ASPX page (a basic Site Page without any code behind), and the jQuery Javascript library (in case you don’t have it already). Upload the two individual files (not the zip file) in the root of a Document Library in any of your SharePoint sites. You can do this by making use of the web user interface; you don’t have to touch anything on the server itself. When done, just click on the link of the uploaded ASPX and you’ll see following page:



Probably you’re not really impressed but think about the fact that this page is just an ASPX file you’ve uploaded through the web user interface, there is absolutely no code behind involved (which would have been blocked by SharePoint’s default security settings). The details of the SharePoint lists are loaded by making use of Javascript code that calls the web SharePoint lists.asmx web service.

So how do you call a SharePoint web service in Javascript code; well you can use the XmlHttpRequest object and write lots of boring code, or you can make use of a Javascript library that wraps this XmlHttpRequest object and exposes a nice and easy interface. In this demo I’ll use the jQuery Javascript library, so the first thing that you’ll need to do is to make sure the page is loading that library:

If you already configured your SharePoint site so the jQuery library is loaded (for example by making use of the SmartTools.jQuery component), you can skip this line of course.

When the page is loaded, the Lists web service (e.g. http://yoursite/_vti_bin/lists.asmx) of SharePoint needs to be called; this can be accomplished by making use of the jQuery’s ajax method. This method can post the necessary SOAP envelope message to the Lists web service. The XML of the SOAP envelope can easily be copied from the .NET web service test form of the desired web method (e.g. http://yoursite/_vti_bin/lists.asmx?op=GetListCollection). In the code below, a call to the GetListCollection web method is made when the page is loaded. The complete parameter of the ajax method is actually a pointer to another Javascript function (which we’ll implement later on) that will be called asynchronously when the web service call is done. Don’t forget to update the url parameter with your SharePoint site’s URL!

$(document).ready(function() {
var soapEnv =
" \
\
\
\
\
";

$.ajax({
url: "
http://yoursite/_vti_bin/lists.asmx",
type: "POST",
dataType: "xml",
data: soapEnv,
complete: processResult,
contentType: "text/xml; charset=\"utf-8\""
});
});

As I already mentioned, the processResult function is called when the response XML of the web service call is received. In this method a loop is created which will iterate over every List element of the response XML. For every List element a

  • element is added to the element with the ID attribute set to data.

    function processResult(xData, status) {
    $(xData.responseXML).find("List").each(function() {
    $("#data").append("

  • " + $(this).attr("Title") + "
  • ");
    });
    }

    This data element is the actual

      list in HTML:

        When you put everything together in a Site Page, this is the result:



        In the zip file mentioned in the beginning of this post, you can find an extended version of the processResult function which will display some additional metadata for every list (like the ID, ItemCount etc). The entire contents of basic version of the Site Page built in this post goes as follows:

        <%@ Page Language="C#" MasterPageFile="~masterurl/default.master" %>






          List Details


          List Details


          Refrence::

          Jan Tielens' Bloggings

          MSDN SharePoint Classes

          Here is the list of the SharePoint classes that I have documented on MSDN, Enjoy!

          Microsoft.SharePoint.SPSecurity.SPOperationCode

          MSDN link

          Microsoft.SharePoint.Administration.SPAdministrationServiceJobDefinition

          MSDN link

          Microsoft.SharePoint.Administration.SPJobDefinitionCollection

          MSDN link

          Microsoft.SharePoint.Administration.SPRunningJob

          MSDN link

          Microsoft.SharePoint.Administration.SPRunningJobCollection

          MSDN link

          Microsoft.SharePoint.Help.SPHelpMerge

          MSDN link

          Microsoft.SharePoint.WebControls.BackLinksIterator

          MSDN link

          Microsoft.SharePoint.WebControls.BaseXmlDataSource

          MSDN link

          Microsoft.SharePoint.WebControls.ContentDatabaseSection

          MSDN link

          Microsoft.SharePoint.WebControls.ContentDatabaseSectionMode

          MSDN link

          Microsoft.SharePoint.WebControls.DataTableDataSourceView

          MSDN link

          Microsoft.SharePoint.WebControls.DiffSelectorIterator

          MSDN link

          Microsoft.SharePoint.WebControls.GroupPermissions

          MSDN link

          Microsoft.SharePoint.WebControls.IDesignTimeHtmlProvider

          MSDN link

          Microsoft.SharePoint.WebControls.IFormDelegateControlSource

          MSDN link

          Microsoft.SharePoint.WebControls.InputFormCheckBox

          MSDN link

          Microsoft.SharePoint.WebControls.ItemHiddenVersion

          MSDN link

          Microsoft.SharePoint.WebControls.IXPathNavigator

          MSDN link

          Microsoft.SharePoint.WebControls.LinkSection

          MSDN link

          Microsoft.SharePoint.WebControls.LinksTable

          MSDN link

          Microsoft.SharePoint.WebControls.ListViewSelector

          MSDN link

          Microsoft.SharePoint.WebControls.MenuSeparatorTemplate

          MSDN link

          Microsoft.SharePoint.WebControls.RadioButtonChoiceField

          MSDN link

          Microsoft.SharePoint.WebControls.RecentChangesIterator

          MSDN link

          Microsoft.SharePoint.WebControls.RepeatedControls

          MSDN link

          Microsoft.SharePoint.WebControls.ServerSelector

          MSDN link

          Microsoft.SharePoint.WebControls.SiteAdministrationSelector

          MSDN link

          Microsoft.SharePoint.WebControls.SiteActions

          MSDN link

          Microsoft.SharePoint.WebControls.SPSqlDataSource

          MSDN link

          Microsoft.SharePoint.WebControls.SPXmlDataSource

          MSDN link

          Microsoft.SharePoint.WebControls.SubMenuTemplate

          MSDN link

          Microsoft.SharePoint.WebControls.VersionDiffIterator

          MSDN link

          Microsoft.SharePoint.WebControls.WebApplicationSelector

          MSDN link

          Microsoft.SharePoint.WebControls.XmlUrlDataSource

          MSDN link

          Refrence ::http://blogs.devhorizon.com

          SSRS 2008 Add-in for SharePoint

          Unless you are living under the rock , you’d probably know that since SQL Server 2005 SP2 time frame , you can configure a deployment of SQL Server Reporting Services to work with a deployment of SharePoint - known as SSRS 2008 installation in SharePoint Integrated mode. In the first attempt to combine their Business intelligence and Information Portal technologies together and by releasing SQL Server 2005 SP2 , Microsoft brought two very interesting technologies together and opened up a world of interest to many people including myself . When I first read about SP2 , I was like wait a minute, this is awesome! Both products that I had been really passionate about for years now are getting much closer! Needless to say that I’ve always appreciated the efforts Microsoft has put into making the technology , geekyness and weirdness around it transparent to the vast majority of people out there.

          When SQL Server 2005 SP2 was released , MS really demonstrated that not only do they listen to their customer feedback, they also care so much about developers and to make their life easier. For example , in the context of SharePoint and SSRS integration , now you can potentially hire a report developer,they can build the reports (in much easier way) and publish them into SharePoint and basically hand them over to the user community and business users. From here , they can take the wheel, manage and interact with these reports (high level) without having to know what the hell is going on under the hood! Isn’t that amazing that how two completely different technologies can be combined to make things much easier for everyone? Remember, easier something is, more people will use it. More people use it, more popular you’ll become! Microsoft ,for sure, has proved that they’ve learned this very simple rule of life…

          The only thing that tipped me over the edge at that time was when I first attempted to bring the the best out of both products in a “real” integration project with a very “difficult-to-get-along” kind of client! (I still have the nightmare of those two days) . I really don’t want to talk about those issues here , but what made it difficult for me was no proper documentation , no active community around both products and , to an extend, the immaturity of the integration . Things certainly have changed since then and obviously I’ve learned my “integration” lessons as well! Not that I don’t face any issues these days, but nowadays it’s much easier to find an answer - and yes , I find the answers to the majority of my questions in the blogs of those who are blessed and willing to SHARE their POINTS with the rest of the world!

          When SQL Server 2008 and SSRS 2008 was RTMed , I didn’t make the same mistake I had made back in 2005 :) . I decided to to gain some home-based lab experiences before I go live with this in real engagements (Didn’t I just tell you that I learnt my integration lessons? ;) ) Surprisingly, every installations I had at my home-based farms from a single stand-alone installation to a scale-out SSRS along with a large SharePoint Server farm went really smooth without big stucking points. Documentation around the integration is much better this time around, but I am still not happy by the coverage of SSRS 2008 and SharePoint integration by MS people and community! Let’s hope it gets better soon.

          Speaking of SSRS 2008 Add-in for SharePoint, here is one question that I frequently get asked :

          I have configured report server in SharePoint integrated mode. I have installed SharePoint Web front-end components on the report server computer.I have downloaded and installed the Reporting Services Add-in for SharePoint Technologies on my other Web front-end servers (including the one that hosts the Central administation site) , but Reporting Services section doesn’t appear in the Central Administration site;therefore I cannot complete the integration. Where did it go?

          Well , the answer is : You need to activate a site collection-scoped feature called Report Server Integration Feature on the Central Administration site.

          CentralAdminReportServerIntegrationFeatureAtSiteCollectionLevel

          This feature has two different behaviors when gets activated on Central administration site than other sites. When activated on the Central administration site , the feature does all of the things it does for other type of sites , plus it adds a section called Reporting Services under the Application Management. This section must be used to make sure SharePoint is aware of my SSRS instance existence. Here is where the fun part starts :) .

          There are three options in this section:

          SSRSCustomSectionCentralAdmin

          1. Grant Database Access: First you need to specify the server which hosts reporting services database, whether it is on a default or named instances. Essentially what happens here is that the Report Server endpoint and Windows service accounts for that instance (named or default) will be granted required access to the SharePoint databases. During this process, the Report Server service will be restarted. This is an essential step in integration.
          2. Manage integration settings : You need to specify Report server URL and the authentication. Pretty straightforward.
          3. Set Server Defaults :You set all of your basic defaults. This page contains all of the things you’d normally use Reporting Services Configuration tool to configure them, but they are now managed via SharePoint tier. For example making sure that all data sources use integrated security, so on and so forth. Ad-hoc reporting is also a powerful feature which can be set and controlled from here.

          There is one more action that Reporting Services Add-in for SharePoint Technologies performs on the Central Administration site which is provisioning SSRS integrated help content in the HelpFold folder:

          HelpFolder

          The add-in also installs some application pages, including pages that you open in Central Administration to set the report server URL and other integration settings in Central Administration and other sites.

          ReportServerLayoutPictures

          In addition to the application pages , the Proxy endpoints are also placed in the 12\ISAPI\ReportServer folder. As you can tell , all of the Reporting Services Proxy endpoints are nicely virtualized and context aware (note wsdl and disco aspx file for each Web service). This means that no matter how deep you are in each site collection , these endpoints are always accessible via a call to the respective asmx file - for example http://mysite/_vti_bin/ReportServer/ReportServer2006.asmx or http://mysite/subsite1/…../subsiteN/_vti_bin/ReportServer/ReportServer2006.asmx.

          More on SSRS Proxy endpoints in the Integrated mode can be found here.

          ISAPI Files

          A quick list of proxy endpoints here:

          1. ReportService2006.asmx : Proxy endpoint to support SharePoint Integrated mode. New functionalities such as Data Driven subscriptions are added to this endpoint.
          2. ReportExecution2005.asmx : Execution endpoint. New functionalities such as On demand load (a.k.a pagination) is added to this endpoint.
          3. As you can tell , ReportService.asmx (SSRS 2000 SOAP endpoint) which was deprecated in 2005 , now is removed and no longer supported!
          4. ReportService2005.asmx: Proxy endpoint to support Native mode (not in this picture- I hope you know why :) )

          All right , let’s just go ahead and see what happens to non-Central admin sites :

          First of all , the same feature that we just activated in the Central administration site appears on every site collection meaning that if you want to have the Reporting Services integration , you need to activate this on each site collection:
          ReportServerIntegrationFeatureAtSiteCollectionLevel

          Once you activate this feature , the following things will be added to your site collection:

          Required content types:

          ReportsContentType

          Report Viewer Web part:

          ReportViwerWebPart

          A section in the Site Settings for managing shared schedules :

          Site Settings

          Obviously if you want to be able to store your reports in a Report Library and your data sources in Data Connection Library , you need to enable another web-scoped “Office SharePoint Server Enterprise Site features” feature to get Report Library and Data Connection Library in the create page. This has nothing to do with SSRS Add-in though !

          EnterpriseFeaturesAtSiteCollectionLevel

          That’s all about it! I hope this blog post can help you verify your SSRS 2008 installation in integration mode.

          refrence::

          Reza Alirezaei’s Blog

          Integrating SharePoint 2007 and jQuery


          In the first part of this article I'll talk about how you can enable the jQuery JavaScript library in SharePoint 2007 sites and pages. The second part of this article will focus on using jQuery in SharePoint 2007 sites and pages.

          When I was at PDC’08, I attended a session about the jQuery JavaScript library (watch online). A few weeks before that Scott Guthrie announced that Microsoft would support, and even ship jQuery together with Visual Studio, along with Microsoft’s own AJAX implementation: ASP.NET AJAX. If you’ve never heard about jQuery, I defenitly recommend you to to check it out, there are some great tutorials available. The defenition of jQuery reads: "jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript." In my opinion jQuery is great because it simplifies a lot the JavaScript that you have to write if you’d like to do fancy AJAX stuff, selecting HTML elements for example is a breeze. Secondly jQuery has a big community that develops plugins for various scenarios. I already wrote and talked quite a bit about integrating ASP.NET AJAX with SharePoint 2007, so let’s check out how you can integrate jQuery as well!

          First things first: you need to get the jQuery library from the official website. It comes in three varieties: uncompressed (with debug information, use it while you develop), packed (smaller, use it for production) and minified (needs to be uncompressed at the client, so slower but even smaller). The jQuery library is just a JavaScript (JS) file, so it can be loaded from any web page (html, aspx, etc). If you’d like to have IntelliSense when writing code in Visual Studio 2008 for jQuery (highly recommended of course), you need to download a Visual Studio hotfix. Now you’re good to go to make use of jQuery in your development environment.

          Before I show you some things you can accomplish with jQuery in your SharePoint sites, let’s think about how we can make the jQuery library available on the ASPX pages of our SharePoint sites. There are two things that need to be done: first the JS file (the library itself) should be deployed to a location which can be accessed by SharePoint pages, secondly the library should be loaded by the SharePoint pages.

          Deploying the jQuery JS file is quite easy: I recommend deploying it to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS folder on every Front End Web Server of your SharePoint Server Farm. By doing so, the file can be loaded by making use of the URL http://yoursite/_layouts/ jquery-1.2.6.min.js or http://yoursite/subsite/_layouts/ jquery-1.2.6.min.js, since the _layouts part of the URL always points to the LAYOUTS folder in the 12-hive.

          Making sure that SharePoint pages will load the library can be accomplished in a couple of ways:

          1) Load the library in the page you want to use it
          This can be done very easily by adding for example a Content Editor Web Part to the page (or modifying the page with an editor), containing the following HTML:

          2) Add the script to the master page
          You can add the same script tag to the master page that is used by your SharePoint sites as well, typically in the HEAD tag:


          . . .

          . . .

          This may look very easy, but remember modifying out-of-the-box files in the 12 hive is typically not supported. So if your sites use the default master page, this is a no-go. Additionally it could be that you’ve to multiple master pages (e.g. system and site master pages) which complicate the situation.

          3) Use the AdditionalPageHead Delegate Control (my favorite!)
          By providing the contents for the AdditionalPageHead Delegate Control that is used by all the out-of-the-box master pages, you can make sure the the jQuery library is loaded by all the SharePoint pages. The AdditionalPageHead Delegate Control allows multiple controls to provide contents, so it’s a great extensibility scenario. To accomplish this you need to build a web user control (ASCX file), that contains the script tag to load the jQuery library:

          <%@ Control Language="VB" ClassName="jQueryControl" %>

          There is no code-behind file required. This control needs to be deployed to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\CONTROLTEMPLATES folder on the hard drive of every SharePoint Front End Web Server. Additionally you need to have a feature that will add the control to the AdditionalPageHead Delegate Control, the feature’s manifest will look like this (assuming the control is named jQueryControl.ascx):



          The feature can be scoped to any level, when it’s activated on a certain level, all the pages will automatically have the script tag in their HEAD tags. Pretty cool, isn’t it?

          You can do all of this manually, but it’s of course much nicer to package the jQuery library JS file, the user control and the corresponding feature into a SharePoint Solution (WSP). I’ve created a sample Solution file, that contains a feature scoped to the Web level so the jQuery library can easily be deployed and enabled or disabled per SharePoint site. There is also an installer available that guides you through the installation process by making use of a nice wizard. You can find the solution, installer and sources as a part of the SmartTools project on CodePlex (direct link to the releases).

          Ok, now we are ready to make use of jQuery in our SharePoint sites, in the second part of this article I'll show you some cool stuff you can do by integrating jQuery with SharePoint 2007.


          Refrence ::

          Jan Tielens' Bloggings