Sharepoint Mashups

Mashups & Sharepoint

This Dev Zone is dedicated to Mashups and Sharepoint. Here's everything the Mashup Developer Community has to say about mashups and their complimentary nature to Sharepoint, whether it's a demo, video, code sample, forum post, Q&A or blog.

Join us on a virtual site tour, it only takes two minutes!

Posted 02/05/2010 - 10:28 by MiMi Levine

Welcome to the Mashup Developer Community!

To help you get acquainted with the site quickly and painlessly, we've have created you a mini virtual site tour video. In the two minute video we touch on how to download Presto, how to join Mashup Interest Groups, how to build your profile and how to share your mashups. Take a minute and review the video, I promise it will jump start your community experience. 

Click here to view the video in full screen. 

Mashing SharePoint Web Services: Example 3

Posted 01/20/2010 - 18:44 by MiMi Levine

 We will expose the newly published service, Query Operation as a mashup Service. [Read More...]

Mashing SharePoint Web Services: Example 2

Posted 01/20/2010 - 18:40 by MiMi Levine

 Before publishing the Web Service to Presto we need to gather the following information, assuming we have a SharePoint Site named  [Read More...]

Mashing SharePoint Web Services: Example 1

Posted 01/20/2010 - 18:38 by MiMi Levine

Before publishing the Web Service to Presto we need to gather the following information, assuming we have a SharePoint Site named  [Read More...]

SharePoint Web Services: Example 2

Posted 01/20/2010 - 18:35 by MiMi Levine

Having identified the SharePoint Web Service endpoint URL, we're able to publish the service as a Presto SOAP Service. Presto requres the URL of the Web Service WSDL which we can get by appending ?wsdl to the Web Service Endpoint address. [Read More...]

SharePoint Web Services: Example 1

Posted 01/20/2010 - 18:33 by MiMi Levine

Presto version 2.6.1 or later is capable of consuming SharePoint Web Services, earlier versions of Presto did not support the NTLM Authentication. [Read More...]

Mashing SharePoint RSS with Presto

Posted 01/20/2010 - 18:31 by MiMi Levine

 The screenshot below shows the example SharePoint Team Discussion List which we will publish in Presto as an RSS Feed. [Read More...]

Presto Consuming SharePoint Services

Posted 01/20/2010 - 18:28 by MiMi Levine

The SharePoint Web Application Settings "RSS Settings" property must be enabled to allow users to subscribe to SharePoint List views in syndicated format. This option is enabled by default. The option can be checked via Central Administration, Web Application Management section, Web Application Settings. [Read More...]

Using Custom Web Parts to publish Mashlets into SharePoint: Example 2

Posted 01/20/2010 - 18:26 by MiMi Levine

Having built the Web Part Assembly we will deploy it to the SharePoint  [Read More...]

Using Custom Web Parts to publish Mashlets into SharePoint: Example 1

Posted 01/20/2010 - 18:23 by MiMi Levine
  • With the SharePoint Server SDK installed you should be able to create a new web part project by selecting the C# SharePoint Web Part Template, name the Project Jackbe.Samples.
  • Delete the default WebPart, WebPart1, and add a new WebPart named MashletView. Which should generate the following template class:
[Read More...]

SharePoint Consuming Mashups using standard XML Web Part

Posted 01/20/2010 - 18:20 by MiMi Levine

With a fairly basic knowledge of XSL, XPath and XSL Stylesheets, the SharePoint XML Web Part can provide a front-end for Presto Mashups. The XML Web part can actually be used to invoke any REST-like, XML based, non-SOAP Web Service, where the invocation request is encapsulated in a URI and the response is received as an XML document. [Read More...]

Using Standard Web Parts to Publish Mashlets into Microsoft SharePoint: Example 2

Posted 01/20/2010 - 18:17 by MiMi Levine

Presto.ServiceMashlets are the particular type of mashlet published by Presto MashletMaker when exposing a Presto published Service with a web UI. This mashlet type is designed to allow mashlets to be configured with specific, primitive, input parameter data, which is required to invoke the underlying Presto Published Service. [Read More...]

Using Standard Web Parts to Publish Mashlets into Microsoft SharePoint: Example 1

Posted 01/20/2010 - 18:13 by MiMi Levine

Probably the quickest way of getting SharePoint to consume service data published by Presto is to configure it to display Mashlets. [Read More...]

Are you putting Excel in the cloud, when you say repository? Where is this Repository? Google Docs, SharePoint?

Posted 01/04/2010 - 13:38 by Blythe

No, in the demo you just saw we were PULLING Excel from the cloud.  But the server was inside our firewall.  And that 'using external data in an internal mashup' is a very common architecture.

JSR-168 is nice, but it doesn't help me as an ASP.NET developer. Is there support for displaying mashlets in ASP.NET apps?

Posted 12/31/2009 - 11:02 by Blythe

Yes, we have a .NET API as well. And we are just about to release some examples of Presto Mashups in Sharepoint. Keep an eye on http://www.jackbe.com/enterprise-mashup/

Are you using .NET FRAMEWORK 3.5 with AJAX?

Posted 12/30/2009 - 10:42 by Blythe

Most of our software is Java-based but we have integrated with .NET-driven tools like Microsoft SharePoint.

Can Presto create mashups with unstructured data (i.e. word doc checked into a SharePoint site)?

Posted 12/30/2009 - 10:27 by Blythe

Yes.  We often use a type-specific library to extract the information.  we do have out-of-the-box Connectors for Microsoft Excel and another Connecter for HTML 'scraping'.  Other unstructured formats would be accessed through document-type-specific access functions.

What is the secret behind the mashlet being able to run in J2EE and .Net containers e.g. BEA Portal and SharePoint portal?

Posted 12/30/2009 - 10:23 by Blythe

There’s no secret.  Presto simply generates mashlet wrappers that are unique to each platform.

Is Presto Server able to integrate with Oracle Webcenter / Oracle (BEA) Portal /PeopleSoft - Portal?

Posted 12/30/2009 - 10:21 by Blythe

Yes.  We have mashup demonstrations that include Oracle BEA and Oracle WebCenter on www.jackbe.tv. 

Will it cost a whole bunch to connect to SAP systems?

Posted 12/30/2009 - 10:20 by Blythe

No.  We've worked with most of the big ERP applications in one way or another.  Of course, the real cost will depend on the exact details of your requirements.  SAP is, afterall, a very large collection of functions and data types.

Excel "apps" that is scalable, maintainable and secure could be built with MOSS (Microsoft Office SharePoint Server) deployment and give the power to end user. Why should we embrace Mashup?

Posted 12/30/2009 - 10:19 by Blythe

Mashups and SharePoint compliment each other quite well, particularly if your data sources are not just Excel but include SOA services, XML/RSS, SQL databases, etc.  Check out our 10-part blog series on 'Mashups and SharePoint': http://www.jackbe.com/enterprise-mashup/blog/mashing-sharepoint-introduction.  Give us your feedback on it!