Sharepoint 2010 Productivity Hub and Office Web Apps

Here is a fix to get Sharepoint 2010 Productivity Hub links working properly with Office Web Apps:

1 - Using Sharepoint Designer, edit the productDV.xsl file in the All Files/supportFiles folder on the site hosting the Productivity Hub.

2 - In the table data section referenced by: <td class="ph-dataviewfeaturetext" colspan="3">, Replace the code for the html link with the following:

    <xsl:choose>
            <xsl:when test="substring(@FileRef,string-length(@FileRef) - 4,5) ='.docx'">
               <strong><a href="/_layouts/WordViewer.aspx?id={@FileRef}"><xsl:value-of select="@Title"/></a></strong>
            </xsl:when>
            <xsl:when test="substring(@FileRef,string-length(@FileRef) - 4,5) ='.pptx'">
               <strong><a href="/_layouts/PowerPoint.aspx?PowerPointView=ReadingView&amp;PresentationId={@FileRef}"><xsl:value-of select="@Title"/></a></strong>
            </xsl:when>
             <xsl:when test="substring(@FileRef,string-length(@FileRef) - 4,5) ='.xlsx'">
               <strong><a href="/_layouts/xlviewer.aspx?id={@FileRef}"><xsl:value-of select="@Title"/></a></strong>
            </xsl:when>
            <xsl:otherwise>
                <strong><a href="{@FileRef}"><xsl:value-of select="@Title"/></a></strong>
            </xsl:otherwise>
            </xsl:choose>

Comments

[Claude M]

Hello Dave,

My company deployed the Microsoft Productivity Hub on a 2007 server farm a couple of years ago, works great. Now I'm trying to deploy the Microsoft Productivity hub 2010 on a SP 2010 server farm. I really like the way the 2010 Hub looks & feels, except I can't get product specific search setup. The search on the main Hub page searches the entire hub, as it should, but on our 2007 hub, we had the ability to do targeted searches on each of the product pages. When using the search box on the Excel page, you would only search for documents related to Excel. When using the search box on the Ribbon product page, you only searched documents related to the Ribbon. Etc...

This doesn't seem to work on the 2010 Hub. I suspect it has something to do with the product.aspx. Is there a workaround for this issue?

Cheers,
Claude...

[bernie10]

Hi Dave
I have just installed the productivity hub on server 2007 farm installation. All is working ok except that i cannot view the videos. The other elements are working ok such as documents and demos. I get the error below; Please help

The package cannot be added to the store because it contains at least one error. at Microsoft.SharePointTrainingKit.SlkStore.RegisterAndValidatePackage(String location, Boolean validateOnly, PackageItemIdentifier& packageId, LearningStoreXml& warnings)
at Microsoft.SharePointTrainingKit.SlkStore.RegisterPackage(String location, PackageItemIdentifier& packageId, LearningStoreXml& warnings)
at Microsoft.SharePointTrainingKit.SlkStore.GetNewAssignmentDefaultProperties(SPWeb destinationSPWeb, String location, Nullable`1 organizationIndex, SlkRole slkRole, LearningStoreXml& packageWarnings)
at Microsoft.SharePointTrainingKit.StkDataAccess.STKdataStoreHelper.CreateAssignment(String packageUrl, Nullable`1 organizationIndex, String assignmentWebUrl, String title, String instructorLoginName, String[] learnerLoginNames)
at Microsoft.SharePointTrainingKit.ApplicationPages.Transit.processPostBack(NameValueCollection formParameters)
at Microsoft.SharePointTrainingKit.ApplicationPages.Transit.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)