Tuesday, March 17, 2009

Data Synchronisation between SQL Sever and SharePoint List

Recently i come across Data Synchronisation (Commercial) tool between SQL Sever and SharePoint List.

Data Synchronisation Studio is a powerful application for publishing business data directly to SharePoint Lists from SQL Server Tables and Views, Oracle, MySQL.

Data Synchronisation Studio is the de-facto solution for integrating and migrating business data with SharePoint Server WSS and MOSS.

Wednesday, March 11, 2009

Browser-based charting for ASP.NET 3.5

Microsoft recently released a cool new ASP.NET server control that can be used for free with ASP.NET 3.5 to enable rich browser-based charting applications

image

Download the Chart controls from the following location. http://www.microsoft.com/downloads/details.aspx?FamilyID=130f7986-bf49-4fe5-9ca8-910ae6ea442c&DisplayLang=en

There is also a Visual Studio 2008 AddIn to support these chart controls. The Chart Control Samples.

Tuesday, March 10, 2009

How to setup Single Sign-On

Single Sign on feature SharePoint, provides authentication to systems and group or individual basis. The SSO service handle authenticating a user against a backbend system so the user is not prompted to login.

Excellent! article by Mr.  Robert L. Bogue MVP, explain how to configure Single Sign on feature on SharePoint.

http://www.thorprojects.com/blog/archive/2008/08/02/moss-single-sign-on-setup-step-by-step.aspx

Sunday, March 1, 2009

Quest Migration Event @ Singapore

Last week 26 February 2009, 9am - 5pm @  Marina Mandarin Hotel, Vanda Room Level 5, We (NCS) setup booth to showcase NCS capability on Lotus Notes to SharePoint Migration.

NCS-Events      Our booth @ Quest event (Me and Swee Gee)

Tuesday, February 24, 2009

Lotus Notes Migration for SharePoint - Quest Discovery Edition free!!!

Good news!!! Planning to migrate Lotus Notes to SharePoint, Quest Discovery Edition helps your discover, usage analysis, data analysis, design analysis, template comparison, reporting and data export capabilities with no restrictions as well free support for 30 days. Those need to discovery of their existing Notes/Domino environments can perform complete analysis absolutely free.

This download also provides limited trial access to the functionality of Notes Migrator for SharePoint Standard Edition and Premier Edition. Database migrations are restricted to 10 records per database and are limited to non-production use.

Click here to download.

Thursday, February 12, 2009

SharePoint Usage Reports (FREE Tool)

SharePoint Server 2007 out of the box feature provides Usage reporting is a service which helps site administrators, site collection administrators to monitor statistics about the use of their sites. Usage reporting also provides usage reporting for search queries. SharePoint provides following  pre-define list.

  • Requests and queries in the last day and the last 30 days.
    Average number of requests per day over the last 30 days.
    A chart of requests per day over the last 30 days.
    A list of the top page requests over the last 30 days.
    A list of top users over the last 30 days.
    A chart of top referring hosts over the last 30 days.
    A chart of top referring pages over the last 30 days.
    A list of top destination pages over the last 30 days.
    Top queries for the last 30 days (if search usage reporting is enabled).
    Search results top destination pages (if search usage reporting is enabled).
    Number of queries per day over the previous 30 days.
    Number of queries per month over the previous 12 months.
    Top queries over the previous 30 days.
    Top site collections originating queries over the previous 30 days.
    Queries per search scope over the previous 30 days.

The above reports provide basic information to site owner to analysis, however this reports not inadequate, the chart are not very basic.

Incase if you are looking for alternative solution you may think CardioLog Lite for SharePoint 2007 includes a set of 3 basic SharePoint usage reports: Unique Users, Visitors and Page Views. Additional trial (14-days) reports are provided with the free download.

Page Views - SharePoint Usage Report

For more details visit : CardioLog Lite