Showing posts from February, 2011

SharePoint Datasheet View

If SharePoint 2007 or 2010 Datasheet View is not working, you need to install:
Access 2007 Download: Access Runtime

2007 Office System Driver: Data Connectivity Components

In every client machine!

Arabic Language Pack on SharePoint 2010 running on Windows 7

If ever you want to install Arabic Language Pack on SharePoint 2010 running on Windows 7, you will get a pre-requisite requirement of having Windows Server 2008 OS.

To overcome this, you need to do a similar change to the files\setup\config.xml the way you did in the SharePoint 2010 install.

Extract the Arabic Lang Pack using /extract switch to a folder. Edit the config file to add the below line.

The following needs to be added.

<Setting Id=”AllowWindowsClientInstall” Value=”True”/>

Windows Server 2008 R2 Blue Screen due to Hyper-V

Windows Server 2008 too can give you a blue screen!

I had tried adding the Hyper-V role on a Windows Server running on a laptop and guess what it gave me the blue screen of death!

Even though I though Windows was smart enough to detect (it got restarted and said, hyper-v has failed so removing it) and remove it, it wasn't just doing it...

Windows 7 Blue Screen because of ConnectiFy

I had installed ConnectiFy on the other day in order to convert my Windows 7 machine as an Wireless access point, but it ended up giving me blue screen of death in my Windows 7. This is the first time I am seeing this on Windows 7 in over an year!

Even in safe mode, I could not uninstall the ConnectiFy drivers which got clinged onto all network adapters.

So be careful!

Validate a SharePoint Date Field against Current Date in Javascript

Consider the following scenario:

You have a SharePoint Site which has its regional settings set to English (UK) - so that the date format becomes dd/mm/yyyy in all date pickersYou would like to validate a particular date field in your List or Document Library against the current dateIf the validation does not pass, you should not allow the form to save
So what the script does is:
Uses the sputility (check my previous posts and also look at to get the particular SharePoint date fieldIt comes out as a date datatype, so I cast it to stringSince the format is in dd/mm/yyyy and Javascript compare and date functions work only with mm/dd/yyyy, I am converting them back to that formatthen using UTC string conversions and comparing...Enjoy!
<script type="text/javascript">
function PreSaveAction() {  var createdate = SPUtility.GetSPField('Date of Creation').GetValue();  var createdatestr=createdate.toString();         var dt1  = createdatestr.subst…