Sharepoint and Lotus Notes Integration

There are many enterprise clients looking for Lotus Notes integration with Sharepoint, such as viewing Sharepoint Calendar in Lotus Notes Client, or Viewing Lotus Notes Calendar in Sharepoint. However, based on my research, there is only web part available to view Sharepoint Calendar from Lotus Notes Client, but not the other way round. One major provider for this integration is Main Soft. For those who want to view Lotus Notes email or calendar from Sharepoint, too bad and sorry, but there is none.

The only integration with Lotus Notes is to browse the Sharepoint Calendar from Lotus Notus Client. I wish there is some solutions to this requirement.

Sharepoint 2007 Site Membership Web Part

We have often encountered the issue whereby the SiteMembership web part in Sharepoint 2007 does not display any site memberships at all. It is always blank at the time. I couldn't find out the reason for this unexpected behavior. Thus, I have built my own Site Membership web part to replace the OOTB SiteMembership web part.

You may download the source code here

Sharepoint My Site Profile Image does not show in Discussion Board and Main Site Collection

In Sharepoint 2007, the user profile pictures sometimes do not appear or show in the main site collection such as the discussion board and the manage user permission page. This is a Sharepoint known bug which has not been fixed by any hotfix or patches. For example, the discussion board below shows that the profile picture is empty:

 

However, this user has already uploaded a profile image in My Site.

This issue is due to the profile picture URL is not sync to Sharepoint User Information List. The synchronization somehow has gone wrong when you have multiple site collection or when you are using HTTPS. Besides the profile picture URL, other information such as the Email, Firstname, Lastname may also go wrong sometimes.

To fix this issue, the profile picture URL, or other missing information, must be copied over from My Site to User Information List. A schedule task/job must be created to run hourly or daily to execute the code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;
using System.Xml.Serialization;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebPartPages;
using Microsoft.Office.Server;
using Microsoft.Office.Server.UserProfiles;
using Microsoft.SharePoint.Administration;

namespace UserProfilePictureJob
{

    class Program
    {
        static void Main(string[] args)
        {
            if (args.Length == 1)
            {
                using (SPSite GlobalSite = new SPSite(args[0]))
                {
                    //ServerContext object current site
                    ServerContext context = ServerContext.GetContext(GlobalSite);

                    // get the user profile manager
                    UserProfileManager userProfileManager = new UserProfileManager(context);

                    using (SPWeb GlobalWeb = GlobalSite.OpenWeb())
                    {
                        SPList userInfo = GlobalWeb.SiteUserInfoList;

                        foreach (UserProfile profile in userProfileManager)
                        {
                            if (profile != null) // if user exists in profile database
                            {
                                if (userInfo.Fields.ContainsField("Picture"))
                                {
                                    SPListItem itemUser;

                                    SPQuery query = new SPQuery();
                                    query.Query = string.Format(@"<Where><And><Eq><FieldRef Name='Name' /><Value Type='Text'>" + profile["AccountName"] + "</Value></Eq>" +
                                        "<Eq><FieldRef Name='ContentType' /><Value Type='Text'>Person</Value></Eq></And></Where>");
                                    SPListItemCollection items = userInfo.GetItems(query);

                                    if (items.Count > 0)
                                    {
                                        itemUser = items[0];
                                    }
                                    else
                                        itemUser = null;

                                    if (itemUser != null)
                                    {
                                            GlobalWeb.AllowUnsafeUpdates = true;
                                            if (profile["PictureURL"].Value == null)
                                                itemUser["Picture"] = null;
                                            else
                                            {
                                                itemUser["Picture"] = profile["PictureURL"].Value;
                                                string thumbnailpictureurl = (string)profile["PictureURL"].Value;
                                                
                                                thumbnailpictureurl = thumbnailpictureurl.Substring(0, thumbnailpictureurl.Length - 4) + "_" + thumbnailpictureurl.Substring(thumbnailpictureurl.Length - 3, 3) + ".jpg";
                                                thumbnailpictureurl = thumbnailpictureurl.Replace("Profile%20Pictures/", "Profile%20Pictures/_t/");
                                                thumbnailpictureurl = thumbnailpictureurl.Replace("Profile Pictures/", "Profile%20Pictures/_t/");

                                                string checkhttps = thumbnailpictureurl.Substring(0, 5);
                                                checkhttps = checkhttps.ToLower();

                                                string weburl = args[0];
                                                if (weburl.Substring(0, 5) == "https:" && checkhttps != "https")
                                                    thumbnailpictureurl = thumbnailpictureurl.Replace("http", "https");

                                                if (thumbnailpictureurl.IndexOf("_t/_t/") == -1) //if picture url not modified before
                                                {
                                                    //Update Picture url in User Information List
                                                    itemUser["Picture"] = thumbnailpictureurl;

                                                    //Update Picture URL in mysite so that...
                                                    //it displays thumbnail in the My Profile page and Search result page
                                                    profile["PictureURL"].Value = thumbnailpictureurl;
                                                    profile.Commit();
                                                }
                                                else
                                                {

                                                }

                                            }

                                            itemUser.Update();
                                            GlobalWeb.AllowUnsafeUpdates = false;
                                    }
                                }
                            }
                        }
                    }//end web
                }//endsite
            }
            else
            {
                Console.WriteLine("Incorrent argument");
            }
        }
    }
}

You may download a copy of the source code and project Here