Saturday, 17 December 2011

Timesheet Blog Series Fix

Part 1 - Design & data storage
Part 2 - Building the UI
Part 3 - Installation Steps
Part 4 - Final Part
Part 5 - This Post - Caveat to watch out for

Problem: Popup pages for the Timesheet application throw an application error (500 error), the uls log refers to the ribbon tab object not being being available.

Initial Hypothesis:  Ensure the popup pages, that use the Dialog framework are of type web part pages.


More Info:

Timesheet Post Series:
Part 1 - Design & data storage
Part 2 - Building the UI
Part 3 - Installation Steps
Part 4 - Final Part

70-668 Exam

I wrote the 70-668 Microsoft SharePoint 2010 Administrator exam this morning and failed with a score of 647.  I thought I had managed to scrape through and saw that I had failed, rather bruised my ego for about 30 minutes. 

So I had a voucher that needed to be used this year, I've been busy at work (excuses excuses ..) and thought I would know enough to pass as I am thinking of doing the MCM and still need to pass this last of the 4 basic exams.  On the plus side I know that I need to spend more time on:
  • "Designing a SharePoint 2010 Farm Topology"; and
  • "Planning SharePoint 2010 Deployments".
These exams are very useful for ensuring you actually know SharePoint.  I'll have to pay for the exam again and try do it in the new year at some point.  This has highlighted to me that I need more time administering SharePoint and can always use improvement on the technical side of SP2010.

Friday, 9 December 2011

Add Expiry Date to a List

Problem:  I have a list and each time the list item is approved, I need to add 180 days to the expiry date.

Initial Hypothesis: Create a Date and Time site column in the list.  Edit the "Calculated Value" box with a formula that will add 180 days to the current date.

Resolution: The formula to move the expiry date 180 days from the current date is:

Wednesday, 7 December 2011

SharePoint Office Web Apps Cache Storage

Overview: Office Web App is used to work on word, power point and excel document without the need to have the client applications for each of these file types on the client machine. The documents are rendered in the browser for editing.
Problem: My default content database that is hosting my root site collection for the web application grows bigger than the 200GB recommended limit for a content database.

Initial Hypothesis: When a "rendition of the presentation" is available in the cache (stored in a content database) SharePoint will use the rendition to show the document. If there is no “document” in the cache, the appropriate service builds the “rendition”, displays it and adds it to the cache.

The cache is stored in the default content database. From Technet “Content databases also contain the Microsoft Office Web Apps cache, if Office Web Apps have been deployed. Only one cache is created per Web application. If multiple site collections that are stored in different content databases have Office Web Apps activated, they will all use the same cache. You can configure the size of cache, the expiration period, and the location.”
Database location for the OWA cache (a SharePoint content database). You can isolate the Office Web Apps cache from other content:
  • Create a separate content database, set it to contain only one site collection.
  • Configure the Office Web Apps cache to use that database.

Read More:

Other: I have used OWA for thumbnails on a past project for search. So when search results return, I get a thumb nail of the word or PowerPoint document in the results. OWA is pretty heavy and it appears that it will have to convert all documents that don’t have a rendition of the presentation in the cache when a search is performed. This doesn’t seem a good use of resources and a potential bottleneck.  Have I understood how FAST generates preview?  Pls leave your comments.

The Microsoft Word Web App and Microsoft PowerPoint Web App generate a series of images to create a rendition of a document that is viewable in the browser. If Microsoft Silverlight 3 is installed, XAML is used to create the rendition.” - Technet