Category Archives: SharePoint - Page 5

Adobe PDF iFilter for 64-bit platforms

Posted by on December 9, 2008 No comments

Adobe has released their 64-bit version of the iFilter, that allows SharePoint Search to index the content of pdf-files.

You can download it here: http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025

Excel Services with Excel 2003

Posted by on November 17, 2008 No comments

One of our customers is still running Office 2003, but wants to use Excel Services. There seems to be some confusion if this is possible or not. As far as I am concerned, it is very well possible, although there are some prerequisites, and some limitations. These are my observations from an end user perspective:

  • The files in SharePoint need to be in .XLSX or .XLSB format, it does not work with .XLS. You can install the Office File Converter pack, which will allow Excel 2003 to save files as xlsx. 
    I had some issues installing it, but installing Service Pack 3 of Office 2003 fixed all issues.
  • With Office 2003, you can not limit the display of the workbook in Excel services to a specific area (worksheet, named range…). It always displays the full workbook if you open the file in Excel Services. In the Excel Web Access web part, you can limit the display to a worksheet or a named range. 
  • Office 2003 can not work with parameters, that allow you to change certain values dynamically in the worksheet (e.g. using filter web parts). 

If you want to know more about Excel Services from an end user perspective, have a look at the Microsoft online training material.

SharePoint and Office 14 for web

Posted by on November 4, 2008 No comments

I watched this video this afternoon, and there was one specific sentence that drew my attention (around 3:20″): “Customers can run these (web versions of Office) on the SharePoint servers in their enterprise”. 

Very interesting! So in the future, we won’t even talk about a tight integration between Office and SharePoint, it might just be the same thing. Client applications that today run on top of SharePoint to keep users away from the browser and on their familiar desktop will be useless. Offline use of SharePoint will be a non-issue, you need to be connected all the time. 

Have a look at the video yourself (requires Silverlight).

Watch out for metadata!

Posted by on September 27, 2008 No comments

Metadata is a great feature for easy retrieval of files in any document management system, not only in SharePoint. But sometimes people forget that in some cases, the metadata is stored in the file itself, not only in the repository.

This can lead to painful situations, as Microsoft experienced recently with their new “I’m a PC” ads.

If you are storing Office files on SharePoint, the same thing happens: metadata such as SharePoint columns or content type info gets stored in the file itself.

If you are using Office 2007, you can use the Inspect Document function to search for hidden metadata, and strip this from the document. This screencast shows you how SharePoint metadata remains in a Word document, and how you can use Inspect Document to remove the metadata.

Groove sync error with SharePoint

Posted by on August 22, 2008 1 comment

Today, a colleague had an interesting issue with Groove and SharePoint: he had synced a document library to a Groove workspace, but when he created a new folder in Groove, syncing with SharePoint failed with an error indicating that the folder already existed. The actual error was “Synchronization completed with errors”, and the detail: “The file “Shared%20Documents/xxx” could not be located: It may have been deleted, renamed, or moved.”

It took me a while to figure this out, but it has something to do with the default document library view in the SharePoint library. If this one has the option activated to hide folders (Show Items without folders), syncing with Groove fails. If you turn the folders back on in SharePoint, all goes well. Life is easy, isn’t it? Have a look at the screencast below for more info.