I drafted this post quite a while ago, but I’ve only just got around to completing it and posting it.
Recently, I was completing some out of hours work to apply the August 2012 Cumulative Update to our production SharePoint 2010 SP1 environment.
After completing the installation of the SharePoint 2010 Foundation and SharePoint Server 2010 update packages, I tried to run the SharePoint Products and Technologies Wizard to initiate the timer job that upgrades the database schema, and it wouldn’t run, reporting that one of the servers was missing the updates that I had just installed.
When searching for the answer, I came across SharePoint Management Shell Cmdlet Get-SPProduct -Local. This useful little Cmdlet for PowerShell forces the local installation of SharePoint to rescan all of it’s installed components and by the looks of it, where needed, updates the SharePoint_Config database with the installed updates for the server. Before running the Cmdlet, I did an iisreset /noforce. Doing this ensures that the web applications are in a suitable state and reloaded with all the latest files.
After running these two commands, running the SharePoint Products and Technologies Wizard successfully validated the servers and allowed the wizard to complete.
I’m currently running a test lab for the purposes of development of a Version 4 Master Page and CSS Stylesheet for SharePoint 2010 to replace the legacy Version 3 UI we are using at work. Whilst developing my flash new fixed width master page and layout I wanted to be able to hide the quick launch on the homepage so that I had the full width of the layout to give the site an eye-catching look.
Using the HTML Webpart we are able to inject some inline CSS Styles which do this for us.
Add the HTML Webpart anywhere on the page that you want to hide the Quick Launch on and add the following source code to it:
/* Hide Quick Launch on Homepage */
Make sure you configure the Webpart as Modeless so that the users don’t see the title of what is essentially a blank Webpart shown in the interface, and that’s it.
Last night we completed a SharePoint 2010 at work and after all the testing, we deemed the upgrade a success, however coming into the office this morning, we received reports from some users that they were unable to open some of their Excel spreadsheets stored in various Document Libraries.
After some diagnosis, it turned out that the problem only effected Office 2007 and Office 2010 XML format documents and that original format Excel documents from Office 2003 and documents saved in the 2003 format were unaffected.
After initially suspecting the problem to be linked to the new Excel Services Application in SharePoint 2010, I worked to resolve the configuration of the Excel Services Application which we had left previous un-configured due to it not being required currently, however the problem persisted.
Whilst searching TechNet for the error code we were receiving I encountered a page entitled â€œConfigure the Default Behaviour for Browser-Enabled Documentsâ€ (http://technet.microsoft.com/en-us/library/ee837425.aspx) which details how to manage the behaviour of SharePoint for launching web compatible documents.
SharePoint 2010 features various web-enabled services and can be configured to use Office Web Apps, which is a hosted version of the applications available via Office Live WebApps. The default behaviour for SharePoint 2010 is to attempt to launch web compatible formats using the web based application, however as this is not configured in our environment the error appeared.
The resolution to the problem was simply enabling the Site Collection Feature Open Documents in Client Applications by Default. Once enabled on the Site Collection to apply the setting to all child sites, SharePoint began prompting the users to open the file with their client side installations of Excel as per the SharePoint 2007 behaviour.
After successfully upgrading from SharePoint 2007 to SharePoint 2010, I noticed that the icon for PDF documents was missing from my Document Libraries. As part of the installation process, SharePoint 2010 installs itself to a folder called 14 to designate its version number as SharePoint 2007 used a folder number of 12. It was apparent that nothing was migrated from the 12 folder as as a result any modifications will be lost.
- Download the PDF icon. Visit http://www.adobe.com/misc/linking.html and download a copy of the small 17×17 PDF icon.
- Copy the icon to Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES
- Open the DOCICON.XML file in Drive:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML
- Add the following line to the DOCICON.XML file:
<Mapping Key="pdf" Value="pdf16.gif"/>
- Save DOCICON.XML
- Open a Command Prompt and type iisreset to reset the IIS Application Pools
You will now have beautiful looking PDF icons in your document libraries in SharePoint 2010.