Tips

Tips

FYI, SharePoint stores dates in UTC

For the second time in the recent past,  I’ve run into unexpected date results from SharePoint.  The first time it happened with the FAST search engine and yesterday I encountered it on a second project while dealing with a simple list. Basically, when a user submits a date in a SharePoint Date and Time field (think list field), SharePoint stores it in UTC.  If SharePoint handles the rendering of that date then users never notice what happens behind the scene.  However, if we have to do something with that SharePoint DateTime field (like synchronize to a database) and we ask for...

Source Path Too Long - Cannot Delete in Explorer View

While attempting to delete a large set of documents from an email enabled SharePoint 2010 document library using Explorer View,  I was greeted with a dialog titled "Source Path Too Long"  and the following details: The source file name(s) are larger than is supported bythe file system. Try moving to a location which has a shorter path name, or try renaming to shorter name(s) before attempting this operation. LONG-FILE-NAME-GOES-HERE..... Type: EML File Size: 215 KB Date modified: 10/30/2012 8:07 AM SKIP CANCEL Do this for all current items (349 found)  Although the web interface was capable of deleting the files that was just going to take to long. The...

Missing site templates in SharePoint 2010

If you have activated SharePoint Server Publishing Infrastructure feature on the site collection level,  when you try to create a new sub-site on SharePoint 2010, there are only two site templates available by default: Publishing Site with Workflow and Enterprise Wiki.  Where are the other site templates? In SharePoint 2010, you have to ‘enable’ the other site templates first.  To do so, go to Site Settings –> ‘Page layouts and site templates’ under ‘Look and Feel’ section.  On the ‘Page Layout and Site Template Settings’ page, you can specify which site templates will be available for creating subsites in this site...

Adobe PDF x64 IFilter for MOSS 2007 Installation Tips

It has been a while since we installed the Adobe PDF IFilter for MOSS 2007 or Search Server 2008.  This is in part because Foxit Software (http://www.foxitsoftware.com) released a 64-bit PDF IFilter for SharePoint before Adobe did and because clients have been gravitating towards 64-bit SharePoint Server Farms for a while now.  In any case, I had to revisit the installation for a new client and came across a couple of things I thought would be good to share.    First, the IFilter installation document found here: http://www.adobe.com/special/acrobat/configuring_pdf_ifilter_for_ms_sharepoint_2007.pdf  instructs you to verify that...

Where is the SQL Server 2005/2008 Service Manager?

If you’ve worked with SQL Server prior to the 2005 release you’ve seen the Service Manager.  It was a taskbar tool that let you quickly stop and start SQL Server Instances and Services without having to load the SQL Server Enterprise Manager or the Services MMC.  Honestly, I hadn’t used it in ages but this morning I wanted to find and stop all SQL Server instances on a development server in order to save on memory usage and host a Virtual Machine.  At that point I remembered that it didn’t exist in the SQL Server 2005 or 2008 versions. ...

Helpful SharePoint Query String Parameters and JavaScript

Every so often I find it necessary to force a SharePoint web part page into edit or design mode using query string parameters. Originally posted on one of our internal development blogs, I decided to share this because it does come in handy from time to time.  SharePoint Query String Parameters Query String Parameter Values DisplayMode ...