Form Server Problems after SharePoint Site Collection Restore

After you restore a site collection, you may not be able to publish to a MOSS Form Server based site, and may receive the following error message:

"This form template is browser-compatible, but it cannot be browser enabled on the selected site."



This error message is caused by several features that have been affected during the restore process. You will have to use the stsadm.exe from the command line to deactivate and reactivate the functions. (You need to use the force attribute to force the changes).

The affected function list:

Premiumweb
Premiumsite
PremiumsiteStapling
PremiumWebApplication
ExcelServerWebApplication
ExcelServerSite
ExcelServer

More on stsadm:
http://www.wssdemo.com/Lists/stsadm/AllItems.aspx

We thank Alex Levitin for this tip.

Office and SharePoint Metadata Synchronization

This article has been moved to:
http://excel.shilor.org/2010/07/office-and-sharepoint-metadata.html

Fixing static links upon migration from SharePoint 2003 to 2007

I have a post in http://excel.shilor.org/2009/08/fixing-static-links-upon-migration-from.html explaining how to make vertical changes to static links that wouldn't work after migrating to 2007 version because the new links are different.

The steps are:

• Export the list from SharePoint to Excel.
• Apply a formula that extracts the URL from its 'friendly name', which requires using a UDF (User Defined Function) macro.
• Apply the 'Copy' and 'Paste special' as values to replace the URL formulas with values. Use 'Replace all' to get the new URLs.
  **It is assumed that you know how to do that.
• Apply the 'HYPERLINK' formula to create the new links.
• Copy the new links back to the SharePoint list.

A detailed explanation is in the other post.