Archive for the 'Excel Services' Category

ISC London: Quickly Delivering Business Applications on SharePoint 2010 Session

I’m looking forward to talking about quickly delivering business applications on SharePoint 2010 at The International SharePoint Conference London 2012 in April. I’ll be co presenting with one of our customers.

When the tools available in SharePoint 2010 are used appropriately, it can be phenomenally productive. In my session, we take a look at how it was possible to build a fully featured business application, with forms, workflow and reporting in a matter of days – and without writing any code. Using Purchase Order management as an example, I’ll review the business requirements and explain why SharePoint was chosen for the application, before getting hands on with some demos and looking at how SharePoint capabilities were leveraged to quickly deliver the application at an engineering company.

Full agenda of speakers can be found here. It’s shaping up to be another excellent event!

Register ICSLondon

Click here to regsiter: http://www.internationalsharepointconference.com/Pages/Register.aspx

When Collaboration Becomes a Commodity, How Do You Choose a Platform that Adds Value?

When SharePoint was first released, the idea of a web site where users could upload documents, and manage their own lists, calendars, etc was quite novel to many people. It was, as we all know, a runaway success and SharePoint has been widely adopted across many organisations. Many other software vendors, as well as Microsoft, also provide collaboration platforms.

Now more and more collaboration platforms are becoming available, with cloud offerings such as Box.net, Huddle, Google Docs and many others being added to the mix.

One of the differentiators of SharePoint 2010 is that you can use it as a platform for the delivery of business applications, as well as for straightforward collaboration. Even the entry level SharePoint 2010 Foundation gives you:

  • Out of the box and custom lists and views. These lists can be linked to deliver simple data driven applications
  • Built in security model. You can set permissions to control who can see and do what
  • Ability to build workflows using SharePoint Designer
  • Forms that use the InfoPath client (part of some editions of Microsoft Office)
  • Core Business Connectivity Services functionality, for interacting with data in other systems
  • An open platform for enhancement through custom development and integration with other systems
  • Possibility to use SQL Server Reporting Services in SharePoint integrated mode to build reports and dashboards

Once you move up the licencing scale to SharePoint Server 2010 Enterprise, you get the “Composites” functionality that adds significantly to the toolset available for building applications. This includes

  • Excel Services, for interacting with and publishing parts of Excel spreadsheets through the browser
  • InfoPath Forms Services, that takes InfoPath forms and renders them in the browser
  • Visio Services, for publishing data driven diagrams
  • Access Services, for converting Access Databases to SharePoint lists and forms, and allowing browser based interaction
  • Enhanced Business Connectivity Services
  • Various web parts and out-of-the-box workflows

This rich toolset for quickly delivering business applications sets SharePoint apart from many collaboration platforms, and it should be a major consideration for many organisations when choosing a collaboration platform.

Our technology neutral white paper, “The Business Applications Deficit” looks at the drivers behind the need for business applications, and the challenges faced by organisations in implementing applications. To receive your complimentary copy please click here.

Delivering Business Applications with SharePoint Composites: Don’t get Stuck!

Suppose that you are in New York and you want to come to my house. You could look at a map of the world that has New York and my house marked on it. Looking at the map you can see that London Heathrow airport is pretty close to my house. So you think, hey that’s cool I’ll fly over. You pay for your flight, tell me what time you are arriving, and tell your wife/husband/partner how much it costs. Sorted. Easy.

So you jump on the plane and all goes well for a few hours. You arrive at Heathrow and walk out of the airport. Now, Ian’s house is somewhere nearby isn’t it? Actually you’ve got still got 94 miles to go and although you have completed 97% of your journey you aren’t at my house. You’ve no UK currency and your mobile phone is flat (and you can’t plug your charger in because of our rather cool power socket design J). So you are stuck.

Let’s compare this to the case of building a SharePoint business application using tools such as InfoPath, SharePoint Designer, Excel Services and Access Services. It’s all too easy to get started with these tools without an absolutely clear idea of how your end solution will work. The tools allow you to do a lot very quickly. So you pull your application together and it almost meets your requirements. But then you hit a problem: the last little bit requires something that the tools don’t let you do. You are faced with having to resort to another tool, possibly some custom code, or even having to rework what you have already done. Also chances are you need to go back to the business and tell them that you need more time and/or money.

The conclusions to this are really as follows:

  • Before you embark on delivering a business application using SharePoint composites, be absolutely clear about what the end solution will be (where are you going)
  • Be clear about how the tools available will deliver all of the required functionality (what is the means of transport for each stage of the journey). If you do a proof of concept then make sure you tackle the difficult bits of functionality up front. Don’t just do the easy bits so that you can show the business users something nice! It may make them happy in the short term but they won’t like it when you have to go back telling them you need more time and money.

Enjoy your journey!

Back to the PointBeyond web site

Index of SharePoint 2010 Issues and Resolutions

Thought I would consolidate the posts I have made over the last few months into a single index. The topics are quite varied as they comprise issues I have encountered while working on real world projects.

InfoPath web form not loading in SharePoint 2010

Error viewing reports in Access Services

Unable to open the file for an unknown reason in Excel Services

Document IDs and the managed metadata service

Unable to find the content type publishing link in site administration, or to use managed metadata columns

No content types have been subscribed error message

 

 

Back to PointBeyond web site

Excel Services – Unable to Open the File for an Unknown Reason

Error messages in the UI to Excel Services aren’t always the most helpful, take for example:

Excel Services is unable to open the file for an unknown reason.

Wait a few minutes and try to open the file again. If the problem persists, contact your administrator.

However, I am often finding that a quick check of the Windows application event log reveals the underlying problem, without the need to revert to the SharePoint log files.

In my particular case, the cause of the problem is revealed in the application log pretty clearly. The service account used to run Excel Services (more specifically the application pool identity that hosts Excel Services) does not have access to the content database containing the Excel file. The resolution is simply to grant the identity database owner rights on the content database. Excel services then works fine. It may be possible to get away with less than database owner rights – I may experiment with this in future, or would be interested to hear other experiences.

Ian

Back to PointBeyond web site



Follow

Get every new post delivered to your Inbox.