Tag: sharepoint

  • Another example of how JQuery can help your site!

    I like this post because it illustrates how JQuery can make your UI code more efficient. Look at the code examples in this post. What once took 6 lines of code only takes one using JQuery. Of course, you have the overhead of loading the JQuery framework – but if you are doing a lot of client-side manipulation of the user interface then look to how JQuery can help you be more efficient.

    Low impact text changing in SharePoint with jQuery

  • Why does making a Lookup site column an indexed field break my CAML Query?

    I created a custom timer job definition that processes email-enabled list items. Since these list items were created from email, I extract certain email header information from the email and save that information as meta-data.

    One of those site columns is called EmailSource. This is a Lookup field using the Title field of the EmailSource list as the value. My timer job queries the main list to find all list items where the EmailSource IsNULL and then I extract information from the email headers, and then find the appropriate EmailSource from the EmailSource list and write it to the EmailSource field in the main list.

    It has been working pretty slick for the last month or so. Recently, I thought that I would try to improve the response of the main list views by setting the EmailSource site column as an indexed column. Since most of the views are created filtering on the EmailSource field, I figured that this would be an ideal candidate for indexing. As soon as I set the EmailSource site column as an indexed column, my query for IsNull started returning 0 (zero) items, even when I could see that there were list items that didn’t have an EmailSource value.

    My query is:

    <Query>
      <Where>
        <IsNull>
          <FieldRef Name='EmailSource' />
        </IsNull>
      </Where>
    </Query>

    Now – normally, when the EmailSource field is NOT set as an indexed column, this query would return all list items where EmailSource didn’t have a value. As soon as I set EmailSource as an indexed column, the query would always return zero items, even though I knew it should return some list items.

    As soon as I removed that field from the indexed columns list, the query began to work correctly again.

    So – I ask you. Why would setting a field as an indexed column break a query?!!!!

  • Configure disaster recovery across SharePoint farms by using SQL Server log shipping

    Microsoft has provided updated information for setting up farm DR with log shipping. Even if you haven’t set up DR w/ log shipping in your environment, it is a good read to gain valuable DR knowledge.

    Configure disaster recovery across SharePoint farms by using SQL Server log shipping.

  • How To Debug STSADM Extensions

    I’ve been writing some StsAdm extensions and I’ve struggled to debug some “unhandled exceptions”! I found this great post that shows you how to set up Visual Studio to debug your extensions.

    http://blogs.prexens.com/Pages/Post.aspx?ID=5

  • Typemock for Unit Testing SharePoint!

    I’ve never used this product but I am excited to add it to my list of tools.  Check it out!

    Unit Testing ASP.NET? ASP.NET unit testing has never been this easy.

    Typemock is launching a new product for ASP.NET developers – the ASP.NET Bundle – and for the launch will be giving out FREE licenses to bloggers and their readers.

    The ASP.NET Bundle is the ultimate ASP.NET unit testing solution, and offers both Typemock Isolator, a unit test tool and Ivonna, the Isolator add-on for ASP.NET unit testing, for a bargain price.

    Typemock Isolator is a leading .NET unit testing tool (C# and VB.NET) for many ‘hard to test’ technologies such as SharePoint, ASP.NET, MVC, WCF, WPF, Silverlight and more. Note that for unit testing Silverlight there is an open source Isolator add-on called SilverUnit.

    The first 60 bloggers who will blog this text in their blog and tell us about it, will get a Free Isolator ASP.NET Bundle license (Typemock Isolator + Ivonna). If you post this in an ASP.NET dedicated blog, you’ll get a license automatically (even if more than 60 submit) during the first week of this announcement.

    Also 8 bloggers will get an additional 2 licenses (each) to give away to their readers / friends.

    Go ahead, click the following link for more information on how to get your free license.