| dc:creator | rss:description | rss:enclosure@length | rss:enclosure@type | rss:guid | rss:guid@ispermalink | rss:link | rss:pubdate | rss:title | template:categories | template:code | template:comments | template:connectors | template:description | template:file | template:imageurl | template:keywords | template:subtitle |
|---|
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/chart.CsvColumnChart_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template shows how to generate a multi series column chart using CSV data. This is accomplished by taking advantage of one of the many feed formatters available with RSSBus.
</td>
</tr>
</table>
| 3210 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.CsvColumnChart | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.CsvColumnChart | Mon, 01 Mar 2010 18:24:28 GMT | Multi Series Column Chart Web Part Template | Database, Charts and Maps |
<rsb:info title="CSV Chart" description="Creates a multi series chart from CSV data.">
<input name="3denable" description="Specifies whether this chart should be rendered in 3d." values="True,False" default="False"/>
<input name="defaultcharttype" description="The type of chart to render." values="Bar,Column,Line,Spline,Bubble" default="Column"/>
<input name="palette" description="The color palette to apply to this chart." values="Bright,Grayscale,Excel,Light,Pastel,EarthTones,SemiTransparent,Berry,Chocolate,Fire,SeaGreen,BrightPastel" default="Excel"/>
<input name="height" description="The height of this chart." default="320"/>
<input name="width" description="The width of this chart." default="640"/>
</rsb:info>
<rsb:import lib="RSSBus.CsvOps"/>
<rsb:import lib="RSSBus.ChartOps"/>
<rsb:set item="_meta" attr="xaxis" value="csv:date"/>
<rsb:set item="_meta" attr="yaxis#1" value="csv:stan"/>
<rsb:set item="_meta" attr="yaxis#2" value="csv:kyle"/>
<rsb:set item="_meta" attr="yaxis#3" value="csv:eric"/>
<rsb:set item="_meta" attr="yaxis#4" value="csv:kenny"/>
<rsb:set item="_meta" attr="seriesname#1" value="Stan"/>
<rsb:set item="_meta" attr="seriesname#2" value="Kyle"/>
<rsb:set item="_meta" attr="seriesname#3" value="Eric"/>
<rsb:set item="_meta" attr="seriesname#4" value="Kenny"/>
<rsb:set item="_meta" attr="charttitle" value="2009 Sales"/>
<rsb:set item="_meta" attr="xaxistitle" value="Month"/>
<rsb:set item="_meta" attr="yaxistitle" value="Monthly Sales"/>
<rsb:set item="_meta" attr="palette" value="[palette]"/>
<rsb:set item="_meta" attr="3denable" value="[3denable]"/>
<rsb:set item="_meta" attr="defaultcharttype" value="[defaultcharttype]"/>
<rsb:set item="_meta" attr="width" value="[width]"/>
<rsb:set item="_meta" attr="height" value="[height]"/>
<rsb:set attr="cols" value="*"/>
<!-- For demo purposes, this data is hard-coded here. You could pull this data in from an existing CSV file or URL -->
<rsb:set attr="data">
Date,Stan,Kyle,Eric,Kenny
Jan.,18,6,14,26
Feb.,19,23.25,31.23,23.5
Mar.,10,15.5,43.9,18
Apr.,22,17.45,45.6,18.4
May,21.35,39,23.39,9.65
Jun,25,62.5,25.89,14
Jul.,30,9.2,12.5,46
Aug.,40,21,32,19.45
Sept.,27,10,2.5,9.5
Oct.,31,21,14,12
Nov.,21,9,18,9.5
Dec.,38,4.5,19,12.75
</rsb:set>
<div align="center">
<rsb:call op="csvListRecords" format="MSChart">
<rsb:set attr="csv:stan" value="[csv:stan | multiply('1000')]"/>
<rsb:set attr="csv:kyle" value="[csv:kyle| multiply('1000')]"/>
<rsb:set attr="csv:eric" value="[csv:eric| multiply('1000')]"/>
<rsb:set attr="csv:kenny" value="[csv:kenny| multiply('1000')]"/>
</rsb:call>
</div>
| | ChartOps, CsvOps | This Web Part template shows how to generate a multi series column chart using CSV data. This is accomplished by taking advantage of one of the many feed formatters available with RSSBus.
| chart.CsvColumnChart.txt | http://rssbus.com/products/sharepoint/templates/chart.CsvColumnChart_thumb.png | csv, chart, graph, database | Multi Series Column Chart |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/chart.CsvMultiSeriesSpline_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template shows how to generate a multi series spline chart using CSV data. This is accomplished by taking advantage of one of the many feed formatters available with RSSBus.
</td>
</tr>
</table>
| 3963 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.CsvMultiSeriesSpline | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.CsvMultiSeriesSpline | Mon, 01 Mar 2010 18:24:29 GMT | Multi Series Spline Chart Web Part Template | Database, Charts and Maps |
<rsb:info title="CSV Multi Series Chart" description="Creates a multi series chart using combined feeds.">
<input name="seriesname" description="The name of the series you would like to show in the legend." values="Stan,Kyle,Eric,Kenny" default="Stan"/>
<input name="3denable" description="Specifies whether this chart should be rendered in 3d." values="True,False" default="False"/>
<input name="defaultcharttype" description="The type of chart to render." values="Bar,Column,Line,Spline,Bubble" default="spline"/>
<input name="palette" description="The color palette to apply to this chart." values="Bright,Grayscale,Excel,Light,Pastel,EarthTones,SemiTransparent,Berry,Chocolate,Fire,SeaGreen,BrightPastel" default="Excel"/>
<input name="height" description="The height of this chart." default="240"/>
<input name="width" description="The width of this chart." default="640"/>
</rsb:info>
<rsb:import lib="RSSBus.CsvOps"/>
<rsb:import lib="RSSBus.ChartOps"/>
<rsb:set attr="seriesname" value="[seriesname | tolower()]" />
<!-- For demo purposes, this data is hard-coded here. You could pull this data in from an existing CSV file or URL -->
<rsb:set attr="data">
Date,Stan,Kyle,Eric,Kenny
Jan.,18,6,14,26
Feb.,19,23.25,31.23,23.5
Mar.,10,15.5,43.9,18
Apr.,22,17.45,45.6,18.4
May,21.35,39,23.39,9.65
Jun,25,62.5,25.89,14
Jul.,30,9.2,12.5,46
Aug.,40,21,32,19.45
Sept.,27,10,2.5,9.5
Oct.,31,21,14,12
Nov.,21,9,18,9.5
Dec.,38,4.5,19,12.75
</rsb:set>
<rsb:set attr="cols" value="*"/>
<rsb:call op="csvListRecords" save="2009">
<rsb:set attr="csv:[seriesname]" value="[csv:[seriesname] | multiply('1000')]"/>
<rsb:set attr="csv:year" value="2009"/>
</rsb:call>
<!-- For demo purposes, this data is hard-coded here. You could pull this data in from an existing CSV file or URL -->
<rsb:set attr="data">
Date,Stan,Kyle,Eric,Kenny
Jan.,16.25,23.5,31.23,23.25
Feb.,20,26,14,28.5
Mar.,7,18.4,14,25.89
Apr.,53,18,9.65,15.5
May,34,12.75,4.5,21
Jun,7.45,39,19.45,32
Jul.,24,32.5,43.9,2.5
Aug.,19.5,9.5,23.79,18
Sept.,32.8,17.45,46,12.5
Oct.,38,9.2,45.6,14
Nov.,13.25,12,81,19
Dec.,55,9.5,9,10
</rsb:set>
<rsb:call op="csvListRecords" save="2008">
<rsb:set attr="csv:[seriesname]" value="[csv:[seriesname] | multiply('1000')]"/>
<rsb:set attr="csv:year" value="2008" />
</rsb:call>
<rsb:set attr="feed#" value="[_feeds.2009]"/>
<rsb:set attr="feed#" value="[_feeds.2008]"/>
<rsb:call op="feedConcat" save="joined"/>
<rsb:set attr="_meta.xaxis" value="csv:date"/>
<rsb:set attr="_meta.yaxis" value="csv:[seriesname]"/>
<rsb:set attr="_meta.yaxislabelstyle" value="c"/>
<rsb:set attr="_meta.xaxislabelstyle" value="D"/>
<rsb:set attr="_meta.groupby" value="csv:year"/>
<rsb:set attr="_meta.seriesname" value="[seriesname]"/>
<rsb:set attr="_meta.seriesmarkertype" value="cross"/>
<rsb:set attr="_meta.3denable" value="[3denable]"/>
<rsb:set attr="_meta.defaultcharttype" value="[defaultcharttype]"/>
<rsb:set attr="_meta.charttitle" value="[seriesname | capitalize()]'s Sales for 2008 & 2009 "/>
<rsb:set attr="_meta.xaxistitle" value="Month"/>
<rsb:set attr="_meta.yaxistitle" value="Sales"/>
<rsb:set attr="_meta.width" value="[width]"/>
<rsb:set attr="_meta.height" value="[height]"/>
<rsb:set attr="_meta.palette" value="[palette]"/>
<div align="center">
<rsb:call op="[_feeds.joined]" format="MSChart"/>
</div>
| | ChartOps, CsvOps | This Web Part template shows how to generate a multi series spline chart using CSV data. This is accomplished by taking advantage of one of the many feed formatters available with RSSBus.
| chart.CsvMultiSeriesSpline.txt | http://rssbus.com/products/sharepoint/templates/chart.CsvMultiSeriesSpline_thumb.png | csv, chart, graph, database, spline | Spline Chart from CSV File |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/chart.FederalReserve_thumb.png'>
</td>
<td VALIGN="top">
Visualize the Federal Reserve Gross National Product and Gross Domestic Product. Data is provided by St. Louis Fed Web Services: FRED API
</td>
</tr>
</table>
| 2727 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.FederalReserve | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.FederalReserve | Mon, 08 Feb 2010 17:26:18 GMT | Chart Federal Reserve Data Web Part Template | News and Information, Charts and Maps, Web Services | <rsb:import lib="RSSBus.XmlOps"/>
<rsb:import lib="RSSBus.ChartOps"/>
<rsb:info title="Chart Federal Reserve Data" description="Creates a chart of the Federal Reserve Gross National Product and Gross Domestic Product">
<input name="apikey" description="Fred API key for stlouisfed.org." default="934889e8b1a083461c56e54fb639be63"/>
<input name="dataseries" description="Series of data to chart." values="GDP,GNP" default="GDP"/>
<input name="height" description="The height of your chart." default="320" />
<input name="width" description="The width of your chart." default="640" />
</rsb:info>
<rsb:set attr="item" value="/observations/observation"/>
<rsb:set attr="document" value="http://api.stlouisfed.org/fred/series/observations?series_id=[dataseries]&api_key=[apikey]"/>
<rsb:call op="xmlListAttributes" output="out" save="fredData">
<rsb:notequals attr="value" value=".">
<rsb:set attr="out.value" value="[value]"/>
<rsb:else>
<rsb:set attr="out.value" value="0"/>
</rsb:else>
</rsb:notequals>
<rsb:set attr="out.value" value="[value | split('.',1)]"/>
</rsb:call>
<rsb:equals attr="dataseries" value="GDP">
<rsb:set item="_meta" attr="charttitle" value="Gross Domestic Product" />
<rsb:else>
<rsb:set item="_meta" attr="charttitle" value="Gross National Product" />
</rsb:else>
</rsb:equals>
<rsb:set item="_meta" attr="yaxis" value="value" />
<rsb:set item="_meta" attr="xaxis" value="pxml:date" />
<rsb:set item="_meta" attr="yaxistitle" value="Billions of Dollars" />
<rsb:set item="_meta" attr="xaxistitle" value="Date" />
<rsb:set item="_meta" attr="defaultcharttype" value="column"/>
<rsb:set item="_meta" attr="height" value="[height]" />
<rsb:set item="_meta" attr="width" value="[width]" />
<rsb:set item="_meta" attr="seriesname" value="[dataseries]"/>
<rsb:set attr="_meta.palette" value="Excel"/>
<rsb:call op="[_feeds.fredData]" format="MSChart" /> | This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.XmlOps.info' target='_blank'>RSSBus.XmlOps</a> and <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.ChartOps.info' target='_blank'>RSSBus.ChartOps</a>. | XmlOps | Visualize the Federal Reserve Gross National Product and Gross Domestic Product. Data is provided by St. Louis Fed Web Services: FRED API | chart.FederalReserve.txt | http://rssbus.com/products/sharepoint/templates/chart.FederalReserve_thumb.png | web service, chart, graph | Chart Federal Reserve Data |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/chart.SqlwithDataTable_thumb.png'>
</td>
<td VALIGN="top">
This Web Part selects sales by country from SQL and displays the results in a YUI Data Table and a Bar Chart. To use this, paste the source into the RSSBus Web Part source editor and edit the connection string and query values to refer to your own database.
</td>
</tr>
</table>
| 2385 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.SqlwithDataTable | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=chart.SqlwithDataTable | Mon, 08 Feb 2010 17:26:18 GMT | SQL Query Bar Chart and Data Table Web Part Template | Database, Charts and Maps |
<rsb:info title="SQL Query Bar Chart and Data Table" description="Selects sales by country and displays the results in a YUI Data Table and Bar Chart.">
<input name="yaxistitle" description="The y axis title." default="Order Count"/>
<input name="xaxistitle" description="The x axis title." default="Country"/>
<input name="charttitle" description="The chart title." default="2008 Sales"/>
</rsb:info>
<rsb:import lib="RSSBus.SqlOps"/>
<rsb:import lib="RSSBus.ChartOps" />
<rsb:set attr="conn" value="Data Source=Serverlocation;Initial Catalog=Northwind;User Id=sa;Password=Password" />
<rsb:set attr="query" value="select shipcountry, count(shipcountry) as x from Orders group by shipcountry order by x asc" />
<rsb:set attr="TableMeta.YUITableAttrs" value="sql:shipcountry, sql:x"/>
<rsb:set attr="TableMeta.YUITableLabels" value="Country,Orders"/>
<rsb:set attr="_meta.yaxis" value="sql:x" />
<rsb:set attr="_meta.xaxis" value="sql:shipcountry" />
<rsb:set attr="_meta.yaxistitle" value="[yaxistitle]" />
<rsb:set attr="_meta.xaxistitle" value="[xaxistitle]" />
<rsb:set attr="_meta.xaxislabelinterval" value="1" />
<rsb:set attr="_meta.height" value="500" />
<rsb:set attr="_meta.showlegend" value="false"/>
<rsb:set attr="_meta.charttype" value="bar"/>
<table>
<tr>
<td colspan="2">
<div align="center"><h1>[charttitle]</h1></div>
</td>
</tr>
<tr>
<td><rsb:call op="sqlQuery" meta="TableMeta" format="ToYuiTable" save="sqlChart"/></td>
<td><rsb:call op="[_feeds.sqlChart]" format="mschart"/></td>
</tr>
</table>
| This Web Part requires write access to the wpresources\charts\ folder. The formatted chart will be written to the charts folder and embeded inside the Web Part via the img tag. | SqlOps, ChartOps | This Web Part selects sales by country from SQL and displays the results in a YUI Data Table and a Bar Chart. To use this, paste the source into the RSSBus Web Part source editor and edit the connection string and query values to refer to your own database. | chart.SqlwithDataTable.txt | http://rssbus.com/products/sharepoint/templates/chart.SqlwithDataTable_thumb.png | sql, chart, database | SQL Query Bar Chart and Data Table |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/exchange.ExportToSharePointCalendar_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template syncs SharePoint Calendar events with a Microsoft Exchange Server Calendar. Each time the template is loaded on a page, it checks for new appointments on a specified Exchange account, and imports them to the specified SharePoint Calendar.
</td>
</tr>
</table>
| 4865 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=exchange.ExportToSharePointCalendar | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=exchange.ExportToSharePointCalendar | Mon, 02 Aug 2010 00:59:26 GMT | Import Microsoft Exchange Calendar Events to SharePoint Web Part Template | Calendars, SharePoint Lists, Business Applications |
<rsb:info title="Microsoft Exchange Calendar Sync" description="Import Microsoft Exchange Calendar Events to SharePoint.">
<input name="server" description="The name of MS Exchange Server or the URL of Exchange Web Services." required="true"/>
<input name="serverversion" description="The name of MS Exchange Server or the URL of Exchange Web Services." default="2007_SP1" />
<input name="folder" description="The path of the folder to list appointments." default="Calendar" />
<input name="username" description="The user name used to authenticate with MS Exchange Server." required="true"/>
<input name="password" description="The password used to authenticate with MS Exchange Server." required="true" style="password"/>
<input name="calendar" description="The SharePoint calendar to sync to." default="Calendar"/>
<input name="days" description="The number of days to import events for." default="30"/>
</rsb:info>
<div style="padding-left:5px;padding-top:5px;">
<rsb:check attr="_request.clickedSync.x">
<!-- import any necessary data connector -->
<rsb:import lib="RSSBus.ExchangeOps"/>
<!-- get all the events in the SharePoint calendar -->
<rsb:set attr="list" value="[calendar]"/>
<rsb:call op="spListItems" out="myitemout" save="myspitems" >
<rsb:call op="spGetItem?id=[sp:id]" >
<rsb:set attr="myitemout.title" value="[sp:title]"/>
<rsb:set attr="myitemout.location" value="[sp:location | def(' ')]"/>
<rsb:set attr="myitemout.start_time" value="[sp:start_time]"/>
<rsb:set attr="myitemout.end_time" value="[sp:end_time]"/>
<rsb:set attr="myitemout.description" value="[sp:description | def(' ')]" />
<rsb:unset attr="sp:*"/>
</rsb:call>
<rsb:unset attr="sp:*"/>
<rsb:unset attr="rss:*"/>
</rsb:call>
<!--get all the events in the MS Exchange calendar -->
<rsb:set attr="server" value="[server]"/>
<rsb:set attr="serverversion" value="[serverversion]"/>
<rsb:set attr="folder" value="[folder]"/>
<rsb:set attr="username" value="[username]"/>
<rsb:set attr="password" value="[password]"/>
<rsb:set attr="sslacceptcert" value="TRUSTED"/>
<rsb:set attr="startdateafter" value="[null | date(d)]"/>
<rsb:set attr="enddatebefore" value="[startdateafter | dateadd(day, [days]) | todate(d) ]"/>
<rsb:call op="exchangeListAppointments" out="myescalout" save="myesitems">
<rsb:set attr="myescalout.title" value="[exchange:subject]"/>
<rsb:set attr="myescalout.location" value="[exchange:location | def(' ')]"/>
<rsb:set attr="myescalout.start_time" value="[exchange:starttime | todate()]"/>
<rsb:set attr="myescalout.end_time" value="[exchange:endtime | todate()]"/>
<rsb:set attr="myescalout.description" value="[exchange:body | def(' ')]"/>
<rsb:unset attr="exchange:*"/>
<rsb:unset attr="rss:*"/>
</rsb:call>
<!-- now find out what is in MS Exchange that is not in the sharepoint list, using title and start time as the filter -->
<rsb:set attr="diff.base" value="[_feeds.myspitems]"/>
<rsb:set attr="diff.feed" value="[_feeds.myesitems]"/>
<rsb:set attr="diff.filter" value="title,start_time"/>
<rsb:set attr="diff.list" value="[list]"/>
<rsb:call op="feedDiff" in="diff">
<!-- for everything not in the sp list, add it! -->
<rsb:set attr="name#" value="Title"/>
<rsb:set attr="name#" value="Location"/>
<rsb:set attr="name#" value="Start Time"/>
<rsb:set attr="name#" value="End Time"/>
<rsb:set attr="name#" value="Description"/>
<rsb:set attr="value#" value="[title]"/>
<rsb:set attr="value#" value="[location | def('')]"/>
<rsb:set attr="value#" value="[start_time]"/>
<rsb:set attr="value#" value="[end_time]"/>
<rsb:set attr="value#" value="[description | def('')]"/>
<rsb:call op="spAddItem"/>
<b>[title]</b> Successfully imported from MS Exchange Server.<br>
</rsb:call>
<input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
Sync Complete!
<rsb:else>
<input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
Sync!
</rsb:else>
</rsb:check>
</div>
| | ExchangeOps | This Web Part template syncs SharePoint Calendar events with a Microsoft Exchange Server Calendar. Each time the template is loaded on a page, it checks for new appointments on a specified Exchange account, and imports them to the specified SharePoint Calendar. | exchange.ExportToSharePointCalendar.txt | http://rssbus.com/products/sharepoint/templates/exchange.ExportToSharePointCalendar_thumb.png | exchange, sharepoint, calendar, ical, sync | Import Microsoft Exchange Calendar Events to SharePoint |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/fedex.globalshipmenttracking_thumb.png'>
</td>
<td VALIGN="top">
Using any of three shipping companies (UPS, USPS, or FedEx), this Web Part template retrieves and displays a list of shipment tracking events for a specified tracking number.
To use, you'll first need to enter your UPS, USPS, and FedEx service credentials in the Web Part Properties and apply them. Then enter your tracking number, select the shipper, and click the Track button.
</td>
</tr>
</table>
| 5248 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=fedex.globalshipmenttracking | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=fedex.globalshipmenttracking | Mon, 08 Feb 2010 17:26:18 GMT | Universal Shipment Tracking Web Part Template | Shipping, Web Services | <rsb:info>
<input name="ups-accesskey" required="true" />
<input name="ups-accountnumber" required="true" />
<input name="ups-user" required="true" />
<input name="ups-password" required="true" />
<input name="usps-user" required="true" />
<input name="usps-password" required="true" />
<input name="fedex-accountnumber" required="true" />
<input name="fedex-meternumber" required="true" />
<input name="fedex-developerkey" required="true" />
<input name="fedex-password" required="true" />
</rsb:info>
<!-- a form to accept tracking number and shipping company -->
<div id="trackinginput">
<table cellspacing="5px">
<tr>
<td>Tracking Number:</td>
<td>
<input type="text" name="trackingnumber" value="" size="25"/>
</td>
<td align="right" colspan="2">
<input type="radio" name="shipper" value="UPS">UPS
<input type="radio" name="shipper" value="USPS">USPS
<input type="radio" name="shipper" value="FedEx" checked>FedEx
</td>
<td align="right">
<input type="submit" value="Track" />
</td>
</tr>
</table>
</div>
<!-- when the form is posted, display a table of ship events -->
<rsb:check attr="_request.form:trackingnumber">
<div style="height:250;overflow:auto">
<rsb:select value="[_request.form:shipper | tolower]">
<rsb:case match="exact" value="ups">
<rsb:import lib="RSSBus.UpsOps" />
<rsb:set attr="ups.user" value="[ups-user]" />
<rsb:set attr="ups.password" value="[ups-password]" />
<rsb:set attr="ups.accesskey" value="[ups-accesskey]" />
<rsb:set attr="ups.accountnumber" value="[ups-accountnumber]" />
<rsb:set attr="ups.url" value="https://wwwcie.ups.com/ups.app/xml/Track" />
<rsb:set attr="ups.trackingid" value="[_request.form:trackingnumber]" />
<rsb:set attr="global.operation" value="upsTrack" />
<rsb:set attr="global.input" value="ups" />
</rsb:case>
<rsb:case match="exact" value="usps">
<rsb:import lib="RSSBus.UspsOps" />
<rsb:set attr="usps.user" value="[usps-user]" />
<rsb:set attr="usps.password" value="[usps-password]" />
<rsb:set attr="usps.url" value="http://production.shippingapis.com/ShippingAPI.dll" />
<rsb:set attr="usps.trackingid" value="[_request.form:trackingnumber]" />
<rsb:set attr="global.operation" value="uspsTrack" />
<rsb:set attr="global.input" value="usps" />
</rsb:case>
<rsb:case match="exact" value="fedex">
<rsb:import lib="RSSBus.FedexOps" />
<rsb:set attr="fedex.password" value="[fedex-password]" />
<rsb:set attr="fedex.accountnumber" value="[fedex-accountnumber]" />
<rsb:set attr="fedex.meternumber" value="[fedex-meternumber]" />
<rsb:set attr="fedex.developerkey" value="[fedex-developerkey]" />
<rsb:set attr="fedex.trackingid" value="[_request.form:trackingnumber]" />
<rsb:set attr="fedex.trackingidtype" value="TRACKINGNUMBERORDOORTAG" />
<rsb:set attr="fedex.url" value="https://gatewaybeta.fedex.com:443/xml" />
<rsb:set attr="global.operation" value="fedexTrack" />
<rsb:set attr="global.input" value="fedex" />
</rsb:case>
</rsb:select>
<rsb:call op="[global.operation]" in="[global.input]">
<rsb:first>
<table width="100%">
<tr>
<th style="background-color:LightGrey; white-space:nowrap">Status</th>
<th style="background-color:LightGrey; white-space:nowrap">Date/Time</th>
<th style="background-color:LightGrey; white-space:nowrap">Location</th>
</tr>
</rsb:first>
<tr>
<td>[scandesc]</td>
<td>[scandate] [scantime]</td>
<td>[scancity], [scanstate] [scancountry]</td>
<tr>
<rsb:last>
</table>
</rsb:last>
</rsb:call>
</div>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.FedexOps.info' target='_blank'>RSSBus.FedexOps</a>, <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.UPsOps.info' target='_blank'>RSSBus.UpsOps</a>, and/or <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.UspsOps.info' target='_blank'>RSSBus.UspsOps</a>, depending on which shipping companies you want it to work with. You'll also need service credentials for each of the companies you use. | FedexOps, UpsOps, UspsOps | Using any of three shipping companies (UPS, USPS, or FedEx), this Web Part template retrieves and displays a list of shipment tracking events for a specified tracking number.
To use, you'll first need to enter your UPS, USPS, and FedEx service credentials in the Web Part Properties and apply them. Then enter your tracking number, select the shipper, and click the Track button.
| fedex.globalshipmenttracking.txt | http://rssbus.com/products/sharepoint/templates/fedex.globalshipmenttracking_thumb.png | FedEx, Federal Express, UPS, United Parcel Service, USPS, US Postal Service, Tracking, Shipping | Universal Shipment Tracking |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/fedex.shipmenttracking_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template retrieves and displays a list of shipment tracking events for a FedEx shipment using the specified tracking number.
To use, you'll first need to enter your FedEx service credentials in the Web Part Properties and apply. Then enter your tracking number and click the Track button.
</td>
</tr>
</table>
| 2525 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=fedex.shipmenttracking | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=fedex.shipmenttracking | Mon, 08 Feb 2010 17:26:18 GMT | Track FedEx Package Shipments Web Part Template | Shipping | <rsb:info>
<input name="accountnumber" required="true" />
<input name="meternumber" required="true" />
<input name="developerkey" required="true" />
<input name="password" required="true" />
</rsb:info>
<!-- a form to get tracking id -->
<div id="trackinginput">
<table cellspacing="5px">
<tr>
<td>Tracking Id:</td>
<td>
<input type="text" name="trackingid" value="" size="25"/>
</td>
<td align="right">
<input type="submit" value="Track" />
</td>
</tr>
</table>
</div>
<!-- when the form is posted, display a table of ship events -->
<rsb:check attr="_request.form:trackingnumber">
<div style="height:250;overflow:auto">
<rsb:import lib="RSSBus.FedexOps" />
<rsb:set attr="trackingid" value="[_request.form:trackingnumber]" />
<rsb:set attr="trackingidtype" value="TRACKINGNUMBERORDOORTAG" />
<rsb:set attr="url" value="https://gatewaybeta.fedex.com:443/xml" />
<rsb:call op="fedexTrack">
<rsb:first>
<table width="100%">
<tr>
<th style="background-color:LightGrey; white-space:nowrap">Status</th>
<th style="background-color:LightGrey; white-space:nowrap">Date/Time</th>
<th style="background-color:LightGrey; white-space:nowrap">Location</th>
</tr>
</rsb:first>
<tr>
<td>[scandesc]</td>
<td>[scandate] [scantime]</td>
<td>[scancity], [scanstate] [scancountry]</td>
<tr>
<rsb:last>
</table>
</rsb:last>
</rsb:call>
</div>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.UspsOps.info' target='_blank'>RSSBus.UspsOps</a>. Also, you'll need to sign up with USPS for to obtain service credentials for accessing USPS web services. | FedexOps | This Web Part template retrieves and displays a list of shipment tracking events for a FedEx shipment using the specified tracking number.
To use, you'll first need to enter your FedEx service credentials in the Web Part Properties and apply. Then enter your tracking number and click the Track button.
| fedex.shipmenttracking.txt | http://rssbus.com/products/sharepoint/templates/fedex.shipmenttracking_thumb.png | FedEx, Federal Express, Tracking, Shipping | Track FedEx Package Shipments |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.AutoRefresh_thumb.png'>
</td>
<td VALIGN="top">
Using any RSS feed, retrieve and display the results at a desired interval without refreshing the entire page.
</td>
</tr>
</table>
| 1814 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.AutoRefresh | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.AutoRefresh | Mon, 08 Feb 2010 17:26:18 GMT | Feed Rotator Web Part Template | Media, News and Information | <rsb:info title="Auto Refresh Example" description="Refresh the Web Part without refreshing the entire page.">
<input name="duration" description="The duration (in seconds) after the which the Web Part is refreshed." def="5"/>
<input name="url" description="The URL that has the contents to be refreshed." req="true" def="http://www.rssbus.com/products/sharepoint/templates/default.rsb"/>
</rsb:info>
<div id="RSSBusAutoRefreshWebPart"></div>
<script type="text/javascript">
refreshWebPart();
setInterval ( "refreshWebPart()", [duration | multiply(1000)]);
function refreshWebPart() {
var mydiv = document.getElementById("RSSBusAutoRefreshWebPart");
if ( mydiv == null ) return;
var xmlhttp = new XMLHttpRequest();
try {
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState==4 && xmlhttp.status==200) {
var allitems = xmlhttp.responseXML.getElementsByTagName('item');
var randomnumber=Math.floor(Math.random()*allitems.length);
var randomitem = xmlhttp.responseXML.selectSingleNode("/rss/channel/item[" + randomnumber + "]/description").text;
mydiv.innerHTML = randomitem;
}
}
xmlhttp.open('GET', '[url]?timespate='+ new Date().getTime(), true);
xmlhttp.send(null);
} catch (e) {
mydiv.innerHTML = '<font color=red>'+e+'</font>';
}
}
</script>
| | | Using any RSS feed, retrieve and display the results at a desired interval without refreshing the entire page.
| feed.AutoRefresh.txt | http://rssbus.com/products/sharepoint/templates/feed.AutoRefresh_thumb.png | ajax, xhr, refresh, rss, feed, media | Feed Rotator |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.Combine_thumb.png'>
</td>
<td VALIGN="top">
This Web Part simultaneously searches multiple web information sources like search engines, twitter, flickr, etc.
To use, enter a search term and click Search. You can customize this template easily by editing or adding to the list of feeds.
</td>
</tr>
</table>
| 1815 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.Combine | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.Combine | Mon, 08 Feb 2010 17:26:18 GMT | Combine Multiple Feeds Web Part Template | News and Information, Search |
<rsb:info title="Combine Multiple Feeds" description="Accepts a single user-defined search input and simultaneously searches multiple online feeds." />
<div id="search">
<input id="search" type="text" name="search" size="25" value="[_request.form:search| def('')]" />
<input type="submit" value="Search" />
</div>
<rsb:check attr="_request.form:search">
<rsb:set item="input" attr="feed#1" value="http://search.msn.com/results.aspx?q=[_request.form:search]&format=rss&FORM=ZZRE" />
<rsb:set item="input" attr="feed#2" value="http://news.search.yahoo.com/news/rss?ei=UTF-8&p=[_request.form:search]" />
<rsb:set item="input" attr="feed#3" value="http://www.flickr.com/services/feeds/photos_public.gne?tags=[_request.form:search]&format=rss_200" />
<rsb:set item="input" attr="feed#4" value="http://news.google.com/news?hl=en&q=[_request.form:search]&ie=UTF-8&output=rss" />
<rsb:set item="input" attr="feed#5" value="http://search.twitter.com/search.rss?q=[_request.form:search]" />
<rsb:call op="feedUnion" in="input">
<a href="[rss:link]">[rss:title]</a><br />
<div>[rss:description]</div><p /><hr />
</rsb:call>
</rsb:check>
| | | This Web Part simultaneously searches multiple web information sources like search engines, twitter, flickr, etc.
To use, enter a search term and click Search. You can customize this template easily by editing or adding to the list of feeds.
| feed.Combine.txt | http://rssbus.com/products/sharepoint/templates/feed.Combine_thumb.png | rss, search, flickr, msn, yahoo, google, twitter, aggregate, multiple, feed | Combine Multiple Feeds |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.embedded-audioplayer_thumb.png'>
</td>
<td VALIGN="top">
Listen to your podcasts straight from SharePoint. This Web Part embeds a play button next to each mp3 link found in a feed. The player "streams" the audio as an alternative to downloading.
</td>
</tr>
</table>
| 1341 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.embedded-audioplayer | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.embedded-audioplayer | Mon, 08 Feb 2010 17:26:18 GMT | Embedded Audio Player Web Part Template | Media | <rsb:info title="Podcast Audio Player" description="List and play podcasts via an embedded player.">
<input name="feed" description="The podcast feed you would like to listen to." required="true" default="http://feeds.feedburner.com/sharepointpodshow"/>
<input name="truncate" description="The length of feed description shown in the WebPart." default="-1"/>
<input name="last" description="The number of feed items shown in the WebPart." default=10/>
</rsb:info>
<script type="text/javascript" src="http://mediaplayer.yahoo.com/js"></script>
<rsb:set attr="start" value="1"/>
<rsb:set attr="last" value="[last | subtract(1)]" />
<rsb:call op="feedRange">
<a href="[rss:enclosure@url | def('#')]">[rss:title]</a><br>
[rss:description | def('No Description') | truncate([truncate])]
<hr>
</rsb:call>
| | | Listen to your podcasts straight from SharePoint. This Web Part embeds a play button next to each mp3 link found in a feed. The player "streams" the audio as an alternative to downloading.
| feed.embedded-audioplayer.txt | http://rssbus.com/products/sharepoint/templates/feed.embedded-audioplayer_thumb.png | rss, audio, podcast, mp3, music, media | Embedded Audio Player |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.GetCurrencyRates_thumb.png'>
</td>
<td VALIGN="top">
This Web Part allows users to select an international currency and uses a freely available web service to retrieve the current exchange rate between the selected currencies.
</td>
</tr>
</table>
| 1721 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.GetCurrencyRates | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.GetCurrencyRates | Mon, 08 Feb 2010 17:26:18 GMT | Currency Exchange Rates Web Part Template | News and Information, Web Services | <rsb:info title="Current Currency Rates" description="Lists the current currency rates for currencies you select"></rsb:info>
<select name="Currency1">
<option value="" >Select Currency</option>
<option value="USD" >USD</option>
<option value="CAD" >CAD</option>
<option value="EUR" >EUR</option>
<option value="AUD" >AUD</option>
<option value="GBP" >GBP</option>
<option value="JPY" >JPY</option>
</select>
<select name="Currency2">
<option value="" >Select Currency</option>
<option value="USD" >USD</option>
<option value="CAD" >CAD</option>
<option value="EUR" >EUR</option>
<option value="AUD" >AUD</option>
<option value="GBP" >GBP</option>
<option value="JPY" >JPY</option>
</select>
<input type="submit" name="submitRates" value="Get Rates"/>
<rsb:check attr="_request.Currency1">
<rsb:check attr="_request.Currency2">
<rsb:set attr="feed" value="http://coinmill.com/rss/[_request.Currency1]_[_request.Currency2].xml"/>
<rsb:call op="feedGet">
<br />[rss:description | def('Could not find the exchange rate.')]
</rsb:call>
</rsb:check>
</rsb:check>
| | | This Web Part allows users to select an international currency and uses a freely available web service to retrieve the current exchange rate between the selected currencies.
| feed.GetCurrencyRates.txt | http://rssbus.com/products/sharepoint/templates/feed.GetCurrencyRates_thumb.png | rss, exchange rate, currency, web service | Currency Exchange Rates |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.multi-search_thumb.png'>
</td>
<td VALIGN="top">
This Web Part simultaneously searches multiple web information sources like search engines, twitter, flickr, etc.
To use, enter a search term and click Search. You can customize this template easily by editing or adding to the list of feeds.
</td>
</tr>
</table>
| 1669 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.multi-search | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.multi-search | Mon, 08 Feb 2010 17:26:18 GMT | Search Multiple Sources Simultaneously Web Part Template | News and Information, Search |
<div id="search">
<input id="search" type="text" name="search" size="25" value="[_request.form:search| def('')]" />
<input type=submit value="Search" />
</div>
<rsb:check attr="_request.form:search">
<rsb:set item="input" attr="feed#1" value="http://search.msn.com/results.aspx?q=[_request.form:search]&format=rss&FORM=ZZRE" />
<rsb:set item="input" attr="feed#2" value="http://news.search.yahoo.com/news/rss?ei=UTF-8&p=[_request.form:search]" />
<rsb:set item="input" attr="feed#3" value="http://www.flickr.com/services/feeds/photos_public.gne?tags=[_request.form:search]&format=rss_200" />
<rsb:set item="input" attr="feed#4" value="http://news.google.com/news?hl=en&q=[_request.form:search]&ie=UTF-8&output=rss" />
<rsb:set item="input" attr="feed#5" value="http://search.twitter.com/search.rss?q=[_request.form:search]" />
<rsb:call op="feedUnion" in="input">
<a href="[rss:link]">[rss:title]</a><br />
<div>[rss:description]</div><p /><hr />
</rsb:call>
</rsb:check>
| | | This Web Part simultaneously searches multiple web information sources like search engines, twitter, flickr, etc.
To use, enter a search term and click Search. You can customize this template easily by editing or adding to the list of feeds.
| feed.multi-search.txt | http://rssbus.com/products/sharepoint/templates/feed.multi-search_thumb.png | rss, search, flickr, msn, yahoo, google, twitter, aggregate | Search Multiple Sources Simultaneously |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.news_thumb.png'>
</td>
<td VALIGN="top">
This Web Part will dynamically pull news headlines into your users SharePoint Portals. End users define the information filters that they care about directly through the SharePoint Web Part property editor.
To use, paste the source into the RSSBus Web Part source editor and apply. Optionally edit the Web Part property "SearchPrase" to specify your own search term.
</td>
</tr>
</table>
| 1331 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.news | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.news | Mon, 08 Feb 2010 17:26:18 GMT | View News & RSS/Atom Feeds Web Part Template | News and Information |
<rsb:info title="News Search" description="Searches the Google News feed with the specified phrase and displays the returned headlines." >
<input name="SearchPhrase" description="The search phrase to search News for." def="NFL"/>
<input name="maxresults" description="Maximum results to return." def="10"/>
</rsb:info>
<rsb:set attr="feed.url" value="http://news.google.com/news?ned=us&hl=en&output=rss&q=[SearchPhrase | urlencode]" />
<rsb:call op="[feed.url]" pagesize="[maxresults]">
<a href="[rss:link]">Google News: [rss:title]</a>
<br>
[rss:description]
<hr>
</rsb:call>
| | | This Web Part will dynamically pull news headlines into your users SharePoint Portals. End users define the information filters that they care about directly through the SharePoint Web Part property editor.
To use, paste the source into the RSSBus Web Part source editor and apply. Optionally edit the Web Part property "SearchPrase" to specify your own search term.
| feed.news.txt | http://rssbus.com/products/sharepoint/templates/feed.news_thumb.png | news, search, portal, rss, feed, google news | View News & RSS/Atom Feeds |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.Random_thumb.png'>
</td>
<td VALIGN="top">
This Web Part accepts a URL for a News/RSS/Atom feed as input, and displays a random item from that source. This is useful
for displaying announcements, product/user spotlights, quotes of the day, etc.
</td>
</tr>
</table>
| 896 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.Random | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.Random | Mon, 08 Feb 2010 17:26:18 GMT | Show Random Item From News/RSS/Atom Feeds Web Part Template | News and Information |
<rsb:info title="Feed Random" description="Searches a given feed and returns a random item.">
<input name="feed" default="http://rss.cnn.com/rss/cnn_tech.rss" />
</rsb:info>
<rsb:call op="feedRandom" pagesize="1">
<a href="[rss:link]">[rss:title]</a><br />
<div>[rss:description]</div><p /><hr />
</rsb:call>
| | | This Web Part accepts a URL for a News/RSS/Atom feed as input, and displays a random item from that source. This is useful
for displaying announcements, product/user spotlights, quotes of the day, etc.
| feed.Random.txt | http://rssbus.com/products/sharepoint/templates/feed.Random_thumb.png | rss, atom, feed, random | Show Random Item From News/RSS/Atom Feeds |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.Search_thumb.png'>
</td>
<td VALIGN="top">
This Web Part allows you to specify input URL(s) and a search query, and displays only items from the feeds that match the specified search query. This is very useful for keeping track of brand mentions in social media, or keeping track of user-relevant items in many data sources that RSSBus connects with through its Connectors.
</td>
</tr>
</table>
| 1241 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.Search | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.Search | Mon, 08 Feb 2010 17:26:18 GMT | Search News/RSS/Atom Feeds Web Part Template | News and Information, Search |
<rsb:info title="Feed Search" description="Searches a given url for the search phrase.">
<input name="feed" default="http://news.google.com/news?ned=us&topic=h&output=rss" />
<input name="query" description="The search phrase to search the for." def="President"/>
</rsb:info>
<!-- to search multiple feeds, use feedConcat first -->
<rsb:call op="feedSearch" pagesize="10">
<div style='margin-bottom:10px;float:left;width:100%;'>
<p>
<a href="[rss:link]">[rss:title]</a><br />
[rss:description]
</p>
</div>
<hr />
</rsb:call>
| | | This Web Part allows you to specify input URL(s) and a search query, and displays only items from the feeds that match the specified search query. This is very useful for keeping track of brand mentions in social media, or keeping track of user-relevant items in many data sources that RSSBus connects with through its Connectors.
| feed.Search.txt | http://rssbus.com/products/sharepoint/templates/feed.Search_thumb.png | rss, atom, feed, search, BI | Search News/RSS/Atom Feeds |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/feed.weather_thumb.png'>
</td>
<td VALIGN="top">
Connecting to remote web services is easy with the RSSBus SharePoint Web Part. Pull local weather information from Yahoo, get stock quotes from NASDAQ or NYSE, mash-up data from various sources, and much more!
</td>
</tr>
</table>
| 1021 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.weather | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=feed.weather | Mon, 08 Feb 2010 17:26:18 GMT | Yahoo Weather Web Service Web Part Template | News and Information, Web Services | <rsb:info title="Weather Information" description="Gets weather information from Yahoo.">
<input name="Location" description="The location for the weather forecast as a zip code or Location ID" req="true" def="27713" />
</rsb:info>
<rsb:cache key="weather_[Location]" duration="60"/>
<rsb:call op="http://weather.yahooapis.com/forecastrss?p=[Location]" >
<a href="[rss:link]">[rss:title]</a>
<br>
[rss:description]
</rsb:call>
| | | Connecting to remote web services is easy with the RSSBus SharePoint Web Part. Pull local weather information from Yahoo, get stock quotes from NASDAQ or NYSE, mash-up data from various sources, and much more!
| feed.weather.txt | http://rssbus.com/products/sharepoint/templates/feed.weather_thumb.png | rss, weather, geo, web service, yahoo | Yahoo Weather Web Service |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/formatters.DigitalClock_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template shows how to use some of the RSSBus attribute formatters for working with date and time, and displays a digital clock and calendar including various international times.
</td>
</tr>
</table>
| 1535 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=formatters.DigitalClock | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=formatters.DigitalClock | Mon, 08 Feb 2010 17:26:18 GMT | Digital Clock Web Part Template | Utilities |
<rsb:info title="Digital Clock" description="Displays various a digital clock and various international times." />
<p class="clock">
[null | now("MMMM yyyy")]<br />
<span class="day">[null | now("dd")]<br /></span>
[null | now("dddd")]<br />
<span class="time">[null | now("h:mm:ss")]<br /></span>
<table rules=cols>
<tr style="text-align:center"><td>New York</td><td>Los Angeles</td><td>London</td><td>Tokyo</td></tr>
<tr>
<td class="intl">[null | utcnow() | dateadd("hour","-5") | todate("h:mm tt")]</td>
<td class="intl">[null | utcnow() | dateadd("hour","-8") | todate("h:mm tt")]</td>
<td class="intl">[null | utcnow("h:mm tt")]</td>
<td class="intl">[null | utcnow() | dateadd("hour","9") | todate("h:mm tt")]</td>
</tr>
</table>
</p>
<style>
.clock {
text-align:center;
font-size:20px;
}
.day {
color:#0099CC;
font-size:30px;
}
.time {
color:#0099CC;
font-size:25px;
}
.intl {
color:#0099CC;
text-align:center;
}
</style>
| | | This Web Part template shows how to use some of the RSSBus attribute formatters for working with date and time, and displays a digital clock and calendar including various international times. | formatters.DigitalClock.txt | http://rssbus.com/products/sharepoint/templates/formatters.DigitalClock_thumb.png | date, time, formatter, clock | Digital Clock |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/ftp.directory-list_thumb.png'>
</td>
<td VALIGN="top">
Lists the directory structure and files for the specified ftp account. Directory structure is linked, allowing folder navigation.
</td>
</tr>
</table>
| 2379 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ftp.directory-list | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ftp.directory-list | Mon, 08 Feb 2010 17:26:18 GMT | FTP Directory Browser Web Part Template | Document Management, Internet | <rsb:script xmlns:rsb="http://www.rssbus.com/ns/rsbscript/2">
<rsb:import lib="RSSBus.FtpOps"/>
<rsb:info title="ftpList" description="ftpList Service (replace this with the service description)">
<input name="password" description="The password to be used for authentication." style="password" required="true" />
<input name="server" description="The remote FTP host." default="localhost" />
<input name="user" description="The user to be used for authentication." required="true" />
<input name="remotepath" description="the remote path you would like to list" default="." />
</rsb:info>
<rsb:set attr="out.previouspath" value=""/>
<rsb:check attr="_request.remotepath">
<rsb:enum list="[_request.remotepath]" seperator="/">
<rsb:set attr="out.previouspath" value="[out.previouspath | def('')]/[_value]"/>
<rsb:set attr="out.value" value="[_value]"/>
</rsb:enum>
<rsb:set attr="out.previouspath" value="[out.previouspath | replace('/[out.value]', '', )]"/>
<a href="?remotepath=[out.previouspath | def('')]">Root[out.previouspath]</a> /[out.value]<br>
<hr>
</rsb:check>
<table width="100%" cellpadding="3">
<tr> <th><b>Name</b></th> <th><b>Size</b></th> </tr>
<rsb:call op="ftpList?remotepath=[_request.remotepath | def('.')]" output="out" save="ftpList"/>
<rsb:call op="feedSort?feed=[_feeds.ftpList]&sort=-ftp:isdir,+ftp:name">
<tr>
<rsb:select value="[ftp:isdir]">
<rsb:case match="regex" value="True">
<td><a href="?remotepath=[_request.remotepath | def('')]/[ftp:name]">[ftp:name]</a> <br> </td>
</rsb:case>
<rsb:case match="regex" value="False">
<td>[ftp:name] </td>
<td>[ftp:size | divide('1024') | round(1)] KB </td>
</rsb:case>
<rsb:default />
</rsb:select>
</tr>
</rsb:call>
</table>
</rsb:script> | | FtpOps | Lists the directory structure and files for the specified ftp account. Directory structure is linked, allowing folder navigation. | ftp.directory-list.txt | http://rssbus.com/products/sharepoint/templates/ftp.directory-list_thumb.png | Ftp, File, internet | FTP Directory Browser |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/google.DisplayCalendarEvents_thumb.png'>
</td>
<td VALIGN="top">
Display upcoming Google Calendar events for the specified date range inside SharePoint. The template includes a calendar link to each event.
</td>
</tr>
</table>
| 1546 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.DisplayCalendarEvents | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.DisplayCalendarEvents | Mon, 08 Feb 2010 17:26:18 GMT | Display Google Calendar Events Web Part Template | News and Information, Search, Calendars |
<rsb:import lib="RSSBus.GoogleOps"/>
<rsb:info>
<input name="email" description="The email used to authenticate with google" required="true"/>
<input name="password" description="The password used to authenticate with google" required="true" style="password"/>
<input name="days" description="The number of days to display events for" values="1,7,14,30" default="7"/>
</rsb:info>
<!-- call the calendar search operation, save the results -->
<rsb:set attr="fromdate" value="[null | date('d')]"/>
<rsb:set attr="todate" value="[fromdate | dateadd('day', '[days]') | todate('d')]"/>
<rsb:call op="googleCalSearch" save="googleCalSearch"/>
<!-- sort the results by date and display -->
<rsb:set attr="feed" value="[_feeds.googleCalSearch]"/>
<rsb:set attr="sort" value="ggl:starttime"/>
<ul>
<rsb:call op="feedSort?type=date">
<li>[ggl:starttime | todate(d)] [ggl:starttime | todate(t)]
<ul><li><b><a href="[ggl:weblink]">[ggl:title]</a></b></li></ul>
</li>
</rsb:call>
</ul>
| | GoogleOps | Display upcoming Google Calendar events for the specified date range inside SharePoint. The template includes a calendar link to each event. | google.DisplayCalendarEvents.txt | http://rssbus.com/products/sharepoint/templates/google.DisplayCalendarEvents_thumb.png | google, calendar, events, ical | Display Google Calendar Events |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/google.ExportToSharePointCalendar_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template syncs SharePoint Calendar events with a Google Calendar. Each time the template is loaded on a page, it checks for new items on a specified Google Calendar account, and imports them to the specified SharePoint Calendar.
</td>
</tr>
</table>
| 4074 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.ExportToSharePointCalendar | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.ExportToSharePointCalendar | Mon, 08 Feb 2010 17:26:18 GMT | Import SharePoint Calendar Events From Google Calendar Web Part Template | Calendars, SharePoint Lists, News and Information |
<rsb:info title="Google Calendar Sync" description="Import SharePoint Calendar Events From Google Calendar.">
<input name="email" description="The email used to authenticate with Google." required="true"/>
<input name="password" description="The password used to authenticate with Google." required="true" style="password"/>
<input name="calendar" description="The SharePoint calendar to sync to." default="Calendar"/>
<input name="days" description="The number of days to import events for." default="30"/>
</rsb:info>
<div style="padding-left:5px;padding-top:5px;">
<rsb:check attr="_request.clickedSync.x">
<!-- import any necessary data connector -->
<rsb:import lib="RSSBus.GoogleOps"/>
<!-- get all the events in the SharePoint calendar -->
<rsb:set attr="list" value="[calendar]"/>
<rsb:call op="spListItems" out="myitemout" save="myspitems" >
<rsb:call op="spGetItem?id=[sp:id]" >
<rsb:set attr="myitemout.title" value="[sp:title]"/>
<rsb:set attr="myitemout.location" value="[sp:location | def(' ')]"/>
<rsb:set attr="myitemout.start_time" value="[sp:start_time]"/>
<rsb:set attr="myitemout.end_time" value="[sp:end_time]"/>
<rsb:set attr="myitemout.description" value="[sp:description | def(' ')]" />
<rsb:unset attr="sp:*"/>
</rsb:call>
<rsb:unset attr="sp:*"/>
<rsb:unset attr="rss:*"/>
</rsb:call>
<!--get all the events in the Google calendar -->
<rsb:set attr="fromdate" value="[null | date(d)]"/>
<rsb:set attr="todate" value="[fromdate | dateadd(day, [days]) | todate(d) ]"/>
<rsb:call op="googleCalSearch" out="mygcalout" save="mygitems">
<rsb:set attr="mygcalout.title" value="[ggl:title]"/>
<rsb:set attr="mygcalout.location" value="[ggl:where | def(' ')]"/>
<rsb:set attr="mygcalout.start_time" value="[ggl:starttime | todate()]"/>
<rsb:set attr="mygcalout.end_time" value="[ggl:endtime | todate()]"/>
<rsb:set attr="mygcalout.description" value="[ggl:description | def(' ')]"/>
<rsb:unset attr="ggl:*"/>
<rsb:unset attr="rss:*"/>
</rsb:call>
<!-- now find out what is in google calendar that is not in the sharepoint list, using title and start time as the filter -->
<rsb:set attr="diff.base" value="[_feeds.myspitems]"/>
<rsb:set attr="diff.feed" value="[_feeds.mygitems]"/>
<rsb:set attr="diff.filter" value="title,start_time"/>
<rsb:set attr="diff.list" value="[list]"/>
<rsb:call op="feedDiff" in="diff">
<!-- for everything not in the sp list, add it! -->
<rsb:set attr="name#" value="Title"/>
<rsb:set attr="name#" value="Location"/>
<rsb:set attr="name#" value="Start Time"/>
<rsb:set attr="name#" value="End Time"/>
<rsb:set attr="name#" value="Description"/>
<rsb:set attr="value#" value="[title]"/>
<rsb:set attr="value#" value="[location | def('')]"/>
<rsb:set attr="value#" value="[start_time]"/>
<rsb:set attr="value#" value="[end_time]"/>
<rsb:set attr="value#" value="[description | def('')]"/>
<rsb:call op="spAddItem"/>
<b>[title]</b> Successfully imported from Google Calendar.<br>
</rsb:call>
<input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
Sync Complete!
<rsb:else>
<input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
Sync!
</rsb:else>
</rsb:check>
</div>
| | GoogleOps | This Web Part template syncs SharePoint Calendar events with a Google Calendar. Each time the template is loaded on a page, it checks for new items on a specified Google Calendar account, and imports them to the specified SharePoint Calendar. | google.ExportToSharePointCalendar.txt | http://rssbus.com/products/sharepoint/templates/google.ExportToSharePointCalendar_thumb.png | google, sharepoint, calendar, ical, sync | Import SharePoint Calendar Events From Google Calendar |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/google.gmail-recent-messages_thumb.png'>
</td>
<td VALIGN="top">
Display a list of your 20 most recent Gmail messages. This template makes use of the YUI formatter to generate a styled table with just a few lines of code.
</td>
</tr>
</table>
| 1757 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.gmail-recent-messages | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.gmail-recent-messages | Mon, 08 Feb 2010 17:26:18 GMT | Gmail Recent Messages Web Part Template | Mail, Internet | <rsb:cache key="gmail" duration="10"/>
<rsb:import lib="RSSBus.GoogleOps"/>
<rsb:info title="List Google Mail Messages" desc="List messages in a Gmail mailbox.">
<input name="email" desc="The Google account email address." required="true" />
<input name="password" desc="The Google account password." required="true" style="password" />
</rsb:info>
<rsb:set attr="maxitems" value="20"/>
<rsb:call op="googleMailListMessages" format="toyuitable">
<rsb:select value="[ggl:flags]">
<rsb:case match="regex" value="\Seen">
<rsb:set attr="Subject">
<a href="http://mail.google.com/mail/#search/subject: [ggl:subject] " target="new">[ggl:subject]</a>
</rsb:set>
</rsb:case>
<rsb:default>
<rsb:set attr="Subject">
<b><a href="http://mail.google.com/mail/#search/subject: [ggl:subject] " target="new">[ggl:subject]</a></b>
</rsb:set>
</rsb:default>
</rsb:select>
<rsb:set attr="From">
[ggl:fromemail]
</rsb:set>
<rsb:unset attr="ggl:*"/>
<rsb:unset attr="ssl:*"/>
<rsb:unset attr="part:*"/>
</rsb:call>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.GoogleOps.info' target='_blank'>RSSBus.GoogleOps</a>. | GoogleOps | Display a list of your 20 most recent Gmail messages. This template makes use of the YUI formatter to generate a styled table with just a few lines of code. | google.gmail-recent-messages.txt | http://rssbus.com/products/sharepoint/templates/google.gmail-recent-messages_thumb.png | Email, google, Gmail, imap | Gmail Recent Messages |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/google.googledocs-to-sharepoint_thumb.png'>
</td>
<td VALIGN="top">
Demonstrates how to import documents from Google Docs into a SharePoint Document Library from within SharePoint.
</td>
</tr>
</table>
| 1898 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.googledocs-to-sharepoint | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.googledocs-to-sharepoint | Mon, 08 Feb 2010 17:26:18 GMT | Import from Google Docs to SharePoint Web Part Template | Document Management, SharePoint Lists | <rsb:import lib="RSSBus.GoogleOps"/>
<rsb:info title="Import from Google Docs" description="Import from Google Docs to SharePoint">
<input name="email" description="The email address used to authenticate with Google." required="true"/>
<input name="password" description="The password used to authenticate with Google." required="true" style='password'/>
<input name="library" description="Shared Documents Library to save documents to." default="Shared Documents"/>
</rsb:info>
<table width="98%" >
<tr>
<td><b>Document Name</b></td>
<td><b>Modified Date</b></td>
<td><b>Created By</b></td>
</tr>
<rsb:check attr="_request.save_to_lib">
<rsb:set attr="name" value="[_request.save_to_lib]"/>
<rsb:set attr="format" value="DOC"/>
<rsb:set attr="localfile" value="sp://[_request.server:HTTP_HOST]/[library]/[_request.save_to_lib].doc"/>
<rsb:call op="googleDocsExport" output="out"/>
<b>[Name]</b> has been saved to <a href="/[library]">[library]</a>
</rsb:check>
<rsb:set attr="doctype" value="DOCS"/>
<rsb:call op="googleDocsListDocs">
<tr>
<td><img src="/_layouts/images/icdoc.gif" />
<a href="?save_to_lib=[ggl:title]">[ggl:title]</a></td>
<td>[ggl:updated | split('T',1)]</td><td>[ggl:author_email]</td>
</tr>
</rsb:call>
</table>
| | GoogleOps | Demonstrates how to import documents from Google Docs into a SharePoint Document Library from within SharePoint. | google.googledocs-to-sharepoint.txt | http://rssbus.com/products/sharepoint/templates/google.googledocs-to-sharepoint_thumb.png | google, documentss, document library, document management, sharepoint | Import from Google Docs to SharePoint |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/google.ImportFromSharePointCalendar_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template syncs Google Calendar events with a SharePoint Calendar. Each time the template is loaded on a page, it checks for new items on a specified SharePoint Calendar, and exports them to the specified Google Calendar.
</td>
</tr>
</table>
| 4490 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.ImportFromSharePointCalendar | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.ImportFromSharePointCalendar | Mon, 08 Feb 2010 17:26:18 GMT | Export SharePoint Calendar Events to a Google Calendar Web Part Template | Calendars, SharePoint Lists, News and Information |
<rsb:info title="Google Calendar Sync" description="This template Syncs events in a Google Calendar account with those in a SharePoint Calendar.">
<input name="email" description="The email used to authenticate with Google." required="true"/>
<input name="password" description="The password used to authenticate with Google." required="true" style="password"/>
<input name="calendar" description="The SharePoint calendar to sync to." default="Calendar"/>
<input name="days" description="The number of days to import events for." default="120"/>
</rsb:info>
<!-- import any necessary data connector -->
<rsb:import lib="RSSBus.GoogleOps"/>
<!-- authenticate with Google -->
<rsb:set attr="google.AuthToken" value="" />
<rsb:call op="googleAuth?service=cl">
<rsb:set attr="google.AuthToken" value="[ggl:authtoken]" />
</rsb:call>
<rsb:set attr="authtoken" value="[google.AuthToken]" />
<!-- get all the events in the SharePoint calendar -->
<rsb:set attr="list" value="[calendar]"/>
<rsb:call op="spListItems?fields=ALL" out="myitemout" save="myspitems" >
<rsb:set attr="fromdate" value="[null | date(d)]"/>
<rsb:set attr="todate" value="[fromdate | dateadd(day, [days]) | todate(d) ]"/>
<rsb:set attr="afterfromdate" value="[sp:start_time | compare('[fromdate]')]" />
<rsb:set attr="beforetodate" value="[sp:start_time | compare('[todate]')]" />
<rsb:equals attr="afterfromdate" value="1">
<rsb:equals attr="beforetodate" value="-1">
<rsb:set attr="myitemout.title" value="[sp:title]"/>
<rsb:set attr="myitemout.location" value="[sp:location | def('')]"/>
<rsb:set attr="myitemout.allday" value="[sp:all_day_event | def('FALSE') | toupper()]"/>
<rsb:set attr="myitemout.start_time" value="[sp:start_time]"/>
<rsb:set attr="myitemout.end_time" value="[sp:start_time | dateadd('second','[sp:duration]')]"/>
<rsb:set attr="myitemout.description" value="[sp:description | def(' ')]" />
<rsb:unset attr="sp:*"/>
</rsb:equals>
</rsb:equals>
<rsb:unset attr="sp:*"/>
<rsb:unset attr="rss:*"/>
</rsb:call>
<!--get all the events in the Google calendar -->
<rsb:set attr="maxresults" value="100"/>
<rsb:set attr="fromdate" value="[null | date(d)]"/>
<rsb:set attr="todate" value="[fromdate | dateadd(day, [days]) | todate(d) ]"/>
<rsb:call op="googleCalSearch" out="mygcalout" save="mygitems">
<rsb:set attr="mygcalout.title" value="[ggl:title]"/>
<rsb:set attr="mygcalout.location" value="[ggl:where | def('')]"/>
<rsb:set attr="mygcalout.start_time" value="[ggl:starttime | todate()]"/>
<rsb:set attr="mygcalout.end_time" value="[ggl:endtime | todate()]"/>
<rsb:set attr="mygcalout.description" value="[ggl:description | def(' ')]"/>
<rsb:unset attr="ggl:*"/>
<rsb:unset attr="rss:*"/>
</rsb:call>
<!-- now find out what is in sharepoint calendar that is not in the google calendar, using title and start time as the filter -->
<rsb:set attr="diff.base" value="[_feeds.mygitems]"/>
<rsb:set attr="diff.feed" value="[_feeds.myspitems]"/>
<rsb:set attr="diff.filter" value="title, start_time"/>
<rsb:call op="feedDiff" in="diff">
<rsb:check attr="title">
<!-- for everything not in the Google Calendar, add it! -->
<rsb:set attr="title" value="[title | htmlencode]"/>
<rsb:set attr="where" value="[location | def('')]"/>
<rsb:set attr="starttime" value="[start_time]"/>
<rsb:set attr="endtime" value="[end_time]"/>
<rsb:set attr="description" value="[description | def('')]"/>
<rsb:set attr="allday" value="[allday | def('FALSE')]" />
<rsb:call op="googleCalCreate">
[ggl:starttime]: "<a href="[ggl:weblink]">[ggl:title]</a>" exported to Google Calendar.<br />
</rsb:call>
</rsb:check>
</rsb:call>
| | GoogleOps | This Web Part template syncs Google Calendar events with a SharePoint Calendar. Each time the template is loaded on a page, it checks for new items on a specified SharePoint Calendar, and exports them to the specified Google Calendar. | google.ImportFromSharePointCalendar.txt | http://rssbus.com/products/sharepoint/templates/google.ImportFromSharePointCalendar_thumb.png | google, sharepoint, calendar, ical, sync | Export SharePoint Calendar Events to a Google Calendar |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/google.Search_thumb.png'>
</td>
<td VALIGN="top">
Bring Google Search into SharePoint with this template. Allow your users to enter their own search terms, or define the term for them.
</td>
</tr>
</table>
| 1726 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.Search | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.Search | Mon, 08 Feb 2010 17:26:18 GMT | Google Web Search Web Part Template | Search | <rsb:import lib="RSSBus.GoogleOps"/>
<rsb:info>
<input name="search" description="The term to search for in Google." def="" />
<input name="showsearch" description="Whether or not to display the search box." values="true,false" default="true"/>
<output name="ggl:*" description="Google Search Results."/>
</rsb:info>
<div style="padding-left:5px;">
<rsb:equals attr="showsearch" value="true">
<rsb:set attr="search" value="[_request.search | def('[search]') | urlencode()]" />
<input id="search" name="search" value="[search]"/>
<input type="Submit"/>
</rsb:equals>
<rsb:check attr="search">
<rsb:set attr="search" value="[search | urlencode()]" />
<rsb:call op="googleSearchWeb">
<p><a href="[ggl:url]" >[ggl:titlenoformatting | replace('0026#39;s','')]</a><br>
[ggl:content | replace('003cb003e','') | replace('003c/b003e','') | replace('0026#39;s','') | replace("0026#39;","'")]<br>
<cite style="color:green;font-style:normal;">[ggl:visibleurl]</cite> | <a href="[ggl:cacheurl | replace('q003d','q=')]">Cached</a></p><br>
</rsb:call>
<rsb:else>
</rsb:else>
</rsb:check>
</div> | This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.GoogleOps.info' target='_blank'>RSSBus.GoogleOps</a>. | GoogleOps | Bring Google Search into SharePoint with this template. Allow your users to enter their own search terms, or define the term for them. | google.Search.txt | http://rssbus.com/products/sharepoint/templates/google.Search_thumb.png | google, search | Google Web Search |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/google.sharepoint-to-googledocs_thumb.png'>
</td>
<td VALIGN="top">
Export a copy of a document stored on SharePoint into a Google Docs account, directly from within a SharePoint portal site.
</td>
</tr>
</table>
| 1927 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.sharepoint-to-googledocs | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=google.sharepoint-to-googledocs | Mon, 08 Feb 2010 17:26:18 GMT | Export SharePoint Documents to Google Docs Web Part Template | Document Management, SharePoint Lists | <rsb:import lib="RSSBus.GoogleOps"/>
<rsb:info title="Google Docs Import" description="Import your documents from SharePoint into Google Docs">
<input name="email" description="The email address used to authenticate with Google." required="true"/>
<input name="password" description="The password used to authenticate with Google." required="true" style='password'/>
<input name="library" description="Document Library to save files into" default="Shared Documents"/>
</rsb:info>
<style>
li {list-style-type: none;}
</style>
<rsb:check attr="_request.save_to_docs">
<rsb:set attr="name" value="[_request.save_to_docs]"/>
<rsb:set attr="format" value="DOC"/>
<rsb:set attr="localfile" value="sp://[_request.server:HTTP_HOST]/[library]/[_request.save_to_docs]"/>
<rsb:call op="googleDocsUpload" output="out"/>
<b>[_request.save_to_docs]</b> has been saved to Google Docs
<rsb:else>
<ul>
<rsb:call op="spListDocuments?library=[library]">
<li>
<img src="/_layouts/images/icdoc.gif" />
<a href="?save_to_docs=[sp:name]" alt="Save [sp:name] to Google Docs">[sp:name]</a>
</li>
</rsb:call>
</ul>
</rsb:else>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.GoogleOps.info' target='_blank'>RSSBus.GoogleOps</a>. | GoogleOps | Export a copy of a document stored on SharePoint into a Google Docs account, directly from within a SharePoint portal site.
| google.sharepoint-to-googledocs.txt | http://rssbus.com/products/sharepoint/templates/google.sharepoint-to-googledocs_thumb.png | google, documents, document library, document management, sharepoint | Export SharePoint Documents to Google Docs |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/ldap.ChangePassword_thumb.png'>
</td>
<td VALIGN="top">
This RSSBus Web Part template will allow your users to easily change their own passwords through Active Directory, saving system
administrators countless hours of support in helping users accomplish this on their own. The LDAP Connector showcased in this example has the
ability to search, add, modify, and delete LDAP entries in Active Directory and any other LDAP directory server.
</td>
</tr>
</table>
| 2435 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.ChangePassword | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.ChangePassword | Mon, 08 Feb 2010 17:26:18 GMT | Change Active Directory Password Web Part Template | System Administration, Directory Services |
<rsb:import lib="RSSBus.LdapOps" />
<rsb:info title="Change Active Directory Password">
<input name="server" required="true" />
<input name="port" default="636" required="true" />
<input name="admindn" required="true" />
<input name="adminpassword" required="true" />
</rsb:info>
<style>
.myinput { width:150px; }
</style>
<table>
<tr><td>User:</td><td><input type="text" class="myinput" style="width:150px" name="user" value="[_spuser.LoginName]"/></td></tr>
<tr><td>Old Password:</td><td><input type="password" class="myinput" name="oldpassword" /></td></tr>
<tr><td>New Password:</td><td><input type="password" class="myinput" name="newpassword" /></td></tr>
<tr><td>Confirm:</td><td><input type="password" class="myinput" name="confirmpassword" /></td></tr>
<tr><td></td><td align="right"><input type="submit" value="Submit"/></td></tr>
</table>
<!-- check to see if they've submitted the required info: -->
<rsb:check attr="_request.oldpassword">
<!-- set LDAP connectivity properties (636 is ssl) -->
<rsb:set attr="server" value="[server]" />
<rsb:set attr="port" value="[port]" />
<rsb:set attr="sslmode" value="IMPLICIT" />
<rsb:set attr="authdn" value="[admindn]" />
<rsb:set attr="password" value="[adminpassword]" />
<!-- and now change the password -->
<rsb:set attr="dn" value="[_request.user]" />
<rsb:set attr="oldpassword" value="[_request.oldpassword]" />
<rsb:set attr="newpassword" value="[_request.newpassword]" />
<rsb:set attr="confirmpassword" value="[_request.confirmpassword]" />
<rsb:call op="ldapChangePassword">
[rss:title]<br />
[ldap:result]
</rsb:call>
</rsb:check>
| | | This RSSBus Web Part template will allow your users to easily change their own passwords through Active Directory, saving system
administrators countless hours of support in helping users accomplish this on their own. The LDAP Connector showcased in this example has the
ability to search, add, modify, and delete LDAP entries in Active Directory and any other LDAP directory server.
| ldap.ChangePassword.txt | http://rssbus.com/products/sharepoint/templates/ldap.ChangePassword_thumb.png | active directory, ad, password | Change Active Directory Password |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/ldap.CustomSearch_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template allows you to perform a custom LDAP search on any LDAP server, like Active Directory, and optionally format it however you like using your own HTML markup.
</td>
</tr>
</table>
| 1421 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.CustomSearch | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.CustomSearch | Mon, 08 Feb 2010 17:26:18 GMT | Custom LDAP Search Web Part Template | System Administration, Directory Services |
<rsb:import lib="RSSBus.LdapOps" />
<rsb:info>
<input name="server" required="true" description="Hostname or IP address of your LDAP server."/>
<input name="authdn" required="true" description="The DN or account name to login with."/>
<input name="password" required="true" description="The password to login with."/>
<input name="dn" required="true" default="cn=Users,dc=Domain" description="The DN to perform the search on."/>
<input name="filter" default="cn=*" description="The search filter to use."/>
<input name="scope" default="SINGLELEVEL" description="The search scope to use (BASEOBJECT, SINGLELEVEL, or WHOLESUBTREE)." />
</rsb:info>
<rsb:set attr="_meta.YUITableAttrs" value="ldap:entry, ldap:description"/>
<rsb:call op="ldapSearch" format="YuiTable" format="YuiTable">
<rsb:set attr="ldap:entry" value="[ldap:cn]<br />[ldap:dn]" />
</rsb:call>
| | LdapOps | This Web Part template allows you to perform a custom LDAP search on any LDAP server, like Active Directory, and optionally format it however you like using your own HTML markup.
| ldap.CustomSearch.txt | http://rssbus.com/products/sharepoint/templates/ldap.CustomSearch_thumb.png | ldap, active directory, ad | Custom LDAP Search |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/ldap.EmailGroupMembers_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template allows you to quickly compose an email message and send it to all members of a selected Active Directory Group.
The RSSBus LDAP Connector includes functionality for accessing information from Active Directory and other LDAP directory servers.
This Connector is utilized in this template to generate an HTML select input element which allows the user to choose an Active Directory group,
whose members will be recipients of the out-going email message. The
SMTP Connector used by this template has the capability of sending email with attachments, html bodies, custom headers, read and delivery receipts,
and it can even make a secure (SSL) connection to the mail server in question. This particular example sends all messages
through a specified mail server, however the SMTP Connector also has the ability to send each message directly to the mail server of the recipient.
This example requires the SMTP Connector and the LDAP Connector.
</td>
</tr>
</table>
| 4479 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.EmailGroupMembers | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.EmailGroupMembers | Mon, 08 Feb 2010 17:26:18 GMT | Email Site Users Web Part Template | System Administration, Directory Services |
<rsb:import lib="RSSBus.SmtpOps" />
<rsb:import lib="RSSBus.LdapOps" />
<rsb:info title="Email AD Groups" description="Quickly compose an email message and have it send to individual users or all users of the select AD Group." >
<input name="ldapserver" required="true" />
<input name="ldapauthdn" required="true" />
<input name="ldappassword" required="true" />
<input name="ldapdn" required="true" default="dc=com" />
<input name="mailserver" required="true" />
<input name="from" default="rssbus@webpart.com" required="true" />
</rsb:info>
<!-- get a list of groups in AD -->
<rsb:set attr="server" value="[ldapserver]" />
<rsb:set attr="authdn" value="[ldapauthdn]" />
<rsb:set attr="password" value="[ldappassword]" />
<rsb:set attr="dn" value="[ldapdn]" />
<rsb:set attr="filter" value="objectClass=group"/>
<rsb:set attr="scope" value="WHOLESUBTREE"/>
<rsb:call op="ldapSearch" save="groups" />
<!-- display input elements for recipient, subject, and message content -->
<table>
<tr><td>To:</td>
<td>
<select name="recipient" style="width:200px">
<!--display the list of groups -->
<rsb:call op="feedGet?feed=[_feeds.groups | urlencode]">
<option value="[ldap:dn]">[ldap:name]</option>
</rsb:call>
</select>
</td>
</tr>
<tr><td>Subject:</td><td><input type="text" value="" style="width:200px" name="Subject" id="Subject" value="" /></td></tr>
<tr><td>Message:</td><td></td></tr>
<tr><td colspan="2"><textarea name="Message" rows="10" cols="71"></textarea></td></tr>
<tr><td></td><td align="right"><input type="submit" /></td></tr>
</table>
<!-- when a message is submitted, send it with the smtpSendMessage operation -->
<rsb:equals attr="_request.request_method" value="POST">
<rsb:check attr="_request.form:Message">
<rsb:notequals attr="_request.form:Message" value="">
<!-- find the members of the group -->
<rsb:set attr="dn" value="[_request.form:recipient]"/>
<rsb:set attr="scope" value="BASEOBJECT"/>
<rsb:set attr="filter" value="objectClass=*"/>
<rsb:call op="ldapSearch">
<!-- for each member, find their email address and send the message -->
<rsb:enum range="1..[ldap:member#]">
<rsb:set attr="dn" value="[ldap:member#[_value]]"/>
<rsb:set attr="server" value="[ldapserver]" />
<rsb:call op="ldapSearch">
<rsb:check attr="ldap:mail" >
<!-- set the properties of the message -->
<rsb:set attr="server" value="[mailserver]" />
<rsb:set attr="from" value="[from]" />
<rsb:set attr="subject" value="[_request.form:Subject]" />
<rsb:set attr="html" value="[_request.form:Message]" />
<rsb:set attr="to" value="[ldap:mail]" />
<rsb:call op="smtpSendMessage">
Emailed [ldap:mail]: [smtp:messageid | def('Message Not Sent.')]<br />
</rsb:call>
<rsb:else>
Skipped [ldap:cn] ([ldap:dn]): No email address in this users entry.<br />
</rsb:else>
</rsb:check>
</rsb:call>
</rsb:enum>
</rsb:call>
</rsb:notequals>
</rsb:check>
</rsb:equals>
| | SmtpOps, LdapOps | This Web Part template allows you to quickly compose an email message and send it to all members of a selected Active Directory Group.
The RSSBus LDAP Connector includes functionality for accessing information from Active Directory and other LDAP directory servers.
This Connector is utilized in this template to generate an HTML select input element which allows the user to choose an Active Directory group,
whose members will be recipients of the out-going email message. The
SMTP Connector used by this template has the capability of sending email with attachments, html bodies, custom headers, read and delivery receipts,
and it can even make a secure (SSL) connection to the mail server in question. This particular example sends all messages
through a specified mail server, however the SMTP Connector also has the ability to send each message directly to the mail server of the recipient.
This example requires the SMTP Connector and the LDAP Connector.
| ldap.EmailGroupMembers.txt | http://rssbus.com/products/sharepoint/templates/ldap.EmailGroupMembers_thumb.png | email, smtp, ldap, Active Directory, ad | Email Site Users |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/ldap.ListGroups_thumb.png'>
</td>
<td VALIGN="top">
Displays a list of Active Directory groups (or groups from any LDAP capable server) and displays group member information.
</td>
</tr>
</table>
| 2385 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.ListGroups | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.ListGroups | Mon, 08 Feb 2010 17:26:18 GMT | List Active Directory Groups and Users Web Part Template | System Administration, Directory Services | <rsb:import lib="RSSBus.LdapOps" />
<rsb:info>
<input name="server" required="true" />
<input name="authdn" required="true" />
<input name="password" required="true" />
<input name="dn" required="true" default="dc=com" />
<input name="showemptygroups" values="false,true" />
</rsb:info>
<!-- get a list of groups -->
<rsb:set attr="filter" value="objectClass=group"/>
<rsb:set attr="scope" value="WHOLESUBTREE"/>
<rsb:call op="ldapSearch" save="groups" />
<!-- for each group, find out who the members are -->
<rsb:call op="feedGet?feed=[_feeds.groups | urlencode]">
<rsb:set attr="showgroup" value="true" />
<rsb:equals attr="_input.showemptygroups" value="false">
<rsb:set attr="showgroup" value="[ldap:member# | def('0') | equals('0', 'false', 'true')]" />
</rsb:equals>
<rsb:equals attr="showgroup" value="true">
<a href="javascript:;" onmousedown="toggleDiv('[ldap:name]-content');">[ldap:name]</a> ([ldap:member# | def('0')])
<div id="[ldap:name]-content" style="display:none">
<rsb:set attr="dn" value="[ldap:dn]"/>
<rsb:set attr="scope" value="BASEOBJECT"/>
<rsb:call op="ldapSearch" output="out">
<table width="100%">
<tr style="background-color:LightGrey"><td>samAccountName:</td><td>[ldap:samaccountname]</td></tr>
<tr style="background-color:LightGrey"><td>Full Group DN:</td><td>[ldap:dn]</td></tr>
<tr></tr>
<rsb:enum attr="ldap:member">
<tr><td colspan="2">[_value]</td></tr>
</rsb:enum>
</table>
</rsb:call>
</div>
<hr />
</rsb:equals>
</rsb:call>
<script type="text/javascript">
function toggleDiv(div) {
var mydiv=document.getElementById(div);
if(mydiv.style.display == 'none') {
mydiv.style.display = 'block';
}
else {
mydiv.style.display = 'none';
}
}
</script>
| | LdapOps | Displays a list of Active Directory groups (or groups from any LDAP capable server) and displays group member information.
| ldap.ListGroups.txt | http://rssbus.com/products/sharepoint/templates/ldap.ListGroups_thumb.png | ldap, active directory, ad, security | List Active Directory Groups and Users |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/ldap.ResetPassword_thumb.png'>
</td>
<td VALIGN="top">
This RSSBus Web Part template will allow an administrator (not just any user) to reset the password of any user through Active Directory.
This is different from the "Change Active Directory Password" web part in that this web part does not require knowledge of the current password, but does
require knowledge of an administrator password.
The LDAP Connector showcased in this example has the ability to search, add, modify, and delete LDAP entries in Active Directory and any other LDAP directory server.
</td>
</tr>
</table>
| 2387 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.ResetPassword | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ldap.ResetPassword | Mon, 02 Aug 2010 00:59:21 GMT | Reset Active Directory Password Web Part Template | System Administration, Directory Services |
<rsb:import lib="RSSBus.LdapOps" />
<rsb:info title="Reset Active Directory Password">
<input name="server" required="true" />
<input name="port" default="636" required="true" />
<input name="admindn" required="true" />
<input name="adminpassword" required="true" />
</rsb:info>
<style>
.myinput { width:150px; }
</style>
<table>
<tr><td>User (Full DN):</td><td><input type="text" class="myinput" style="width:150px" name="user" value=""/></td></tr>
<tr><td>New Password:</td><td><input type="password" class="myinput" name="newpassword" /></td></tr>
<tr><td>Confirm:</td><td><input type="password" class="myinput" name="confirmpassword" /></td></tr>
<tr><td></td><td align="right"><input type="submit" value="Submit"/></td></tr>
</table>
<!-- check to see if they've submitted the required info: -->
<rsb:check attr="_request.newpasswordpassword">
<!-- set LDAP connectivity properties (636 is ssl) -->
<rsb:set attr="server" value="[server]" />
<rsb:set attr="port" value="[port]" />
<rsb:set attr="sslmode" value="IMPLICIT" />
<rsb:set attr="authdn" value="[admindn]" />
<rsb:set attr="password" value="[adminpassword]" />
<!-- and now change the password -->
<rsb:set attr="dn" value="[_request.user]" />
<rsb:set attr="newpassword" value="[_request.newpassword]" />
<rsb:set attr="confirmpassword" value="[_request.confirmpassword]" />
<rsb:call op="ldapResetPassword">
[rss:title]<br />
[ldap:result]
</rsb:call>
</rsb:check>
| | | This RSSBus Web Part template will allow an administrator (not just any user) to reset the password of any user through Active Directory.
This is different from the "Change Active Directory Password" web part in that this web part does not require knowledge of the current password, but does
require knowledge of an administrator password.
The LDAP Connector showcased in this example has the ability to search, add, modify, and delete LDAP entries in Active Directory and any other LDAP directory server.
| ldap.ResetPassword.txt | http://rssbus.com/products/sharepoint/templates/ldap.ResetPassword_thumb.png | active directory, ad, password | Reset Active Directory Password |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/mscrm.GetAppointments_thumb.png'>
</td>
<td VALIGN="top">
Bring Microsoft CRM Appointments Into SharePoint. This template displays a list of upcoming appointments from Microsoft CRM inside a data table.
</td>
</tr>
</table>
| 2201 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=mscrm.GetAppointments | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=mscrm.GetAppointments | Mon, 08 Feb 2010 17:26:18 GMT | List Microsoft CRM Appointments Web Part Template | CRM Systems | <rsb:import lib="RSSBus.MscrmOps"/>
<rsb:info>
<input name="server" description="The IP address or hostname of your Microsoft Dynamics CRM Install." required="true" />
<input name="user" description="A user name for authenticating with MS Dynamics CRM Services." required="true" />
<input name="password" description="A password for authenticating with MS Dynamics CRM Services." required="true" />
<output name="mscrm:subject" description="subject of the appointment"/>
<output name="mscrm:scheduledstart" description="start datetime of the appointment"/>
<output name="mscrm:scheduleddurationminutes" description=""/>
<output name="mscrm:location" description="location of the event"/>
<output name="mscrm:description" description="description of the appointment"/>
</rsb:info>
<rsb:set attr="serviceurl" value="http://[server]:5555/mscrmservices/2006/crmservice.asmx"/>
<rsb:set attr="username" value="[user]"/>
<rsb:set attr="password" value="[password]"/>
<rsb:set attr="maxresults" value="300" />
<rsb:set attr="_meta.YUITableAttrs" value="mscrm:subject, mscrm:scheduledstart, mscrm:scheduleddurationminutes, mscrm:location, mscrm:description"/>
<rsb:set attr="_meta.YUITableLabels" value="Subject, Start Time, Duration (minutes), Location, Description"/>
<rsb:call op="mscrmAppointment" format="yuitable">
<rsb:set attr="mscrm:scheduledstart" value="[mscrm:scheduledstart | todate('MM/dd/yyyy hh:mm')]" />
<rsb:set attr="mscrm:subject" value="<a href='http://www.rssbus.com'>[mscrm:subject]</a>" />
</rsb:call>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.MscrmOps.info' target='_blank'>RSSBus.MscrmOps</a>. | MscrmOps | Bring Microsoft CRM Appointments Into SharePoint. This template displays a list of upcoming appointments from Microsoft CRM inside a data table. | mscrm.GetAppointments.txt | http://rssbus.com/products/sharepoint/templates/mscrm.GetAppointments_thumb.png | mscrm, crm, microsoft | List Microsoft CRM Appointments |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/mscrm.GetContacts_thumb.png'>
</td>
<td VALIGN="top">
Bring Microsoft CRM Contacts into SharePoint. This template displays a data table containing a list of contacts retrieved from Microsoft Dynamics CRM.
</td>
</tr>
</table>
| 1823 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=mscrm.GetContacts | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=mscrm.GetContacts | Mon, 08 Feb 2010 17:26:18 GMT | List Microsoft Dynamics CRM Contacts Web Part Template | CRM Systems | <rsb:import lib="RSSBus.MscrmOps"/>
<rsb:info>
<input name="server" description="The IP address or hostname of your Microsoft Dynamics CRM Install." required="true" />
<input name="user" description="A user name for authenticating with MS Dynamics CRM Services." required="true" />
<input name="password" description="A password for authenticating with MS Dynamics CRM Services." required="true" />
<output name="mscrm:fullname" description="The full name of the contact."/>
<output name="mscrm:telephone1" description="The telephone number of the contact."/>
<output name="mscrm:address1_city" description="The city of the contact."/>
</rsb:info>
<rsb:set attr="serviceurl" value="http://[server]:5555/mscrmservices/2006/crmservice.asmx"/>
<rsb:set attr="username" value="[user]"/>
<rsb:set attr="password" value="[password]"/>
<rsb:set attr="maxresults" value="300" />
<rsb:set attr="_meta.YUITableAttrs" value="mscrm:fullname, mscrm:telephone1, mscrm:address1_city"/>
<rsb:set attr="_meta.YUITableLabels" value="Full Name, Phone #, City"/>
<rsb:call op="mscrmContact" format="yuitable" />
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.MscrmOps.info' target='_blank'>RSSBus.MscrmOps</a>. | MscrmOps | Bring Microsoft CRM Contacts into SharePoint. This template displays a data table containing a list of contacts retrieved from Microsoft Dynamics CRM. | mscrm.GetContacts.txt | http://rssbus.com/products/sharepoint/templates/mscrm.GetContacts_thumb.png | crm, microsoft, data migration, dymanics, contact, web service | List Microsoft Dynamics CRM Contacts |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/mysql.RecordEditor_thumb.png'>
</td>
<td VALIGN="top">
Edit MySQL Records from within Sharepoint with this RSSBus Web Part template.
</td>
</tr>
</table>
| 2956 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=mysql.RecordEditor | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=mysql.RecordEditor | Mon, 08 Feb 2010 17:26:18 GMT | MySQL Record Editor Web Part Template | Database | <rsb:import lib="RSSBus.MysqlOps"/>
<rsb:info>
<input name="table" description="Table containing the records you would like to edit" required="true"/>
<input name="conn" default="Server=127.0.0.1;Database=sakila;Uid=myUsername;Pwd=myPassword;"
</rsb:info>
<rsb:set attr="query" value="select email, first_name, last_name from [table]"/>
<!-- Check for post and do Sql Update -->
<rsb:check attr="_request.mysqlUpdateSubmit">
<rsb:set attr="rec:email" value="[_request.email]"/>
<rsb:set attr="new:first_name" value="[_request.first_name]"/>
<rsb:set attr="new:last_name" value="[_request.last_name]"/>
<rsb:set attr="table" value="[table]"/>
<rsb:call op="mysqlUpdate">
<!-- Make sure the insert is successful -->
<rsb:check attr="mysql:affectedrows">
<b>Update Successful!</b>
</rsb:check>
</rsb:call>
</rsb:check>
<!-- Hidden Update Form (company name used as key)-->
<div id="editForm" style="visibility:hidden;display:none">
<input type="hidden" id="email" name="email"/>
<label>First Name<input id="first_name" name="first_name"/></label>
<label>Last Name<input id="last_name" name="last_name"/></label>
<input type="submit" name="mysqlUpdateSubmit" >
</div>
<!-- mySql Query to display our records in a datatable -->
<rsb:set attr="_meta.YUITableAttrs" value="edit, mysql:first_name, mysql:last_name, mysql:email"/>
<rsb:set attr="_meta.YUITableLabels" value="Action, First Name, Last Name, E-Mail"/>
<rsb:set attr="_meta.YUIDivname" value="sqlData"/>
<rsb:call op="mysqlQuery" save="mysqlQuery" out="out">
<rsb:set attr="out.edit">
<a href="javascript:editRow('[_index]')">edit</a>
</rsb:set>
</rsb:call>
<rsb:call op="[_feeds.mysqlQuery]" format="yuitable"/>
<script>
function editRow(key)
{
//Show edit div
var editForm = document.getElementById('editForm');
editForm.style.visibility='visible';
editForm.style.display='block';
//Get JSON Record
var _curRow = [_meta.YUIDivname].items[key - 1];
//Populate Inputs
populateField(_curRow,"last_name");
populateField(_curRow,"email");
populateField(_curRow,"first_name");
}
function populateField(curRow,name)
{
document.getElementById(name).value = curRow["mysql:"+name];
}
</script>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.MysqlOps.info' target='_blank'>RSSBus.MysqlOps</a>. This template uses the sakila sample MySQL database | MySqlOps | Edit MySQL Records from within Sharepoint with this RSSBus Web Part template. | mysql.RecordEditor.txt | http://rssbus.com/products/sharepoint/templates/mysql.RecordEditor_thumb.png | MySql, Database, Sakila, crud | MySQL Record Editor |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/nntp.newsgroup-browser_thumb.png'>
</td>
<td VALIGN="top">
Displays a list of the latest articles from the specified newsgroup and allows users to display the content of messages through a simple message reader.
</td>
</tr>
</table>
| 2573 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=nntp.newsgroup-browser | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=nntp.newsgroup-browser | Mon, 08 Feb 2010 17:26:18 GMT | USENET Newsgroup Browser Web Part Template | Internet | <rsb:import lib="RSSBus.NntpOps" />
<rsb:info title="RSSBus SharePoint WebPart: USENET Newsgroup Browser">
<input name="Server" default="msnews.microsoft.com" required="true" />
<input name="Group" default="microsoft.public.sharepoint.windowsservices" required="true" />
<input name="Range" default="25" />
</rsb:info>
<style>
#news { height:100;overflow:auto }
#news TABLE, #headers TABLE { width:98%; }
#news TH, #news TD { white-space:nowrap }
#news TH, #headers TABLE { background-color:LightGrey; }
</style>
<div id=news>
<table>
<tr>
<th>Subject</th> <th>Author</th> <th>Size</th> <th>Date</th>
</tr>
<rsb:call op="nntpListArticles">
<tr>
<td><a href="?msgnumber=[nntp:number]">[nntp:subject | truncate('60')]</a></td>
<td>[nntp:author]</td>
<td>[nntp:size]</td>
<td>[nntp:date]</td>
</tr>
</rsb:call>
</table>
</div>
<div>
<rsb:check attr="_request.msgnumber">
<hr />
<rsb:call op="nntpGetArticle?article=[_request.msgnumber]">
<div id="headers">
<table width="98%" style="background-color:LightGrey">
<tr><td width="75px">From:</td>
<td><a href="mailto:[nntp:author | htmlencode]">[nntp:author | htmlencode]</a></td>
</tr>
<tr><td width="75px">Date:</td><td>[nntp:date]</td></tr>
<tr><td width="75px">Subject:</td><td>[nntp:subject]</td></tr>
<tr />
<tr><td colspan="2"> <a href="http://groups.google.com/groups?threadm=[nntp:id | Replace('<', '') | Replace('>', '') | urlencode]">View in Google Groups</a>
</td></tr>
</table>
</div>
<div id="body" style="height:400;overflow:auto">
<hr />
[nntp:body | Replace('0A','<br>','true')]
</div>
<p />
<a href="http://groups.google.com/groups?threadm=[nntp:id | Replace('<', '') | Replace('>', '') | urlencode]">View in Google Groups</a>
</rsb:call>
</rsb:check>
</div>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.NntpOps.info' target='_blank'>RSSBus.NntpOps</a>. | NntpOps | Displays a list of the latest articles from the specified newsgroup and allows users to display the content of messages through a simple message reader.
| nntp.newsgroup-browser.txt | http://rssbus.com/products/sharepoint/templates/nntp.newsgroup-browser_thumb.png | nntp, newsgroup, news group, usenet | USENet Newsgroup Browser |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/oracle.PieChartQuery_thumb.png'>
</td>
<td VALIGN="top">
This Web Part performs a simple query on a sample Oracle database and then displays the results using the MSChart formatter, one of the many feed formatters available with RSSBus.
</td>
</tr>
</table>
| 3003 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.PieChartQuery | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.PieChartQuery | Mon, 08 Feb 2010 17:26:18 GMT | Pie Chart from an Oracle Query Web Part Template | Database, Charts and Maps |
<rsb:import lib="RSSBus.OracleOps"/>
<rsb:import lib="RSSBus.ChartOps"/>
<rsb:info title="ChartQuery" description="Create a pie chart from an Oracle query.">
<input name="conn" description="The connection string used to define the connection." default="Data Source=XE;User Id=hr;Password=hr;Integrated Security=no;" required="true" />
<input name="query" description="The query to execute." required="true" default="select * from JOBS" required="true"/>
<input name="defaultcharttype" description="The type of chart to render." values="Pie,Doughnut" default="Doughnut"/>
<input name="palette" description="The color palette to apply to this chart." values="Bright,Grayscale,Excel,Light,Pastel,EarthTones,SemiTransparent,Berry,Chocolate,Fire,SeaGreen,BrightPastel" default="SemiTransparent"/>
<input name="3denable" description="Specifies whether this chart should be rendered in 3d." values="True,False" default="True"/>
<input name="displaylabels" description="Specifies whether this chart display X axis labels." values="True,False" default="False"/>
<input name="height" description="The height of this chart." default="240"/>
<input name="width" description="The width of this chart." default="320"/>
</rsb:info>
<rsb:set item='_meta' attr='yaxis' value='ora:max_salary' />
<rsb:set item='_meta' attr='xaxis' value='ora:job_title' />
<rsb:set item='_meta' attr='charttitle' value='Company Salaries' />
<rsb:set item='_meta' attr='width' value='[width]' />
<rsb:set item='_meta' attr='height' value='[height]' />
<rsb:set item='_meta' attr='3denable' value='[3denable]' />
<rsb:set item='_meta' attr='xaxisinterval' value='1' />
<rsb:set item='_meta' attr='defaultcharttype' value='[defaultcharttype]' />
<rsb:set item='_meta' attr='displayxaxislabel' value='[displaylabels]' />
<rsb:set item="_meta" attr="palette" value="[palette]"/>
<rsb:set item="_meta" attr="3dinclination" value="40"/>
<div align="center">
<rsb:call op="oracleQuery" format="MSChart" pagesize="5" >
<rsb:set attr="ora:job_title" value="[ora:job_title]([ora:max_salary | divide('1000')]k)"/>
</rsb:call>
</div>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.OracleOps.info' target='_blank'>RSSBus.OracleOps</a> & <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.ChartOps.info' target='_blank'>RSSBus.ChartOps</a>. | OracleOps, ChartOps | This Web Part performs a simple query on a sample Oracle database and then displays the results using the MSChart formatter, one of the many feed formatters available with RSSBus. | oracle.PieChartQuery.txt | http://rssbus.com/products/sharepoint/templates/oracle.PieChartQuery_thumb.png | oracle, chart, graph, database | Pie Chart From an Oracle Query |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/oracle.Query_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template shows how to perform a basic Oracle query without requiring use of the SharePoint Business Data Catalog. The results are displayed in a table format by taking advantage of one of the many feed formatters available with RSSBus.
</td>
</tr>
</table>
| 1441 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.Query | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.Query | Mon, 08 Feb 2010 17:26:18 GMT | Oracle Query Results Web Part Template | Database | <rsb:import lib="RSSBus.OracleOps"/>
<rsb:info>
<input name="conn" description="The connection string used to define the connection." required="true" />
<input name="query" description="The query to execute" required="true" default="SELECT CompanyName, City, Phone, ContactTitle FROM Suppliers ORDER BY CompanyName" />
<input name="maxrows" description="The Max number of rows to return (-1 is used to return all rows)" default="-1"/>
</rsb:info>
<rsb:set attr="_meta.YUITableAttrs" value="oracle:companyname, oracle:city, oracle:phone, oracle:contacttitle"/>
<rsb:set attr="_meta.YUITableLabels" value="Company Name, City, Phone, Title"/>
<rsb:call op="oracleQuery" format="ToYuiTable"/>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.OracleOps.info' target='_blank'>RSSBus.OracleOps</a>. | OracleOps | This Web Part template shows how to perform a basic Oracle query without requiring use of the SharePoint Business Data Catalog. The results are displayed in a table format by taking advantage of one of the many feed formatters available with RSSBus. | oracle.Query.txt | http://rssbus.com/products/sharepoint/templates/oracle.Query_thumb.png | oracle, database, oracle query, crud | Oracle Query Results |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/oracle.RecordEditor_thumb.png'>
</td>
<td VALIGN="top">
This Web Part shows how to query and update records in an Oracle database from within SharePoint. The Oracle Connector includes full parameterized CRUD functionality.
</td>
</tr>
</table>
| 3198 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.RecordEditor | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.RecordEditor | Mon, 08 Feb 2010 17:26:18 GMT | Edit Records in Oracle Database (CRUD) Web Part Template | Database | <rsb:import lib="RSSBus.OracleOps"/>
<rsb:info>
<input name="conn" description="The connection string for your Oracle database." required="true"/>
</rsb:info>
<rsb:set attr="conn" value="[conn]"/>
<rsb:set attr="query" value="SELECT CompanyName, City, Phone, ContactTitle FROM Suppliers ORDER BY CompanyName"/>
<!-- Check for post and do Oracle Update -->
<rsb:check attr="_request.oracleUpdateSubmit">
<rsb:set attr="new:city" value="[_request.city]"/>
<rsb:set attr="new:contacttitle" value="[_request.contacttitle]"/>
<rsb:set attr="new:phone" value="[_request.phone]"/>
<rsb:set attr="rec:companyname" value="[_request.companyname]"/>
<rsb:set attr="table" value="Suppliers"/>
<rsb:call op="oracleUpdate">
<!-- Make sure the insert is successful -->
<rsb:check attr="oracle:affectedrows">
<b>Update Successful!</b>
</rsb:check>
</rsb:call>
</rsb:check>
<!-- Hidden Update Form (company name used as key)-->
<div id="editForm" style="visibility:hidden;display:none">
<label>City<input id="city" name="city"/></label>
<input type="hidden" id="companyname" name="companyname"/>
<label>Title<input id="contacttitle" name="contacttitle"/></label>
<label>Phone<input id="phone" name="phone"/></label>
<input type="submit" name="oracleUpdateSubmit" >
</div>
<!-- Oracle Query to display our records in a datatable -->
<rsb:set attr="_meta.YUITableAttrs" value="edit, oracle:companyname, oracle:city, oracle:phone, oracle:contacttitle"/>
<rsb:set attr="_meta.YUITableLabels" value="Action, Company Name, City, Phone, Title"/>
<rsb:set attr="_meta.YUIDivname" value="oracleData"/>
<rsb:call op="oracleQuery" save="oracleQuery" out="out">
<rsb:set attr="out.edit">
<a href="javascript:editRow('[_index]')">edit</a>
</rsb:set>
</rsb:call>
<rsb:call op="[_feeds.oracleQuery]" format="yuitable"/>
<script>
function editRow(key)
{
//Show edit div
var editForm = document.getElementById('editForm');
editForm.style.visibility='visible';
editForm.style.display='block';
//Get JSON Record
var _curRow = [_meta.YUIDivname].items[key - 1];
//Populate Inputs
populateField(_curRow,"city");
populateField(_curRow,"companyname");
populateField(_curRow,"contacttitle");
populateField(_curRow,"phone");
}
function populateField(curRow,name)
{
document.getElementById(name).value = curRow["oracle:"+name];
}
</script>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.OracleOps.info' target='_blank'>RSSBus.OracleOps</a>. | OracleOps | This Web Part shows how to query and update records in an Oracle database from within SharePoint. The Oracle Connector includes full parameterized CRUD functionality. | oracle.RecordEditor.txt | http://rssbus.com/products/sharepoint/templates/oracle.RecordEditor_thumb.png | Oracle, Database, crud | Edit Records in Oracle Database (CRUD) |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/oracle.select_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template displays the results of a standard Oracle query without requiring use of the SharePoint Business Data Catalog.
</td>
</tr>
</table>
| 1273 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.select | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=oracle.select | Mon, 08 Feb 2010 17:26:18 GMT | Oracle Database Select Web Part Template | Database | <rsb:import lib="RSSBus.OracleOps"/>
<rsb:info>
<input name="table" description="The table to select from" required="true" default="EMPLOYEES" />
<input name="cols" description="The columns to select from the table" required="true" default="FIRST_NAME,LAST_NAME,PHONE_NUMBER,JOB_ID" />
<input name="maxrows" description="The Max number of rows to return (-1 is used to return all rows)" default="-1"/>
</rsb:info>
<rsb:set attr="conn" value="Data Source=DatabaseIP;User Id=hr;Password=hr"/>
<rsb:call op="oracleSelect" format="yuitable"/>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.OracleOps.info' target='_blank'>RSSBus.OracleOps</a>. Note: The Oracle connecter requires you install the "Oracle Client" on the same machine that sharepoint resides. | OracleOps | This Web Part template displays the results of a standard Oracle query without requiring use of the SharePoint Business Data Catalog. | oracle.select.txt | http://rssbus.com/products/sharepoint/templates/oracle.select_thumb.png | database, oracle | Oracle Database Select |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/qb.SearchCustomers_thumb.png'>
</td>
<td VALIGN="top">
Take advantage of the QuickBooks Connector to search QuickBooks for customer information and display it in your SharePoint site.
</td>
</tr>
</table>
| 2240 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=qb.SearchCustomers | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=qb.SearchCustomers | Mon, 08 Feb 2010 17:26:18 GMT | Search QuickBooks for Customer Information Web Part Template | Business Applications, CRM Systems | <rsb:info>
<input name="conn" desc="If QuickBooks is running remotely, set this the the url to the Remote Connector (ie, url='http://remoteconnectorserver:2080')." def="" />
</rsb:info>
Customer: <input type="text" name="name" value="" />
<input type="submit" " value="Search" />
<rsb:check attr="_request.form:name" >
<rsb:import lib="RSSBus.QbOps"/>
<rsb:set attr="myinput.conn" value="[conn]" />
<rsb:call op="qbSearchCustomers?matchtype=CONTAINS&name=[_request.form:name]" input="myinput">
<rsb:first>
<div style="height:150;overflow:auto">
<table width="100%">
<tr>
<th style="background-color:LightGrey;"></th>
<th style="background-color:LightGrey; white-space:nowrap">Customer</th>
<th style="background-color:LightGrey; white-space:nowrap">Balance</th>
</tr>
</rsb:first>
<tr>
<td valign="top"><a href="mailto:[qb:email]"><img src="/Picture Library/icons/email.ico" width="16px" border="0" /></td>
<td>[qb:name | CapitalizeAll]</a><br />
<a id="company">[qb:company| CapitalizeAll]</a><br />
[qb:phone| CapitalizeAll]<br />
</td>
<td valign="top">[qb:balance | Divide('100') | Currency]</td>
</tr>
<rsb:last>
</table>
</rsb:last>
</rsb:call>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.QbOps.info'>RSSBus.QbOps</a>. If QuickBooks is running remotely, you'll need the <a href='http://rssbus.com/download/download.aspx?file=tools/QBRemoteConnector.zip'>Remote Connector</a> installed and the Web Part conn input should be set to its url (ie, url='http://remoteconnectorserver:2080'). | QbOps | Take advantage of the QuickBooks Connector to search QuickBooks for customer information and display it in your SharePoint site.
| qb.SearchCustomers.txt | http://rssbus.com/products/sharepoint/templates/qb.SearchCustomers_thumb.png | qb, quickbooks, quick books, accounting, book keeping, crm | Search QuickBooks for Customer Information |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/qb.SearchJobs_thumb.png'>
</td>
<td VALIGN="top">
This Web Part templates uses the QuickBooks Connector to search QuickBooks for information about jobs and display that information in a table on your SharePoint site.
</td>
</tr>
</table>
| 1848 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=qb.SearchJobs | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=qb.SearchJobs | Mon, 08 Feb 2010 17:26:18 GMT | Search QuickBooks for Information about Jobs Web Part Template | Business Applications, CRM Systems |
<rsb:info>
<input name="conn" desc="The url to the Remote Connector." def="" />
</rsb:info>
Customer: <input type="text" name="name" value="" />
<input type="submit" " value="Search" />
<rsb:check attr="_request.name" >
<rsb:import lib="RSSBus.QbOps" />
<!-- configure the YUI table appearance -->
<rsb:set attr="_meta.YuiTableAttrs" value="qb:details, qb:job_status, qb:job_startdate, qb:job_enddate" />
<rsb:set attr="_meta.YuiTableLabels" value="Job Details, Status, Start, End" />
<!-- now do the call to QuickBooks -->
<rsb:set attr="name" value="[_request.name]" />
<rsb:call op="qbSearchCustomers?includejobs=TRUE&matchtype=CONTAINS" format="YuiTable">
<rsb:set attr="qb:details">
<a href="mailto:[qb:email]">[qb:contact]</a><br />
[qb:bill_street], [qb:bill_state] [qb:bill_zip]<br />
[qb:phone]<br />
[qb:job_typename]<br />
<p>[qb:job_description]</p>
</rsb:set>
</rsb:call>
</rsb:check>
| If QuickBooks is running remotely, you'll need the <a href='http://rssbus.com/download/download.aspx?file=tools/QBRemoteConnector.zip'>Remote Connector</a> installed and the Web Part conn input should be set to its url (ie, url='http://remoteconnectorserver:2080'). | QbOps | This Web Part templates uses the QuickBooks Connector to search QuickBooks for information about jobs and display that information in a table on your SharePoint site.
| qb.SearchJobs.txt | http://rssbus.com/products/sharepoint/templates/qb.SearchJobs_thumb.png | qb, quickbooks, quick books, accounting, book keeping, crm | Search QuickBooks for Information about Jobs |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/s3.ExportToS3_thumb.png'>
</td>
<td VALIGN="top">
This simple Web Part template allows you to save and backup documents from any SharePoint document library directly to an Amazon S3 Account with a single click.
</td>
</tr>
</table>
| 1946 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=s3.ExportToS3 | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=s3.ExportToS3 | Mon, 08 Feb 2010 17:26:18 GMT | Export/Backup SharePoint Documents to Amazon S3 Web Part Template | Document Management, SharePoint Lists, Web Services | <rsb:import lib="RSSBus.AmazonOps"/>
<rsb:info title="S3 Backup" description="Backup a document to Amazon S3.">
<input name="accesskey" description="Access key of your Amazon S3 account." req="true"/>
<input name="secretkey" description="Secret key of your Amazon S3 account. req="true"/>
<input name="bucket" description="The bucket to which you would like to save the document. req="true"/>
<input name="library" description="Name of the document library from which to save documents." default="Shared Documents"/>
</rsb:info>
<b>Click to save to Amazon S3.</b>
<hr>
<rsb:call op="spListDocuments?library=[library]">
<rsb:first>
<table class="ms-ls"><tr><th>Document</th><th>Modified</th>
</rsb:first>
<tr><td><a href="?save_to_s3=[sp:url]">[sp:name]</a><td>[sp:modified]</td>
<rsb:last>
</table>
</rsb:last>
</rsb:call>
<rsb:check attr="_request.save_to_s3">
<rsb:set attr="file" value="sp://[_request.server:HTTP_HOST]/[_request.save_to_s3]"/>
<rsb:call op="amazonS3CreateObject">
<hr>Saved the file [_request.save_to_s3] as [amz:object] in the bucket [bucket].</br>
</rsb:call>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.AmazonOps.info' target='_blank'>RSSBus.AmazonOps</a>. | AmazonOps | This simple Web Part template allows you to save and backup documents from any SharePoint document library directly to an Amazon S3 Account with a single click.
| s3.ExportToS3.txt | http://rssbus.com/products/sharepoint/templates/s3.ExportToS3_thumb.png | amazon, cloud, s3, document management, sync, amazon bucket | Export/Backup SharePoint Documents to Amazon S3 |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/s3.ImportFromS3_thumb.png'>
</td>
<td VALIGN="top">
This simple Web Part allows you to restore/import documents from Amazon S3 into any SharePoint Document Library with a single click.
</td>
</tr>
</table>
| 2004 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=s3.ImportFromS3 | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=s3.ImportFromS3 | Mon, 08 Feb 2010 17:26:18 GMT | Import/Restore SharePoint Documents from Amazon S3 Web Part Template | Document Management, SharePoint Lists, Web Services | <rsb:import lib="RSSBus.AmazonOps"/>
<rsb:info title="S3 Backup" description="Retrieve a document from Amazon S3.">
<input name="accesskey" description="Access key of your Amazon S3 account." req="true"/>
<input name="secretkey" description="Secret key of your Amazon S3 account. req="true"/>
<input name="bucket" description="The bucket from which you would like to retrieve the document. req="true"/>
<input name="library" description="Name of the document library to restore to." default="Shared Documents"/>
</rsb:info>
<b>Click to restore from Amazon S3.</b>
<hr>
<rsb:call op="amazonS3ListObjects">
<rsb:first>
<table class="ms-ls"><tr><th>Object</th><th>Modified</th>
</rsb:first>
<tr><td><a href="?save_to_lib=[amz:object]">[amz:object]</a><td>[amz:lastmod | split('T','1')]</td>
<rsb:last>
</table>
</rsb:last>
</rsb:call>
<rsb:check attr="_request.save_to_lib">
<rsb:set attr="file" value="sp://[_request.server:HTTP_HOST]/[library]/[_request.save_to_lib]"/>
<rsb:set attr="object" value="[_request.save_to_lib]"/>
<rsb:call op="amazonS3GetObject">
<hr>Saved the object [_request.save_to_lib] from the bucket [bucket] to [library].</br>
</rsb:call>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.AmazonOps.info' target='_blank'>RSSBus.AmazonOps</a>. | AmazonOps | This simple Web Part allows you to restore/import documents from Amazon S3 into any SharePoint Document Library with a single click.
| s3.ImportFromS3.txt | http://rssbus.com/products/sharepoint/templates/s3.ImportFromS3_thumb.png | amazon, cloud, s3, document management, sync, amazon bucket | Import/Restore SharePoint Documents from Amazon S3 |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/salesforce.ContactsSync_thumb.png'>
</td>
<td VALIGN="top">
Syncs a SharePoint Contact list from a SalesForce Leads Table.
</td>
</tr>
</table>
| 4798 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.ContactsSync | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.ContactsSync | Mon, 08 Feb 2010 17:26:18 GMT | SalesForce Contacts Sync Web Part Template | CRM Systems | <rsb:info title="Sync SharePoint Contacts from SalesForce Leads." description="Syncs a SharePoint Contact list from a SalesForce Leads Table.">
<input name="user" description="Your SalesForce account login." />
<input name="password" style="password" description="Your SalesForce account password." />
<input name="list" description="The name of the SharePoint Contact list to sync." required="true"/>
</rsb:info>
<div style="padding-left:5px;padding-top:5px;">
<rsb:check attr="_request.clickedSync.x">
<!-- import any necessary data connector -->
<rsb:import lib="RSSBus.SalesforceOps"/>
<!-- get all the items from my SP list -->
<rsb:call op="spListItems" out="myitemout" save="myspitems" >
<rsb:call op="spGetItem?id=[sp:id]" >
<rsb:set attr="myitemout.lastname" value="[sp:last_name]"/>
<rsb:set attr="myitemout.firstname" value="[sp:first_name]"/>
<rsb:set attr="myitemout.fullname" value="[sp:full_name| def(' ')]"/>
<rsb:set attr="myitemout.phone" value="[sp:business_phone]"/>
<rsb:set attr="myitemout.email" value="[sp:e-mail_address]" />
<rsb:set attr="myitemout.company" value="[sp:company | def('')]" />
<rsb:set attr="myitemout.spid" value="[sp:id]" />
</rsb:call>
</rsb:call>
<!-- get all the items from my salesforce leads -->
<rsb:set attr="user" value="[user]"/>
<rsb:set attr="password" value="[password]"/>
<rsb:call op="salesforceSelectLead" save="mysfitems">
<!-- set any attributes I want to sync -->
<rsb:set attr="lastname" value="[sf:lastname]"/>
<rsb:set attr="firstname" value="[sf:firstname]"/>
<rsb:set attr="fullname" value="[sf:name]"/>
<rsb:set attr="phone" value="[sf:phone]"/>
<rsb:set attr="email" value="[sf:email]"/>
<rsb:set attr="company" value="[sf:company]"/>
<rsb:set attr="sfid" value="[sf:id]" />
</rsb:call>
<!-- now find out what is in salesforce leads that is not in the sharepoint list, using email address as the filter -->
<rsb:set attr="diff.base" value="[_feeds.myspitems]"/>
<rsb:set attr="diff.feed" value="[_feeds.mysfitems]"/>
<rsb:set attr="diff.filter" value="email"/>
<rsb:set attr="diff.list" value="[list]"/>
<rsb:call op="feedDiff" in="diff">
<!-- for everything not in the sp list, add it! -->
<rsb:set attr="name#" value="First Name"/>
<rsb:set attr="value#" value="[firstname]"/>
<rsb:set attr="name#" value="Last Name"/>
<rsb:set attr="value#" value="[lastname]"/>
<rsb:set attr="name#" value="Full Name"/>
<rsb:set attr="value#" value="[fullname]"/>
<rsb:set attr="name#" value="Business Phone"/>
<rsb:set attr="value#" value="[phone]"/>
<rsb:set attr="name#" value="Email"/>
<rsb:set attr="value#" value="[email]"/>
<rsb:set attr="name#" value="Company"/>
<rsb:set attr="value#" value="[company]"/>
<rsb:call op="spAddItem"/>
<b>[fullname]</b> Successfully imported from SalesForce.<br>
</rsb:call>
<!-- now find out what is in the sharepoint list that is not in the salesforce leads, using email address as unique key -->
<rsb:set attr="diff.base" value="[_feeds.mysfitems]"/>
<rsb:set attr="diff.feed" value="[_feeds.myspitems]"/>
<rsb:set attr="diff.filter" value="email"/>
<rsb:set attr="diff.user" value="[user]"/>
<rsb:set attr="diff.password" value="[password]"/>
<rsb:set attr="diff.list" value="[list]"/>
<rsb:call op="feedDiff" in="diff" out="diffout">
<!-- for everything not in the salesforce list, delete it from sp! -->
<rsb:call op="feedGet?feed=[_feeds.myspitems | urlencode]" out="spout">
<rsb:equals attr="spout.email" value="[diffout.email]">
<rsb:call op="spDeleteItem?id=[spout.sp:id]">
<b>[fullname]</b> Successfully deleted from SharePoint.<br>
</rsb:call>
</rsb:equals>
</rsb:call>
</rsb:call>
<input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
Sync Complete!
<rsb:else>
<input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
Sync!
</rsb:else>
</rsb:check>
</div>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SalesforceOps.info' target='_blank'>RSSBus.SalesforceOps</a>. | SalesforceOps | Syncs a SharePoint Contact list from a SalesForce Leads Table. | salesforce.ContactsSync.txt | http://rssbus.com/products/sharepoint/templates/salesforce.ContactsSync_thumb.png | salesforce, sales, crm, erp, contacts, sync, saas | SalesForce Contacts Sync |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/salesforce.CustomObject_thumb.png'>
</td>
<td VALIGN="top">
Displays a grid of SalesForce Custom Objects inside SharePoint.
</td>
</tr>
</table>
| 1742 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.CustomObject | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.CustomObject | Mon, 08 Feb 2010 17:26:18 GMT | List SalesForce Custom Objects Web Part Template | CRM Systems | <rsb:import lib="RSSBus.SalesforceOps"/>
<rsb:info title="SalesForce Custom Objects" description="Displays a grid of SalesForce Custom Objects.">
<input name="user" description="Your SalesForce account login." />
<input name="password" style="password" description="Your SalesForce account password." />
<input name="customobject" description="The name of the custom object in SalesForce." required="true"/>
<output name="sf:*" description="Custom object attributes"/>
</rsb:info>
<rsb:import lib="RSSBus.SalesforceOps"/>
<!-- specify the attributes to display in the YUI Table -->
<rsb:set attr="_meta.YUITableAttrs" value="sf:name, sf:total__c, sf:contacts__c, sf:lastmodifieddate, sf:url__c"/>
<rsb:set attr="_meta.YUITableLabels" value="Name, Total, #Contacts, Last Modified, URL"/>
<!-- call the salesforceSelect operation to retrieve the custom objects -->
<rsb:call op="salesforceSelect?objectname=[customobject]__c" format="yuitable">
<rsb:set attr="sf:lastmodifieddate" value="[sf:lastmodifieddate | date('MM/dd/yyyy hh:mm')]" />
<rsb:set attr="sf:url__c">
<a href="[sf:url__c]">web</a>
</rsb:set>
</rsb:call>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SalesforceOps.info' target='_blank'>RSSBus.SalesforceOps</a>. | SalesforceOps | Displays a grid of SalesForce Custom Objects inside SharePoint. | salesforce.CustomObject.txt | http://rssbus.com/products/sharepoint/templates/salesforce.CustomObject_thumb.png | salesforce, sales, crm, erp, saas | List SalesForce Custom Objects |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/salesforce.HtmlSelect_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template shows how to integrate external data into SharePoint via an HTML select element. This particular example connects to SalesForce as the external data source, but the data source could be almost anything.
</td>
</tr>
</table>
| 1402 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.HtmlSelect | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.HtmlSelect | Mon, 08 Feb 2010 17:26:18 GMT | HTML Selector Web Part Template | CRM Systems | <rsb:info title="SalesForce Document Selector" description="Displays a drop down selector of SalesForce Documents.">
<input name="user" description="Your SalesForce account login." required="true" />
<input name="password" style="password" description="Your SalesForce account password." required="true" />
</rsb:info>
<rsb:import lib="RSSBus.SalesforceOps"/>
<rsb:set attr="query" value="select type, name, description, lastmodifieddate,id from document"/>
<select name="myselect" style="width:200px">
<option value="" selected>Select a SalesForce Document</option>
<rsb:call op="salesforceQuery">
<option value="[sf:name]">[sf:name]</option>
</rsb:call>
</select>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SalesforceOps.info' target='_blank'>RSSBus.SalesforceOps</a>. | SalesforceOps | This Web Part template shows how to integrate external data into SharePoint via an HTML select element. This particular example connects to SalesForce as the external data source, but the data source could be almost anything. | salesforce.HtmlSelect.txt | http://rssbus.com/products/sharepoint/templates/salesforce.HtmlSelect_thumb.png | html, select, salesforce, sales, saas | HTML Selector |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/salesforce.ListDocuments_thumb.png'>
</td>
<td VALIGN="top">
Displays a grid of SalesForce Documents with links to the document download location.
</td>
</tr>
</table>
| 1735 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.ListDocuments | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=salesforce.ListDocuments | Mon, 08 Feb 2010 17:26:18 GMT | List SalesForce Documents Web Part Template | CRM Systems, Document Management | <rsb:info title="SalesForce Documents" description="Displays a grid of SalesForce Documents.">
<input name="user" description="Your SalesForce account login." />
<input name="password" style="password" description="Your SalesForce account password." />
</rsb:info>
<rsb:import lib="RSSBus.SalesforceOps"/>
<!-- specify the attributes to display in the YUI Table -->
<rsb:set attr="_meta.YUITableAttrs" value="sf:type, sf:name, sf:description, sf:lastmodifieddate"/>
<rsb:set attr="_meta.YUITableLabels" value="Type, Name, Description, Last Modified"/>
<!-- call the salesforceSelect operation to retrieve the custom objects -->
<div align="center">
<rsb:set attr="query" value="select type, name, description, lastmodifieddate,id from document"/>
<rsb:call op="salesforceQuery" out="out" format="yuitable">
<rsb:set attr="out.sf:name">
<a href="https://na2.salesforce.com/servlet/servlet.FileDownload?file=[sf:id]">[sf:name]</a>
</rsb:set>
<rsb:set attr="out.sf:lastmodifieddate" value="[sf:lastmodifieddate | date('MM/dd/yyyy hh:mm')]" />
</rsb:call>
</div>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SalesforceOps.info' target='_blank'>RSSBus.SalesforceOps</a>. | SalesforceOps | Displays a grid of SalesForce Documents with links to the document download location. | salesforce.ListDocuments.txt | http://rssbus.com/products/sharepoint/templates/salesforce.ListDocuments_thumb.png | salesforce, sales, crm, erp, document management, saas | List SalesForce Documents |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/SalesForceLeads_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template lists leads from a SalesForce account and allows users to easily email each lead. This template can also search the web to find more about the contact and their company.
</td>
</tr>
</table>
| 1759 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=SalesForceLeads | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=SalesForceLeads | Mon, 08 Feb 2010 17:26:18 GMT | ListSalesForce Leads Web Part Template | CRM Systems |
<rsb:import lib="RSSBus.SalesforceOps"/>
<rsb:cache key="salesforceLeads" duration="20"/>
<rsb:info title="SalesForce Leads" description="Shows the leads in your SalesForce account and allows you to google them and email them with one click.">
<input name="user" description="Your SalesForce account login." />
<input name="password" style="password" description="Your SalesForce account password." />
<input name="subject" description="The subject of the template email." def="More information on our current promotions"/>
</rsb:info>
<rsb:call op="salesforceSelectLead" format="toyuitable">
<rsb:set attr="Email">
<a href="mailto:[sf:email]?subject=[subject | urlencode]">[sf:email]</a>
</rsb:set>
<rsb:set attr="Name">
<a href="http://www.google.com/search?q=[sf:name]">[sf:name]</a>
</rsb:set>
<rsb:set attr="Company">
<a href="http://www.google.com/search?q=[sf:company]">[sf:company]</a>
</rsb:set>
<rsb:set attr="Phone">
[sf:phone]
</rsb:set>
<rsb:unset attr="sf:*"/>
</rsb:call>
|
This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SalesforceOps.info' target='_blank'>RSSBus.SalesforceOps</a>.
| SalesforceOps | This Web Part template lists leads from a SalesForce account and allows users to easily email each lead. This template can also search the web to find more about the contact and their company.
| SalesForceLeads.txt | http://rssbus.com/products/sharepoint/templates/SalesForceLeads_thumb.png | SalesForce, Crm, sales, leads, saas | List SalesForce Leads |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sftp.directoryBrowse_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template allows you to list the directory structure and files for the specified SFTP account inside SharePoint. Directories are hyperlinked, allowing folder navigation.
</td>
</tr>
</table>
| 2188 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sftp.directoryBrowse | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sftp.directoryBrowse | Mon, 08 Feb 2010 17:26:18 GMT | SFTP Directory Browser Web Part Template | Document Management, Internet |
<rsb:import lib="RSSBus.SftpOps"/>
<rsb:info title="SFTP Browser" description="Browse an SFTP server from within SharePoint.">
<input name="server" description="The remote SFTP host." default="localhost" />
<input name="user" description="The username used for authentication." required="true" />
<input name="password" description="The password to be used for authentication." style="password" required="true" />
<input name="remotepath" description="The remote path to retrieve a directory listing for." default="." />
</rsb:info>
<rsb:set attr="sshserverhostkey" value="ANY"/>
<rsb:set attr="sshauthmode" value="password"/>
<rsb:call op="sftpList?remotepath=[_request.remotepath | def('.') ]" save="ftpList">
<rsb:select value="[sftp:isdir]">
<rsb:case value="True">
<rsb:set attr="Name">
<a href="?remotepath=[_request.remotepath | def('.')]/[sftp:name]">[sftp:name]</a>
</rsb:set>
<rsb:set attr="Size" value=""/>
</rsb:case>
<rsb:case value="False">
<rsb:set attr="Size" value="[sftp:size | divide('1024') | round(1)] KB"/>
<rsb:set attr="Name" value="[sftp:name]"/>
</rsb:case>
<rsb:default />
</rsb:select>
</rsb:call>
<rsb:set attr="_meta.YUITableAttrs" value="name,size"/>
<rsb:set attr="_meta.YUITableLabels" value="Name, Size"/>
<rsb:call op="feedSort?feed=[_feeds.ftpList | urlencode()]&sort=+Size,+Name" format="yuitable" meta="_meta"/>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.sftpOps.info' target='_blank'>RSSBus.SftpOps</a>. | SftpOps | This Web Part template allows you to list the directory structure and files for the specified SFTP account inside SharePoint. Directories are hyperlinked, allowing folder navigation. | sftp.directoryBrowse.txt | http://rssbus.com/products/sharepoint/templates/sftp.directoryBrowse_thumb.png | SFTP, File, internet, SSH, FTP, Document Management | SFTP Directory Browser |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/smtp.EmailSiteUsers_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template allows you to quickly compose an email message and send it to individual users or all users of a site.
The RSSBus Web Part includes built-in functionality for accessing SharePoint Lists, Libraries, Users, etc. This built-in power is used in
this template to generate an HTML select input element which allows the user to choose the recipient(s) of the out-going email message. The
SMTP Connector showcased by this template has the capability of sending email with attachments, html bodies, custom headers, read and delivery receipts,
and it can even make a secure (SSL) connection to the mail server in question. This particular example sends all messages
through a specified mail server, however the SMTP Connector also has the ability to send each message directly to the mail server of the recipient.
This example requires the SMTP Connector.
</td>
</tr>
</table>
| 3703 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=smtp.EmailSiteUsers | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=smtp.EmailSiteUsers | Mon, 08 Feb 2010 17:26:18 GMT | Email Site Users Web Part Template | Mail, System Administration |
<rsb:import lib="RSSBus.SmtpOps" />
<rsb:info title="Email Site Users" description="Quickly compose an email message and have it send to individual users or all users of the site." >
<input name="mailserver" required="true" />
<input name="from" default="You@Yoursite.com" required="true" />
</rsb:info>
<!-- display input elements for recipient, subject, and message content -->
<table>
<tr><td>To:</td>
<td>
<select name="recipient" multiple style="width:200px">
<option value="All Users">All Users</option>
<rsb:call op="spListUsers">
<rsb:check attr="sp:email">
<option value="[sp:email]">[sp:name]</option>
</rsb:check>
</rsb:call>
</select>
</td>
</tr><tr><td>Subject:</td><td><input type="text" value="[_request.Subject | def('')]" style="width:200px" name="Subject" id="Subject" /></td></tr>
<tr><td>Message:</td><td></td></tr>
<tr><td colspan="2"><textarea name="Message" rows="10" cols="71">[_request.Message| def('')]</textarea></td></tr>
<tr><td></td><td align="right"><input type="submit" /></td></tr>
</table>
<!-- when a message is submitted, send it with the smtpSendMessage operation -->
<rsb:equals attr="_request.request_method" value="POST">
<rsb:check attr="_request.form:recipient">
<rsb:notequals attr="_request.form:Message" value="">
<!-- set the properties of the message -->
<rsb:set attr="from" value="[from]" />
<rsb:set attr="server" value="[mailserver]" />
<rsb:set attr="subject" value="[_request.form:Subject]" />
<rsb:set attr="html" value="[_request.form:Message]" />
<rsb:equals attr="_request.form:recipient" value="All Users">
<!-- send the message to all users -->
<rsb:call op="spListUsers">
<rsb:notequals attr="sp:email" value="">
<rsb:set attr="to" value="[sp:email]" />
<rsb:call op="smtpSendMessage">
Emailed [sp:email]: [smtp:messageid | def('Message Not Sent.')]<br />
</rsb:call>
<rsb:else>
Skipped [sp:name]: No email address in this users profile.<br />
</rsb:else>
</rsb:notequals>
</rsb:call>
<rsb:else>
<!-- send the message to one specific user -->
<rsb:enum list="[_request.recipient]" separator=",">
<rsb:set attr="to" value="[_value]" />
<rsb:call op="smtpSendMessage">
[smtp:messageid | def('Message Not Sent.')]
</rsb:call>
</rsb:enum>
</rsb:else>
</rsb:equals>
</rsb:notequals>
</rsb:check>
</rsb:equals>
| | SmtpOps | This Web Part template allows you to quickly compose an email message and send it to individual users or all users of a site.
The RSSBus Web Part includes built-in functionality for accessing SharePoint Lists, Libraries, Users, etc. This built-in power is used in
this template to generate an HTML select input element which allows the user to choose the recipient(s) of the out-going email message. The
SMTP Connector showcased by this template has the capability of sending email with attachments, html bodies, custom headers, read and delivery receipts,
and it can even make a secure (SSL) connection to the mail server in question. This particular example sends all messages
through a specified mail server, however the SMTP Connector also has the ability to send each message directly to the mail server of the recipient.
This example requires the SMTP Connector.
| smtp.EmailSiteUsers.txt | http://rssbus.com/products/sharepoint/templates/smtp.EmailSiteUsers_thumb.png | email, smtp, sharepoint | Email Site Users |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.docsmodifiedbyme_thumb.png'>
</td>
<td VALIGN="top">
With this template, easily get an overview of what documents have been modified by the currently logged in user. This template makes use of RSSBus'
built-in SharePoint operations and sorting capabilities.
</td>
</tr>
</table>
| 1723 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.docsmodifiedbyme | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.docsmodifiedbyme | Mon, 08 Feb 2010 17:26:18 GMT | List Documents Modified By Current User Web Part Template | SharePoint Lists, Document Management | <rsb:info>
<input name="maxlibraries" default="5" />
<input name="maxdocuments" default="5" />
</rsb:info>
<rsb:call op="spListLists?listtype=DocumentLibrary" save="lists" />
<table width="100%">
<rsb:call op="feedSort?type=date&sort=-sp:item_modified&feed=[_feeds.lists | urlencode]" pagesize="[maxlibraries]" >
<tr>
<th style="background-color:LightGrey; white-space:nowrap" colspan="2" align="left">
<a href="[sp:url]">[rss:title]</a>
</th>
</tr>
<rsb:call op="spListDocuments?library=[rss:title]" save="mydocs" />
<rsb:call op="feedSort?type=date&sort=-sp:modified&feed=[_feeds.mydocs | urlencode]" pagesize="[maxdocuments]" >
<tr>
<td><a href="[sp:url]">[rss:title]</a></td>
<td>
<rsb:set attr="today" value="[sp:modified | todate('MM/dd/yy')]" />
<rsb:equals attr="today" value="[null | date('MM/dd/yy')]">
[sp:modified | todate('hh:mm:ss')]
<rsb:else>
[sp:modified | todate('MM/dd/yy')]
</rsb:else>
</rsb:equals>
</td>
</tr>
</rsb:call>
</rsb:call>
</table>
| | | With this template, easily get an overview of what documents have been modified by the currently logged in user. This template makes use of RSSBus'
built-in SharePoint operations and sorting capabilities.
| sp.docsmodifiedbyme.txt | http://rssbus.com/products/sharepoint/templates/sp.docsmodifiedbyme_thumb.png | document library, document management, sharepoint | List Documents Modified By Current User |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.EmailListAddresses_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template allows you to quickly compose an email message and send it to individual addresses or all addresses found in
a specified SharePoint list. The RSSBus Web Part includes built-in functionality for accessing SharePoint Lists, Libraries, Users, etc.
This built-in power is used in
this template to generate an HTML select input element which allows the user to choose the recipient of the out-going email message. The
SMTP Connector utilized by this template has the capability of sending email with attachments, html bodies, custom headers, read and delivery receipts,
and it can even make a secure (SSL) connection to the mail server in question. This particular example sends all messages
through a specified mail server, however the SMTP Connector also has the ability to send each message directly to the mail server of the recipient.
This example requires the SMTP Connector.
</td>
</tr>
</table>
| 4535 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.EmailListAddresses | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.EmailListAddresses | Mon, 08 Feb 2010 17:26:18 GMT | Email SharePoint List Addresses Web Part Template | Mail, System Administration, SharePoint Lists |
<rsb:import lib="RSSBus.SmtpOps" />
<rsb:info title="Email List" description="Quickly compose an email message and have it send to an individual address or all addresses in a SharePoint list." >
<input name="list" required="true" />
<input name="mailserver" required="true" />
<input name="from" default="rssbus@webpart.com" required="true" />
</rsb:info>
<!-- display input elements for recipient, subject, and message content -->
<table>
<tr><td>To:</td>
<td>
<select name="recipient" style="width:200px">
<option value="All Users">All Users</option>
<!--display the list of addresses found in the list -->
<rsb:call op="spListItems?list=[list]">
<rsb:call op="spGetItem?list=[list]&id=[sp:id]">
<option value="[sp:id]">[sp:full_name]</option>
</rsb:call>
</rsb:call>
</select>
</td>
</tr>
<tr><td>Subject:</td><td><input type="text" value="" style="width:200px" name="Subject" id="Subject" value="" /></td></tr>
<tr><td>Message:</td><td></td></tr>
<tr><td colspan="2"><textarea name="Message" rows="10" cols="71"></textarea></td></tr>
<tr><td></td><td align="right"><input type="submit" /></td></tr>
</table>
<!-- when a message is submitted, send it with the smtpSendMessage operation -->
<rsb:equals attr="_request.request_method" value="POST">
<rsb:check attr="_request.form:Message">
<rsb:notequals attr="_request.form:Message" value="">
<rsb:equals attr="_request.form:recipient" value="All Users">
<!-- send the message to all users -->
<rsb:call op="spListItems?list=[list]">
<rsb:call op="spGetItem?list=[list]&id=[sp:id]">
<rsb:check attr="sp:e-mail_address">
<!-- set the properties of the message -->
<rsb:set attr="from" value="[from]" />
<rsb:set attr="server" value="[mailserver]" />
<rsb:set attr="subject" value="[_request.form:Subject]" />
<rsb:set attr="html" value="[_request.form:Message]" />
<rsb:set attr="to" value="[sp:e-mail_address]" />
<rsb:call op="smtpSendMessage">
Emailed [sp:full_name]: [smtp:messageid | def('Message Not Sent')].
</rsb:call>
<rsb:else>
Skipped [sp:full_name]: No email address in this users entry.<br />
</rsb:else>
</rsb:check>
</rsb:call>
</rsb:call>
<rsb:else>
<!-- send the message to one specific user -->
<rsb:call op="spGetItem?list=[list]&id=[_request.form:recipient]">
<rsb:check attr="sp:e-mail_address">
<!-- set the properties of the message -->
<rsb:set attr="from" value="[from]" />
<rsb:set attr="server" value="[mailserver]" />
<rsb:set attr="subject" value="[_request.form:Subject]" />
<rsb:set attr="html" value="[_request.form:Message]" />
<rsb:set attr="to" value="[sp:e-mail_address]" />
<rsb:call op="smtpSendMessage">
Emailed [sp:full_name]: [smtp:messageid | def('Message Not Sent')].
</rsb:call>
<rsb:else>
Skipped [sp:full_name]: No email address in this users entry.<br />
</rsb:else>
</rsb:check>
</rsb:call>
</rsb:else>
</rsb:equals>
</rsb:notequals>
</rsb:check>
</rsb:equals>
| | SmtpOps | This Web Part template allows you to quickly compose an email message and send it to individual addresses or all addresses found in
a specified SharePoint list. The RSSBus Web Part includes built-in functionality for accessing SharePoint Lists, Libraries, Users, etc.
This built-in power is used in
this template to generate an HTML select input element which allows the user to choose the recipient of the out-going email message. The
SMTP Connector utilized by this template has the capability of sending email with attachments, html bodies, custom headers, read and delivery receipts,
and it can even make a secure (SSL) connection to the mail server in question. This particular example sends all messages
through a specified mail server, however the SMTP Connector also has the ability to send each message directly to the mail server of the recipient.
This example requires the SMTP Connector.
| sp.EmailListAddresses.txt | http://rssbus.com/products/sharepoint/templates/sp.EmailListAddresses_thumb.png | email, smtp, sharepoint | Email SharePoint List Addresses |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.Hello_thumb.png'>
</td>
<td VALIGN="top">
This user greeting Web Part template allows you to
welcome users to your site by displaying a personalized greeting that includes the users name.
The RSSBus Web Part has built-in functionality for accessing SharePoint Lists, Libraries, Users, etc.
That power is used in this template to gather information about the currently logged in user and address them by name with a different
message depending on the time of day.
</td>
</tr>
</table>
| 1376 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.Hello | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.Hello | Mon, 08 Feb 2010 17:26:18 GMT | SharePoint User Greeting Web Part Template | SharePoint Lists |
<!-- find out if it is morning, afternoon, or evening -->
<rsb:set attr="hour" value="[null | now('HH')]" />
<rsb:set attr="ismorning" value="[hour | isbetween('0','11')]" />
<rsb:set attr="isafternoon" value="[hour | isbetween('12','16')]" />
<rsb:set attr="isevening" value="[hour | isbetween('17','23')]" />
<!-- use a different greeting depending on time of day -->
<rsb:equals attr="ismorning" value="true">Good morning</rsb:equals>
<rsb:equals attr="isafternoon" value="true">Good afternoon</rsb:equals>
<rsb:equals attr="isevening" value="true">Good evening</rsb:equals>
, [_spuser.Name], welcome to RSSBus!
| | | This user greeting Web Part template allows you to
welcome users to your site by displaying a personalized greeting that includes the users name.
The RSSBus Web Part has built-in functionality for accessing SharePoint Lists, Libraries, Users, etc.
That power is used in this template to gather information about the currently logged in user and address them by name with a different
message depending on the time of day.
| sp.Hello.txt | http://rssbus.com/products/sharepoint/templates/sp.Hello_thumb.png | user, greeting | SharePoint User Greeting |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.picture-rotator_thumb.png'>
</td>
<td VALIGN="top">
This Web Part shows a random image from a specified Picture Library. This Web Part could also be easily configured to load images from external sources, such as Flickr or Picasa.
To use, paste the source into the RSSBus Web Part source editor, and modify the picturelibrary variable to set its value to the name of your SharePoint picture library. To customize this Web Part to automatically refresh the picture at a specified interval, see the Feed Rotator Web Part as an example.
</td>
</tr>
</table>
| 1143 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.picture-rotator | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.picture-rotator | Mon, 08 Feb 2010 17:26:18 GMT | Picture Library Rotator Web Part Template | Media, SharePoint Lists | <rsb:set attr="picturelibrary" value="Picture Library" />
<rsb:call op="spListItems?list=[picturelibrary]&fields=ALL" save="pictures" />
<rsb:call op="feedRandom?feed=[_feeds.pictures | urlencode]">
<rsb:first>
<img src="[sp:web_image_url]" border="0" align="right" />
</rsb:first>
</rsb:call>
| | | This Web Part shows a random image from a specified Picture Library. This Web Part could also be easily configured to load images from external sources, such as Flickr or Picasa.
To use, paste the source into the RSSBus Web Part source editor, and modify the picturelibrary variable to set its value to the name of your SharePoint picture library. To customize this Web Part to automatically refresh the picture at a specified interval, see the Feed Rotator Web Part as an example.
| sp.picture-rotator.txt | http://rssbus.com/products/sharepoint/templates/sp.picture-rotator_thumb.png | image, picture, image library, random | Picture Library Rotator |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.sorteddocuments_thumb.png'>
</td>
<td VALIGN="top">
This template displays a list of libraries and documents that are available on SharePoint, sorted by last modified date.
</td>
</tr>
</table>
| 1619 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.sorteddocuments | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.sorteddocuments | Mon, 08 Feb 2010 17:26:18 GMT | Sorted Libraries and Documents Web Part Template | SharePoint Lists, Document Management | <rsb:info>
<input name="maxlibraries" default="5" />
<input name="maxdocuments" default="5" />
</rsb:info>
<rsb:call op="spListLists?listtype=DocumentLibrary" save="lists" />
<table width="100%">
<rsb:call op="feedSort?type=date&sort=-sp:item_modified&feed=[_feeds.lists | urlencode]" pagesize="[maxlibraries]" >
<tr>
<th style="background-color:LightGrey; white-space:nowrap" colspan="2" align="left">
<a href="[sp:url]">[rss:title]</a>
</th>
</tr>
<rsb:call op="spListDocuments?library=[rss:title]" save="mydocs" />
<rsb:call op="feedSort?type=date&sort=-sp:modified&feed=[_feeds.mydocs | urlencode]" pagesize="[maxdocuments]" >
<tr>
<td><a href="[sp:url]">[rss:title]</a></td>
<td>
<rsb:set attr="today" value="[sp:modified | todate('MM/dd/yy')]" />
<rsb:equals attr="today" value="[null | date('MM/dd/yy')]">
[sp:modified | todate('hh:mm:ss')]
<rsb:else>
[sp:modified | todate('MM/dd/yy')]
</rsb:else>
</rsb:equals>
</td>
</tr>
</rsb:call>
</rsb:call>
</table>
| | | This template displays a list of libraries and documents that are available on SharePoint, sorted by last modified date.
| sp.sorteddocuments.txt | http://rssbus.com/products/sharepoint/templates/sp.sorteddocuments_thumb.png | document library, document management, sharepoint | Sorted Libraries and Documents |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.streamingVideoPlayer_thumb.png'>
</td>
<td VALIGN="top">
Play Windows Media videos inside SharePoint. Videos are stored in a document library inside SharePoint, but could also be streamed from external sources.
</td>
</tr>
</table>
| 1976 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.streamingVideoPlayer | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.streamingVideoPlayer | Mon, 08 Feb 2010 17:26:18 GMT | Windows Media Video Player Web Part Template | Media | <rsb:info title="Streaming Video Demo">
<input name="Width" desc="Width of the player." def="320"/>
<input name="Height" desc="Height of the player." def="240"/>
<input name="linklist" desc="Document Library containing your videos." req="true" />
</rsb:info>
<select id="selectedVideoLocal" name="selectedVideoLocal" onchange="this.form.submit()">
<option value="">-Select-</option>
<rsb:call op="spListItems?list=[linklist]">
<option value="[rss:link]">[rss:link]: [rss:title]</option>
</rsb:call>
</select>
<br>
<rsb:check attr="_request.selectedVideoLocal">
<OBJECT ID="SHWMP" WIDTH="[Width]" HEIGHT="[Height]" CLASSID="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6" TYPE="APPLICATION/X-OLEOBJECT">
<PARAM NAME="URL" VALUE="[_request.selectedVideoLocal | def('') | split(',',1)]">
<PARAM NAME="AutoStart" VALUE="True">
<PARAM NAME="UIMode" VALUE="FULL">
<PARAM NAME="FullScreen" value="False">
<PARAM NAME="EnableContextMenu" value="True">
<PARAM NAME="ShowStatusBar" value="True">
<PARAM NAME="StretchToFit" value="True">
<PARAM NAME="Mute" VALUE="False">
<EMBED TYPE="APPLICATION/X-MPLAYER2" SRC="[_request.selectedVideoLocal | def('') | split(',',1)]" WIDTH="[Width]" HEIGHT="[Height]" AutoStart="1" EnableContextMenu="1" ShowStatusBar="1" StretchToFit="1" Mute="0" ShowControls="1" ShowAudioControls="1" AutoHideControls="0" ShowPositionControls="1"></EMBED>
</OBJECT>
</rsb:check> | | | Play Windows Media videos inside SharePoint. Videos are stored in a document library inside SharePoint, but could also be streamed from external sources. | sp.streamingVideoPlayer.txt | http://rssbus.com/products/sharepoint/templates/sp.streamingVideoPlayer_thumb.png | video, media, wmv, streaming video, microsoft | Embedded Windows Media Video Player |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.tasks-barchart_thumb.png'>
</td>
<td VALIGN="top">
Visualize the status of SharePoint tasks. This Web Part displays a SharePoint task list as a chart using the Google Charting API.
</td>
</tr>
</table>
| 1408 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.tasks-barchart | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.tasks-barchart | Mon, 08 Feb 2010 17:26:18 GMT | SharePoint Tasks Chart Web Part Template | SharePoint Lists, Charts and Maps | <rsb:info>
<input name="width" default="400" description="Graph Width"/>
<input name="height" default="125" description="Graph Height"/>
<input name="color" default="83B0EC" description="Graph Color"/>
</rsb:info>
<rsb:set attr="list" value="Tasks" />
<rsb:call op="spListItems">
<rsb:set attr="id" value="[[sp:id]]"/>
<rsb:call op="spGetItem">
<rsb:notequal attr="sp:status" value="Completed">
<rsb:set attr="tasks.totals" value="[[tasks.totals | def('t:')]],[[sp:_complete | def('0') | multiply(100) ]]" />
<rsb:set attr="tasks.labels" value="[[tasks.labels | def('0:') ]]|[[sp:title]] [[sp:_complete | def('0') | multiply(100) ]]%" />
</rsb:notequal >
</rsb:call>
</rsb:call>
<img src="http://chart.apis.google.com/chart?chxt=y,x&chxl=[[tasks.labels]]&cht=bhs&chd=[[tasks.totals | replace(':,',':')]]&chco=[[color]]&chs=[[width]]x[[height]]&chbh=r,0.3&chts=000000,5" />
| | | Visualize the status of SharePoint tasks. This Web Part displays a SharePoint task list as a chart using the Google Charting API.
| sp.tasks-barchart.txt | http://rssbus.com/products/sharepoint/templates/sp.tasks-barchart_thumb.png | Tasks, Chart, sharepoint | SharePoint Tasks Chart |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sp.WhatsNew_thumb.png'>
</td>
<td VALIGN="top">
Get an at-a-glance overview of what is new on your SharePoint site with this RSSBus Web Part template that makes use of RSSBus'
built-in SharePoint operations and sorting capabilities. This Web Part displays a list of library documents and list items that have been recently added or modified, sorted by last modified date.
</td>
</tr>
</table>
| 1844 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.WhatsNew | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sp.WhatsNew | Mon, 08 Feb 2010 17:26:18 GMT | What's New In Site Libraries and Documents Web Part Template | SharePoint Lists, Document Management |
<rsb:info>
<input name="maxlibraries" default="5" />
<input name="maxdocuments" default="5" />
</rsb:info>
<rsb:call op="spListLists" save="lists" />
<table width="100%">
<rsb:call op="feedSort?type=date&sort=-sp:item_modified&feed=[_feeds.lists | urlencode]" pagesize="[maxlibraries]" >
<tr>
<th style="background-color:LightGrey; white-space:nowrap" colspan="2" align="left">
<a href="[sp:url]">[rss:title]</a>
</th>
</tr>
<rsb:call op="spListItems?list=[rss:title]" save="mydocs" />
<rsb:call op="feedSort?type=date&sort=-sp:item_modified&feed=[_feeds.mydocs | urlencode]" pagesize="[maxdocuments]" >
<tr>
<td><a href="[sp:url]">[rss:title]</a></td>
<td>
<rsb:set attr="today" value="[sp:item_modified | todate('MM/dd/yy')]" />
<rsb:equals attr="today" value="[null | date('MM/dd/yy')]">
[sp:item_modified | todate('hh:mm:ss')]
<rsb:else>
[sp:item_modified | todate('MM/dd/yy')]
</rsb:else>
</rsb:equals>
</td>
</tr>
</rsb:call>
</rsb:call>
</table>
| | | Get an at-a-glance overview of what is new on your SharePoint site with this RSSBus Web Part template that makes use of RSSBus'
built-in SharePoint operations and sorting capabilities. This Web Part displays a list of library documents and list items that have been recently added or modified, sorted by last modified date.
| sp.WhatsNew.txt | http://rssbus.com/products/sharepoint/templates/sp.WhatsNew_thumb.png | document library, list, document management, sharepoint | What's New In Site Libraries and Documents |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sql.geocode-sql_thumb.png'>
</td>
<td VALIGN="top">
GeoCodes a list of addresses retrieved from an SQL Select Statement and Displays them in Virtual Earth.
</td>
</tr>
</table>
| 1418 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.geocode-sql | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.geocode-sql | Mon, 08 Feb 2010 17:26:18 GMT | Virtual Earth / SQL Northwind Mashup Web Part Template | Database, Charts and Maps | <rsb:info title="Virtual Earth Northwind Customers Mashup" >
</rsb:info>
<script src="http://dev.virtualearth.net/mapcontrol/mapcontrol.ashx?v=6"></script>
<script type="text/javascript">
window.onload=function() {
map = new VEMap('myMap');
map.onLoadMap = function() {
var l = new VEShapeLayer();
var veLayerSpec = new VEShapeSourceSpecification(VEDataType.GeoRSS, "Services/GeoCodeSql.rsb", 1);
map.ImportShapeLayerData(veLayerSpec, null);
}
map.LoadMap();
}
</script>
<div id='myMap' style="position:relative; width:100%; height:100%;"></div>
| This template requires the installation of a local RSSBus Service on SharePoint Server. To make use of this example, first download <a href='GeoCodeSql.zip' target='_blank'>GeoCodeSql.rsb</a>. Then create a "Services" document library on the SharePoint root and upload the RSBScript (.rsb) to that location. | SqlOps, YahooOps | GeoCodes a list of addresses retrieved from an SQL Select Statement and Displays them in Virtual Earth.
| sql.geocode-sql.txt | http://rssbus.com/products/sharepoint/templates/sql.geocode-sql_thumb.png | Sql, Virtual Earth, geo, geocode, Database | Virtual Earth / SQL Northwind Mashup |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sql.PieChart_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template shows how to perform a basic SQL query without requiring use of the SharePoint Business Data Catalog. The results are displayed in a doughnut style chart by taking advantage of one of the many feed formatters available with RSSBus. You can create different charts by simply choosing a different chart type, such as pie, bar, line, etc.
</td>
</tr>
</table>
| 2647 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.PieChart | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.PieChart | Mon, 08 Feb 2010 17:26:18 GMT | Chart From a SQL Query Web Part Template | Database, Charts and Maps |
<rsb:info>
<input name="conn" description="The connection string used to define the connection." default="Data Source=YOURSERVER;Initial Catalog=Northwind;User Id=YOURUSERID;Password=YOURPASSWORD" required="true" />
<input name="query" description="The query to execute" required="true" default="select shipcountry, count(shipcountry) as x from Orders group by shipcountry order by x desc" required="true"/>
<input name="defaultcharttype" description="The type of chart to render." values="Pie,Doughnut" default="Doughnut"/>
<input name="palette" description="The color palette to apply to this chart." values="Bright,Grayscale,Excel,Light,Pastel,EarthTones,SemiTransparent,Berry,Chocolate,Fire,SeaGreen,BrightPastel" default="SemiTransparent"/>
<input name="3denable" description="Specifies whether this chart should be rendered in 3d." values="True,False" default="True"/>
<input name="height" description="The height of this chart." default="240"/>
<input name="width" description="The width of this chart." default="320"/>
</rsb:info>
<rsb:import lib="RSSbus.SqlOps"/>
<rsb:set attr="_meta.yaxis" value="sql:x"/>
<rsb:set attr="_meta.xaxis" value="sql:shipcountry"/>
<rsb:set attr="_meta.defaultcharttype" value="[defaultcharttype]"/>
<rsb:set attr="_meta.width" value="[width]"/>
<rsb:set attr="_meta.height" value="[height]"/>
<rsb:set attr="_meta.3denable" value="[3denable]"/>
<rsb:set attr="_meta.palette" value="[palette]"/>
<rsb:set attr="_meta.showlegend" value="true"/>
<rsb:set attr="_meta.charttitle" value="Number of Orders per Country"/>
<rsb:set attr="_meta.3dinclination" value="40"/>
<rsb:call op="sqlQuery" format="mschart" pagesize="5">
<rsb:set attr="sql:shipcountry" value="[sql:shipcountry] ([sql:x])"/>
</rsb:call>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SqlOps.info' target='_blank'>RSSBus.SqlOps</a> | SqlOps, ChartOps | This Web Part template shows how to perform a basic SQL query without requiring use of the SharePoint Business Data Catalog. The results are displayed in a doughnut style chart by taking advantage of one of the many feed formatters available with RSSBus. You can create different charts by simply choosing a different chart type, such as pie, bar, line, etc.
| sql.PieChart.txt | http://rssbus.com/products/sharepoint/templates/sql.PieChart_thumb.png | sql, chart, graph, database | Chart From a SQL Query |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sql.query_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template displays the results of a standard SQL query without requiring use of the SharePoint Business Data Catalog.
To use this Web Part, paste the source into the RSSBus Web Part Source Editor and click apply. In the RSSBus Web Part properties pane, modify the conn and query inputs to refer to your own database.
</td>
</tr>
</table>
| 1715 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.query | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.query | Mon, 08 Feb 2010 17:26:18 GMT | SQL Query Results Web Part Template | Database | <rsb:import lib="RSSBus.SqlOps"/>
<rsb:info>
<input name="conn" description="The connection string used to define the connection." required="true" default="Data Source=MYSERVER;Initial Catalog=Northwind;User Id=MYUSERID;Password=MYPASSWORD" />
<input name="query" description="The query to execute" required="true" default="SELECT CompanyName, City, Phone, ContactTitle FROM Suppliers ORDER BY CompanyName" />
<input name="maxrows" description="The Max number of rows to return (-1 is used to return all rows)" default="-1"/>
</rsb:info>
<rsb:set attr="_meta.YUITableAttrs" value="sql:companyname, sql:city, sql:phone, sql:contacttitle"/>
<rsb:set attr="_meta.YUITableLabels" value="Company Name, City, Phone, Title"/>
<rsb:call op="sqlQuery" format="ToYuiTable"/>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SqlOps.info' target='_blank'>RSSBus.SqlOps</a>. Note: This example uses the Northwind sample database from Microsoft, change connection string and ColumnDefs to reflect your desired database. | SqlOps | This Web Part template displays the results of a standard SQL query without requiring use of the SharePoint Business Data Catalog.
To use this Web Part, paste the source into the RSSBus Web Part Source Editor and click apply. In the RSSBus Web Part properties pane, modify the conn and query inputs to refer to your own database. | sql.query.txt | http://rssbus.com/products/sharepoint/templates/sql.query_thumb.png | sql, database, sql query | SQL Query Results |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/sql.RecordEditor_thumb.png'>
</td>
<td VALIGN="top">
Edit SQL Records from within SharePoint with this RSSBus Web Part template.
To use this Web Part, paste the source into the RSSBus Web Part Source Editor, and edit the source to refer to your own connection string and stored procedure.
</td>
</tr>
</table>
| 3201 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.RecordEditor | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=sql.RecordEditor | Mon, 08 Feb 2010 17:26:18 GMT | SQL Suppliers Record Editor Web Part Template | Database | <rsb:import lib="RSSBus.SqlOps"/>
<rsb:info title="SQL Suppliers Record Editor"></rsb:info>
<rsb:set attr="conn" value="Data Source=location;Initial Catalog=Northwind;User Id=user;Password=password"/>
<rsb:set attr="query" value="SELECT CompanyName, City, Phone, ContactTitle FROM Suppliers ORDER BY CompanyName"/>
<!-- Check for post and do Sql Update -->
<rsb:check attr="_request.sqlUpdateSubmit">
<rsb:set attr="new:city" value="[_request.city]"/>
<rsb:set attr="new:contacttitle" value="[_request.contacttitle]"/>
<rsb:set attr="new:phone" value="[_request.phone]"/>
<rsb:set attr="rec:companyname" value="[_request.companyname]"/>
<rsb:set attr="table" value="Suppliers"/>
<rsb:call op="sqlUpdate">
<!-- Make sure the insert is successful -->
<rsb:check attr="sql:affectedrows">
<b>Update Successful!</b>
</rsb:check>
</rsb:call>
</rsb:check>
<!-- Hidden Update Form (company name used as key)-->
<div id="editForm" style="visibility:hidden;display:none">
<label>City<input id="city" name="city"/></label>
<input type="hidden" id="companyname" name="companyname"/>
<label>Title<input id="contacttitle" name="contacttitle"/></label>
<label>Phone<input id="phone" name="phone"/></label>
<input type="submit" name="sqlUpdateSubmit" >
</div>
<!-- Sql Query to display our records in a datatable -->
<rsb:set attr="_meta.YUITableAttrs" value="edit, sql:companyname, sql:city, sql:phone, sql:contacttitle"/>
<rsb:set attr="_meta.YUITableLabels" value="Action, Company Name, City, Phone, Title"/>
<rsb:set attr="_meta.YUIDivname" value="sqlData"/>
<rsb:call op="sqlQuery" save="sqlQuery" out="out">
<rsb:set attr="out.edit">
<a href="javascript:editRow('[_index]')">edit</a>
</rsb:set>
</rsb:call>
<rsb:call op="[_feeds.sqlQuery]" format="yuitable"/>
<script>
function editRow(key)
{
//Show edit div
var editForm = document.getElementById('editForm');
editForm.style.visibility='visible';
editForm.style.display='block';
//Get JSON Record
var _curRow = [_meta.YUIDivname].items[key - 1];
//Populate Inputs
populateField(_curRow,"city");
populateField(_curRow,"companyname");
populateField(_curRow,"contacttitle");
populateField(_curRow,"phone");
}
function populateField(curRow,name)
{
document.getElementById(name).value = curRow["sql:"+name];
}
</script>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.SqlOps.info' target='_blank'>RSSBus.SqlOps</a>. | SqlOps | Edit SQL Records from within SharePoint with this RSSBus Web Part template.
To use this Web Part, paste the source into the RSSBus Web Part Source Editor, and edit the source to refer to your own connection string and stored procedure. | sql.RecordEditor.txt | http://rssbus.com/products/sharepoint/templates/sql.RecordEditor_thumb.png | Sql, Database, Northwind, crud | SQL Suppliers Record Editor |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/twitter.Search_thumb.png'>
</td>
<td VALIGN="top">
This template allows you to define search terms and automatically monitor networking sites like Twitter, to get up to the minute information based on search terms right inside SharePoint.
</td>
</tr>
</table>
| 966 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=twitter.Search | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=twitter.Search | Mon, 08 Feb 2010 17:26:18 GMT | Twitter Search Web Part Template | News and Information, Search |
<rsb:info title="Twitter Search" >
<input name="SearchPhrase" description="The search phrase to search Twitter for." def="RSSBus"/>
</rsb:info>
<rsb:call op="http://search.twitter.com/search.atom?q=[SearchPhrase]" pagesize="10">
<div style='margin-bottom:10px;float:left;'>
<a href="[rss:link#1]"><img align="left" src="[rss:link#2]" border="0" width="33px"/>[atom:author_name]</a>:
[rss:description]
</div>
</rsb:call>
| | | This template allows you to define search terms and automatically monitor networking sites like Twitter, to get up to the minute information based on search terms right inside SharePoint.
| twitter.Search.txt | http://rssbus.com/products/sharepoint/templates/twitter.Search_thumb.png | twitter, tweet, search, Internet | Twitter Search |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/ups.shipmenttracking_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template retrieves and displays a list of shipment tracking events for a UPS shipment using the specified tracking id.
To use, you'll first need to enter your UPS service credentials in the Web Part Properties and apply. Then enter your tracking id and click the Track button.
</td>
</tr>
</table>
| 2446 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ups.shipmenttracking | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=ups.shipmenttracking | Mon, 08 Feb 2010 17:26:18 GMT | Track UPS Package Shipments Web Part Template | Shipping | <rsb:info>
<input name="accesskey" required="true" />
<input name="accountnumber" required="true" />
<input name="user" required="true" />
<input name="password" required="true" />
</rsb:info>
<!-- a form to get tracking id -->
<div id="trackinginput">
<table cellspacing="5px">
<tr>
<td>Tracking Id:</td>
<td>
<input type="text" name="trackingid" value="" size="25"/>
</td>
<td align="right">
<input type="submit" value="Track" />
</td>
</tr>
</table>
</div>
<!-- when the form is posted, display a table of ship events -->
<rsb:check attr="_request.form:trackingnumber">
<div style="height:250;overflow:auto">
<rsb:import lib="RSSBus.UpsOps" />
<rsb:set attr="url" value="https://wwwcie.ups.com/ups.app/xml/Track" />
<rsb:set attr="trackingid" value="[_request.form:trackingid]" />
<rsb:call op="upsTrack">
<rsb:first>
<table width="100%">
<tr>
<th style="background-color:LightGrey; white-space:nowrap">Status</th>
<th style="background-color:LightGrey; white-space:nowrap">Date/Time</th>
<th style="background-color:LightGrey; white-space:nowrap">Location</th>
</tr>
</rsb:first>
<tr>
<td>[scandesc]</td>
<td>[scandate] [scantime]</td>
<td>[scancity], [scanstate] [scancountry]</td>
<tr>
<rsb:last>
</table>
</rsb:last>
</rsb:call>
</div>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.UpsOps.info' target='_blank'>RSSBus.UpsOps</a>. Also, you'll need to sign up for UPSTools to obtain service credentials for accessing UPS Online. | UpsOps | This Web Part template retrieves and displays a list of shipment tracking events for a UPS shipment using the specified tracking id.
To use, you'll first need to enter your UPS service credentials in the Web Part Properties and apply. Then enter your tracking id and click the Track button.
| ups.shipmenttracking.txt | http://rssbus.com/products/sharepoint/templates/ups.shipmenttracking_thumb.png | UPS, United Parcel Service, Tracking, shipping | Track UPS Package Shipments |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/usps.shipmenttracking_thumb.png'>
</td>
<td VALIGN="top">
This Web Part template retrieves and displays a list of shipment tracking events for a USPS shipment using the specified tracking id.
To use, you'll first need to enter your USPS service credentials in the Web Part Properties and apply. Then enter your tracking id and click the Track button.
</td>
</tr>
</table>
| 2384 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=usps.shipmenttracking | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=usps.shipmenttracking | Mon, 08 Feb 2010 17:26:18 GMT | Track USPS Package Shipments Web Part Template | Shipping | <rsb:info>
<input name="user" required="true" />
<input name="password" required="true" />
</rsb:info>
<!-- a form to get tracking id -->
<div id="trackinginput">
<table cellspacing="5px">
<tr>
<td>Tracking Id:</td>
<td>
<input type="text" name="trackingid" value="" size="25"/>
</td>
<td align="right">
<input type="submit" value="Track" />
</td>
</tr>
</table>
</div>
<!-- when the form is posted, display a table of ship events -->
<rsb:check attr="_request.form:trackingnumber">
<div style="height:250;overflow:auto">
<rsb:import lib="RSSBus.UspsOps" />
<rsb:set attr="url" value="http://production.shippingapis.com/ShippingAPI.dll" />
<rsb:set attr="trackingid" value="[_request.form:trackingid]" />
<rsb:call op="uspsTrack">
<rsb:first>
<table width="100%">
<tr>
<th style="background-color:LightGrey; white-space:nowrap">Status</th>
<th style="background-color:LightGrey; white-space:nowrap">Date/Time</th>
<th style="background-color:LightGrey; white-space:nowrap">Location</th>
</tr>
</rsb:first>
<tr>
<td>[scandesc]</td>
<td>[scandate] [scantime]</td>
<td>[scancity], [scanstate] [scancountry]</td>
<tr>
<rsb:last>
</table>
</rsb:last>
</rsb:call>
</div>
</rsb:check>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.UspsOps.info' target='_blank'>RSSBus.UspsOps</a>. Also, you'll need to sign up with USPS for to obtain service credentials for accessing USPS web services. | UspsOps | This Web Part template retrieves and displays a list of shipment tracking events for a USPS shipment using the specified tracking id.
To use, you'll first need to enter your USPS service credentials in the Web Part Properties and apply. Then enter your tracking id and click the Track button.
| usps.shipmenttracking.txt | http://rssbus.com/products/sharepoint/templates/usps.shipmenttracking_thumb.png | USPS, United States Postal Service, Tracking, shipping | Track USPS Package Shipments |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/vearth_thumb.png'>
</td>
<td VALIGN="top">
Mashup and combine data from multiple sources with RSSBus SharePoint Web Part. This template combines GeoRSS tagging of Flickr with a Microsoft Virtual Earth Overlay to show where photos were taken.
</td>
</tr>
</table>
| 1553 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=vearth | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=vearth | Mon, 08 Feb 2010 17:26:18 GMT | Flickr / Virtual Earth Mashup Web Part Template | Charts and Maps | <rsb:info title="Virtual Earth Mashup" >
<input name="FlickrURL" description="The Flickr feed URL to retrieve." req="true" />
</rsb:info>
<script src="http://dev.virtualearth.net/mapcontrol/mapcontrol.ashx?v=6"></script>
<script type="text/javascript">
window.onload=function() {
map = new VEMap('myMap');
map.onLoadMap = function() {
var l = new VEShapeLayer();
var veLayerSpec = new VEShapeSourceSpecification(VEDataType.GeoRSS, "/Services/vearth.rsb?feedurl=[FlickrURL]", 1);
map.ImportShapeLayerData(veLayerSpec, null);
}
map.LoadMap();
}
</script>
<div id='myMap' style="position:relative; width:100%; height:100%;"></div>
| This template requires the installation of a local RSSBus Service on SharePoint Server. To make use of this example, first download <a href='templates/vearth.zip' target='_blank'>vearth.rsb</a>. Then create a "services" folder on the SharePoint root and copy the RSBScript (.rsb) to that location. | | Mashup and combine data from multiple sources with RSSBus SharePoint Web Part. This template combines GeoRSS tagging of Flickr with a Microsoft Virtual Earth Overlay to show where photos were taken.
| vearth.txt | http://rssbus.com/products/sharepoint/templates/vearth_thumb.png | virtual earth, geo, flickr, microsoft, map | Flickr / Virtual Earth Mashup |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/xml.flickr-picture-rotator_thumb.png'>
</td>
<td VALIGN="top">
Shows a random image from Flickr's most interesting photos. Take a look at the <i>Refresh Flickr Content Automatically</i> template to make this script loop the images.
</td>
</tr>
</table>
| 1312 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=xml.flickr-picture-rotator | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=xml.flickr-picture-rotator | Mon, 08 Feb 2010 17:26:18 GMT | Flickr Picture Rotator Web Part Template | Media, Web Services | <rsb:import lib="RSSBus.XmlOps" />
<!-- This gets a feed of "interesting" photos from Flickr -->
<rsb:set attr="attr#1" value="@id"/>
<rsb:set attr="attr#2" value="@farm"/>
<rsb:set attr="attr#3" value="@server"/>
<rsb:set attr="attr#4" value="@secret"/>
<rsb:set attr="item" value="/rsp/photos/photo"/>
<rsb:set attr="url" value="http://www.flickr.com/services/rest/?method=flickr.interestingness.getList&api_key=5688ee5ac4d01c90d8d80a6b5106b3b5&per_page=10"/>
<rsb:call op="xmlHttp" save="pictures" />
<!-- now randomize that feed and take the first one -->
<rsb:call op="feedRandom?feed=[_feeds.pictures | urlencode]">
<rsb:first>
<img src="http://farm[pxml:farm].static.flickr.com/[pxml:server]/[pxml:id]_[pxml:secret]_m.jpg" />
</rsb:first>
</rsb:call>
| | XmlOps | Shows a random image from Flickr's most interesting photos. Take a look at the <i>Refresh Flickr Content Automatically</i> template to make this script loop the images.
| xml.flickr-picture-rotator.txt | http://rssbus.com/products/sharepoint/templates/xml.flickr-picture-rotator_thumb.png | flickr, jpg, image, random, yahoo, web service | Flickr Picture Rotator |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/xml.MapIPLocation_thumb.png'>
</td>
<td VALIGN="top">
This Web Part shows how to consume web services. In this particular example, the template is calling a web service to approximate the geographic location of a visitor based on that visitors IP address, displaying the location on a map.
</td>
</tr>
</table>
| 1807 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=xml.MapIPLocation | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=xml.MapIPLocation | Mon, 08 Feb 2010 17:26:18 GMT | Map a Visitors Location Web Part Template | Charts and Maps, Web Services | <rsb:import lib="RSSBus.XmlOps" />
<rsb:info>
<input name="mapsapikey" description="A Google Maps API key." required="true" />
</rsb:info>
<rsb:set attr="url" value="http://api.hostip.info/?ip=71.111.254.67" />
<rsb:set attr="item" value="/HostipLookupResultSet/gml:featureMember/Hostip" />
<div style="text-align:center">
<rsb:call op="xmlHttp">
<rsb:set attr="lat" value="[pxml:coordinates | split(',','1')]" />
<rsb:set attr="long" value="[pxml:coordinates | split(',','1')]" />
Welcome user. You're accessing this site from [pxml:name | lsplit(',','1')], [pxml:name | lsplit(',','2')], [pxml:countryname]<br />
Lat/Long: [lat], [long]<br />
<img src="http://maps.google.com/maps/api/staticmap?size=512x256&maptype=roadmap&markers=size:mid|color:red|[lat],[long]&mobile=true&sensor=false&key=[mapsapikey]" />
</rsb:call>
</div>
| This template makes use of the Google Maps API to create the map. Use of the Google Maps API requires a free signup, during which you will receive your Google Maps API Key that is required by this template. This template also requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.XmlOps.info' target='_blank'>RSSBus.XmlOps</a>. | XmlOps | This Web Part shows how to consume web services. In this particular example, the template is calling a web service to approximate the geographic location of a visitor based on that visitors IP address, displaying the location on a map.
| xml.MapIPLocation.txt | http://rssbus.com/products/sharepoint/templates/xml.MapIPLocation_thumb.png | geo, map, web service, xml | Map a Visitors Location |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/xml.seoBacklinkReport_thumb.png'>
</td>
<td VALIGN="top">
This template searches Yahoo for incoming links to the supplied websites and displays and counts the urls discovered.
</td>
</tr>
</table>
| 2724 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=xml.seoBacklinkReport | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=xml.seoBacklinkReport | Mon, 08 Feb 2010 17:26:18 GMT | Search Engine Backlink Report Web Part Template | Search | <rsb:import lib="RSSBus.XmlOps"/>
<rsb:info>
<input name="hostlist" description="Comma separated list of web hosts (in the format http://mysite.com, http://anothersite.com) to find backlinks for." required="true"/>
<input name="showresults" description="Whether or not to display the found backlinks." default="false" values="true,false"/>
</rsb:info>
<rsb:enum list="[hostList]" separator=",">
<rsb:set attr="searchHost" value="[_value]"/>
<rsb:set attr="document" value="http://search.yahooapis.com/SiteExplorerService/V1/inlinkData?start=1&results=100&query=[searchHost]&appid=lKn.XBnIkY0j41UxKGCm38NMQpNl8I2i4mfP"/>
<rsb:set attr="item" value="/ResultSet/Result"/>
<rsb:call op="xmlListAttributes?item=/ResultSet">
<rsb:set attr="links.total" value="[pxml:totalresultsavailable]"/>
</rsb:call>
<!-- Handle Remaining Results -->
<rsb:set attr="links.pages" value="[links.total | divide(100)]"/>
<rsb:set attr="links.remainder" value="[links.total | divide(100) | split('.',2) | def('')]"/>
<rsb:check attr="links.remainder">
<rsb:set attr="links.pages" value="[links.pages | add(1) | round(0)]"/>
</rsb:check>
<!-- Can only show 1000 results -->
<rsb:set attr="isGreater" value="[links.total | isgreater(1000)]"/>
<rsb:check attr="isGreater">
<rsb:set attr="links.pages" value="9"/>
</rsb:check>
<br>
<div style="padding-left:5px;">
Discovered <b>[links.total]</b> Urls linking to: <a href="[searchHost]">[searchHost]</a><hr />
<rsb:equals attr="showresults" value="true">
<rsb:enum range="1..[links.pages]">
<rsb:call op="xmlGet">
<div style="padding-left:5px;"><a href="[pxml:url]">[pxml:title]</a></div>
</rsb:call>
<rsb:set attr="document" value="http://search.yahooapis.com/SiteExplorerService/V1/inlinkData?start=[_value | add(1) | multiply(100)]&results=100&query=[searchHost]&appid=lKn.XBnIkY0j41UxKGCm38NMQpNl8I2i4mfP"/>
<rsb:set attr="debug.document" value="[document]"/>
</rsb:enum>
</rsb:equals>
</div>
</rsb:enum>
<rsb:catch code="*"/>
| This template requires you to install <a href='http://rssbus.com/connectors/info.aspx?con=RSSBus.XmlOps.info' target='_blank'>RSSBus.XmlOps</a>. | XmlOps | This template searches Yahoo for incoming links to the supplied websites and displays and counts the urls discovered. | xml.seoBacklinkReport.txt | http://rssbus.com/products/sharepoint/templates/xml.seoBacklinkReport_thumb.png | seo, yahoo, xml, web service, search | Search Engine Backlink Report |
| info@rssbus.com | <table>
<tr>
<td>
<img src='http://rssbus.com/products/sharepoint/templates/yahoo.stock-quotes_thumb.png'>
</td>
<td VALIGN="top">
Specify a ticker symbol or a space separated list of symbols, click the Quote button, and this Web Part will use the Yahoo connector to retrieve stock quotes from Yahoo.
</td>
</tr>
</table>
| 1716 | image/png | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=yahoo.stock-quotes | true | http://rssbus.com/products/sharepoint/templates/template.aspx?webpart=yahoo.stock-quotes | Mon, 08 Feb 2010 17:26:18 GMT | Yahoo Stock Quotes Web Part Template | News and Information, Web Services |
<rsb:info></rsb:info>
<rsb:import lib="RSSBus.YahooOps"/>
<div id="stockquotes">
<input id="symbols" type="text" name="symbols" size="75" value="[_request.form:symbols| def('')]" />
<input type=submit value="Quote" />
</div>
<rsb:check attr="_request.form:symbols">
<p />Current time: [null | now('MM/dd/yyyy hh:mm:ss')] (data is 15 minutes delayed, see Yahoo for details)<p />
<table width="100%" cellpadding="10px">
<rsb:call op="yahooStockQuotes?symbols=[_request.form:symbols]">
<rsb:first>
<tr style="background-color:LightGrey"><th>Symbol</th><th>Last Value</th><th>Change</th><th>High</th><th>Low</th><th>Open</th><th>Volume</th></tr>
</rsb:first>
<tr>
<td><b>[yahoo:symbol]</b></td>
<rsb:set attr="gain" value="[yahoo:change | startswith('-')]" />
<rsb:equals attr="gain" value="true">
<td style="color:red"><b>[yahoo:lastvalue]</b></td>
<rsb:else>
<td style="color:green"><b>[yahoo:lastvalue]</b></td>
</rsb:else>
</rsb:equals>
<td>[yahoo:change]</td>
<td>[yahoo:high]</td>
<td>[yahoo:low]</td>
<td>[yahoo:open]</td>
<td>[yahoo:volume]</td>
</rsb:call>
</table>
</rsb:check>
| | YahooOps | Specify a ticker symbol or a space separated list of symbols, click the Quote button, and this Web Part will use the Yahoo connector to retrieve stock quotes from Yahoo.
| yahoo.stock-quotes.txt | http://rssbus.com/products/sharepoint/templates/yahoo.stock-quotes_thumb.png | stocks, finance, yahoo | Yahoo Stock Quotes |