Sladescross's Blog

Blogging about Sharepoint related stuff

Uninstall Office Web Apps March 12, 2012

Filed under: Office Web Apps,Office Web Apps Uninstall,Uninstall — sladescross @ 2:22 pm

http://blogs.msdn.com/b/opal/

Here’re a few points you must remember when you want to uninstall Office Web Apps:

  • Uninstall Office Web Apps will remove the server from the SharePoint Farm. If you read the notification carefully when you click the uninstall button you will know this.
  • All web applications and sites created by SharePoint will be deleted from IIS.
  • You can rejoin the machine back to the Server Farm by psconfig with your farm passphrase.
  • You need to redeploy customizations to the server.
  • If this happens to be the server which hosts Central Administration, you need to rebuild the CA. This can be done through the Management Shell: New-SPCentralAdministration -Port xxxx -WindowsAuthProvider “NTLM”

If you can tolerance server down time then maybe it’s fine for you. Otherwise the whole process are not that pleasant. So how about just disable it like this:http://technet.microsoft.com/en-us/library/ee837418.aspx ?

To deactivate the Office Web Apps Feature on a single site collection by using Windows PowerShell

Using Notepad, open a new text file and then copy and paste the following script into the file.

$webAppsFeatureId = $(Get-SPFeature -limit all | where {$_.displayname -eq "OfficeWebApps"}).Id 
$singleSiteCollection = Get-SPSite -Identity http://<site_name> 
Disable-SPFeature $webAppsFeatureId -Url $singleSiteCollection.URL 

Hmm, in fact this will not completely disable the feature. You have to enable “Open in Client” feature as well, then all files can be opened in Office clients instead of the browser. However if you visit the server without Office client installed or using something like Safari/Chrome, you will still be redirected to the Office Web Apps page like WordViewer.aspx even you have deleted the service applications, stopped the related services.

Why? Because the modification to the drop down menu and open behavior by Office Web Apps cannot be turned off using those ways. Of course, a full uninstall will work – but like what I listed above, it has many cons. Luckily this is not the end of the world. With a few hours work I identified the change made by Office Web Apps and confirmed with the product team. Here’s my findings:

The reason why you can see those drop down menus with items like “Edit in Browser” is because the XML definition is changed. Take this one as an example:

c:\program files\common files\microsoft shared\web server extensions\14\template\xml\serverfilesword.xml

Content:

<?xml version=”1.0″ encoding=”utf-8″ ?> <!– Copyright (c) Microsoft Corporation. All rights reserved. –> <ServerFiles>     <Mapping FileExtension=”doc”  RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” />     <Mapping FileExtension=”dot”  RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” />     <Mapping FileExtension=”docx” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate= “/_layouts/CreateNewDocument.aspx?id=|0″ />     <Mapping FileExtension=”docm” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate= “/_layouts/CreateNewDocument.aspx?id=|0″ />     <Mapping FileExtension=”dotx” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate= “/_layouts/CreateNewDocument.aspx?id=|0″ />     <Mapping FileExtension=”dotm” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” /> </ServerFiles>

The purpose of this file is to tell SharePoint that if it has such doc files within a doc lib, use the redirect url template to process it. So what we will do is to simply remove this file or comment out the section to make it looks like this:

<?xml version=”1.0″ encoding=”utf-8″ ?> <!– Copyright (c) Microsoft Corporation. All rights reserved. –> <ServerFiles> <!–     <Mapping FileExtension=”doc”  RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” />     <Mapping FileExtension=”dot”  RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” />     <Mapping FileExtension=”docx” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate= “/_layouts/CreateNewDocument.aspx?id=|0″ />     <Mapping FileExtension=”docm” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate= “/_layouts/CreateNewDocument.aspx?id=|0″ />     <Mapping FileExtension=”dotx” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate= “/_layouts/CreateNewDocument.aspx?id=|0″ />     <Mapping FileExtension=”dotm” RedirectUrlTemplate= “/_layouts/WordViewer.aspx?id=|0″ NoGetRedirect=”TRUE” /> –> </ServerFiles>

Then do the same to serverfilespowerpoint.xml. Unless you are using standard CAL, there’s no need to touch Excel Services since it’s a part of Enterprise CAL and is not installed by Office Web Apps.

Then combine this change with the disable of Office Web Apps feature and the enable of Open in Client feature, Office Web Apps can be disabled completely on the site collection from a user experience perspective. You can also stop the related services and service applications.

 

Office Web Apps Cache June 23, 2011

Filed under: Cache,Office Web Apps,Office Web Apps Cache — sladescross @ 4:45 pm

http://www.idera.com/News/Newsletters/Quick-Tips-for-Mnging-SP2010-Office-Web-Apps-Cache.pdf

The Office Web Apps Cache Creation timer job creates an Office_Viewing_Service_Cache site collection in a content database that is collocated with one or more of the “real” site collections within each of your content Web applications. Since the cache site collection is allowed to grow by default to a beefy 100GB, it makes sense to relocate the cache site collection to its own (new) content database. Relocating the cache site collection to its own content

When an Office_Viewing_Service_Cache site collection is provisioned within a Web application by the Office Web Apps Cache Creation timer job, it is initially configured to hold cached document resources for 30 days. As mentioned in Tip No. 1, a cache site collection can also grow by default to a maximum of 100GB.

database makes it easier to exclude it from other maintenance, such as backups.

When an Office_Viewing_Service_Cache site collection is provisioned within a Web application by the Office Web Apps Cache Creation timer job, it is initially configured to hold cached document resources for 30 days. As mentioned in Tip No. 1, a cache site collection can also grow by default to a maximum of 100GB.

 

Install Office Web Apps November 9, 2010

Filed under: Office Web Apps — sladescross @ 5:09 pm

http://technet.microsoft.com/en-us/library/ff431687.aspx

 

Excel Services Publishing Tutorial July 24, 2010

Filed under: Excel Services,Office Web Apps — sladescross @ 1:12 pm

http://www.sharepointmonitor.com/2010/02/getting-started-with-the-sharepoint-2010-excel-services/

The first step is to create the Document library where the Excel spreadsheet will be published. To do this, select the Site Actions menu and then choose New Document Library

The next thing we need to do is to define some named cells. These cells will be modified later by the end user via the web browser interface.

To publish the spreadsheet we have just created, go to Excel Services from the Publish menu as shown in Figure 5. A new Save As dialog will open, where you will need to provide the URL of the Document library we have created early and a name for the spreadsheet. To find the library URL navigate to the “Wages” library and partially copy the URL displayed by the browser as shown in Figure 6. Paste this URL inside the Save As dialog and append the file name. Separate the file name and the URL with “/”. For example, the end result will look like this: “http://win-m81s8bk9hra/Wages/Wage-Calc-2010.xlsx”. While you are still in the Save As dialog, press the Excel Services Options button. A new popup dialog will appear. Here you need to define the parameters that will be editable via the web interface. So switch to the Parameters tab and press the Add button (Figure 7). Select “HourRate” and “Hours” and click OK . Confirm the Excel Services Options dialog by pressing OK. Now you are back inside Save As dialog. Make sure that the Open in Excel Services check box is selected and hit Save . After a while the spreadsheet is published and the web browser will open it automatically.

 

Office Web Apps and Excel Services July 22, 2010

Filed under: Excel Services,Office Web Apps — sladescross @ 11:08 am

http://blogs.technet.com/b/tothesharepoint/archive/2010/07/21/excel-services-and-excel-web-apps-common-different-features.aspx

 

 
Follow

Get every new post delivered to your Inbox.

Join 63 other followers