10 DIY SharePoint Web Parts

10 DIY SharePoint Web Parts

10 DIY SharePoint Web Parts is a series of postings containing examples of SharePoint WebParts that anybody can build all by themselves.  These examples will require the use of the highly acclaimed RSSBus SharePoint WebPart.

The RSSBus SharePoint Web Part isn’t like most others – it cannot be called a uni-tasker.  It is the most exciting thing I’ve had the pleasure to work with in quite a while... its just a thing of beauty.

What does it do?  It lets you expose data to SharePoint (WSS or MOSS) from just about anywhere. 

The power comes when you use the “Connectors” – these Connectors get data from all sorts of data sources like web services, Excel documents, CRM systems, databases, email and other Internet servers, office applications, and tons more.  It does any of hundreds of tasks that you direct it to do, and is completely customizable.  It is literally hundreds of WebParts in one.

The 10

In this series, I will show 10 example web parts that you can build and customize yourself.  From there, you will have the know-how to build custom web parts out of your own ideas.

  1. Image Rotator - Easy
  2. Recently Modified Libraries and Documents List - Easy
  3. Custom SQL Queries - Medium
  4. List Active Directory Groups and Users - Medium
  5. QuickBooks Web Part! - Easy
  6. Shipment Tracking Web Part - Easy
  7. Search Email History - Medium
  8. Twitter - Easy
  9. MS Dynamics CRM - Easy
  10. Keep Your SharePoint Calendar Synced with Google - Easy

Installing RSSBus SharePoint Web Part


Before any of the 10 DIY Web Parts will work, you'll have to install the RSSBus SharePoint Web Part.  To do this, download and run the setup

Using the RSSBus SharePoint Web Part


Here is a screencast showing the absolute basics of how to use the RSSBus SharePoint Web Part after it is installed.

Print | posted on Monday, June 29, 2009 3:44 AM

Feedback

# re: 10 DIY SharePoint Web Parts

Left by Dale Sweet at 9/20/2009 5:06 PM
Gravatar Hi there Lance,

I have a little problem with example 3, i am attempting the 2nd example here with the YUI option enabled, and for some reason the web part isnt displaying any information (theres no error message - which is a good thing at least). The query i am using is as follows:

<rsb:info>
<input name="conn" default="server="my servername and instance name are here";database=ASDev_Responsibility_List;User ID=username is here;Password=password is here" />
<input name="query" default="SELECT appname, description, client, noofusers, applicationsource, who FROM dbo.Resp_List ORDER BY Appname" />
</rsb:info>

<rsb:import lib="RSSBus.SqlOps"/>

<rsb:set attr='_meta.YUIDataColDefs' value='DataDefsDown'/>
<rsb:set attr='_meta.YUIDataFields' value='DataFieldsDown'/>
<rsb:call op="sqlQuery" format=ToYuiTable/>

<script> var DataDefsDown = [
{key:"sql:Appname",label:"Appname",sortable:True,resizeable:true},
{key:"sql:Description",label:"Description",sortable:false,resizeable:true},
{key:"sql:Client",label:"Client",sortable:True,resizeable:true},
{key:"sql:NoofUsers",label:"NoOfUsers",sortable:true,resizeable:true},
{key:"sql:ApplicationSource",label:"ApplicationSource",sortable:true,resizeable:true},
{key:"sql:Who",label:"Who",sortable:true,resizeable:true}
];
var DataFieldsDown = [
{key:"sql:Appname"},
{key:"sql:Description"},
{key:"sql:Client"},
{key:"sql:NoofUsers"},
{key:"sql:ApplicationSource"},
{key:"sql:who"}
];
</script>



When i hit Apply, the webpart is blank, no headers or data. I dont know if i am missing something, or have mis-ready your instructions. Any advise you can pass on would be greatly appreciated....at the moment i am using the trial version of RSSBUS.

Thanks.

Dale Sweet

# re: 10 DIY SharePoint Web Parts

Left by Lance at 9/22/2009 4:22 AM
Gravatar Dale and I appear to have gotten this problem worked out via email. I gave Dale a new copy (soon to be published on the website) of the web part that includes an improved YuiTable formatter that requires no javascript. Simple as:

<rsb:info>
<input name="conn" default="server="my servername and instance name are here";database=ASDev_Responsibility_List;User ID=username is here;Password=password is here" />
<input name="query" default="SELECT appname, description, client, noofusers, applicationsource, who FROM dbo.Resp_List ORDER BY Appname" />
</rsb:info>

<rsb:import lib="RSSBus.SqlOps"/>
<rsb:call op="sqlQuery" format=ToYuiTable/>

Your comment:





 

Copyright © Lance Robinson

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski