Infopath Form picking date time from the client machine instead from the SharePoint Server

When using date time in InfoPath Forms, make sure you are aware of the fact that InfoPath 2007 is picking up the date time from the machine on which it's running i.e. clientt machine.

If the usage of the Infopath Forms (i.e. application) is in a single time zone then this might work well until and unless the client machine has the incorrect value set for date time.

Your application at certain time instances won't work properly if you have validations like date time greater then or less then current time and is being accessed by client located in the different time zones around the world.

To mitigate this issue, you need to write code behind in the page load function of infopath form. The code will basically pick the server time and store it with infopath form so that validations can be performed seamlessely regardless of the timezone of the client machine.

DataView WebPart Sorting Across Pagination Issue

The Sorting in data view web part (when enabling the "basic list toolbar" checkbox in properties using SharePoint Designer) works for the rows which are currently displayed (i.e. displayed on the page)

To make this work properly, you need to do the following:    <ParameterBinding Name="dvt_sortfield" Location="Postback;Connection" DefaultValue="Modified"/> <ParameterBinding Name="dvt_sortdir" Location="Postback;Connection"  DefaultValue="descending"/> Above i have sorted on the "Modified" column in the descending order.   No need to modify the XSLT. Sorting will not work across pagination as this is to sort list which has huge amount of data and sorting the entire list might take long time. Although, If you would like to sort the entire list, please use the toolbar for sorting option in data view properties.

 

SharePoint Maintenance Page

Three options for the SharePoint Maintenance page based on the available infrastructure:

1)      Using modified ISA custom error page and display custom messages.
          - For internal clients, the files are named Error_number.htm. \
          - For external clients, the files are named Error_numberR.htm (where R indicates reverse).

2)      Display custom message on IIS at Web Front End Server in the SharePoint Farm
         - Create a page "App_Offline.htm" in the Root Site

3)      Route the request from ISA to another Site hosting maintenance page.
         - Maintenace page site on same IIS

Reference: ISA