ColdFusion & SharePoint

ColdFusion & SharePointTwo Great Tastes that Taste Great Together!(No, not really)

Sponsored by:

DavidWilson BrownLead Web Developer,Europa Sports ProductsPRESENTED BY: 1Major Abbreviations UsedCF = ColdFusionCF9 = ColdFusion 9 (released October 5th 2009)

SP = SharePointSP 2010 = SharePoint 2010 (to be released late 2009)

SSO = Single Sign-OnAgendaIntro: Why CF & SP together?

Pre-CF9Page Viewer Web Parts

CF9

Single Sign-On access

SP 2010?Basic

Intermediate

Advanced

Pure SpeculationWhy CF & SP together?ColdFusion is a rapid application development platform whose language, CFML is comparable to ASP, JSP & PHP, but more closely resembles HTML in syntax. ColdFusion is most often used for data-driven web sites, but can also be used to generate remote services such as SOAP web services or Flash remoting.

SharePoint is becoming the ubiquitous corporate team collaboration tool, often times used as a companys Intranet.Why CF & SP together?Many companies use ColdFusion for their external websites and some for their Intranet.

The growth of SharePoint is such that many companies with current ColdFusion development are bringing SharePoint in-house as well.Why CF & SP together?So a big request has been how to save the long developed ColdFusion apps with the move to a SharePoint based Intranet (for example)

We were one of those requestingBen Fortas Blog(Adobes Director of Platform Evangelism)3/18/08 - What Would You Want From ColdFusion Microsoft SharePoint Integration?

We are a ColdFusion house. Our external website will always be ColdFusion (I hope!), but I have gotten my team to use WSS for several years and we are now looking to upgrade to MOSS 2007 within the month. We will then begin the process of changing our corporate intranet (which is now CF based) to a SharePoint portal. Being in that situation, I would love to see:

1. A ColdFusion web part for SharePoint where ColdFusion applications can act normally within SharePoint structure. I would love to save some of our current CF applications and utilize them within SharePoint.

2. A CF tag that would help add a list item to a list in SharePoint. I think the big stumbling block to adding a list item is some proprietary code (GUID) that MS puts into a list item record. Determining the appropriate value for the code would be the main thing necessary, I think.

Thanks Ben. I am excited to see an interest in what I thought was a fairly unique situation that we were in. Me 3/24/08Assumptions going forwardYou have some knowledge of CF

You have some knowledge of SharePoint

You care to hear more about this topic

You generally like me, at least from what youve seen of me thus farPre-ColdFusion 9Stone Chisel

Page Viewer Web PartsAdd Page Viewer web part to any pagePoint the web part to a ColdFusion template via URLResize the web part to fit the contentVoil Adding Web Part w/ ColdFusion

From the SharePoint Server page, click Modify Shared Page.

Select Add Web Part.

Click Browse from the pop-up menu. The Web Parts list appears.

Select Page Viewer Web Part.

Click Add. The Page Viewer Web Part loads.

Click the Open the Tools Pane link.

Specify the URL of the ColdFusion application in the URL text field. The ColdFusion application loads within the Web Part.

EXAMPLE

ColdFusion 9Hal 9000

Could it be any more obvious?Allows your ColdFusion server to communicate to and from your SharePoint instance.The following is an Adobe example.

myimage = filereadbinary(expandpath("Bird.jpg")); //convert the image into byte array to pass as input for "upload" action.

baseimage = filereadbinary(expandpath("bird.jpg")); //convert the image into byte array to pass as input for "upload" action.

Single Sign-OnAllows your ColdFusion app to utilize the AD login from SharePoint.

CF9 ships with SSO Web Part (CF9SSOWebPart.wsp)Deploy to your MOSS

Benefit is to capitalize on SharePoint Permission Hierarchies to limit what a user can do.

Taking it to the Next LevelYou have the SP Page Viewer web part

So why not build a Flex App

To run with a CF9 backend

Which would be able to affect SharePoint list items!

EXAMPLE (sort of)Features in SP 2010Server software 64-bit ONLYMenu interface changeIf SharePoint 2007 = Office XP, then SharePoint 2010 = Office 2007Silverlight web partsHolographic Laser Shows (just kidding)No word yet on how SP 2010 will effect CF9 integrationME

davidwilsonbrown@gmail.com@davidwbrown/davidwilsonbrown/David Wilson Brown

davidwilsonbrown.wordpress.comLinksBen Fortas SharePoint in CF9 announcement: http://forta.com/blog/index.cfm/2009/7/10/ColdFusion-SharePoint-Integration

CF9 SharePoint integration: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSE4D1ED62-0267-445f-8A3B-4642F3F26383.html

CF9 Beta Hosting: http://hostek.com/hosting/coldfusion/coldfusion9-hosting.asp

Good Blog with CFSharepoint contenthttp://www.singularityconcepts.com