Thursday, 17 January 2013

Creating a Spell Checker with the native Sharepoint 2010 web services

I was checking the other day different ways to create a spell checker for a nice web part I was doing in Sharepoint 2010. I have been trying jQuery spell checkers, but to be honest, they all look quite clunky, in fact most of them work outside Sharepoint but as soon as you try to use them in your webpart, become unstable. If fact, a couple of them work “sometimes” what is the last thing you want when you have to deliver a project to a client.

I heard about Sharepoint Spell Checker, so I start doing some research, I have found a couple of posts on Internet, but they didn’t work either, the closest one comes from “Cherry Bytes” (thanks for sharing the info) and it was for MOSS 2007, so I tried to make it work.

It is pretty simple anyway. The final solution will be a nice pop up box suggesting the spelling (see below):


Follow my five steps and in less than 2 minutes, you will have it done!

Step 1
Add the following line on the top of the page:

<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> 

Step 2
Add this line after all the “Registers”… almost top of the page:

<script type="text/javascript" language="javascript" src="/_layouts/1033/form.js"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/core.js"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/bform.js"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/SpellCheckEntirePage.js"></script>

Step 3
Add the JavaScript call to display the form and check the fields:

<script language="javascript" type="text/javascript">
function doSpellCheck() {
    SpellCheckEntirePage('<%= SPContext.Current.Web.Url %>/_vti_bin/SpellCheck.asmx', '<%= SPContext.Current.Web.Url %>/_layouts/SpellChecker.aspx');

Step 4
Add a button to do the spell checking:

<input type="button" value="Spelling" class="bg-color-orange metro-font" onclick="javascript:doSpellCheck();"/>                            

Step 5
Add two textboxes. The first one will be checked by our spell checker, but the second one will be avoided because of the “excludeFromSpellCheck” set it to true:

<asp:TextBox ID="TextBox2" runat="server" ></asp:TextBox> 
<asp:TextBox ID="TextBox1" runat="server" CssClass="ms-long" excludeFromSpellCheck="true"></asp:TextBox> 


Probably this is not the most elegant solution in terms of coding, but if we are using Sharepoint as a platform, it is quite good to use native web services instead of third party solutions…and it looks neat!

Tuesday, 8 January 2013

Value does not fall within the expected range

I get this error when I try to retrieve a field. The name of the field is ok and I check the internal name with CAML Query Builder and it is ok as well.

foreach (TaxonomyFieldValue JURISDICTION in (TaxonomyFieldValueCollection)item["Jurisdiction"])                          
    switch (JURISDICTION.Label.ToLower())
        case "uk": this.CHKJUK.Checked = true; break;
        case "england": this.CHKJEngland.Checked = true; break;
        case "scotland": this.CHKJScotland.Checked = true; break;
        case "wales": this.CHKJWales.Checked = true; break;
        case "northern ireland": this.CHKJNIreland.Checked = true; break;
        case "Republic of Ireland": this.CHKJRIreland.Checked = true; break;
        case "eu": this.CHKJEU.Checked = true; break;
        default: break;

To fix it, increase the List View Threshold:

1- Login to Central Admin
2- Go to Application Management -> Manage Web Applications
3- Pick the Web application for which you want to change the LVT (If you only have 1 web app plus the central admin one, the one you want to pick is the 1 web app; changing this for the central admin does you no good)
4- In the ribbon above, click General Settings. That will bring down a menu, from which you should pick Resource Throttling
5- Change the LVT (first item in this list) to another value and press OK, but please try to keep it to a reasonable number!